11g Dynamic v$ Performance Views

In this post, we are gonna have look on some important views of Oracle Database. The follow v$ views are used by the new 11g result cache:

The Oracle 11g RAT suite includes database replay and the following v$ view provides details on usage and status for this key new 11g feature with Oracle. […]

Read More

Data Dictionary Architecture in Oracle Database

Till today date normally we all know about Oracle Database Architecture. As we take one step forward in Oracle world we get introduces new terms and technology in Oracle. In this post let’s have a look on data dictionary architecture. Which might be new for you but I am sure it will be more interesting as Oracle Database architecture. […]

Read More

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