When executing a procedure I am getting “ORA-04031: unable to allocate shared memory” error. How do I avoid this error?
What is the cause of the error ORA-00054 “resource busy and acquire with NOWAIT specified or timeout expired”?
What is the cause of the error “ORA-01110 data file %s”? How do I resolve this?
What is the cause of the “ORA-00918 column ambiguously defined” error? How do I resolve this?
Occasionally there is a need to generate multiple AWR reports for database analysis. In my case, a storage vendor will use a tool to extract data from all time periods from the AWR reports to find IO related specific information. Here is how I generated these reports.