No question at this time
DBA Top 10
1 M. Cadot 5400
2 P. Wisse 1300
3 P. Tsongayinwe 900
4 B. Vroman 500
4 J. Schnackenberg 500
6 M. Pagac 400
7 A. Deledda 200
7 D. Walgude 200
7 B. M 200
10 J. Alcroft 100
10 G. Trivedi 100
10 A. Hudspith 100
10 V. Sharma 100
10 L. Ywema 100
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48741
Total active users1338
Act. users last 24h6
Act. users last hour0
Registered user hits last week145
Registered user hits last month435
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
opiodr aborting process unknown ospid (92) as a result of ORA-609

Hi Team

We have a DB server that has 5 instances running on it.

We are experiencing slow respo... (4 repl.)
DR configuration on Windows

Dear Experts,

I am Configuring 19c Physical Standby on Windows Server.

When i tried to use dup... (1 repl.)
Dataguard Role Transition Timestamp


Is there any way to find exact time/date when role transition took place in DG other than ... (1 repl.)
SYSAUX tablespace full

One of our databases has a full SYSAUX tablespace (31.5G). Whilst I try and work out why it is s... (2 repl.)
database can't open due to sysaux tablespace is full

when trying to "alter database open", it hangs,

in alert.log, showing :
ORA-01688: unable to ext... (5 repl.)
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.)
--> 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.