Blogspot - el-caro.blogspot.com - el-caro
General Information:
Latest News:
12C ADG Enhancements 21 Aug 2013 | 08:27 am
Explain plan now works on Standby SQL> select database_role from v$database; DATABASE_ROLE ---------------- PHYSICAL STANDBY SQL> select open_mode from v$database; OPEN_MODE -------------...
Looping synonyms and transportable 4 Jun 2012 | 11:01 am
Whilst doing an export as part of TTS > expdp directory=tmp_dir dumpfile=test_meta.dmp transport_tablespaces=tts_conv Export: Release 10.2.0.4.0 - 64bit Production on Thursday, 31 May, 2012 11:03:50...
Scheduler jobs and Active Standby 7 May 2012 | 05:30 pm
One of the kewl enhancements in 11g is fact that you can now have a standby database in read only active mode applying changes from the primary. You need to be licensed for the Active Dataguard featur...
RDBMS events 30 Jul 2010 | 04:36 pm
RDBMS events are often used to do additional tracing and for debug purposes. Most of them are listed in $ORACLE_HOME/rdbms/mesg/oraus.msg One such event I use quite often to determine which locks/enqu...
Dynamic Re-Mastering in 11g 7 Apr 2010 | 11:19 pm
This is a follow-up on a post from last year http://el-caro.blogspot.com/search/label/10g%20RAC%20DRM Node 1 ======== SQL> create table obj as select * from sys.obj$; Table created. SQL> select ob...
Oracle Advanced Compression Advisor 6 Dec 2009 | 03:28 pm
Am currently working on how best to use compression techniques in an OLTP environment on a current 10g database which is due to be migrated to 11.2 in the next 6 months and I came across this OTN note...
Interrupting Flashback Database 19 Sep 2009 | 01:52 pm
So a user called me up and said he was flashing back a database and he was not too happy with the amount of time it was taking to complete the operation and so he did a Ctrl-C... When he tried to ope...
Are you sure you will be able to activate your standby?? 28 Jun 2009 | 11:50 pm
A couple of weeks I faced a scenario where the standby database crashed On looking at the alert.log I see the following message in the alert.log of the standby **************************************...
Outbound_connect_timeout 28 Jan 2009 | 12:34 pm
Outbound_connect_timeout comes into play when nodes in a cluster are down and we cannot wait for the OS timeout as this causes long delays in connect time. For example on Solaris the value of tcp_ip_a...
Parallel Rollback 30 Nov 2008 | 10:13 pm
I had a user call up and ask to kill a session which was causing him grief and hence I killed it without much thought since it was not a Production system A few hours later I noticed that SMON was do...
