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
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
when does an alert gets signaled?
What are the recovery models for a database? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
what is a user-defined lock?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What are the different ways you can create databases in sql server? : sql server DBA
What is dcl? : sql server DBA
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
How would you go about verifying the network name that the local_listener is currently using?
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 implement fine-grained auditing?
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.