Home » RDBMS Server » Server Administration » resolve the issue rgds performance
resolve the issue rgds performance [message #126943] Thu, 07 July 2005 08:13 Go to next message
subusona
Messages: 70
Registered: March 2005
Location: delhi
Member
If a table has the statistics as attached.

How to resolve these??

OBJECT_NAME		STATISTIC_NAME				VALUE
CAT_ITEM_PRICE_SOURCE	logical reads				743,896,000.00
CAT_ITEM_PRICE_SOURCE	buffer busy waits			25,269,802.00
CAT_ITEM_PRICE_SOURCE	db block changes			61,602,960.00
CAT_ITEM_PRICE_SOURCE	physical reads				37,478,879.00
CAT_ITEM_PRICE_SOURCE	physical writes				4,423,473.00
CAT_ITEM_PRICE_SOURCE	physical reads direct			0.00
CAT_ITEM_PRICE_SOURCE	physical writes direct			0.00
CAT_ITEM_PRICE_SOURCE	global cache cr blocks served		0.00
CAT_ITEM_PRICE_SOURCE	global cache current blocks served	0.00
CAT_ITEM_PRICE_SOURCE	ITL waits				0.00
CAT_ITEM_PRICE_SOURCE	row lock waits				8,382.00
Re: resolve the issue rgds performance [message #127868 is a reply to message #126943] Wed, 13 July 2005 15:41 Go to previous message
Frank Naude
Messages: 4587
Registered: April 1998
Senior Member
In isolation these statistics doesn't mean anything. What is the problem you are trying to solve?

Best regards.

Frank
Previous Topic: max number of datafile per a database
Next Topic: selective exporting
Goto Forum:
  


Current Time: Sat Jan 25 06:17:29 CST 2025