Select Fetching from UNDO
From: Krishnaprasad Yadav <chrishna0007_at_gmail.com>
Date: Tue, 5 Sep 2023 12:13:52 +0530
Message-ID: <CAO8FHeWpYuDawPXgHg=3gZ9z7tUijLZHY2TGe+HAKsuGHKC3rg_at_mail.gmail.com>
Dear Gurus,
Krishna
Date: Tue, 5 Sep 2023 12:13:52 +0530
Message-ID: <CAO8FHeWpYuDawPXgHg=3gZ9z7tUijLZHY2TGe+HAKsuGHKC3rg_at_mail.gmail.com>
Dear Gurus,
we see a performance issue and Application team provided session id , we tried to figure out the detail and understand that session was executing one select statement , going further we see that most of the reads activity happening on UNDO tablespace for select statement , want to understand is fetching all records from UNDO is normal behavior or i should look for any rollback too or on which aspect such situation get raised .
File ID % Activity Event % Event
--------------- ---------- ------------------------------ ----------
Tablespace
4237 5.30 db file sequential read 3.31 UNDOTBS2
gc cr disk read 1.49 4238 4.97 db file sequential read 2.90UNDOTBS2
gc cr disk read 1.74 4258 4.06 db file sequential read 2.24UNDOTBS2
gc cr disk read 1.66 4239 3.73 db file sequential read 2.24UNDOTBS2
gc cr disk read 1.16 4257 3.48 db file sequential read 2.40UNDOTBS2 Regards,
Krishna
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 05 2023 - 08:43:52 CEST