No question at this time
DBA Top 10
1 A. Kavsek 10000
2 M. Cadot 9900
3 B. Vroman 5700
4 P. Wisse 4300
5 J. PĂ©ran 1800
6 . Lauri 1200
7 J. Schnackenberg 600
8 F. Pachot 500
9 Z. Hudec 400
9 G. Lambregts 400
9 N. Havard 400
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48503
Total active users1429
Act. users last 24h2
Act. users last hour0
Registered user hits last week104
Registered user hits last month599
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
Listener issue.

Hi DBA team,
In our environment every thing is monitoried by corn jobs. In below cronjob is reading... (1 repl.)
Can we have NON CDB databases in Oracle 19C

Hi everyone,

First of all, I hope everyone is healthy and safe, and that you may have all retu... (5 repl.)
ORA-01839: date not valid for month specified

Dear Guru's

While selecting view ( used unpiovt) getting error

ORA-01839: date not valid for... (16 repl.)

HI Masters,

i have one procedure written in PL/SQL, which is having multiple sql queries written.... (1 repl.)
Audit successful login session for sql developer in oracle database

Dear Friend,

Kindly share code to audit successful login session for sql developer in oracle data... (7 repl.)


In a RAC configuration, nodes (let's ay we have two nodes) will be given a public IP and a pr... (4 repl.)
Golden Gate data retention policy

Hi masters,

i have to implement different data retention on primary and reporting,

on primary... (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...