No question at this time
DBA Top 10
1 M. Cadot 70900
2 J. Schnackenberg 41200
3 F. Diaz 33200
4 A. Kavsek 25550
5 P. Wisse 23250
6 B. Vroman 22850
7 T. Boles 21300
8 M. Hidayathullah ... 17000
9 A. Hudspith 11500
10 H. Shahi 10500
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Mar 02, 2016
(recommended update: build 1476)
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered47682
Total active users30175
Act. users last 24h16
Act. users last hour2
Hits last week528
Hits last month2497
Latest Forum Threads
Invalid username/password on instance shutdown

I know that I just have to be missing something in the documentation somewhere but I can not find it... (4 repl.)
COnfusion on creating Single Instance Standby

We are going to create a Single instance standby database from 2 node RAC database and the for that ... (1 repl.)
CRS on which network

What is deemed a good practice in configuring CRS ? Should CRS be configured on management hostnames... (1 repl.)
Purpose of the OCW patch on the DB Home?


could you please point me to documentation describing the purpose of applying OCW patch on... (3 repl.)
Slow query because of filter predicate

The following query is very slow because the subquery and the or in the where clause is pushed as a ... (2 repl.)
Grid Infrastructure upgrade

Hello All -

Am looking for details for accomplishing below items.

i) Upgrade GI from 11.2 to 1... (0 repl.)
list all tables used in a select


is there a method to list all tables used by a query.

I check in v$sql_plan but if a query... (2 repl.)
--> Start a new thread ...
What do you think of bigfile tablespaces?
Not used yet.
If it works, all well and good. Let's see eh?
We are not using bigfiles. Our main database is less than 3TB large, a...
No. Not using this type.
Not using this type of tablespace
Not used yet.
I need to give it some thought before I would recommend it. In most...