• 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

How to transfer statistics between databases in Oracle

May 5, 2023 by techgoeasy Leave a Comment

We can transfer statistics between servers allowing consistent execution plans between servers with varying amounts of data. This is possible using the DBMS_STATS package Here are the steps to do for a table Step 1. Create the stat table EXEC DBMS_STATS.CREATE_STAT_TABLE(‘SCOTT,’STATTAB’, ‘TOOLS’); Step 2 Export table statistics to statistics table. EXEC DBMS_STATS.EXPORT_TABLE_STATS(OWNNAME=>’SCOTT’,TABNAME=>’EMP’, STATTAB=>’STATTAB’,STATID=>’EXP_1′,STATOWN=>’SCOTT); Step 3 […]

Filed Under: Oracle, Oracle Database

How to import statistics in Oracle

May 4, 2023 by techgoeasy Leave a Comment

We can import statistics from the user statistics table identified by stattab and stored in the data dictionary. Basically, you can import the statistics which you exported sometime before to the use statistics table. To import statistics in Oracle, you can use the DBMS_STATS package. This package provides several procedures and functions for managing database statistics. […]

Filed Under: Oracle, Oracle Database

How to export statistics in Oracle

May 3, 2023 by techgoeasy Leave a Comment

To export statistics in Oracle, you can use the DBMS_STATS package. This package provides several procedures and functions for managing database statistics. Here are the basic steps: (1) Connect to your database as a user with the necessary privileges (such as SYS or SYSTEM). (2) create a stat table to hold the statistics EXEC DBMS_STATS.CREATE_STAT_TABLE(‘SCOTT’,’STATTAB’); […]

Filed Under: Oracle, Oracle Database

How to create stat table in Oracle

May 2, 2023 by techgoeasy Leave a Comment

We can create a stat table in Oracle that can be used to store statistics of the schema, tables, and indexes. In this post we will see how to create and drop the stat table in Oracle, and what are the uses of it. what is the structure of the table? How to create stat […]

Filed Under: Oracle, Oracle Database

How to check automatic statistics collection in Oracle

May 2, 2023 by techgoeasy Leave a Comment

What is automatic statistics collection in Oracle? Automatic statistics jobs automatically gather Missing and Stale statistics on tables, indexes, and partitions for use by the Cost Based Optimizer (CBO) in determining the most optimal access paths for queries. This job was built to assist with the collection of statistics from the start with newly created […]

Filed Under: Oracle, Oracle Database

How to restore optimizer statistics

April 13, 2023 by techgoeasy Leave a Comment

As we know that DBMS_STATS takes a backup of the statistics every time dbms_stats is run on the table. So we can restore the statistics from the backup. Let’s see a few important things in this feature How far back in time we can go to restore statistics? We can find this using the below […]

Filed Under: Oracle, Oracle Database

  • « Previous Page
  • Page 1
  • Page 2
  • Page 3
  • Page 4
  • Page 5
  • Page 6
  • …
  • Page 122
  • Next Page »

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 create sql baseline from AWR repository without STS
  • how to create sql baseline from Sql tuning set in Oracle
  • How to create sql baseline from cursor cache in Oracle
  • how to create sql baseline in oracle 19c
  • Sql plan Management in Oracle

Copyright © 2023 : TechGoEasy

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