Use of v$archived_log and v$log_history on Physical Standby

This blog entry is about the use of v$archived_log and v$log_history views on the standby database, which many of you would be aware of, and few like me mite not. Till now i always used the below sql to check the last "applied" archived log on the standby, which had almost given me the correct … Continue reading Use of v$archived_log and v$log_history on Physical Standby

ORA-04031

Few days back, while on a visit to client place, came across ORA-04031 on an oracle 10g database. ORA-04031: "unable to allocate 4096 bytes of shared memory ("shared pool", "object_name", "alloc type(2,0)" ...)" Many good articles are available on shared pool management and ORA-04031, but i really like the two mentioned below :- 1. http://blog.tanelpoder.com/2009/06/04/ora-04031-errors-and-monitoring-shared-pool-subpool-memory-utilization-with-sgastatxsql/Continue reading ORA-04031