Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Gather table stats frees sga!
Hi There,
I run a little job weekly to get the stats updated on all the user tables and indexes. On one of my databases, this also frees up about 100MB from the SGA.
Can anyone suggest a reason for this, and also whether it's something to worry about??
Cheers,
Steve Received on Wed Jul 16 2003 - 12:19:59 CDT