ORA blog: June 2013

Friday, 21 June 2013

Hemant's Oracle DBA Blog: Getting the ROWIDs present in a Block: Here is a demonstration of getting the ROWIDs present in a block. First I start with a new Table and identify its OBJECT_ID and Blo...

Data Warehousing and Big Data from an Oracle Perspective: Oracle Wins Big Data Company of the Year 2013: Great news from the Storage Awards 2013. Oracle won the "Big Data Company of the Year 2013" award. The event took place on 6 June ...

The Arup Nanda Blog: Primary Keys Guarantee Uniqueness? Think Again.: When you create a table with a primary key or a unique constraint, Oracle automatically creates a unique index, to ensure that the column do...

The Momen Blog: OOW-2012: Very Large Databases (VLDB): Challenges ...: I would like to thank all the attendees for attending my session "Very Large Databases (VLDB): Challenges and Opportunities". I am...

The Momen Blog: Bug: ORA-00979: not a GROUP BY expression: Bugs and performance degradation are part of database upgrade stories and we have witnessed yet another post-upgrade bug after upgrading our...

The Momen Blog: Exporting Multiple Tables on a Common Filter: To be frank, I consider myself novice when it comes to advanced export/import requirements. This is because I don’t deal with these utilit...

The Momen Blog: Connecting to Oracle Database Even if Background P...: Yesterday, I received an email update from MOS Hot Topics Email alert regarding a knowledge article which discusses how to connect to an Ora...

The Arup Nanda Blog: Switching Back to Regular Listener Log Format: Did you ever miss the older listener log file format and want to turn off the ADR-style log introduced in 11g? Well, it's really very si...

The Arup Nanda Blog: Application Design is the only Reason for Deadlock...: [Updated on 4/20/2013 after feedback from Charles Hooper , Jonathan Lewis , Lau rent Schneider and Mohamed Houri and with some minor cosm...

The Arup Nanda Blog: Streams Pool is only for Streams? Think Again!: If you don’t use the automatic SGA (i.e. set the sga_target=0 ) - something I frequently do - and don’t use Streams, you probably have set t...

The Arup Nanda Blog: Demystifying Big Data for Oracle Professionals: Ever wonder about Big Data and what exactly it means, especially if you are already an Oracle Database professional? Or, do you get lost in ...