Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How can you gather statistics on a table?

Answer Posted / santosh

you can use dbms_stats package

Is This Answer Correct ?    19 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to restore files with rman?

2285


how can you initialize log miner?

1115


How do you open a cluster administrator? : sql server DBA

1076


how can you connect from 10g user to 11g user??

2093


Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1893


Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2321


List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

1242


What are the steps you will take to improve performance of a poor performing query?

2835


Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2028


What happens on checkpoint? : sql server DBA

1067


I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

4331


what is the use of recording information about current session?

1033


What the different components in replication and what is their use? : sql server DBA

1033


Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

2155


What are the commands used in dcl? : sql server DBA

1043