by issuing "alter tablespace begin backup;" what happens to
tablespace?
Answer Posted / kittu
by issuing above statement it freezes tablespace it won't
allow single transaction to datafile
Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
what is a user-defined lock?
What would you do with an "in-doubt" distributed transaction?
What the different components in replication and what is their use? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What are the commands used in dcl? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What the different types of replication and why are they used? : 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
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
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 performance views in an oracle rac environment?