The experiences, Test cases, views, and opinions etc expressed in this website are my own and does not reflect the views or opinions of my employer. This site is independent of and does not represent Oracle Corporation in any way. Oracle does not officially sponsor, approve, or endorse this site or its content.Product and company names mentioned in this website may be the trademarks of their respective owners.
Posted by Sriram Sanka on September 12, 2022
set linesize 100
set pagesize 100
SELECT * FROM
(SELECT substr(sql_text,1,40) sql,
buffer_gets, executions, buffer_gets/executions "Gets/Exec",
hash_value,address
FROM V$SQLAREA
WHERE buffer_gets > 10000
ORDER BY buffer_gets DESC)
WHERE rownum <=10
;
Posted in Buffer Gets, sql | Tagged: Buffer Gets, oracle tuning, sql | Leave a Comment »
Its all about Databases & their performance, troubleshooting & much more .... ¯\_(ツ)_/¯
Michael T. Dinh, Oracle DBA
by Mehmet Eser
Performance troubleshooting as exact science
get sum oracle stuffs
Dani Schnider's Blog
Oracle DBA's Daily Work
Welcome everyone!! The idea of this blog is to help the DBA in their daily tasks. Enjoy.
Learn. Share. Repeat.
Oracle Performance Tuning, Troubleshooting, Internals
Journey as an Oracle Certified Master
Sharing Knowledge is ultimate key to Gaining knowledge...
A resource for Database Professionals
Tips, tricks, (and maybe a few rants) so more DBA's become bulletproof!
Consulting and Training
My Experiences with Databases 