Most of my databases are on version
10.1 or lower
Answer and see the results
DBA Top 10
1 M. Cadot 35500
2 F. Diaz 34000
3 J. Schnackenberg 16400
4 A. Kavsek 15250
4 B. Vroman 15250
6 P. Wisse 14250
7 T. Boles 13500
8 M. Hidayathullah ... 10900
9 A. Hudspith 9200
10 A. Khan 4100
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Sep 02, 2016
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users47787
Total active users2115
Act. users last 24h10
Act. users last hour1
Registered user hits last week731
Registered user hits last month6482
Latest Forum Threads
Capture column value change in another column in same table

Hi Gurus,

I would like to know if we can define a table to capture a date time stamp in a date co... (2 repl.)
Increased MRP0 Process


How to increase MRP process on standby database for fast recovery.

Thanks (1 repl.)
upgrade database to

Dear All,

I want to upgrade database from Oracle 11gR2 to

i have single instance 1... (5 repl.)
Temp Tablespace fillup !!

Hi Friends,
When i execute a query in prod,
It almost instantly starts filling up the temp tables... (4 repl.)
SYSAUX table space purging

Our SYSAUX tablespace is getting full rapidly. What are the options available to make the free space... (2 repl.)
Binding variable value to a column PSQL

In a cursor a fill to variable with data.
Variable "ATTRIBUUT" contains just text and variable "COL... (1 repl.)
Changing position of string

Dear DBA's

I need to change the position of string using SQL statement, below is the example whi... (15 repl.)
--> Start a new thread ...
What is your experience with 12c so far?
We are currently using 11.2, discussions are going to upgrade to 12c
Our customers still have 11.2, which is very stable.
Used it with Multitenant, not much issues. Ones of the databases has s...
Upgraded multiple customer databases from 11.2 to 12c. No big issues s...
We are using 12c ( for our some application and did not encou...
Big issues with containers and trying to limit resource usage to one p...
Not worked anywhere that uses it yet.