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 the commands you'd issue to show the explain plan for "select * from dual"?
what is the role of dip user in our database?
what functionality does oracle provide to secure sensitive information?
What happens on checkpoint? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
which background process invoke at the time of upgradation tell me???
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 are the operating modes in which database mirroring runs? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
What the different components in replication and what is their use? : sql server DBA
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?