RE: Count(*) last 30 seconds

[Koivu, Lisa]

Title: Message

well, have you traced the statement yet?  That's where to start, with autotrace.

 

My count(*) which executes a FTS (in a load to mitigate any ORA-1555 error) takes 15 minutes to count 50 million rows.

 

Lisa Koivu 
Tired, Tired, Tired.
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA  33063
Office: 954-935-4117 
Fax:    954-935-3639
Cell:    954-683-4459

-----Original Message-----
From: Ramon E. Estevez [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 11:19 AM
To: Multiple recipients of list ORACLE-L
Subject: Count(*) last 30 seconds

Hi list,

 

I issue a select count(*) from mytable and last 30 seconds.

 

The table has 1,466,196 records and were loaded with a batch process, so they are in a countinous space.

 

I consider that time exagerated.

 

The TBS is LMT with a Uniform size of 128 MB.

 

The block size is 8MB, version 9.2.0.1.0 in Windows 2000.

 

Where should I start looking ???

 

TIA

 

Ramon E. Estevez

[EMAIL PROTECTED]

809-565-3121