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
Why does Oracle not permit the use of PCTUSED with indexes?
what are the benefits of flashback feature?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
what is the use of recording information about current session?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
What is the difference between clustered and non-clustered index? : sql server DBA
How do you open a cluster administrator? : sql server DBA
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
What the different components in replication and what is their use? : sql server DBA
how can you schedule a job in database?
what do you understand by fine-grained auditing?
what is the role of dip user in our database?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
what do you understand by flashback feature of oracle?
what is a crs resource?