Home » RDBMS Server » Server Administration » dbms_status.auto_sample_size
dbms_status.auto_sample_size [message #60870] Thu, 11 March 2004 06:29 Go to next message
Vinny75
Messages: 44
Registered: October 2003
Member
I ran this function to check what oracle chooses for sample size and I get zero. What is wrong here? I checked the dba_tables prior to running this and sample_size column had proper values.

 

Report message to a moderator

Re: dbms_status.auto_sample_size [message #60874 is a reply to message #60870] Thu, 11 March 2004 10:57 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
am not sure what you re trying to do, but sample_size is choosen by Oracle for each table, depending on the number of rows/size etc.

-Thiru

Report message to a moderator

Previous Topic: tablesapce offline
Next Topic: A stupid question.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 12:48:23 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.