- Home
- Oracle 10g Tutorial
- Automatic Statistics Collection Job - Oracle 10g
Automatic Statistics Collection Job - Oracle 10g
Interview Questions
Practice Test
Pragnyameter Exam
All Tutorials
Job SearchA Scheduler program GATHER _STATS _PROG and Scheduler job GATHER _STATS _JOB are predefined on installation of Oracle Database. GATHER _STATS _PROG collects optimizer statistics for all objects in the database for which there are no statistics or only stale statistics. GATHER _STATS _JOB is defined on GATHER_ STATS _PROG and is scheduled to run in the MAINTENANCE _WINDOW _GROUP.
If you prefer to manage statistics collection manually, you can disable the job as follows:
EXECUTE DBMS _SCHEDULER.DISABLE('GATHER_STATS_JOB');
|
|
Oracle 10g Related Tutorials |
|
|---|---|
| Oracle 9i Tutorial | Oracle 8i Tutorial |
| Informatica Tutorial | Oracle 11g Tutorial |
Oracle 10g Related Interview Questions |
|
|---|---|
| Oracle 10g Interview Questions | Oracle 9i Interview Questions |
| Oracle 8i Interview Questions | Informatica Interview Questions |
| PL/SQL Interview Questions | Oracle 11g Interview Questions |
| SQL Interview Questions | Oracle apps Interview Questions |
| Sybase Interview Questions | Oracle Apps ERP Interview Questions |
| Oracle 7.3 Interview Questions | Oracle Access Manager Interview Questions |
| Oracle Application Framework Interview Questions | Oracle Apps DBA Interview Questions |
Oracle 10g Related Practice Tests |
|
|---|---|
| Oracle 10g Practice Tests | Oracle 9i Practice Tests |
| Oracle 8i Practice Tests | Informatica Practice Tests |
| PL/SQL Practice Tests | Oracle 11g Practice Tests |
| SQL Practice Tests | Oracle apps Practice Tests |
| Sybase Practice Tests | Oracle Apps ERP Practice Tests |
| Oracle 7.3 Practice Tests |
Oracle 10g Tutorial
- Types Of Oracle Database Users
- Tasks Of A Database Administrator
- Identifying Your Oracle Database Software Release
- Database Administrator Security And Privileges
- Database Administrator Authentication
- Creating And Maintaining A Password File
- Server Manageability
- Deciding How To Create An Oracle Database
- Manually Creating An Oracle Database
- Understanding The Create Database Statement
- Initialization Parameters And Database Creation
- Troubleshooting Database Creation
- Dropping A Database
- Managing Initialization Parameters Using A Server Parameter File
- Defining Application Services For Oracle Database 10g
- Considerations After Creating A Database
- Viewing Information About The Database
- Starting Up A Database
- Altering Database Availability
- Shutting Down A Database
- Quiescing A Database
- Suspending And Resuming A Database
- About Dedicated And Shared Server Processes
- Configuring Oracle Database For Shared Server
- About Oracle Database Background Processes
- Managing Processes For Parallel Sql Execution
- Managing Processes For External Procedures
- Terminating Sessions
- Monitoring The Operation Of Your Database
- What Is A Control File?
- Guidelines For Control Files
- Creating Control Files
- Troubleshooting After Creating Control Files
- Backing Up Control Files
- Recovering A Control File Using A Current Copy
- Dropping Control Files
- Displaying Control File Information
- What Is The Redo Log?
- Planning The Redo Log
- Creating Redo Log Groups And Members
- Relocating And Renaming Redo Log Members
- Dropping Redo Log Groups And Members
- Forcing Log Switches
- Verifying Blocks In Redo Log Files
- Clearing A Redo Log File
- Viewing Redo Log Information
- What Is The Archived Redo Log?
- Choosing Between Noarchivelog And Archivelog Mode
- Controlling Archiving
- Specifying The Archive Destination
- Specifying The Mode Of Log Transmission
- Managing Archive Destination Failure
- Controlling Trace Output Generated By The Archivelog Process
- Viewing Information About The Archived Redo Log
- Guidelines For Managing Tablespaces
- Creating Tablespaces
- Specifying Nonstandard Block Sizes For Tablespaces
- Controlling The Writing Of Redo Records
- Altering Tablespace Availability
- Guidelines For Managing Datafiles
- Creating Datafiles And Adding Datafiles To A Tablespace
- Changing Datafile Size
- Altering Datafile Availability
- Renaming And Relocating Datafiles
- Dropping Datafiles
- Verifying Data Blocks In Datafiles
- Copying Files Using The Database Server
- Mapping Files To Physical Devices
- Viewing Datafile Information
- What Is Undo?
- Introduction To Automatic Undo Management
- Sizing The Undo Tablespace
- Managing Undo Tablespaces
- Monitoring The Undo Tablespace
- Flashback Features And Undo Space
- Migration To Automatic Undo Management
- Best Practices
- What Are Oracle-managed Files?
- Enabling The Creation And Use Of Oracle-managed Files
- Creating Oracle-managed Files
- Behavior Of Oracle-managed Files
- Scenarios For Using Oracle-managed Files
- What Is Automatic Storage Management?
- Overview Of The Components Of Automatic Storage Management
- Administering An Asm Instance
- Configuring The Components Of Automatic Storage Management
- Using Automatic Storage Management In The Database
- Viewing Information About Automatic Storage Management
- Managing Space In Data Blocks
- Managing Space In Tablespaces
- Managing Storage Parameters
- Managing Resumable Space Allocation
- Reclaiming Unused Space
- Understanding Space Usage Of Datatypes
- Displaying Information About Space Usage For Schema Objects
- Capacity Planning For Database Objects
- About Tables
- Guidelines For Managing Tables
- Creating Tables In Oracle10g
- Inserting Data Into Tables Using Direct-path Insert
- Automatically Collecting Statistics On Tables
- Altering Tables
- Redefining Tables Online
- Auditing Table Changes Using Flashback Transaction Query
- Recovering Tables Using The Flashback Table Feature
- Dropping Tables
- Using Flashback Drop And Managing The Recycle Bin
- Managing Index-organized Tables
- Managing External Tables
- Viewing Information About Tables
- About Indexes
- Guidelines For Managing Indexes
- Creating Indexes
- Altering Indexes
- Monitoring Space Use Of Indexes
- Dropping Indexes
- Viewing Index Information
- When To Use Composite Range-list Partitioning
- About Partitioned Tables And Indexes
- Partitioning Methods
- Creating Partitioned Tables
- Maintaining Partitioned Tables
- Partitioned Tables And Indexes Example
- Viewing Information About Partitioned Tables And Indexes
- About Clusters
- Guidelines For Managing Clusters
- Creating Clusters
- Altering Clusters
- Dropping Clusters
- Viewing Information About Clusters Table
- About Hash Clusters
- When To Use Hash Clusters
- Creating Hash Clusters
- Altering Hash Clusters
- Dropping Hash Clusters
- Viewing Information About Hash Clusters
- Managing Views
- Managing Sequences
- Managing Synonyms
- Viewing Information About Views, Synonyms, And Sequences
- Creating Multiple Tables And Views In A Single Operation
- Analyzing Tables, Indexes, And Clusters
- Truncating Tables And Clusters
- Enabling And Disabling Triggers
- Managing Integrity Constraints
- Renaming Schema Objects
- Managing Object Dependencies
- Managing Object Name Resolution
- Switching To A Different Schema
- Displaying Information About Schema Objects
- Options For Repairing Data Block Corruption
- About The Dbms_repair Package
- Using The Dbms_repair Package
- Dbms_repair Examples
- The Importance Of Establishing A Security Policy For Your Database
- Managing Users And Resources
- Managing User Privileges And Roles
- Auditing Database Use
- Maintenance Windows
- Automatic Statistics Collection Job
- Resource Management In Oracle
- What Is The Database Resource Manager?
- Administering The Database Resource Manager
- Creating A Simple Resource Plan
- Creating Complex Resource Plans
- Managing Resource Consumer Groups
- Enabling The Database Resource Manager
- Putting It All Together: Database Resource Manager Examples
- Monitoring And Tuning The Database Resource Manager
- Interaction With Operating-system Resource Control
- Viewing Database Resource Manager Information
- Moving From Dbms_job To Dbms_scheduler
- Overview Of The Scheduler
- Basic Scheduler Concepts
- Advanced Scheduler Concepts
- Scheduler Architecture
- Scheduler Objects And Their Naming
- Administering Jobs
- Administering Programs
- Administering Schedules
- Administering Job Classes
- Administering Windows
- Administering Window Groups
- Allocating Resources Among Jobs
- Configuring The Scheduler
- Monitoring And Managing The Scheduler
- Import/export And The Scheduler
- Examples Of Using The Scheduler
- Distributed Database Architecture
- Database Links
- Distributed Database Administration
- Transaction Processing In A Distributed System
- Distributed Database Application Development
- Character Set Support For Distributed Environments
- Managing Global Names In A Distributed System
- Creating Database Links
- Using Shared Database Links
- Managing Database Links
- Viewing Information About Database Links
- Creating Location Transparency
- Managing Statement Transparency
- Managing A Distributed Database: Examples
- Managing The Distribution Of Application Data
- Controlling Connections Established By Database Links
- Maintaining Referential Integrity In A Distributed System
- Tuning Distributed Queries
- Handling Errors In Remote Procedures
- What Are Distributed Transactions?
- Session Trees For Distributed Transactions
- Two-phase Commit Mechanism
- In-doubt Transactions
- Distributed Transaction Processing: Case Study
- Specifying The Commit Point Strength Of A Node
- Naming Transactions
- Viewing Information About Distributed Transactions
- Deciding How To Handle In-doubt Transactions
- Manually Overriding In-doubt Transactions
- Purging Pending Rows From The Data Dictionary
- Manually Committing An In-doubt Transaction: Example
- Data Access Failures Due To Locks
- Simulating Distributed Transaction Failure
- Managing Read Consistency
Overview Of Administering An Oracle Database
Creating An Oracle Database
Starting Up And Shutting Down
Managing Oracle Database Processes
Managing Control Files
Managing The Redo Log
Managing Archived Redo Logs
Managing Tablespaces
Managing Datafiles And Tempfiles
Managing The Undo Tablespace
Using Oracle-managed Files
Using Automatic Storage Management
Managing Space For Schema Objects
Managing Tables
Managing Indexes
Managing Partitioned Tables And Indexes
Managing Clusters
Managing Hash Clusters
Managing Views, Sequences, And Synonyms
General Management Of Schema Objects
Detecting And Repairing Data Block Corruption
Managing Users And Securing The Database
Managing Automatic System Tasks Using The Maintenance Window
Using The Database Resource Manager
Moving From Dbms_job To Dbms_scheduler
Overview Of Scheduler Concepts
Using The Scheduler
Administering The Scheduler
Distributed Database Concepts
Managing A Distributed Database
Developing Applications For A Distributed Database System
Distributed Transactions Concepts
Managing Distributed Transactions
