Interested to Buy Any Domain ? << Click Here >> for more details...
by issuing "alter tablespace begin backup;" what happens to
tablespace?
- 5 Answers
- 9308 Views
- CSC, Logica CMG, I also Faced
- E-Mail Answers
Answer Posted / kittu
by issuing above statement it freezes tablespace it won't
allow single transaction to datafile. by this time redologs are generated & excessive redologs also
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
what is the diffrence between core dba and apps dba?
How would you extract DDL of a table without using a GUI tool?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
What the different types of replication and why are they used? : sql server DBA
how can you find out if a table can be redefined?
how can you communicate with operating system files from oracle?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
Why would you call update statistics? : sql server DBA
what is the use of recording information about current session?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is the importance of a recovery model? : sql server DBA
