On querying the v$session_event, I could see one
process taking a very large wait time. The process
takes about 4 Hrs to complete on *this* instance (A),
whereas it takes a few minutes on another instance(B)
with almost same amount of data. The Metalink pages
suggest to test by increasing DB_BLOCK_BUFFERS, but
the interesting thing is that instance A's SGA is
128M, whereas instance B's is 44M. Any suggestions ?
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/
Received on Wed May 03 2000 - 11:57:25 CDT
