Fundamental of Data Dictionary in oracle database

Today let’s have look on the basic question of Oracle database. It will add some good knowledge in Oracle’s knowledge treasure. Normally in any interviews some of the questions ask for this topic example What is the difference between data dictionary views and dynamic performance views?, What do you mean by data dictionary views?   Let’s have look […]

Read More

Oracle Licenses

Despite reams of legalese and countless blog/forum posts, basic Oracle RDBMS licensing still remains a mystery to many. While I won’t even begin to discuss components like Oracle Apps, hopefully this post may help you attain a basic understanding of Oracle, what you can license, and what it costs. Editions The first and most important […]

Read More

Using the Remote Diagnostic Agent (RDA)

The Remote Diagnostic Agent (RDA) is an Oracle-provided diagnostic tool that captures data about your database environment and packages it into a web page report. When submitting a Service Request to Oracle Support, you will often be asked to run the Remote Diagnostic Agent (RDA) and upload the results.  This allows the support analyst to review […]

Read More

Methods for viewing SQL Execution Plans

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 | |* […]

Read More

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 […]

Read More

Startup And Shutdown Modes Of An Oracle Database

An oracle database can be started in various modes. Each mode is used by the DBA’s to perform some specific operation in the database. Nomount State:  We can bring database to nomount state from shutdown state. When we start an oracle database in nomount state then oracle will create the oracle instance. The instance is […]

Read More

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 […]

Read More

ORA-00600: internal error code, arguments: [kwqitnmphe:ltbagi]

Recently started seeing this error on few of the RAC environments.

As per metalink this is a known Bug 20987661 – Doc ID 20987661.8

This works until the database is restarted i.e. we’ll have to execute it every time, we restart the database. I’ve seen this in 11204 and 12102 both. As per […]

Read More

ORA-00600: internal error code, arguments: [ksprcvsp:ksfdread_resilver]

On an Oracle 11204 restart environment, ASM spfile creation failed with error ora-600

Fixed the problem, by adding the disk in ASM diskgroup

Post this change, I was able to create spfile without any issue. Metalink Doc ID 2096227.1

Read More

ORA-00600: internal error code, arguments: [kzsrgpw]

Recently I started getting ORA-00600 error, while I was trying to connect to SQLPlus

This was caused due to a corrupt password file. Re-creating password file fixed the issue.

Metalink Doc ID 1073283.1

Read More