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(*)…

Using Oracle Snapshot Standby 11g and forward – using automatic restore points

New 11g feature (not sure if this came out in 11gR1 or 11gR2) – but it doesn’t get any easier… or should I say it used to be a lot harder. This feature creates a “guaranteed restore point” and generates flashback logs – whether flashback database is on or not to do the flashback.  So…

12.1 Oracle Data Guard Related Views

Per https://docs.oracle.com/database/121/SBYDB/views.htm#SBYDB01300 Views Relevant to Oracle Data Guard There are a number of views that are especially useful when monitoring an Oracle Data Guard environment. Table 19-1 describes the views and indicates if a view applies to physical standby databases, logical standby databases, snapshot standby databases, or primary databases. See Oracle Database Reference for complete information about views. Table…

hidden oracle parameter / param to turn on and off real time query / Active Data Guard

alter system set “_query_on_physical”=false scope=spfile; alter system reset “_query_on_physical”=false scope=spfile;