Database Administrator

set pagesize 1000 set lines 100 col sid format 9999 col username format a12 col module format a30 column pga_memory_mb format 9,999.99 headi...

Whenever the value of the v$sysstat statistic estimated PGA memory for one-pass exceeds pga_aggregate_target, then you’ll want to increase p...

select * from v$sgastat order by 1; select * from v$pgastat order by 1; I noticed that you have some Pools in your SGA which are not used: l...

select (select highwater from dba_high_water_mark_statistics where name = ('SESSIONS'))*(2048576+a.value+b.value)/1024/1024 pga_size...

High CPU_COUNT and increased granule size can cause ORA-0431 error. ------CPU_COUNT specifies the number of CPUs available to Oracle. On sin...