Skip to content

Category Archives: Oracle

Changes (Ace Comic)

The Adventures of Ace DBA

This entry is part 19 of 19 in the series Adventures of Ace, DBA It’s the only explanation! Related Ace has dealt with problems before… Default blame accepter?

The post Changes (Ace Comic) appeared first on Steve Karam :: The Oracle Alchemist.

Posted 10 May 2013 † The Oracle Alchemist § Uncategorized ‡ Comments Off ° Tagged:

Direct path read and fast full index scans

This is yet another blogpost on Oracle’s direct path read feature which was introduced for non-parallel query processes in Oracle version 11. For full table scans, a direct path read is done (according to my tests and current knowledge) when: – The segment is bigger than 5 * _small_table_threshold. – Less than 50% of the …

Read More

Posted 09 May 2013 † Frits Hoogland § Uncategorized ‡ Comments Off °

Clustering_factor

Cost Based Oracle – Fundamentals (November 2005) But the most interesting function for our purposes is sys_op_countchg(). Judging from its name, this function is probably counting changes, and the first input parameter is the block ID portion (object_id, relative file number, and block number) of the table’s rowid, so the function is clearly matching our … … Continue reading →

Posted 09 May 2013 † Jonathan Lewis § Uncategorized ‡ Comments Off °

Logger: a PL/SQL Logging and Debugging Framework

Martin D’Souza: Logger is a PL/SQL logging and debugging framework. It’s used in many organizations to instrument code in their Oracle applications. Tyler Muth created Logger a few years ago and has since released several upgrades, the last being 1.4.0. After some great feedback, I’m pleased to announce that we’ve just launched Logger 2.0.0 Beta. Instrumentation, logging [...]★

Posted 06 May 2013 † Eddie Awad § Uncategorized ‡ Comments Off ° Tagged: , ,

SLOB

Anyone who has used Kevin Closson’s “Silly Little Oracle Benchmark” will want to know about his significantly updated SLOB2.

Posted 05 May 2013 † Jonathan Lewis § Uncategorized ‡ Comments Off ° Tagged:

Not a Fan of Public Synonyms, Here is Why

Tom is not not a fan of public synonyms, here is why: public synonyms pollute the namespace. public synonyms can lead to security issues. public synonyms can lead to a maintenance headache. public synonyms are public – no one owns them. So, instead of public synonyms… Continue reading… © Eddie Awad’s Blog, 2013. | Permalink [...]★

Posted 04 May 2013 † Eddie Awad § Uncategorized ‡ Comments Off ° Tagged: ,

When does an Oracle process know it’s on Exadata?

When an Oracle process starts executing a query and needs to do a full segment scan, it needs to make a decision if it’s going to use ‘blockmode’, which is the normal way of working on non-Exadata Oracle databases, where blocks are read from disk and processed by the Oracle foreground process, either “cached” (read …

Read More

Posted 03 May 2013 † Frits Hoogland § Uncategorized ‡ Comments Off ° Tagged:

Log Buffer #318, A Carnival of the Vanities for DBAs

News and views are an integral part of our modern daily life. When it comes to the information-hungry roles such as database professionals, such need becomes more pressing. Log Buffer is one way to keep abreast of news and views from the world of Oracle, SQL Server, and MySQL. Oracle: There is a significant update…

Posted 03 May 2013 † Fahd Mirza § Uncategorized ‡ Comments Off °

Watching the “CopyBack” progress of a new disk on an Exadata compute node

This is just a very small post on how to watch the progress of the “CopyBack” state of a freshly inserted disk in an Exadata “Computing” (database) node. A disk failed in the (LSI Hardware) RAID5 set, and the hotspare disk was automatically used. The failed disk was replaced, and we are now awaiting the …

Read More

Posted 03 May 2013 † Frits Hoogland § Uncategorized ‡ Comments Off ° Tagged:

SLOB 2 — A Significant Update. Links Are Here.

BLOG UPDATE 2012.05.05: Updated the tar archive distribution file with some bug fixes.  Simply preserve your slob.conf file and extract this tar archive over your prior SLOB install directory. BLOG UPDATE 2012.05.04: The PDF README will no longer be bundled in with the tar archive. BLOG UPDATE 2012.05.03: First time visitors should see the introductory page […]

Posted 03 May 2013 † kevinclosson § Uncategorized ‡ Comments Off °