No question at this time
DBA Top 10
1 M. Cadot 10800
2 A. Kavsek 9600
3 B. Vroman 4700
4 P. Wisse 4100
5 J. Schnackenberg 2900
6 J. PĂ©ran 2000
7 . Lauri 1000
8 F. Pachot 500
9 Z. Hudec 400
9 G. Lambregts 400
9 N. Havard 400
9 T. Boles 400
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48527
Total active users1412
Act. users last 24h6
Act. users last hour2
Registered user hits last week147
Registered user hits last month416
Tips, Scripts, Papers, Events, Links, ...
Tip:Fixed size and variable Size in SGA

vijay kaushik, Feb 25
Link:Oracle Database Tutorials

karl vi, Aug 01
Link:JDBC Driver Connection URL

mark King, Aug 01
Script:Better lock tree script using v$wait_chains

Luis Santos, Dec 19
Script:SQL*PLus script to extract DDL Database Links

Lauri, Nov 12
Latest Forum Threads
oracle on linux 8

I have an old hardware, linux 6, oracle SE.
New hardware is ready to install and apps... (9 repl.)
RMAN ckpn SCN and cumulative differential backup

Hi all

I need to understand several concepts in rman recovery and cumulative incremental backup ... (3 repl.)
peformance issues

Hi Guys

On the 6th June 2020, my database crashed with errors:

ORA-07445: exception encountere... (6 repl.)
trouble during restore / switch datafile

I just restored a big database.
<pre>run {
set newname for tempfile 1 to '+DATAC';
set newna... (1 repl.)
Your opinion regarding the autoupgrade new feature

Hi everyone,

I am currently in a studying phase for a big migration project (to 19c). I have a... (2 repl.)
Accidentally remove diskgroup


Can anyone help? I accidentally remove the diskgroup from the server using asmcmd. I am think... (6 repl.)
lots of processes


I have on a single node oracle grid infra + oracle database (test purpose) (single node).
Af... (1 repl.)
--> Start a new thread ...
What is your experience with pluggable databases so far?
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.
R&D at the moment, with the intention of utilizing the CDB architectur...