Re: sources for hidden and useful hints for testin

  • From: "Juan Carlos Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 26 Jul 2004 09:32:18 -0400

Thans every one for you help.
 
 
-------Original Message-------
 
From: oracle-l@xxxxxxxxxxxxx
Date: 07/24/04 00:46:17
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: sources for hidden and useful hints for testin
 
On your home database, set sql_trace to true for the whole database and just
play with it (the
database!) in the normal way. You'll be amazed at some of the goodies (hints
and otherwise) that
pop up in the trace files
 
hth
connor
 
--- Juan Carlos Reyes Pacheco <jreyes@xxxxxxxxxxxxxxxx> wrote: >
> Hi list, once I read Tom Kyte use some hints, I ask where you get
> informatoin about them, or is only for Oracle people,
> I think they should help when tuning and try to find the specific problem.
> thanks
>
> Juan Carlos Reyes Pacheco
> OCP
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
 
=====
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
ISBN: 1590592174
 
web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald@xxxxxxxxx
 
Coming Soon! "Oracle Insight - Tales of the OakTable"
 
"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and
.he will sit in a boat and drink beer all day"
 
------------------------------------------------------------
 
 
 
 
 
___________________________________________________________ALL-NEW Yahoo!
Messenger - all new features - even more fun! http://www.allnewmessenger.com
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: