Using Autotrace SQL> set autotrace traceonly explain SQL> select ename from emp where sal > 500; Execution Plan ———————————————————- Plan hash value: 2872589290 ————————————————————————- | Id | Operation | Name | Rows | Bytes |Cost (%CPU)| Time | ————————————————————————- | 0 | SELECT STATEMENT | | 1 | 25 | 2 (0)| 00:00:01 | |* […]
Articles Tagged: Oracle Database
Quiescing a Oracle Database
There are times when a DBA needs to perform work on the database that requires no other ACTIVE sessions. This is very common is development databases, where a DBA tries to run a package or a modify a table when the application is till running. There are also frequent occurrences where too much IT support […]
Oracle Proxy Users
If you have required privileges, it’s possible to connect as a user account without knowing or changing his password. This is called proxy connection. To authorize a user account to connect using a proxy account, use the GRANT CONNECT THROUGH clause of the ALTER USER statement. Consider, we have a Application User called ‘APPUSR‘ and […]
ORA-00600: internal error code, arguments: [kwqitnmphe:ltbagi]
Recently started seeing this error on few of the RAC environments. Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl01/trace/orcl01_q002_5570998.trc: ORA-00600: internal error code, arguments: [kwqitnmphe:ltbagi], [1], [0], [], [], [], [], [], [], [], [], [] As per metalink this is a known Bug 20987661 – Doc ID 20987661.8 DECLARE po dbms_aqadm.aq$_purge_options_t; BEGIN po.block := FALSE; DBMS_AQADM.PURGE_QUEUE_TABLE( queue_table => […]
ORA-00600: internal error code, arguments: [ksprcvsp:ksfdread_resilver]
On an Oracle 11204 restart environment, ASM spfile creation failed with error ora-600 create spfile=’+DATA5′ from pfile=’/u03/asmpfile.ora’ * ERROR at line 1: ORA-01078: failure in processing system parameters ORA-00600: internal error code, arguments: [ksprcvsp:ksfdread_resilver],[0x0A2435D48], [3], [0x7F710EE38000], [512], [], [], [], [], [], [], [] This was caused due to a ASM disk with UNKNOWN HEADER_STATUS. […]
ORA-00600: internal error code, arguments: [kzsrgpw]
Recently I started getting ORA-00600 error, while I was trying to connect to SQLPlus sqlplus sys as sysdba SQL*Plus:Release 11.2.0.3.0 Production on Tue Jan 17 06:13:16 2017 Copyright (c) 1982, 2011, Oracle. All rights reserved. Enter password: ERROR: ORA-00600: internal error code, arguments: [kzsrgpw], [], [], [], [], [], [], [], [], [], [], [] […]
HugePages for Oracle
If you run a Oracle Database on a Linux Server with more than 16 GB physical memory and your System Global Area (SGA) is greater than 8 GB, you should configure HugePages. For large SGA sizes, HugePages can give substantial benefits in virtual memory management. Without HugePages, the memory of the SGA is divided into […]
Enabling Flashback Database in Oracle
Oracle Flashback Database, allows to quickly recover the entire database from logical data corruptions or user errors. It is very similar to PITR (Point In Time Recovery) which puts back the database to a state at a particular time in recent past. 1. Place your database in mount stage. sql>shutdown immediate sql>startup mount 2. Set DB_FLASHBACK_RETENTION_TARGET […]
Enable Archive Log Mode In Oracle RAC
1. stop the database service. srvctl stop database -d RAC 2. start the database in mount state. srvctl start database -d RAC -o mount 3. enable archive log mode. SQL> alter database archivelog; Database altered. 4. Restart the database service (using srvctl) srvctl stop database -d RAC srvctl start database -d RAC 5. set the […]
Recreate Oracle Central Inventory
Inventory is the index for the oracle installation. All the details about the ORACLE_HOME including different utility versions, patch details etc. If you do a fresh Oracle installation the inventory will be updated. But if you copy the ORACLE binaries from some other location and if you are not updating the inventory, we cannot read […]