Home » RDBMS Server » Performance Tuning » long and short table scans
long and short table scans [message #153637] Tue, 03 January 2006 07:54 Go to next message
alanm
Messages: 284
Registered: March 2005
Senior Member

Hi all,
I have run a statspack report over an hour period and got the following

244 table scans on long tables during the whole report
and 95,849 on short tables (almost 30 per sec. and 6 per transaction).

Can someone please explain what long tables are and also what short tables are.

many thanks

Alan.
Re: long and short table scans [message #153642 is a reply to message #153637] Tue, 03 January 2006 08:26 Go to previous messageGo to next message
Art Metzer
Messages: 2480
Registered: December 2002
Senior Member
Re: long and short table scans [message #153643 is a reply to message #153637] Tue, 03 January 2006 08:36 Go to previous message
alanm
Messages: 284
Registered: March 2005
Senior Member

Hi,
Thanks for the info.

So in an hour period I had 95,849 full table scans on short tables. Is it possible to get information on the name of these tables?

I am guessing that this could be a performance bottleneck.

regards

Alan.
Previous Topic: Inlist operator performance
Next Topic: Improve performance with MV
Goto Forum:
  


Current Time: Thu Mar 28 07:04:55 CDT 2024