Tuning

So you need a little data about how much archivelog your DB is producing?

Here is a query that will give you the last 24 hour summary. select to_char(first_time,’dd-mon-yy’) In_Day, round(sum(blocks*block_size)/1024/1024/1024,2) Total_GB_Archived, count(*) Num_of_Archs, round(sum(blocks*block_size)/1024/1024/count(*),2) Avg_MB_Per_Arch from v$archived_log where first_time>sysdate-1 group by to_char(first_time,’dd-mon-yy’) order by to_char(first_time,’dd-mon-yy’); Need to see the hourly archivelog data? — want to see archivelog data by the hour select to_char(first_time,’dd-mon-yy hh24′) InHour, round(sum(blocks*block_size)/1024/1024/1024,1) Total_GB_Archived, count(*) …

So you need a little data about how much archivelog your DB is producing? Read More »

Linux Huge Page Configuration and Oracle Memory Management Compatibility

For large Oracle Database footprints – say 8GB or above (not really too large any more) configure Linux huge pages and assure Oracle’s SGA is using manual or Automatic Shared Memory Management. Note Automatic Memory Management (using MEMORY_MAX_TARGET) is not compatible with Linux huge pages.  Do not confuse Automatic Shared Memory Management / ASMM (which …

Linux Huge Page Configuration and Oracle Memory Management Compatibility Read More »