Answer Posted / santosh
you can use dbms_stats package
| Is This Answer Correct ? | 19 Yes | 3 No |
Post New Answer View All Answers
how to restore files with rman?
how can you initialize log miner?
How do you open a cluster administrator? : sql server DBA
how can you connect from 10g user to 11g user??
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
What are the steps you will take to improve performance of a poor performing query?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What happens on checkpoint? : sql server DBA
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
what is the use of recording information about current session?
What the different components in replication and what is their use? : sql server DBA
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.
What are the commands used in dcl? : sql server DBA