No question at this time
DBA Top 10
1 M. Cadot 82750
2 A. Kavsek 42200
3 J. Schnackenberg 39400
4 T. Boles 34650
5 B. Vroman 32100
6 P. Wisse 26400
7 H. Shahi 17000
8 J. Péran 12450
9 K. Subramaniam 12300
10 M. Hidayathullah ... 11600
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Apr 07, 2015
(recommended update: build 1462)
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered47366
Total active users29894
Act. users last 24h11
Act. users last hour0
Hits last week1136
Hits last month4442
Tips, Scripts, Papers, Events, Links, ...
Tip:retrieving oracle internal information

vijay kaushik, May 19
Link:Oracle 12c new features summary

Karthick T, Apr 21
Paper:Oracle RAC Upgrade from to

Shakti Agarwal, Mar 31
Tip:ORAchk new version is out.

Adam Hudspith, Mar 24
Link:Oracle sgadef file info

Karthick T, Mar 10
Latest Forum Threads
Obtain last sequence Number for db clone


I would like to take a clone of a database and have all the necessary steps. However
one c... (5 repl.)
What is the default compression algorithm in 11gR2 RMAN


I am working on to reduce the RMAN backup size in 11gR2. We do not have Advance Compression l... (5 repl.)
how to get the current code package and module from dbms_utility.format_call_stack

after finding the package, function or procedure name of the current running code or exception and t... (2 repl.)
Anyone know how to find out which plsql is running in v$session?

In v$session there are 4 columns(2 pairs) that tell about running stored procedures:
Plsql_entry_... (2 repl.)
Virtual RAC

What are your thoughts/experiences on running Oracle RAC on a virtual environment?

A few years ag... (2 repl.)
upgrade adf


I want to update ADF to with Weblogic 10.3.5

Please guide

Thank... (2 repl.)
Very Poor performance by SQLS

hi DBAs..

I am facing issue with two SQLs.

Below are the explain plans.

| Id | Operation ... (8 repl.)
--> Start a new thread ...
How do you handle flash/SSD disks on your SAN?
We dont use flash/SSD disks.
The future is here, it’s just not widely distributed.
we dont have flash/ssd disks and if available it will be handle by sto...
Haven't seen flash disk in SAN yet , but yes have seen the performance...
I manage our SAN, it is interesting. I have placed the undo tablespace...
Yes, I work with SAN most of the times but I don't know the underlying...