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. by this time redologs are generated & excessive redologs also
Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
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?
what is the diffrence between core dba and apps dba?
what do you understand by fine-grained auditing?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
What types of replication are supported in sql server? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
how can you implement fine-grained auditing?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
what is a crs resource?
What are the different types of indexes available in sql server? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What is transparent data encryption? : sql server DBA
what is the use of ocr?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?