Saturday, September 5, 2015

steps to check sql is hard/soft parse ,#execution,rows_processed in oracle database?

1.check from oem HISTORY FOR CURSOR AND HISOTRIC DATA
2.USE v$SQL,v$SQLAREA,DBA_HIST_SQLSTAT VIEWS TO GET THE INFORMATION
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)