SQL Reviewer

Posted on Thursday, 16th April 2009 by kwatog

If you can monitor SQL Server processes you can bet your dog that you can also do that with Oracle without using sophisticated but uberly bloated software. The query below will help you with that.
SELECT sess.sid, sess.serial#, sess.sql_child_number, sess.sql_exec_id,
sess.process, sess.status, sess.username, sess.osuser, sess.program,
sess.schemaname, sql.sql_text
FROM v$session sess,
v$sql sql
WHERE sql.sql_id(+) = sess.sql_id
AND sess.type = ‘USER’
–AND sess.osuser [...]

Posted in Intermediate, Oracle, Performance Tuning | Comments (0)

Posted on Sunday, 12th April 2009 by kwatog

TOAD for Oracle and PL/SQL Developer are two indespensable developer tools. They have built-in tools to check the query plan of your SQL scripts. But in case you only have SQL*Plus as your editor, you ultimately need to know how it is done manually.
First Step : create plan

EXPLAIN PLAN FOR
your_query_to_optimize

a sample of which [...]

Tags: Explain Plan, Oracle, Query Plan, SQL*Plus
Posted in Intermediate, Oracle, Performance Tuning | Comments (0)

Posted on Thursday, 9th April 2009 by kwatog

A handy SQL query you can use to monitor server processes. With the lack of advanced SQL editor and DBA Tools, this query will be very helpful.

Tags: blocking, locking, monitor processes, SQL Server
Posted in Advanced, Performance Tuning, SQL Server | Comments (0)