Answer Posted / guest
dbcc dbreindex ('table_name' [, index_name [,
fillfactor ]]) [WITH NO_INFOMSGS]
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What are statistics, under what circumstances they go out of date, how do you update them?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
how can you get actual data change values from previous transactions in oracle?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
how can you connect from 10g user to 11g user??
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What is the importance of a recovery model? : 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?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?
what functionality does oracle provide to secure sensitive information?
What is a system database and what is a user database? : sql server DBA