Are you over 18 and want to see adult content?
4
More Annotations
2
A complete backup of www.www.amkingdom.com
www.www.amkingdom.com
Are you over 18 and want to see adult content?
A complete backup of www.vintagemags.org
www.vintagemags.org
Are you over 18 and want to see adult content?
2
Favourite Annotations
A complete backup of howtoexportimport.com
howtoexportimport.com
Are you over 18 and want to see adult content?
1
A complete backup of leeprecision.com
leeprecision.com
Are you over 18 and want to see adult content?
A complete backup of ralphlauren-outlets.co.uk
ralphlauren-outlets.co.uk
Are you over 18 and want to see adult content?
5
Text
QUEST_IN_ORACLEDBA: TOP 10 BIGGEST DATABASES IN THE WORLD Also AT&T has one of the largest database with most number of rows (around 1.9 Trillion), second to Sprint. It’s said that AT&T has been recording the details of callers long before terabytes storing came into market. 4. Google: The giants in internet searching- Google bags the number 4th spot in top 10 largest databases. QUEST_IN_ORACLEDBA: ORACLE HISTOGRAMS AND WHY??? In this short series on histograms we will be looking at the reasons why we need histograms and the methods Oracle has to create them. We will examine the costs of creating them, and the potential they introduce for undesirable overheads, and then review their potential for giving you stability problems in your execution plans. QUEST_IN_ORACLEDBA: QUERY TO IDENTIFY THE SESSIONS CAUSING Query to identify the sessions causing huge archive log generation. Check which session is generating more redo. To find sessions generating lots of redo, you can use either of the following methods. Both methods examine the amount of undo generated. When a transaction generates undo, it will automatically generate redo as well. QUEST_IN_ORACLEDBA: ORACLE RAC It is an alternative to other file systems and volume managers. Oracle recommends using ASM as storage manager. 2. ASM Disk. Every physical disk in ASM is called an ASM disk. Every disk has a device name in operating system For example the first scsi disk in a Linux OS is named "sda" unless defined otherwise. 1. QUEST_IN_ORACLEDBA: MOVE LOB SEGMENT AND INDEX TO A Above command will move the table to new tablespace but will not move the. CLOB segment and it will still be in original tablespace. This is because LOB. data is stored outside of the table. Check the tablespace of the CLOB column by issuing following sql. SELECT index_name, tablespace_name. FROM user_indexes WHERE table_name = 'IMAGE'; QUEST_IN_ORACLEDBA: ORA-12526: TNS:LISTENER: ALL DBA role: connected by using user who has DBA role. $ sqlplus system@orcl. Enter password: ERROR: ORA-12526: TNS:listener: all appropriate instances are in restricted mode. Found!!! ORA-12526: TNS:listener: all appropriate instances are in restricted mode. Then solved it by changed TNSNAMES.ORA: using " (UR=A) ". QUEST_IN_ORACLEDBA: ASM DISKGROUP SPACE USAGE QUERIES From Gavin Soorma: Monitor space used in ASM Disk Groups SET LINESIZE 145 SET PAGESIZE 9999 SET VERIFY off COLUMN group_name QUEST_IN_ORACLEDBA: HOW TO INSTALL ODBC DRIVER FOR ORACLE 1. cd c:\oracle\instant_client_11. and then – still in cmd, install ODBC: 1. odbc_install.exe. When successfully, you should get the following info: 1. Oracle ODBC Driver is installed successfully. So, right now we can configure ODBC connection: choose Control Panel, then Administrative Tools, then Data Sources (ODBC), then System DNS and QUEST_IN_ORACLEDBA: ORACLE RAC Beginning with the version 11g Release 2, the ASM spfile is stored automatically in the first disk group created during Grid Infrastructure installation. QUEST_IN_ORACLEDBA: OS SYSTEM DEPENDENT OPERATION:FORK 1. Check your swap space and increase swap area in system. Because due to lack of space in swap are Oracle unable to create new process and PSP0 Process SPwaner is unable to QUEST_IN_ORACLEDBA: TOP 10 BIGGEST DATABASES IN THE WORLD Also AT&T has one of the largest database with most number of rows (around 1.9 Trillion), second to Sprint. It’s said that AT&T has been recording the details of callers long before terabytes storing came into market. 4. Google: The giants in internet searching- Google bags the number 4th spot in top 10 largest databases. QUEST_IN_ORACLEDBA: ORACLE HISTOGRAMS AND WHY??? In this short series on histograms we will be looking at the reasons why we need histograms and the methods Oracle has to create them. We will examine the costs of creating them, and the potential they introduce for undesirable overheads, and then review their potential for giving you stability problems in your execution plans. QUEST_IN_ORACLEDBA: QUERY TO IDENTIFY THE SESSIONS CAUSING Query to identify the sessions causing huge archive log generation. Check which session is generating more redo. To find sessions generating lots of redo, you can use either of the following methods. Both methods examine the amount of undo generated. When a transaction generates undo, it will automatically generate redo as well. QUEST_IN_ORACLEDBA: ORACLE RAC It is an alternative to other file systems and volume managers. Oracle recommends using ASM as storage manager. 2. ASM Disk. Every physical disk in ASM is called an ASM disk. Every disk has a device name in operating system For example the first scsi disk in a Linux OS is named "sda" unless defined otherwise. 1. QUEST_IN_ORACLEDBA: MOVE LOB SEGMENT AND INDEX TO A Above command will move the table to new tablespace but will not move the. CLOB segment and it will still be in original tablespace. This is because LOB. data is stored outside of the table. Check the tablespace of the CLOB column by issuing following sql. SELECT index_name, tablespace_name. FROM user_indexes WHERE table_name = 'IMAGE'; QUEST_IN_ORACLEDBA: ORA-12526: TNS:LISTENER: ALL DBA role: connected by using user who has DBA role. $ sqlplus system@orcl. Enter password: ERROR: ORA-12526: TNS:listener: all appropriate instances are in restricted mode. Found!!! ORA-12526: TNS:listener: all appropriate instances are in restricted mode. Then solved it by changed TNSNAMES.ORA: using " (UR=A) ". QUEST_IN_ORACLEDBA: ASM DISKGROUP SPACE USAGE QUERIES From Gavin Soorma: Monitor space used in ASM Disk Groups SET LINESIZE 145 SET PAGESIZE 9999 SET VERIFY off COLUMN group_name QUEST_IN_ORACLEDBA: HOW TO INSTALL ODBC DRIVER FOR ORACLE 1. cd c:\oracle\instant_client_11. and then – still in cmd, install ODBC: 1. odbc_install.exe. When successfully, you should get the following info: 1. Oracle ODBC Driver is installed successfully. So, right now we can configure ODBC connection: choose Control Panel, then Administrative Tools, then Data Sources (ODBC), then System DNS and QUEST_IN_ORACLEDBA: ORACLE RAC Beginning with the version 11g Release 2, the ASM spfile is stored automatically in the first disk group created during Grid Infrastructure installation. QUEST_IN_ORACLEDBA: OS SYSTEM DEPENDENT OPERATION:FORK 1. Check your swap space and increase swap area in system. Because due to lack of space in swap are Oracle unable to create new process and PSP0 Process SPwaner is unable to QUEST_IN_ORACLEDBA: MOVE LOB SEGMENT AND INDEX TO A Above command will move the table to new tablespace but will not move the. CLOB segment and it will still be in original tablespace. This is because LOB. data is stored outside of the table. Check the tablespace of the CLOB column by issuing following sql. SELECT index_name, tablespace_name. FROM user_indexes WHERE table_name = 'IMAGE'; QUEST_IN_ORACLEDBA: ORACLE RAC It is an alternative to other file systems and volume managers. Oracle recommends using ASM as storage manager. 2. ASM Disk. Every physical disk in ASM is called an ASM disk. Every disk has a device name in operating system For example the first scsi disk in a Linux OS is named "sda" unless defined otherwise. 1. QUEST_IN_ORACLEDBA: ARCHITECTURAL DIAGRAMS Overview: 1.Download psu patch and interim patch 2.Move to server 3.Check for conflict patch 4.Bring down the instance on each node to
ro
QUEST_IN_ORACLEDBA: AUTOMATED MAINTENANCE TASKS IN ORACLE 11G The Automatic Optimizer Statistics Collection task collects statistics for all objects with no or stale statistics. The Automatic Segment Advisor task provides advice on which database segments have free space that can be reclaimed. QUEST_IN_ORACLEDBA: ORA-12526: TNS:LISTENER: ALL DBA role: connected by using user who has DBA role. $ sqlplus system@orcl. Enter password: ERROR: ORA-12526: TNS:listener: all appropriate instances are in restricted mode. Found!!! ORA-12526: TNS:listener: all appropriate instances are in restricted mode. Then solved it by changed TNSNAMES.ORA: using " (UR=A) ". QUEST_IN_ORACLEDBA: 2013 WorkArounds :-. 1) If archive exist on primary Troubleshoot the issue, It will automatically shipped if the archive is not corrupted. 2) If archive is corrupted at OS level, if we do have backup, Then Restore archivelogs from Backup. 3) Incremental SCN for standby/ Roll Forward. QUEST_IN_ORACLEDBA: QUERY TO FIND THE DDL OF A DATABASE Query to find the DDL of a database link in Oracle DatabaseSET LONG 9000SELECT DBMS_METADATA.GET_DDL (‘DB_LINK’,a.db_link,a.owner) FROM dba_db_links a; Posted by Dba Satheesh at 4:13 PM. Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest. QUEST_IN_ORACLEDBA: MRP0: BACKGROUND MEDIA RECOVERY RAC : 11gR2 Clusterware Startup Sequence For whoever that has worked with the 11gR2 version of RAC , has ran into the startup sequence QUEST_IN_ORACLEDBA: TNS ERROR: ORA-609 TNS-12537 11g: ORA-609 TNS-12537 and TNS-12547 or TNS-12170 in 11g Alert.log (Doc ID 1116960.1) To Bottom QUEST_IN_ORACLEDBA: ORACLE 12C: HOW TO CHANGE OPEN MODE OF When you need to modify the open mode of all your PDBs at the same time (look at this post if you want to change the open mode of only a specific pluggable database) QUEST_IN_ORACLEDBA: TOP 10 BIGGEST DATABASES IN THE WORLD hrough your life, you may have come across some very large collections. These collections can vary from things that you use in your day to day life to things such as stones or even bugs. QUEST_IN_ORACLEDBA: ORACLE RAC 2. Enterprise Manager: Enterprise Manager also lets you manage ASM instances through its GUI. 3. SRVCTL: This "server control" command line tool lets you control ASM instances along with database instances. 4. ASMCA: ASM Configuration Assistant.This GUI program lets you manage disk groups and volumes. ASM Authentication Oracle has introduced a new privilege called "SYSASM" for ASM instance QUEST_IN_ORACLEDBA: ORACLE HISTOGRAMS AND WHY??? In this short series on histograms we will be looking at the reasons why we need histograms and the methods Oracle has to create them. We will examine the costs of creating them, and the potential they introduce for undesirable overheads, and then review their potential for giving you stability problems in your execution plans. QUEST_IN_ORACLEDBA: RMAN 12C RESTRICTIONS ON PDB(PLUGGABLE If instead you connect directly to a PDB, you can use the same commands that you would use when connecting to a non-CDB.For example, to back up a PDB, you would use the BACKUP DATABASE command. QUEST_IN_ORACLEDBA: SOME INFORMATION ON INDEX REBUILDING There have been many discussions about whether rebuilding indexes is useful or not. Generally speaking, the need to rebuild b-tree indexes is very rare, basically because a b-tree index is largely self-managedor self-balanced.
QUEST_IN_ORACLEDBA: QUERY TO IDENTIFY THE SESSIONS CAUSING To find sessions generating lots of redo, you can use either of the following methods. Both methods examine the amount of undo generated. When a transaction generates undo, it will automatically generate redoas well.
QUEST_IN_ORACLEDBA: ORA-12526: TNS:LISTENER: ALL ORA-12526: TNS:listener: all appropriate instances are in restricted mode Nothing special just tested some about Database in Restricted M QUEST_IN_ORACLEDBA: ORACLE RAC -To read the ASM spfile during the ASM instance startup, it is not necessary to open the disk group. All information necessary to access the data is stored in the device’s header. QUEST_IN_ORACLEDBA: HOW TO INSTALL ODBC DRIVER FOR ORACLE Installation of the ODBC driver in Windows 7 is quite simple but there are a few tricks better to know. Here is a step-by-step instruction how to install the ODBC driver. QUEST_IN_ORACLEDBA: MOVE LOB SEGMENT AND INDEX TO A Anonymous said Topic was very well explained. Thank you for the note. Ab. January 8, 2015 at 12:59 AM QUEST_IN_ORACLEDBA: TOP 10 BIGGEST DATABASES IN THE WORLD hrough your life, you may have come across some very large collections. These collections can vary from things that you use in your day to day life to things such as stones or even bugs. QUEST_IN_ORACLEDBA: ORACLE HISTOGRAMS AND WHY??? In this short series on histograms we will be looking at the reasons why we need histograms and the methods Oracle has to create them. We will examine the costs of creating them, and the potential they introduce for undesirable overheads, and then review their potential for giving you stability problems in your execution plans. QUEST_IN_ORACLEDBA: ORACLE RAC 2. Enterprise Manager: Enterprise Manager also lets you manage ASM instances through its GUI. 3. SRVCTL: This "server control" command line tool lets you control ASM instances along with database instances. 4. ASMCA: ASM Configuration Assistant.This GUI program lets you manage disk groups and volumes. ASM Authentication Oracle has introduced a new privilege called "SYSASM" for ASM instance QUEST_IN_ORACLEDBA: RMAN 12C RESTRICTIONS ON PDB(PLUGGABLE If instead you connect directly to a PDB, you can use the same commands that you would use when connecting to a non-CDB.For example, to back up a PDB, you would use the BACKUP DATABASE command. QUEST_IN_ORACLEDBA: SOME INFORMATION ON INDEX REBUILDING There have been many discussions about whether rebuilding indexes is useful or not. Generally speaking, the need to rebuild b-tree indexes is very rare, basically because a b-tree index is largely self-managedor self-balanced.
QUEST_IN_ORACLEDBA: QUERY TO IDENTIFY THE SESSIONS CAUSING To find sessions generating lots of redo, you can use either of the following methods. Both methods examine the amount of undo generated. When a transaction generates undo, it will automatically generate redoas well.
QUEST_IN_ORACLEDBA: ORA-12526: TNS:LISTENER: ALL Opening the Database in Restricted Mode,that will only allow users with special privileges (RESTRICTED SESSION) SQL> select * from dba_sys_privs where privilege='RESTRICTED SESSION'; QUEST_IN_ORACLEDBA: ORACLE RAC Beginning with the version 11g Release 2, the ASM spfile is stored automatically in the first disk group created during Grid Infrastructure installation. QUEST_IN_ORACLEDBA: MOVE LOB SEGMENT AND INDEX TO A Anonymous said Topic was very well explained. Thank you for the note. Ab. January 8, 2015 at 12:59 AM QUEST_IN_ORACLEDBA: HOW TO INSTALL ODBC DRIVER FOR ORACLE Installation of the ODBC driver in Windows 7 is quite simple but there are a few tricks better to know. Here is a step-by-step instruction how to install the ODBC driver. QUEST_IN_ORACLEDBA: ARCHITECTURAL DIAGRAMS Overview: 1.Download psu patch and interim patch 2.Move to server 3.Check for conflict patch 4.Bring down the instance on each node toro
QUEST_IN_ORACLEDBA: AUTOMATED MAINTENANCE TASKS IN ORACLE 11G The Automatic Optimizer Statistics Collection task collects statistics for all objects with no or stale statistics. The Automatic Segment Advisor task provides advice on which database segments have free space that can be reclaimed. QUEST_IN_ORACLEDBA: ORA-12526: TNS:LISTENER: ALL ORA-12526: TNS:listener: all appropriate instances are in restricted mode Nothing special just tested some about Database in Restricted M QUEST_IN_ORACLEDBA: ORACLE RAC -To read the ASM spfile during the ASM instance startup, it is not necessary to open the disk group. All information necessary to access the data is stored in the device’s header. QUEST_IN_ORACLEDBA: ORACLE 11.2.0.4 RELEASED( TERMINAL 1.4 Database Replay Support for Database Consolidation Database Replay now supports simultaneous execution of multiple database captures on a single consolidated database. Consolidated database replay supports scheduling of the individual replays enabling investigations of various scenarios (for example, what if all my individual workloads hit their peak utilizations at the same time). QUEST_IN_ORACLEDBA: HOW TO INSTALL ODBC DRIVER FOR ORACLE Installation of the ODBC driver in Windows 7 is quite simple but there are a few tricks better to know. Here is a step-by-step instruction how to install the ODBC driver. QUEST_IN_ORACLEDBA: ORACLE 11GR2 RAC SERVICES CREATE How to see what services you have and where they are running: $ srvctl status service -d RAC Service CONTACT is running on instance(s) RAC1 QUEST_IN_ORACLEDBA: MOVE LOB SEGMENT AND INDEX TO A Anonymous said Topic was very well explained. Thank you for the note. Ab. January 8, 2015 at 12:59 AM QUEST_IN_ORACLEDBA: ORACLE 12C: WHAT HAPPENED TO ALL THE Got this from Johannes Ahrands Blog.. Very interesting.. Multi-Process Multi-Threaded Oracle If you are running Oracle databases on Unix or Linux you probably know that there are many processes even if no useris connected.
QUEST_IN_ORACLEDBA: RMAN Clone an Oracle database using a cold backup (same server) This procedure will clone a database using a cold copy of the sourcedatabase files.
QUEST_IN_ORACLEDBA: TOP 10 BIGGEST DATABASES IN THE WORLD hrough your life, you may have come across some very large collections. These collections can vary from things that you use in your day to day life to things such as stones or even bugs. QUEST_IN_ORACLEDBA: ORACLE RAC 2. Enterprise Manager: Enterprise Manager also lets you manage ASM instances through its GUI. 3. SRVCTL: This "server control" command line tool lets you control ASM instances along with database instances. 4. ASMCA: ASM Configuration Assistant.This GUI program lets you manage disk groups and volumes. ASM Authentication Oracle has introduced a new privilege called "SYSASM" for ASM instance QUEST_IN_ORACLEDBA: ORACLE HISTOGRAMS AND WHY??? In this short series on histograms we will be looking at the reasons why we need histograms and the methods Oracle has to create them. We will examine the costs of creating them, and the potential they introduce for undesirable overheads, and then review their potential for giving you stability problems in your execution plans. QUEST_IN_ORACLEDBA: RMAN 12C RESTRICTIONS ON PDB(PLUGGABLE If instead you connect directly to a PDB, you can use the same commands that you would use when connecting to a non-CDB.For example, to back up a PDB, you would use the BACKUP DATABASE command. QUEST_IN_ORACLEDBA: SOME INFORMATION ON INDEX REBUILDING There have been many discussions about whether rebuilding indexes is useful or not. Generally speaking, the need to rebuild b-tree indexes is very rare, basically because a b-tree index is largely self-managedor self-balanced.
QUEST_IN_ORACLEDBA: QUERY TO IDENTIFY THE SESSIONS CAUSING To find sessions generating lots of redo, you can use either of the following methods. Both methods examine the amount of undo generated. When a transaction generates undo, it will automatically generate redoas well.
QUEST_IN_ORACLEDBA: ORA-12526: TNS:LISTENER: ALL ORA-12526: TNS:listener: all appropriate instances are in restricted mode Nothing special just tested some about Database in Restricted M QUEST_IN_ORACLEDBA: ORACLE RAC -To read the ASM spfile during the ASM instance startup, it is not necessary to open the disk group. All information necessary to access the data is stored in the device’s header. QUEST_IN_ORACLEDBA: HOW TO INSTALL ODBC DRIVER FOR ORACLE Installation of the ODBC driver in Windows 7 is quite simple but there are a few tricks better to know. Here is a step-by-step instruction how to install the ODBC driver. QUEST_IN_ORACLEDBA: MOVE LOB SEGMENT AND INDEX TO A Anonymous said Topic was very well explained. Thank you for the note. Ab. January 8, 2015 at 12:59 AM QUEST_IN_ORACLEDBA: TOP 10 BIGGEST DATABASES IN THE WORLD hrough your life, you may have come across some very large collections. These collections can vary from things that you use in your day to day life to things such as stones or even bugs. QUEST_IN_ORACLEDBA: ORACLE RAC 2. Enterprise Manager: Enterprise Manager also lets you manage ASM instances through its GUI. 3. SRVCTL: This "server control" command line tool lets you control ASM instances along with database instances. 4. ASMCA: ASM Configuration Assistant.This GUI program lets you manage disk groups and volumes. ASM Authentication Oracle has introduced a new privilege called "SYSASM" for ASM instance QUEST_IN_ORACLEDBA: ORACLE HISTOGRAMS AND WHY??? In this short series on histograms we will be looking at the reasons why we need histograms and the methods Oracle has to create them. We will examine the costs of creating them, and the potential they introduce for undesirable overheads, and then review their potential for giving you stability problems in your execution plans. QUEST_IN_ORACLEDBA: RMAN 12C RESTRICTIONS ON PDB(PLUGGABLE If instead you connect directly to a PDB, you can use the same commands that you would use when connecting to a non-CDB.For example, to back up a PDB, you would use the BACKUP DATABASE command. QUEST_IN_ORACLEDBA: SOME INFORMATION ON INDEX REBUILDING There have been many discussions about whether rebuilding indexes is useful or not. Generally speaking, the need to rebuild b-tree indexes is very rare, basically because a b-tree index is largely self-managedor self-balanced.
QUEST_IN_ORACLEDBA: QUERY TO IDENTIFY THE SESSIONS CAUSING To find sessions generating lots of redo, you can use either of the following methods. Both methods examine the amount of undo generated. When a transaction generates undo, it will automatically generate redoas well.
QUEST_IN_ORACLEDBA: ORA-12526: TNS:LISTENER: ALL ORA-12526: TNS:listener: all appropriate instances are in restricted mode Nothing special just tested some about Database in Restricted M QUEST_IN_ORACLEDBA: ORACLE RAC -To read the ASM spfile during the ASM instance startup, it is not necessary to open the disk group. All information necessary to access the data is stored in the device’s header. QUEST_IN_ORACLEDBA: HOW TO INSTALL ODBC DRIVER FOR ORACLE Installation of the ODBC driver in Windows 7 is quite simple but there are a few tricks better to know. Here is a step-by-step instruction how to install the ODBC driver. QUEST_IN_ORACLEDBA: MOVE LOB SEGMENT AND INDEX TO A Anonymous said Topic was very well explained. Thank you for the note. Ab. January 8, 2015 at 12:59 AM QUEST_IN_ORACLEDBA: ARCHITECTURAL DIAGRAMS Overview: 1.Download psu patch and interim patch 2.Move to server 3.Check for conflict patch 4.Bring down the instance on each node toro
QUEST_IN_ORACLEDBA: AUTOMATED MAINTENANCE TASKS IN ORACLE 11G The Automatic Optimizer Statistics Collection task collects statistics for all objects with no or stale statistics. The Automatic Segment Advisor task provides advice on which database segments have free space that can be reclaimed. QUEST_IN_ORACLEDBA: ORA-12526: TNS:LISTENER: ALL ORA-12526: TNS:listener: all appropriate instances are in restricted mode Nothing special just tested some about Database in Restricted M QUEST_IN_ORACLEDBA: ORACLE RAC -To read the ASM spfile during the ASM instance startup, it is not necessary to open the disk group. All information necessary to access the data is stored in the device’s header. QUEST_IN_ORACLEDBA: ORACLE 11.2.0.4 RELEASED( TERMINAL 1.4 Database Replay Support for Database Consolidation Database Replay now supports simultaneous execution of multiple database captures on a single consolidated database. Consolidated database replay supports scheduling of the individual replays enabling investigations of various scenarios (for example, what if all my individual workloads hit their peak utilizations at the same time). QUEST_IN_ORACLEDBA: HOW TO INSTALL ODBC DRIVER FOR ORACLE Installation of the ODBC driver in Windows 7 is quite simple but there are a few tricks better to know. Here is a step-by-step instruction how to install the ODBC driver. QUEST_IN_ORACLEDBA: ORACLE 11GR2 RAC SERVICES CREATE How to see what services you have and where they are running: $ srvctl status service -d RAC Service CONTACT is running on instance(s) RAC1 QUEST_IN_ORACLEDBA: MOVE LOB SEGMENT AND INDEX TO A Anonymous said Topic was very well explained. Thank you for the note. Ab. January 8, 2015 at 12:59 AM QUEST_IN_ORACLEDBA: ORACLE 12C: WHAT HAPPENED TO ALL THE Got this from Johannes Ahrands Blog.. Very interesting.. Multi-Process Multi-Threaded Oracle If you are running Oracle databases on Unix or Linux you probably know that there are many processes even if no useris connected.
QUEST_IN_ORACLEDBA: RMAN Clone an Oracle database using a cold backup (same server) This procedure will clone a database using a cold copy of the sourcedatabase files.
QUEST_IN_ORACLEDBA: TOP 10 BIGGEST DATABASES IN THE WORLDBEST DATABASEIN THE WORLD
Also AT&T has one of the largest database with most number of rows (around 1.9 Trillion), second to Sprint. It’s said that AT&T has been recording the details of callers long before terabytes storing came into market. 4. Google: The giants in internet searching- Google bags the number 4th spot in top 10 largest databases. QUEST_IN_ORACLEDBA: ORACLE RAC It is an alternative to other file systems and volume managers. Oracle recommends using ASM as storage manager. 2. ASM Disk. Every physical disk in ASM is called an ASM disk. Every disk has a device name in operating system For example the first scsi disk in a Linux OS is named "sda" unless defined otherwise. 1. QUEST_IN_ORACLEDBA: ORACLE HISTOGRAMS AND WHY??? In this short series on histograms we will be looking at the reasons why we need histograms and the methods Oracle has to create them. We will examine the costs of creating them, and the potential they introduce for undesirable overheads, and then review their potential for giving you stability problems in your execution plans. QUEST_IN_ORACLEDBA: RMAN 12C RESTRICTIONS ON PDB(PLUGGABLE To perform operations on a single PDB, you can connect as target either to the root or directly to the PDB. If you connect to the root, you must use the PLUGGABLE DATABASE syntax in your RMAN commands. For example, to back up a PDB, you use the BACKUP PLUGGABLE DATABASE command. If instead you connect directly to a PDB, you can use thesame
QUEST_IN_ORACLEDBA: QUERY TO IDENTIFY THE SESSIONS CAUSING Query to identify the sessions causing huge archive log generation. Check which session is generating more redo. To find sessions generating lots of redo, you can use either of the following methods. Both methods examine the amount of undo generated. When a transaction generates undo, it will automatically generate redo as well. QUEST_IN_ORACLEDBA: ARCHITECTURAL DIAGRAMS Overview: 1.Download psu patch and interim patch 2.Move to server 3.Check for conflict patch 4.Bring down the instance on each node toro
QUEST_IN_ORACLEDBA: ORA-12526: TNS:LISTENER: ALL DBA role: connected by using user who has DBA role. $ sqlplus system@orcl. Enter password: ERROR: ORA-12526: TNS:listener: all appropriate instances are in restricted mode. Found!!! ORA-12526: TNS:listener: all appropriate instances are in restricted mode. Then solved it by changed TNSNAMES.ORA: using " (UR=A) ". QUEST_IN_ORACLEDBA: ASM DISKGROUP SPACE USAGE QUERIESASM DISKGROUP QUERYASM DISKGROUP STATUSMOUNT ASM DISKGROUPASM ADD DISKGROUPCREATE DISKGROUPORACLE ASM CREATE DISKGROUP From Gavin Soorma: Monitor space used in ASM Disk Groups SET LINESIZE 145 SET PAGESIZE 9999 SET VERIFY off COLUMN group_name QUEST_IN_ORACLEDBA: HOW TO INSTALL ODBC DRIVER FOR ORACLE 1. cd c:\oracle\instant_client_11. and then – still in cmd, install ODBC: 1. odbc_install.exe. When successfully, you should get the following info: 1. Oracle ODBC Driver is installed successfully. So, right now we can configure ODBC connection: choose Control Panel, then Administrative Tools, then Data Sources (ODBC), then System DNS and QUEST_IN_ORACLEDBA: TNS ERROR: ORA-609 TNS-12537 11g: ORA-609 TNS-12537 and TNS-12547 or TNS-12170 in 11g Alert.log (Doc ID 1116960.1) To Bottom QUEST_IN_ORACLEDBA: TOP 10 BIGGEST DATABASES IN THE WORLDBEST DATABASEIN THE WORLD
Also AT&T has one of the largest database with most number of rows (around 1.9 Trillion), second to Sprint. It’s said that AT&T has been recording the details of callers long before terabytes storing came into market. 4. Google: The giants in internet searching- Google bags the number 4th spot in top 10 largest databases. QUEST_IN_ORACLEDBA: ORACLE RAC It is an alternative to other file systems and volume managers. Oracle recommends using ASM as storage manager. 2. ASM Disk. Every physical disk in ASM is called an ASM disk. Every disk has a device name in operating system For example the first scsi disk in a Linux OS is named "sda" unless defined otherwise. 1. QUEST_IN_ORACLEDBA: ORACLE HISTOGRAMS AND WHY??? In this short series on histograms we will be looking at the reasons why we need histograms and the methods Oracle has to create them. We will examine the costs of creating them, and the potential they introduce for undesirable overheads, and then review their potential for giving you stability problems in your execution plans. QUEST_IN_ORACLEDBA: RMAN 12C RESTRICTIONS ON PDB(PLUGGABLE To perform operations on a single PDB, you can connect as target either to the root or directly to the PDB. If you connect to the root, you must use the PLUGGABLE DATABASE syntax in your RMAN commands. For example, to back up a PDB, you use the BACKUP PLUGGABLE DATABASE command. If instead you connect directly to a PDB, you can use thesame
QUEST_IN_ORACLEDBA: QUERY TO IDENTIFY THE SESSIONS CAUSING Query to identify the sessions causing huge archive log generation. Check which session is generating more redo. To find sessions generating lots of redo, you can use either of the following methods. Both methods examine the amount of undo generated. When a transaction generates undo, it will automatically generate redo as well. QUEST_IN_ORACLEDBA: ARCHITECTURAL DIAGRAMS Overview: 1.Download psu patch and interim patch 2.Move to server 3.Check for conflict patch 4.Bring down the instance on each node toro
QUEST_IN_ORACLEDBA: ORA-12526: TNS:LISTENER: ALL DBA role: connected by using user who has DBA role. $ sqlplus system@orcl. Enter password: ERROR: ORA-12526: TNS:listener: all appropriate instances are in restricted mode. Found!!! ORA-12526: TNS:listener: all appropriate instances are in restricted mode. Then solved it by changed TNSNAMES.ORA: using " (UR=A) ". QUEST_IN_ORACLEDBA: ASM DISKGROUP SPACE USAGE QUERIESASM DISKGROUP QUERYASM DISKGROUP STATUSMOUNT ASM DISKGROUPASM ADD DISKGROUPCREATE DISKGROUPORACLE ASM CREATE DISKGROUP From Gavin Soorma: Monitor space used in ASM Disk Groups SET LINESIZE 145 SET PAGESIZE 9999 SET VERIFY off COLUMN group_name QUEST_IN_ORACLEDBA: HOW TO INSTALL ODBC DRIVER FOR ORACLE 1. cd c:\oracle\instant_client_11. and then – still in cmd, install ODBC: 1. odbc_install.exe. When successfully, you should get the following info: 1. Oracle ODBC Driver is installed successfully. So, right now we can configure ODBC connection: choose Control Panel, then Administrative Tools, then Data Sources (ODBC), then System DNS and QUEST_IN_ORACLEDBA: TNS ERROR: ORA-609 TNS-12537 11g: ORA-609 TNS-12537 and TNS-12547 or TNS-12170 in 11g Alert.log (Doc ID 1116960.1) To Bottom QUEST_IN_ORACLEDBA: ARCHITECTURAL DIAGRAMS Overview: 1.Download psu patch and interim patch 2.Move to server 3.Check for conflict patch 4.Bring down the instance on each node toro
QUEST_IN_ORACLEDBA: MOVE LOB SEGMENT AND INDEX TO A Above command will move the table to new tablespace but will not move the. CLOB segment and it will still be in original tablespace. This is because LOB. data is stored outside of the table. Check the tablespace of the CLOB column by issuing following sql. SELECT index_name, tablespace_name. FROM user_indexes WHERE table_name = 'IMAGE'; QUEST_IN_ORACLEDBA: RAC : 11GR2 CLUSTERWARE STARTUP SEQUENCE Short summary of the startup sequence: INIT spawns init.ohasd (with respawn) which in turn starts the OHASD process (Oracle High Availability Services Daemon). This daemon spawns 4 processes. Level 1: OHASD Spawns: cssdagent - Agent responsible for spawning CSSD. orarootagent - Agent responsible for managing all root owned ohasdresources.
QUEST_IN_ORACLEDBA: ORA-12526: TNS:LISTENER: ALL DBA role: connected by using user who has DBA role. $ sqlplus system@orcl. Enter password: ERROR: ORA-12526: TNS:listener: all appropriate instances are in restricted mode. Found!!! ORA-12526: TNS:listener: all appropriate instances are in restricted mode. Then solved it by changed TNSNAMES.ORA: using " (UR=A) ". QUEST_IN_ORACLEDBA: ORACLE FLASH BACK TECHNOLOGY In this series of articles, we are discussing the collection of tools that make up the Oracle Flashback Technology suite. They are varied in their purpose and in their implementation, but together they act very much like a morning-after pill for your database, a means by which developers and administrators can protect their database from immediate past errors and indiscretions. QUEST_IN_ORACLEDBA: QUERY TO FIND THE DDL OF A DATABASE Query to find the DDL of a database link in Oracle DatabaseSET LONG 9000SELECT DBMS_METADATA.GET_DDL (‘DB_LINK’,a.db_link,a.owner) FROM dba_db_links a; Posted by Dba Satheesh at 4:13 PM. Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest. QUEST_IN_ORACLEDBA: 2013 WorkArounds :-. 1) If archive exist on primary Troubleshoot the issue, It will automatically shipped if the archive is not corrupted. 2) If archive is corrupted at OS level, if we do have backup, Then Restore archivelogs from Backup. 3) Incremental SCN for standby/ Roll Forward. QUEST_IN_ORACLEDBA: TNS ERROR: ORA-609 TNS-12537 11g: ORA-609 TNS-12537 and TNS-12547 or TNS-12170 in 11g Alert.log (Doc ID 1116960.1) To Bottom QUEST_IN_ORACLEDBA: ORACLE RAC -To read the ASM spfile during the ASM instance startup, it is not necessary to open the disk group. All information necessary to access the data is stored in the device’s header. QUEST_IN_ORACLEDBA: OS SYSTEM DEPENDENT OPERATION:FORK 1. Check your swap space and increase swap area in system. Because due to lack of space in swap are Oracle unable to create new process and PSP0 Process SPwaner is unable to QUEST_IN_ORACLEDBA: TOP 10 BIGGEST DATABASES IN THE WORLDBEST DATABASEIN THE WORLD
Also AT&T has one of the largest database with most number of rows (around 1.9 Trillion), second to Sprint. It’s said that AT&T has been recording the details of callers long before terabytes storing came into market. 4. Google: The giants in internet searching- Google bags the number 4th spot in top 10 largest databases. QUEST_IN_ORACLEDBA: ORACLE RAC It is an alternative to other file systems and volume managers. Oracle recommends using ASM as storage manager. 2. ASM Disk. Every physical disk in ASM is called an ASM disk. Every disk has a device name in operating system For example the first scsi disk in a Linux OS is named "sda" unless defined otherwise. 1. QUEST_IN_ORACLEDBA: ORACLE HISTOGRAMS AND WHY??? In this short series on histograms we will be looking at the reasons why we need histograms and the methods Oracle has to create them. We will examine the costs of creating them, and the potential they introduce for undesirable overheads, and then review their potential for giving you stability problems in your execution plans. QUEST_IN_ORACLEDBA: RMAN 12C RESTRICTIONS ON PDB(PLUGGABLE To perform operations on a single PDB, you can connect as target either to the root or directly to the PDB. If you connect to the root, you must use the PLUGGABLE DATABASE syntax in your RMAN commands. For example, to back up a PDB, you use the BACKUP PLUGGABLE DATABASE command. If instead you connect directly to a PDB, you can use thesame
QUEST_IN_ORACLEDBA: QUERY TO IDENTIFY THE SESSIONS CAUSING Query to identify the sessions causing huge archive log generation. Check which session is generating more redo. To find sessions generating lots of redo, you can use either of the following methods. Both methods examine the amount of undo generated. When a transaction generates undo, it will automatically generate redo as well. QUEST_IN_ORACLEDBA: ARCHITECTURAL DIAGRAMS Overview: 1.Download psu patch and interim patch 2.Move to server 3.Check for conflict patch 4.Bring down the instance on each node toro
QUEST_IN_ORACLEDBA: ORA-12526: TNS:LISTENER: ALL DBA role: connected by using user who has DBA role. $ sqlplus system@orcl. Enter password: ERROR: ORA-12526: TNS:listener: all appropriate instances are in restricted mode. Found!!! ORA-12526: TNS:listener: all appropriate instances are in restricted mode. Then solved it by changed TNSNAMES.ORA: using " (UR=A) ". QUEST_IN_ORACLEDBA: ASM DISKGROUP SPACE USAGE QUERIESASM DISKGROUP QUERYASM DISKGROUP STATUSMOUNT ASM DISKGROUPASM ADD DISKGROUPCREATE DISKGROUPORACLE ASM CREATE DISKGROUP From Gavin Soorma: Monitor space used in ASM Disk Groups SET LINESIZE 145 SET PAGESIZE 9999 SET VERIFY off COLUMN group_name QUEST_IN_ORACLEDBA: HOW TO INSTALL ODBC DRIVER FOR ORACLE 1. cd c:\oracle\instant_client_11. and then – still in cmd, install ODBC: 1. odbc_install.exe. When successfully, you should get the following info: 1. Oracle ODBC Driver is installed successfully. So, right now we can configure ODBC connection: choose Control Panel, then Administrative Tools, then Data Sources (ODBC), then System DNS and QUEST_IN_ORACLEDBA: TNS ERROR: ORA-609 TNS-12537 11g: ORA-609 TNS-12537 and TNS-12547 or TNS-12170 in 11g Alert.log (Doc ID 1116960.1) To Bottom QUEST_IN_ORACLEDBA: TOP 10 BIGGEST DATABASES IN THE WORLDBEST DATABASEIN THE WORLD
Also AT&T has one of the largest database with most number of rows (around 1.9 Trillion), second to Sprint. It’s said that AT&T has been recording the details of callers long before terabytes storing came into market. 4. Google: The giants in internet searching- Google bags the number 4th spot in top 10 largest databases. QUEST_IN_ORACLEDBA: ORACLE RAC It is an alternative to other file systems and volume managers. Oracle recommends using ASM as storage manager. 2. ASM Disk. Every physical disk in ASM is called an ASM disk. Every disk has a device name in operating system For example the first scsi disk in a Linux OS is named "sda" unless defined otherwise. 1. QUEST_IN_ORACLEDBA: ORACLE HISTOGRAMS AND WHY??? In this short series on histograms we will be looking at the reasons why we need histograms and the methods Oracle has to create them. We will examine the costs of creating them, and the potential they introduce for undesirable overheads, and then review their potential for giving you stability problems in your execution plans. QUEST_IN_ORACLEDBA: RMAN 12C RESTRICTIONS ON PDB(PLUGGABLE To perform operations on a single PDB, you can connect as target either to the root or directly to the PDB. If you connect to the root, you must use the PLUGGABLE DATABASE syntax in your RMAN commands. For example, to back up a PDB, you use the BACKUP PLUGGABLE DATABASE command. If instead you connect directly to a PDB, you can use thesame
QUEST_IN_ORACLEDBA: QUERY TO IDENTIFY THE SESSIONS CAUSING Query to identify the sessions causing huge archive log generation. Check which session is generating more redo. To find sessions generating lots of redo, you can use either of the following methods. Both methods examine the amount of undo generated. When a transaction generates undo, it will automatically generate redo as well. QUEST_IN_ORACLEDBA: ARCHITECTURAL DIAGRAMS Overview: 1.Download psu patch and interim patch 2.Move to server 3.Check for conflict patch 4.Bring down the instance on each node toro
QUEST_IN_ORACLEDBA: ORA-12526: TNS:LISTENER: ALL DBA role: connected by using user who has DBA role. $ sqlplus system@orcl. Enter password: ERROR: ORA-12526: TNS:listener: all appropriate instances are in restricted mode. Found!!! ORA-12526: TNS:listener: all appropriate instances are in restricted mode. Then solved it by changed TNSNAMES.ORA: using " (UR=A) ". QUEST_IN_ORACLEDBA: ASM DISKGROUP SPACE USAGE QUERIESASM DISKGROUP QUERYASM DISKGROUP STATUSMOUNT ASM DISKGROUPASM ADD DISKGROUPCREATE DISKGROUPORACLE ASM CREATE DISKGROUP From Gavin Soorma: Monitor space used in ASM Disk Groups SET LINESIZE 145 SET PAGESIZE 9999 SET VERIFY off COLUMN group_name QUEST_IN_ORACLEDBA: HOW TO INSTALL ODBC DRIVER FOR ORACLE 1. cd c:\oracle\instant_client_11. and then – still in cmd, install ODBC: 1. odbc_install.exe. When successfully, you should get the following info: 1. Oracle ODBC Driver is installed successfully. So, right now we can configure ODBC connection: choose Control Panel, then Administrative Tools, then Data Sources (ODBC), then System DNS and QUEST_IN_ORACLEDBA: TNS ERROR: ORA-609 TNS-12537 11g: ORA-609 TNS-12537 and TNS-12547 or TNS-12170 in 11g Alert.log (Doc ID 1116960.1) To Bottom QUEST_IN_ORACLEDBA: ARCHITECTURAL DIAGRAMS Overview: 1.Download psu patch and interim patch 2.Move to server 3.Check for conflict patch 4.Bring down the instance on each node toro
QUEST_IN_ORACLEDBA: MOVE LOB SEGMENT AND INDEX TO A Above command will move the table to new tablespace but will not move the. CLOB segment and it will still be in original tablespace. This is because LOB. data is stored outside of the table. Check the tablespace of the CLOB column by issuing following sql. SELECT index_name, tablespace_name. FROM user_indexes WHERE table_name = 'IMAGE'; QUEST_IN_ORACLEDBA: RAC : 11GR2 CLUSTERWARE STARTUP SEQUENCE Short summary of the startup sequence: INIT spawns init.ohasd (with respawn) which in turn starts the OHASD process (Oracle High Availability Services Daemon). This daemon spawns 4 processes. Level 1: OHASD Spawns: cssdagent - Agent responsible for spawning CSSD. orarootagent - Agent responsible for managing all root owned ohasdresources.
QUEST_IN_ORACLEDBA: ORA-12526: TNS:LISTENER: ALL DBA role: connected by using user who has DBA role. $ sqlplus system@orcl. Enter password: ERROR: ORA-12526: TNS:listener: all appropriate instances are in restricted mode. Found!!! ORA-12526: TNS:listener: all appropriate instances are in restricted mode. Then solved it by changed TNSNAMES.ORA: using " (UR=A) ". QUEST_IN_ORACLEDBA: ORACLE FLASH BACK TECHNOLOGY In this series of articles, we are discussing the collection of tools that make up the Oracle Flashback Technology suite. They are varied in their purpose and in their implementation, but together they act very much like a morning-after pill for your database, a means by which developers and administrators can protect their database from immediate past errors and indiscretions. QUEST_IN_ORACLEDBA: QUERY TO FIND THE DDL OF A DATABASE Query to find the DDL of a database link in Oracle DatabaseSET LONG 9000SELECT DBMS_METADATA.GET_DDL (‘DB_LINK’,a.db_link,a.owner) FROM dba_db_links a; Posted by Dba Satheesh at 4:13 PM. Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest. QUEST_IN_ORACLEDBA: 2013 WorkArounds :-. 1) If archive exist on primary Troubleshoot the issue, It will automatically shipped if the archive is not corrupted. 2) If archive is corrupted at OS level, if we do have backup, Then Restore archivelogs from Backup. 3) Incremental SCN for standby/ Roll Forward. QUEST_IN_ORACLEDBA: TNS ERROR: ORA-609 TNS-12537 11g: ORA-609 TNS-12537 and TNS-12547 or TNS-12170 in 11g Alert.log (Doc ID 1116960.1) To Bottom QUEST_IN_ORACLEDBA: ORACLE RAC -To read the ASM spfile during the ASM instance startup, it is not necessary to open the disk group. All information necessary to access the data is stored in the device’s header. QUEST_IN_ORACLEDBA: OS SYSTEM DEPENDENT OPERATION:FORK 1. Check your swap space and increase swap area in system. Because due to lack of space in swap are Oracle unable to create new process and PSP0 Process SPwaner is unable toQUEST_IN_ORACLEDBA
THURSDAY, MARCH 3, 2016 ORA-15040: DISKGROUP IS INCOMPLETE ORA-15040: DISKGROUP IS INCOMPLETE I received this error while I was trying to bring up cluster on the second in my 2-node cluster. When I tried to start cluster, ora.asm resource was found inintermediate state.
# crsctl start cluster CRS-5702: Resource 'ora.evmd' is already running on 'host02' CRS-2800: Cannot start resource 'ora.asm' as it is already in the INTERMEDIATE state on server 'host02' CRS-4000: Command Start failed, or completed with errors. – SINCE ASM WAS NOT UP, OCR COULD NOT BE READ AND HENCE CLUSTERCOULD NOT COME UP
# crsctl stat res -t -init -------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS --------------------------------------------------------------------------------Cluster Resources
--------------------------------------------------------------------------------ora.asm
1 ONLINE INTERMEDIATE host02 OCR not started – THE ALERT LOG SHOWED THAT DATA DISKGROUP COULD NOT BE MOUNTED. 2013-09-04 13:55:38.896CRS-5019:ALL OCR
LOCATIONS ARE ON ASM DISK GROUPS , AND NONE OF THESE DISK GROUPS ARE MOUNTED. Details are at “(:CLSN00100:)” in “/u01/app/11.2.0/grid/log/host02/agent/ohasd/oraagent_grid/oraagent_grid.log”. – I TRIED TO MOUNT DATA DISKGROUP USING SQL BUT I GOT ORA-15040 WHICH INDICATED THAT DISK “0” COULD NOT BE READ SQL> alter diskgroup data mount; alter diskgroup data mount*
ERROR at line 1:
ORA-15032: not all alterations performed ORA-15040: diskgroup is incomplete ORA-15042: ASM disk "0" is missing from group number "1" – WHEN I LISTED ASM DISKS ON SECOND NODE, ASMDISK01 WAS NOT LISTED # oracleasm listdisksASMDISK010
ASMDISK011
ASMDISK012
ASMDISK013
ASMDISK014
ASMDISK02
ASMDISK03
ASMDISK04
ASMDISK05
ASMDISK06
ASMDISK07
ASMDISK08
ASMDISK09
– I ISSUED ORACLEASM SCANDISKS WHICH LED TO DISCOVERY OF ASMDISK01 # oracleasm scandisks Reloading disk partitions: done Cleaning any stale ASM disks... Scanning system for ASM disks... INSTANTIATING DISK "ASMDISK01" – NOW WHEN I ISSUED ORACLEASM LISTDISKS, ASMDISK01 WAS ALSO LISTED. # oracleasm listdisksASMDISK01
ASMDISK010
ASMDISK011
ASMDISK012
ASMDISK013
ASMDISK014
ASMDISK02
ASMDISK03
ASMDISK04
ASMDISK05
ASMDISK06
ASMDISK07
ASMDISK08
ASMDISK09
— Now I could mount DATA diskgroup successfully SQL> alter diskgroup data mount;DISKGROUP ALTERED.
REFERENCE:HTTP://ORACLEINACTION.COM/ORA-15040/ Posted by Dba Satheeshat 5:08 PM
Reactions:
No comments:
Links to this post
Email This
BlogThis!
Share
to Twitter
Share
to Facebook
Share
to Pinterest
Labels: Oracle errors and solutions,
Oracle RAC
WEDNESDAY, FEBRUARY 17, 2016 GATHER OPTIMIZER STATISTICS, 11G GATHER OPTIMIZER STATISTICS, 11G In Oracle 11g: The automatic statistics gathering job for Oracle 11g is an internal procedure named GATHER_DATABASE_STATS_JOB_PROC. Below are the steps in case if we want to delete & gather schema stats on adhoc basis. GATHERING STATISTICS FOR ALL OBJECTS IN A SCHEMA * Ensure that the automatic statistics gathering job is scheduled, using the following SQL. SELECT ENABLED FROM DBA_SCHEDULER_PROGRAMS WHERE PROGRAM_NAME = 'GATHER_STATS_PROG'; Output should be 'TRUE'. NOTE: GATHER_STATS_PROG is the program that runs the internal procedure GATHER_DATABASE_STATS_JOB_PROC. * Delete any existing statistics, using the following command fromSQLPLUS.
EXEC DBMS_STATS.DELETE_SCHEMA_STATS('SCOTT'); * Change the default "ESTIMATE_PERCENT" to 100% for DBMS_STATS. Use the following procedure from SQLPLUS to change the default. Run this using the Oracle SYSDBA user ID: EXEC DBMS_STATS.SET_PARAM('ESTIMATE_PERCENT','100'); d. Run GATHER_DATABASE_STATS using the following command from SQLPLUS. Run this command using the Oracle SYSDBA user ID. EXEC DBMS_STATS.GATHER_DATABASE_STATS(ESTIMATE_PERCENT => DBMS_STATS.AUTO_SAMPLE_SIZE, METHOD_OPT => 'FOR ALL COLUMNS SIZE AUTO', DEGREE => 2, CASCADE => TRUE); GATHERING STATISTICS AN INDIVIDUAL TABLE exec dbms_stats.gather_table_stats( - ownname => ' Schema_name ', - tabname => ' Table_name ', - estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE, - cascade => TRUE, - method_opt => 'FOR ALL COLUMNS SIZE AUTO' ); NOTE: For a more cautious approach as outlined in the text above and where column statistics are known not to be beneficial, Replace: method_opt => 'FOR ALL COLUMNS SIZE AUTO'with
method_opt => 'FOR ALL COLUMNS SIZE 1' Note that the defaults for statistics gathering on different versions of Oracle are not necessarily the same, for example: * ESTIMATE_PERCENT: DEFAULTS:* 9i : 100%
* 10g : DBMS_STATS.AUTO_SAMPLE_SIZE (using very small estimatepercentage)
* 11g: DBMS_STATS.AUTO_SAMPLE_SIZE (using larger estimate percentage- 100%)
* METHOD_OPT: DEFAULTS: * 9i: "FOR ALL COLUMNS SIZE 1" effectively no detailed columnstatistics.
* 10g and 11g: "FOR ALL COLUMNS SIZE AUTO" - This setting means that DBMS_STATS decides which columns to add histogram to where it believes that they may help to produce a better plan. Posted by Dba Satheeshat 4:38 PM
Reactions:
No comments:
Links to this post
Email This
BlogThis!
Share
to Twitter
Share
to Facebook
Share
to Pinterest
Labels: Oracle jobs
Older Posts
Home
Subscribe to: Posts (Atom)SEARCH THIS BLOG
ABOUT ME
* Dba Satheesh
View my complete profile FOR CONSULTING SERVICES OR TRAININGS RELATED TO ORACLEFOLLOW BY EMAIL
TOTAL PAGEVIEWS
0
18
1
21
2
18
3
14
4
34
5
12
6
9
7
11
8
29
9
33
10
16
11
16
12
9
13
29
14
39
15
10
16
24
17
32
18
43
19
98
20
34
21
15
22
34
23
33
24
31
25
36
26
26
27
38
28
26
29
17
176035
LABELS
* cloud database migration* Hadoop/Bigdata
* Installation
* Interview questions* Invalid Objects
* Job openings
* Migration
* Motivation
* MySQL
* mysql failover
* ORACLE
* Oracle 12 C New features* Oracle 12c
* oracle ACLs
* Oracle architecture* Oracle backups
* Oracle Block Corruption* oracle database
* Oracle database health check * Oracle database Switch over procedure * Oracle Datagaurd- Standby database * Oracle DBA Interview questions * Oracle DBA query collection* oracle enqueue
* Oracle errors and solutions * Oracle Golden gate* Oracle indexes
* Oracle jobs
* Oracle Licensing information* Oracle Listener
* Oracle Materialized view queries * Oracle OraInventory * Oracle Performance tuning* Oracle queries
* Oracle RAC
* Oracle RAC upgrade * Oracle Row chaining * Oracle sessions related* oracle tables
* oracle users and privileges* recovery
* Recruitment
* Reference
* Resize standby redolog* RMAN
* RMAN duplication
* RMAN FULLBACKUP SCRIPT * rman restore and recovery* sqlserver
* sqlserver error and solutions * sqlserver restart time * sqlserver servicepack * sqlserver transactionlogs* statspack
* Tablespace
* unix for dba - www.oracle.com/technology/dba/index.html * Unix/Linux Related* Windows
BLOG ARCHIVE
* ▼ 2016 (11)
* ▼ March (1)
* ORA-15040: diskgroup is incomplete * ► February (8) * ► January (2)* ► 2015 (103)
* ► November (3) * ► October (9) * ► September (18) * ► August (21)* ► July (7)
* ► June (15)
* ► April (7)
* ► March (12)
* ► February (9) * ► January (2)* ► 2014 (87)
* ► December (3) * ► November (4) * ► October (11) * ► September (1)* ► August (6)
* ► July (10)
* ► June (22)
* ► May (4)
* ► April (4)
* ► March (7)
* ► February (8) * ► January (7)* ► 2013 (172)
* ► November (1) * ► October (15) * ► September (15) * ► August (65)* ► July (27)
* ► June (20)
* ► May (26)
* ► April (2)
* ► February (1)* ► 2012 (21)
* ► November (1) * ► October (3) * ► September (3)* ► August (3)
* ► July (3)
* ► June (3)
* ► May (1)
* ► February (1) * ► January (3)* ► 2011 (52)
* ► December (3) * ► November (1) * ► October (2)* ► August (1)
* ► July (1)
* ► June (6)
* ► May (38)
* ► 2009 (6)
* ► November (6)POPULAR POSTS
*
RAC : 11gR2 Clusterware Startup Sequence RAC : 11gR2 Clusterware Startup Sequence For whoever that has worked with the 11gR2 version of RAC , has ran into the startup sequence ...*
Top 10 Biggest Databases in the WORLD hrough your life, you may have come across some very large collections. These collections can vary from things that you use inyour day to ...
*
Oracle PSU patching - Oracle 11gR2 GRID environment - 3 node RAC Overview: 1.Download psu patch and interim patch 2.Move to server 3.Check for conflict patch 4.Bring down the instance on each node toro...
*
Move LOB Segment and Index to a different tablespace How to move a lob segment and a lob index to a differrent tablespace. =====================================================================...
*
Oracle Licensing Information 2 Options and Packs This chapter describes the separately licensed Oracle Database options, management packs, and other products you canpu...
*
Oracle 11.2.0.4 Released( Terminal Patchset for 11g R2) For further information about Release Schedules and Maintenance refer to “Release Schedule of Current Database Releases (Doc ID742060.1)”....
*
Upgrading Oracle RAC database 11.2.0.2 to 11.2.0.3 (Grid+DB) A nice link to demonstrate: http://www.gokhanatil.com/2011/09/upgrading-oracle-rac-database-11202-to.html*
RMAN - Clone an Oracle database using a cold backup (same server) Clone an Oracle database using a cold backup (same server) This procedure will clone a database using a cold copy of the sourcedatabase f...
*
Oracle Database 11.2.0.4 installation on Oracle Solaris Sparc server Oracle Database Quick Installation Guide 11 g Release 2 (11.2) for Oracle Solaris on SPARC (64-Bit) Reference: Oracle support link...*
TNS Error: ORA-609 TNS-12537 11g: ORA-609 TNS-12537 and TNS-12547 or TNS-12170 in...SUBSCRIBE TO
Posts
Atom
Posts
All Comments
Atom
All Comments
CONTACT FORM
Name
Email *
Message *
FOLLOWERS
Simple theme. Powered by Blogger .Details
6
Copyright © 2024 ArchiveBay.com. All rights reserved. Terms of Use | Privacy Policy | DMCA | 2021 | Feedback | Advertising | RSS 2.0