• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General

oracle unlock statistics

How to find table where statistics are locked

December 20, 2020 by techgoeasy Leave a Comment

Statistics played in key role for Oracle performance tuning. Oracle Optimizer creates the execution plan based on the statistics of the oracle table involved in the SQL queries. You may want to lock statistics in a oracle table in some cases, for example you don’t want a table to be analyzed by schedule  statistics job […]

Filed Under: Oracle, Oracle Database Tagged With: dba_tab_statistics, dbms_stats.unlock_schema_stats, How to find table where statistics are locked, ORA-20005, ORA-38029, oracle unlock statistics

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • How to check Stale statistics
  • Java web start(JWS) in R12
  • How to delete the archive logs in Oracle
  • How to generate sql monitor report in Oracle
  • How to find the long running (longops session) in Oracle

Copyright © 2023 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us