New Oracle 12c IO Outlier Views
With 12c Oracle provides a couple of new views that report IOs that take over 500ms. That 500ms threshold is […]
With 12c Oracle provides a couple of new views that report IOs that take over 500ms. That 500ms threshold is […]
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,
For large Oracle Database footprints – say 8GB or above (not really too large any more) configure Linux huge pages
Getting an ADDM Report Manually – Not Using OEM Basically, generating an ADDM report requires that a ADDM task was