Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • pvm_pre_change.sql Oracle
  • eplan9i.sql Oracle
  • Gathering statistics with DBMS_STATS Oracle
  • Oracle Recommended Patches — Oracle Database ID 756671.1 Oracle
  • How to find the real execution plan and binds used in that explain plan in Oracle 10g?? Oracle
  • usnsql.sql Displays information about UNDO segments with sql statements Oracle
  • ext#.sql Oracle
  • backspace in SQL Plus not working then..? Linux/Unix
  • Ports used by Oracle Software Oracle
  • How To Transfer Passwords Between Databases (ref note: 199582.1) Oracle
  • exp syntax in oracle 10g Oracle
  • standard Monitoring – 1 Oracle
  • Important Script Method for tuning Oracle
  • Very clear article about oracle dataguard Oracle
  • 10g RAC: Troubleshooting CRS Root.sh Problems Oracle

DBA_HIST_SQLSTAT contents

Posted on 10-May-202310-May-2023 By Admin No Comments on DBA_HIST_SQLSTAT contents

Query DBA_HIST_WR_CONTROL to see the interval, retention and the TOPNSQL setting.  For TOPNSQL a setting of DEFAULT translates to:

30 where statistics_level is typical

100 where statistics_level is all

Simply because this one SQL appears to consume 7% of the load it may not be in the top SQLs in these categories:

Elapsed Time

CPU Time

Parse Calls

Shareable Memory

Version Count

If the SQL doesn’t make the ‘cut’ it isn’t saved and statistics aren’t collected.

Ref: David Fitzjarrell from Oracle community group

Oracle

Post navigation

Previous Post: Find_planinfo.sql
Next Post: PHP code to add WordPress posts in bulk programmatically

Related Posts

  • How to find where datafile is created dbf_info.sql Oracle
  • pvm_metric.sql for gathering report from vmstat tables Oracle
  • FGA Part-I Oracle
  • Find execution plan from dba_hist_sql_plan for a specific SQL_ID and PLAN_HASH_VALUE fplan.sql Oracle
  • Absolute file number and relative file number Oracle
  • findinfo.sql (SQL for getting CPU and Active session info) Oracle

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • Oracle (392)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (341)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • load SPM baseline from cursor cache05-Jun-2025
  • Drop all SPM baselines for SQL handle05-Jun-2025
  • Load SPM baseline from AWR05-Jun-2025
  • Drop specific SQL plan baseline – spm05-Jun-2025
  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • How to find where datafile is created dbf_info.sql Oracle
  • how to find VIP from ifconfig Linux/Unix
  • Global Unique Identifier Generation in Oracle 9.2 SYS_GUID() Oracle
  • load SPM baseline from cursor cache Oracle
  • CTAS with LONG Column for 7.x and 8 and 8i Oracle
  • How to change hostname in Linux Linux/Unix
  • ORA-1841 Error Connecting to Upgraded Database After Set PASSWORD_LIFE_TIME Oracle
  • Example of How To Resize the Online Redo Logfiles Note:1035935.6 Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme