No question at this time
DBA Top 10
1 B. Vroman 12100
2 M. Cadot 9800
3 J. Schnackenberg 8500
4 T. Boles 7450
5 A. Kavsek 6200
6 M. Hidayathullah ... 1900
7 P. Wisse 1400
8 G. Lambregts 1100
9 T. P 1000
10 . Lauri 800
About
DBA-Village
Advertise here
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48316
Total active users1584
Act. users last 24h11
Act. users last hour0
Registered user hits last week354
Registered user hits last month971
Tips, Scripts, Papers, Events, Links, ...
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
Link:Oracle Database 18c Important Changes

Tim Boles, Mar 08
Link:AceHints - Data Pump and Other Oracle related blog topics

Tom Mtkl, Jun 26
Link:Export batch SQL to HTML report,export batch SQL to txt file.

Daniel Wang, Jun 14
Latest Forum Threads
upgrade database from 12.1.0.2 to 12.2.0.1

Hi Guys

I was busy upgrading database from 12.1.0.2 to 12.2.0.1, during the upgrade process the u... (3 repl.)
How to change disconnect:true to disconnect:false

Hi,

We currently have the following in one of the Oracle RAC services

We want to change Disco... (2 repl.)
ORA-01555: snapshot too old -- When querying Materialized views with CLOB data

Users are coming across ORA-1555 errors when querying data against materialized views with CLOB data... (1 repl.)
Will be possible to patch standby first and prod after one week??

Hello Team,

We are going to plan the Oct psu on one of our RAC setup. we have below setup.

DR ... (1 repl.)
PERFORMANCE ISSUE

Hi Experts,

Suddenly my warehouse performance was down. User are complaining about it. All stats ... (2 repl.)
OEM13 Installation fail

Hi,

I have created OEM pdb in 2 node RAC Node 12cr2 on our non-prod environment. OEM server is i... (2 repl.)
stats collection on a table with data and we specifying the number of rows

We have a job where it loads one of the table and deletes 98% of of the data from it..
2% of the... (8 repl.)
--> Start a new thread ...
Headlines
Jan, 26 Oracle CPU and PSU patches Jan 2016 available
Apr, 15 Oracle CPU and PSU patches Apr 2015 available
Jan, 22 Oracle CPU and PSU patches Jan 2015 available
Jan, 22 Oracle announced new ODA X5-2 and Exadata X5
Jul, 16 Oracle CPU and PSU patches July 2014 available
Jul, 14 Oracle VM 3.3 now available

More ...
Imho
What is your experience with pluggable databases so far?
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...
Early days yet but a bit clunky.

More...