No question at this time
DBA Top 10
1 A. Kavsek 12200
2 M. Cadot 7000
3 P. Wisse 5600
4 B. Vroman 5400
5 J. PĂ©ran 1900
6 . Lauri 1500
7 T. P 500
7 R. Pattyn 500
9 T. Boles 400
10 A. Chavan 300
10 J. Schnackenberg 300
10 D. Johnson 300
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48454
Total active users1499
Act. users last 24h5
Act. users last hour0
Registered user hits last week216
Registered user hits last month950
Latest Forum Threads
High CPU for a simple queery


I have the following query that takes a "high percentage" of CPU from the server:

SELECT *... (7 repl.)
How is PID (SPID) is allocated on server level?


Does someone know how a PID (SPID) is allocated on server level?
If I run few times one afte... (2 repl.)
Download Oracle 10g Developer Suite Complete

Oracle 10g Developer Suite Release 2 (Forms10g, Reports10g, JDeveloper10g etc) very difficult to fin... (1 repl.)
Using PPRC as DR solutoin

We are thinking of using PPRC as replication technology for having a DR site for our product... (1 repl.)
DR out of sync, datafile added on primary

Hi masters,

i have one question,

if my DR is out of sync and i m taking incremental RMAN backu... (5 repl.)
Cleaning archived redo logs from standby site using RMAN


Archive logs are shipped to the server of the standby database.
Does someone know a way to c... (5 repl.)
Negative numbers in primary key column

What can be the negatives of using a negative number in a primary key number column.

There is one... (6 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...