Database Tuning (MOSC)

MOSC Banner

understanding AWR report during ora-04031 shared memory

edited May 25, 2016 11:21AM in Database Tuning (MOSC) 14 commentsAnswered

hello,

     My memory has been fragmented, I did a flush of my memory.

then I retrieved an AWR report and I saw below :

1 - SQL ordered by Elapsed Time

234.6401.119.2991.22d3hpncnbqxgfp01@<dappl/xxbertin/11.5.0/sql/XX_EXTRACT_OTL.sqlDECLARE CURSOR C_EXTRACT IS SE...
234.621234.621.119.2891.234rmh3500bxnv301@<dappl/xxbertin/11.5.0/sql/XX_EXTRACT_OTL.sqlSELECT PPF.FULL_NAME, HAOU.NAM...

2 - Sql ordered by get

4,123,24514,123,245.005.97234.629.391.24rmh3500bxnv301@<dappl/xxbertin/11.5.0/sql/XX_EXTRACT_OTL.sqlSELECT PPF.FULL_NAME, HAOU.NAM...

3 - SQL  User I/O Wait Time

214.041214.0457.36234.629.2891.234rmh3500bxnv301@<dappl/xxbertin/11.5.0/sql/XX_EXTRACT_OTL.sqlSELECT PPF.FULL_NAME, HAOU.NAM...
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center