Answer Posted / santosh
you can use dbms_stats package
Is This Answer Correct ? | 19 Yes | 3 No |
Post New Answer View All Answers
What are statistics, under what circumstances they go out of date, how do you update them?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
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
What the different topologies in which replication can be configured? : sql server DBA
how can you get actual data change values from previous transactions in oracle?
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
what is asm?
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 are the different types of upgrades that can be performed in sql server? : sql server DBA
Where would you look for errors from the database engine?
What is the difference between clustered and non-clustered index? : sql server DBA
What the different components in replication and what is their use? : sql server DBA
how can you enable flashback feature?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What is dcl? : sql server DBA