Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Time a sql statement

Re: Time a sql statement

From: Paul Drake <paled_at_home.com>
Date: Fri, 01 Mar 2002 04:18:35 GMT
Message-ID: <3C7F01A3.7020606@home.com>


godmann wrote:

> Hi Paul,
>
> Sadly yes, I am Oracle DBA who needs to do more Tuning now these days.
> I wonder if you know also a good book that does good explanation
> for Utlbstat and utlestat. The note 62161.1 is hard to read. Any pointers
> to where more explanation of using utlbstat and utlestat will be welcomed.
>
> I am learning still and I am glad I don't have an OCP at this moment in time.
>
>
> Allan W. Tham
> Oracle DBA
>

try this:
sqlplus @D:\Oracle\Ora81\rdbms\admin\spcreate.sql; (might want to read the comments in the headers first).

Paul Received on Thu Feb 28 2002 - 22:18:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US