The Trouble with Listener Logs Is that over time, they’re easily forgotten about. Then they get ginormous, and really unmanageable.…
Category Uncategorized
ACFS stands for ASM Cluster filesystem, which is basically a cluster filesystem on top of ASM Diskgroups. It is similar to…
1) Query on old standby database (new primary) SQL> SELECT TO_CHAR(STANDBY_BECAME_PRIMARY_SCN) FROM V$DATABASE; TO_CHAR(STANDBY_BECAME_PRIMARY_SCN) —————————————- 12496643189 2) Flash back the…
The below command will not import the dump, but will just create a .sql file with the DDL statements impdp…
set lines 999 select GROUP_NUMBER,NAME,TOTAL_MB/1024/1024 as “Total Space in TB” ,FREE_MB/1024/1024 as “Free Space in TB” ,DATABASE_COMPATIBILITY from v$asm_diskgroup;
— Move SPFILE to ASM RAC — Already we have a PFILE called initmove.ora which was created previously from spfile…
If like me, you are addicted to command line, this post will help you to realize useful operation in EM…
NSA’s massively distributed database of everything on the Internet.
Who says RDBMS cannot be geographically distributed and maintain all the ACID properties.
Oracle launches Exadata X4
Last week EMC announced that Oracle RAC on VPLEX stretched clusters is now officially supported and certified by Oracle! News…
One of the most interesting articles explaining De-duplication from a DBA’s perspective. Storage for DBAs: Data deduplication – or “dedupe”…
Last week EMC announced that Oracle RAC on VPLEX stretched clusters is now officially supported and certified by Oracle! News…
Disclaimer: I got informed that the mentioned underscore parameter is not reliable on every database version and that it never…
With the announcement of Oracle Golden Gate 12c, there comes a few new features that everyone is going to explore. …
http://www.theregister.co.uk/2013/08/30/google_f1_deepdive/
Facebook leverages a traditional RDBMS to run the engine of its core services. When you’re storing every transaction for 800…
I normally post to this blog things relevant to Databases in general and Oracle in particular but once in a…
Oracle Locking Mechanism Probably the best article out their explaining Oracle’s locking mechanism. Oracle Guru Arup Nanda explains the mystical…
SQL Server and DB2 still dont have features like Flashback Table or Flashback Query. SQL Server has snapshots mimicking similar behaviour of…
Flashing Back a Failed Primary Database into a Physical Standby Database The following steps assume the user has already performed…
I know we are an Oracle DB blog. But for Technology enthusiasts an opportunity to learn something new shouldn’t pass by.
“An irrefutable tenet of physics argues that matter cannot exist in two places at one time. But data definitely can and often should.” So DBA’s…