Re: STATSPACK in Oracle 8.1.6.0

2003-07-18 Thread Richard Foote
PM To: Multiple recipients of list ORACLE-L Subject: STATSPACK in Oracle 8.1.6.0 Hi, I want to delete all old records of statspack from perfstat schema. What would be best way to do this either by truncating all tables or remove and recreate ? Pl advice. thx -Seema

RE: STATSPACK in Oracle 8.1.6.0

2003-07-18 Thread Scott . Shafer
Subject: Re: STATSPACK in Oracle 8.1.6.0 Hi Scott, Although the recommendation of RTFM often has it's merits, where precisely do you suggest Seema should look for the above mentioned FM within the *8.1.6* doco set for the sp* statspack scripts ? Cheers Richard Foote - Original

STATSPACK in Oracle 8.1.6.0

2003-07-17 Thread Seema Singh
Hi, I want to delete all old records of statspack from perfstat schema. What would be best way to do this either by truncating all tables or remove and recreate ? Pl advice. thx -Seema _ Add photos to your e-mail with MSN 8. Get 2

Re: STATSPACK in Oracle 8.1.6.0

2003-07-17 Thread Kirtikumar Deshpande
The latter. Scripts are already supplied. - Kirti --- Seema Singh [EMAIL PROTECTED] wrote: Hi, I want to delete all old records of statspack from perfstat schema. What would be best way to do this either by truncating all tables or remove and recreate ? Pl advice. thx -Seema