understanding AWR report during ora-04031 shared memory
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.64 | 0 | 1.11 | 9.29 | 91.22 | d3hpncnbqxgfp | 01@<dappl/xxbertin/11.5.0/sql/XX_EXTRACT_OTL.sql | DECLARE CURSOR C_EXTRACT IS SE... | |
234.62 | 1 | 234.62 | 1.11 | 9.28 | 91.23 | 4rmh3500bxnv3 | 01@<dappl/xxbertin/11.5.0/sql/XX_EXTRACT_OTL.sql | SELECT PPF.FULL_NAME, HAOU.NAM... |
2 - Sql ordered by get
4,123,245 | 1 | 4,123,245.00 | 5.97 | 234.62 | 9.3 | 91.2 | 4rmh3500bxnv3 | 01@<dappl/xxbertin/11.5.0/sql/XX_EXTRACT_OTL.sql | SELECT PPF.FULL_NAME, HAOU.NAM... |
3 - SQL User I/O Wait Time
214.04 | 1 | 214.04 | 57.36 | 234.62 | 9.28 | 91.23 | 4rmh3500bxnv3 | 01@<dappl/xxbertin/11.5.0/sql/XX_EXTRACT_OTL.sql | SELECT PPF.FULL_NAME, HAOU.NAM... |
1