you can use dbms_stats package

How can you gather statistics on a table?

Question Posted / santosh

Answer Posted / santosh

Is This Answer Correct ?

19 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Where do you find the default index fill factor and how to change it? : sql server DBA

1022

what is the use of recording information about current session?

995

What is dcl? : sql server DBA

1184

How do you troubleshoot errors in a sql server agent job? : sql server DBA

1051

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

2641

What is the default port no on which sql server listens? : sql server DBA

1084

how can you process messages in order asynchronously?

930

What is transparent data encryption? : sql server DBA

1115

How do you trace the traffic hitting a sql server? : sql server DBA

1464

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

2017

What is the default fill factor value? : sql server DBA

1059

What are the operating modes in which database mirroring runs? : sql server DBA

1106

How would you go about verifying the network name that the local_listener is currently using?

3157

What is the difference between clustered and non-clustered index? : sql server DBA

1023

What the different topologies in which replication can be configured? : sql server DBA

1179