somesh anil raote

33 Flips | 3 Magazines | 22 Followers | @someshleo1 | Keep up with somesh anil raote on Flipboard, a place to see the stories, photos, and updates that matter to you. Flipboard creates a personalized magazine full of everything, from world news to life’s great moments. Download Flipboard for free and search for “somesh anil raote”

Skewness

How will you determine which column will be appropriate for Index, that can avoid skewness?I have given below the syntax. Before assigning a column …

Checking TD Version from UNIX

How would you check what version of teradata is being used in your UNIX env?You simply have to create a bteq script:bteq<<EOF.logon …

Comment on Clusterware Startup by Chowdary

Hi,One of my OEL 6 server, while rebboting it using run level 3, OHASD is coming up without any issues, but when using run level 5, OHASD is not …

Add database to Oracle Restart

With Oracle Real Application Clusters the Oracle database can be configured to restart as each node in the cluster is restarted. For single instance …

swing out sister - windmills of your mind

By: | Senior Principal Support Engineer<p>Since the first release of JDBC and event longer ago with Pro* Precompilers to this day I still see the …

Enabling DBMS_OUTPUT by default in SQL Developer

Tell Others About This Story:<p>DBMS_OUTPUT is one of the most well-known and least understood SYS packages. If you have questions about how it works in …

Round Robin and Parallel Forced to Serial

So we have a parallel process, coordinator 739 running, just not very well… I have an ugly pink section in my OEM grid and as we know, pink is not a …

Application Design is the only Reason for Deadlocks? Think Again

[Updated on 4/20/2013 after feedback from Charles Hooper, Jonathan Lewis, Laurent Schneider and Mohamed Houri and with some minor cosmetic …

Drill down to sql_id execution details in ASH

Some times ago I explained how we can link a huge PGA or TEMP consumption to a sql_id over a period of time into this blog post.<p>Now I need to extract …

Understanding SQLTXPLAIN Health-Checks

SQLTXPLAIN (SQLT) collects diagnostics details about a SQL statement that either performs poorly or it produces unexpected results (also known as …

Performance: It’s All About Balance…

<b>Storage For DBAs</b>: Everyone wants their stuff to go faster. Whether it’s your laptop, tablet, phone, database or application… performance is one of …

Direct Path Reads Again

<b>Note:</b> This post is about diagnosing real life scenario caused by direct path decision change on 11.2.0.3 which already covered by <b>Tanel Poder</b> on his …

Delete one billion row

To delete large number of rows, for instance rows with date until 2010, you can issue this simple statement.<p>This is perfectly fine. The table remains …

Monitoring a SQL that executes well thousands of times but sometimes it takes longer

Problem Description<p>There is this SQL that is constantly executed by many users. This SQL executes in a subsecond thousands of times per day. Every …

Comment on Oracle Troubleshooting with Snapper – detecting who’s causing excessive redo generation by Dird

This example is broken in the latest version?<br>@snapper out,gather=s,sinclude=%redo_size% 10 90 “select sid from v$session”/* inst_filter */ …

Bind variable peeking: Retrieve peeked and passed values per execution in oracle 11.2

To understand this blog post you have to know what bind variable peeking is. You can found a very good explanation into this Kerry Osborne’s blog …

QUICK OVERVIEW OF SHARED POOL TUNING

In continuation with my earlier post on shared pool latches,locks, pins and mutexes, I will give a quick overview of shared pool tuning in this …

Databases

High Performance Tuning Tools

Obligatory Melodrama<p>No matter how much time goes by I still remember it. The day my database was crippled beyond reckoning. That moment when I saw my …

Recover corrupted blocks using Flashback Logs

Starting with 11g Oracle can perform block media recovery using flashback logs to get good copies of the blocks.<br>Flashback database is not enabled by …

Webinar questions

Following the webinars about 11g stats that I presented on Monday John Goodhue emailed me a few questions that had come through the chat line while I …

Oracle CPU Time

Image from Bertrand Drouvot<p>UPDATE: thanks to a discussion in the comments it’s come to my attention that there should be some more clarification on …