No question at this time
DBA Top 10
1 M. Cadot 9500
2 B. Vroman 7200
3 A. Kavsek 4600
4 P. Wisse 2000
5 J. PĂ©ran 1700
6 J. Schnackenberg 1200
7 T. Boles 800
8 D. Johnson 600
9 D. Dave 400
10 S. Spb 300
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48624
Total active users1393
Act. users last 24h1
Act. users last hour0
Registered user hits last week48
Registered user hits last month117
Tips, Scripts, Papers, Events, Links, ...
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
Link:JDBC Driver Connection URL

mark King, Aug 01
Latest Forum Threads
Can we use UTL_TCP to write data into remote directory ?

Using PL/SQL program, I need to retrieve data from the oracle database and write it to a text file l... (1 repl.)
Can I create DBA directories in oracle with the path as remote path from application server ?

Using UTL_FILE, we are able to read/write files into Oracle directory which is pointing to Oracle d... (1 repl.)
Select query taking time -, in 24 hours window, the query having issue in between 21:30 to 22:30.

Hello Friends,

According to the report , in 24 hours window, the query having issue in between 2... (0 repl.)


I am using utl_smtp package to send email in pl/sql procedure,Procedure is geeting execute... (2 repl.)
Query Help!

Hi Team,
Need some help to figure out this requirement.

How can I list the latest patch date wit... (6 repl.)
db growth on daily basis

Hi Masters,

can you please provide me the sql script which can create the report for DB growth on... (3 repl.)
Comparison of rows

Hi guys,

I want a query which compare date wise column values and output the process who does not... (5 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...