Monday, December 24, 2012


You can use the query below to show the amount of free memory in your shared pool. It was run on an Oracle database:
SQL> l
  1  select bytes from v$sgastat
  2  where pool = 'shared pool'
  3* and name = 'free memory'
SQL> /
If this figure remains high and you have insufficient physical memory on your server, you could consider reducing the size of your shared pool. This would allow you to reuse the memory elsewhere.

In Spanish / en español  

No comments: