Tag: Oracle

Upgraded to 11GR2? Congrats! You Are in Direct Reads Trouble!

I made this blog title intentionally provocative. However it isn’t far from the truth. Don’t believe me? Continue reading :)

Read More >

Case Study: How to Return a Good SQL Execution Plan from 10g Days After an 11g Migration

Any database upgrade suppose to change SQLs’ execution plans for the better. In 99 cases out of 100 this is exactly what happens. What to do with rest 1% of the SQLs? This blog post is exactly about such unlucky case I have resolved today. Hope that you will learn something out of it. As always let me know what you think using the comments section at the end of the post.

Read More >

Yury, Remember: This is How You Disable AUTO_TASKs in 11G

I find myself forgetting on how to disable Oracle AUTO_TASKs on regular basis. Therefore I have decided to document it under this small blog post. As an additional bonus I may hear others experience in the area. So if you disagree or have some other experience please do not hesitate to comment under this post.

Read More >

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

Log writer process of Oracle is one of the most revered background process, a real work horse, a real charming darling who keeps the whole Oracle database system consistent and humming beautifully and many technologies in Oracle sprout from this good old process. Consistency is the key in database systems, and so in the Log Buffer Editions, and this Log Buffer #294 continues it. And yes, the coolest 2012 PASS Summit is also there.

Read More >

RMAN: Corrupt Block? Let’s Re-Read… Nope, It’s All Good

Just received a page about “Corrupt block”. From the first look it kind of scary to receive such page 40 minutes before your shift ends. Right?
After examining an alert.log (see below) and looking through knowledge bases found an explanation that it isn’t as bad as I thought. I liked the explanation I found therefore I decided to share it with rest of the world. Here you go folks

Read More >

Are There Performance Penalties Running Oracle ASM on NFS?

In this blog post I am publishing my SLOB tests results and conclusions testing Oracle database IO performance placing data files on NFS directly and on ASM disk group located on NFS.

Read More >

Pythian at Oracle with 20:20 Foresight Perth Australia

Perth is far from everywhere, but not far from the Oracle technologies. Passion, knowledge, and urge to share the experience, skills, tips and knowledge brought people from across the planet to gather under one roof and learn, educate and network under the banner of Oracle with 20:20 Foresight.

Read More >

Select Statement Generating Redo and Other Mysteries of Exadata

Like many good stories, this one also started with an innocent question from customer: “I often check “SELECT COUNT(*) FROM TABLE;” on our old 10.2.0.4 cluster and the new Exadata. The Exadata is slower than our old cluster by few minutes. Exadata is not good at count(*) ? or other problem?” Here’s how I fixed it.

Read More >

Reasons to Use ASM on NFS

My tweet few days ago – “Personally I don’t see the point building ASM on (d)NFS. ASM suppose to exclude unnecessary layers. In NAS case it adds an additional layer.” Since then Oracle people in my Social Media environment helped me to find several legitimate reasons to run ASM on NAS. Thank you folks very much. Now I am sharing our common thoughts with the rest of the community.

Read More >

My Agenda for AUSOUG Conference in Perth

There is a very strong Oracle Community in Perth, Australia. I admire many Perth based Oracle User Group volunteers who year from your organizing a great Oracle event. This year it isn’t an exception. I just spent 30 minutes going through the program and I should say the lineup of speakers is very impressive. Here’s the schedule.

Read More >
Page 32 of 143« First Page...10...3031323334...40...Last Page »