No question at this time
DBA Top 10
1 M. Cadot 7400
2 B. Vroman 1700
3 P. Wisse 1300
4 P. Tsongayinwe 1200
5 J. PĂ©ran 800
6 J. Schnackenberg 400
7 J. Alcroft 200
7 D. Walgude 200
7 B. M 200
10 A. Hudspith 100
10 L. Ywema 100
10 D. Johnson 100
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48726
Total active users1323
Act. users last 24h0
Act. users last hour0
Registered user hits last week35
Registered user hits last month263
Tips, Scripts, Papers, Events, Links, ...
Link:Oracle DBA career

Gitesh Trivedi, Mar 21
Link:12c Interactive quick reference

Bruno Vroman, Dec 30

Philip Wisse, Aug 14
Tip:Fixed size and variable Size in SGA

vijay kaushik, Feb 25
Link:Oracle Database Tutorials

karl vi, Aug 01
Latest Forum Threads
RDS instance:- ORA-29283: invalid file operation: nonexistent file or path [29434]

Dear All

Facing " ORA-29283: invalid file operation: nonexistent file or path [29434] " while rea... (7 repl.)
DBTIMEZONE of both instances shows UTC.


The database is supposed to run on Active-Passive mode with one of the ExaCC node running
a... (2 repl.)
Full DB export


Could you pls suggest me some parameters in expdp to take full DB export
for the DB size 12... (1 repl.)
Monitor RMAN Duplicate DB from ACTIVE DATABASE

I am creating a physical standby database using rman duplicate target database form active database ... (7 repl.)
maximum number of open files per process

Hi Team

We have been experiencing issues with the database server, we did an upgrade from Solaris... (1 repl.)
performance issues

Hi Team

We are experiencing performance issues in our environment.

We have 5 database instanc... (5 repl.)
Help with a SQL query

Hi All,

Need some SQL help!

I have two tables... one is having below data


Databas... (2 repl.)
--> Start a new thread ...
What is your experience with pluggable databases so far?
I still hate the things. The way Oracle implemented this is utterly ma...
Use it for testing purpose.
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.