| From: | Steve Adams |
| Date: | 30-Aug-2000 23:36 |
| Subject: | Large Pool |
I think Oracle's expectation is that you will do it by trial and (hopefully not
too much) error. If you get ORA-4031 errors against the large pool, then it is
not big enough. If V$SGASTAT always shows plenty of 'free memory' then its too
big. If you don't yet have a large pool at all, then you may be able make a
reasonable first estimate based on the current memory usage in the shared pool
by querying V$SGASTAT (and possibly also using the shared_pool_summary.sql
script from the Ixora web site).
-----Original Message-----
Sent: Wednesday, 30 August 2000 22:29
How do you go about sizing the Large Pool for MTS, I/O Slaves and RMAN.
Documentation seems thin in these areas!