Answer Posted / balu
exec dbms_stats.gather_table_stats('ownername','tablename')
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What authentication modes does sql server support? : sql server DBA
What is dcl? : sql server DBA
what are the types of connection load-balancing?
how can you initialize log miner?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
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.
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
which background process invoke at the time of upgradation tell me???
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
what is logical system in sap basis
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
what is asm?
what functionality does oracle provide to secure sensitive information?