Answer Posted / ramesh
ALTER INDEX <Index> REBUILD ONLINE;
one Should Configure a script to Rebuild indexes at Regular
intervals for the needy
Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Query processing is slow(eg select query)how will u solve that
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
what is the role of dip user in our database?
Why does Oracle not permit the use of PCTUSED with indexes?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
how can you create a user-defined lock?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What the different types of replication and why are they used? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
how can you process messages in order asynchronously?
what is the diffrence between core dba and apps dba?
What are statistics, under what circumstances they go out of date, how do you update them?