No question at this time
DBA Top 10
1 M. Cadot 83150
2 A. Kavsek 42300
3 J. Schnackenberg 39600
4 T. Boles 34850
5 B. Vroman 31900
6 P. Wisse 26600
7 H. Shahi 17100
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 registered47368
Total active users29899
Act. users last 24h22
Act. users last hour4
Hits last week1073
Hits last month4611
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
Thread 1 cannot allocate new log,Checkpoint not complete


Could you please help me out in the below issue.

the Database in No Archive Mode..
Mon... (4 repl.)
execute to parse %

Hi Guys

I have database that reflects a very low execute to parse 26.63 %. I checked the the pars... (2 repl.)
How to extract 2yrs data from a table with LONG RAW column

I am having a table with size 1.5 TB. I need to extract only for 2 yrs data . Other data will b... (11 repl.)
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... (6 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.)
--> 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...