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.

Report message to a moderator

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

Report message to a moderator

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.

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jan 07 03:15:36 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.