No question at this time
DBA Top 10
1 B. Vroman 14600
2 M. Cadot 11000
3 J. Schnackenberg 8200
4 T. Boles 7950
5 A. Kavsek 6200
6 M. Hidayathullah ... 2200
7 G. Lambregts 1100
8 T. P 1000
9 P. Wisse 900
10 B. Derous 500
10 . Lauri 500
10 R. Pattyn 500
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48286
Total active users1591
Act. users last 24h3
Act. users last hour0
Registered user hits last week242
Registered user hits last month1121
Latest Forum Threads
JDBC Thin Client

Dear Expert,

We have a 12c RAC running. When I check the gv$session, I found there are many inact... (4 repl.)
ORA-00942 Raise By DBMS_SPM


I am working with Oracle RDBMS 12c2.

I have a user that has been granted the roles ADMINIS... (1 repl.)
SQL plan managemnt and optimizer


Here is what I understand about SQL plan managemnt and the role of the optimizer (correct me ... (1 repl.)
Unusable versus invisble indexes


Is there any reason to use unusable indexes instead of invisible?

I have the following pro... (4 repl.)
SQL Profile, SQL Plan Management, SQL Plan Baseline, Stored Outlines


Can someone explain me what is the differences or the relations between SQL Profiles, SQL Pla... (2 repl.)

Hi Guys

I have a problem with the listener on the db server.

The listener start fine but afte... (1 repl.)
About Oracle RDBMS 18c


Oracle released Oracle RDBMS 18c.
If I understood well - correct me if I am wrong - it is ju... (2 repl.)
--> Start a new thread ...
What is your experience with pluggable databases so far?
I have some experience with pluggable databases. Until now for databa...
With a licence for only one PDB out of the box it's not the most widel...
Actively using it for testing applications, database on the fly in min...
Already using it....but not extensively yet...
Already using. One or two gotcha's but generally ok.
R&D at the moment, with the intention of utilizing the CDB architectur...
Early days yet but a bit clunky.