No question at this time
DBA Top 10
1 M. Cadot 26200
2 A. Kavsek 16900
3 B. Vroman 11000
4 M. Hidayathullah ... 10500
5 T. Boles 7600
6 F. Diaz 6700
7 P. Wisse 6400
8 J. Schnackenberg 4700
9 A. Hudspith 4500
10 P. Knibbs 2500
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 users47898
Total active users1919
Act. users last 24h13
Act. users last hour1
Registered user hits last week245
Registered user hits last month1316
Latest Forum Threads
DB Migration


Can you please suggest the best way to migrate 15TB db(10g) to 12c server without using exp/i... (4 repl.)
how to send tablespace alerts to my email?

create or replace procedure send_tablespace(
v_from in varchar2 := 'dio.mahardhika@intra.sri-astr... (2 repl.)
Error in Recover Database ORA-17502: ksfdcre:4 Failed to create file +FRA ORA-15347: logical block s

Hi GM.

I have a problem when I try to restore a database on another server.

In the recover d... (4 repl.)
enq:tm contention

Hi Guys

I have a database that keeps on having blocking sessions that are preventing users to do ... (2 repl.)
fixed objects stats

Hi Guys

I am trying to gather fixed objects stats on my database but I get an error:

ERROR at ... (3 repl.)
Querying with CONTAINS is giving error

I have created the index with below code
Data base slowness issue

Since 27 Feb 2017 same issue. There are is no update in the DB side. (6 repl.)
--> Start a new thread ...
What is your experience with pluggable databases so far?
Yes, a nice feature.
Has anyone managed to get DBVisit to work in a pluggable ecosystem? I ...
We are using 12c/SE2 that means that we only can host 1 PDB in a CDB. ...
Told this was the future, we have one project Dev, UAT, Prod on single...
Have not used this feature !
Yes to explore this feature practically.
As this is supposed to be the only architecture in the future, we crea...