What is mean by fractured block in terms of manual hot backup?
Latest Answer: The concept of fractured block occrus when backup is under process.It means you are taking backup and some other session is updating it.Then backup process can not get the consistent image of the block and it will be inconsistent right thats why it is ...
Can we read Control file? If yes, then how?
Latest Answer: SQL> ALTER DATABASE BACKUP controlfile TO trace;
You can find the trace file which is backup of control file in udump directory.
...
Latest Answer: Sql>alter database begin backup;The above query is used to freeze the header of all datafiles belongs to tablespace in that particular database.Freeze means lock i.e during backup no data's will be get in the datafiles.To release the headers from ...
Latest Answer: In 10g the AWR repository keeps track of data for 60 days by default and can store the information of tablespace growth for this period.Alternativey you can set the threshold in entreprise manager for a tablespace to respective which can trigger email ...
Latest Answer: Sets of free lists available for use by one or more instances.When data is frequently inserted into a table from multiple nodes and the table is not partitioned, use free list groups to avoid performance issues. In such situations, contention can be due ...
Latest Answer: A process that runs on each of the nodes. It functions as the executor of jobs and events sent by the console by way of the mangement server. High availability is ensured since the agent can function regardless of the status of the cosole or ...
Latest Answer: It is two. It is the minimum no of extents that we can assign to roll back segment.The max extents depends on the version of Oracle being used. ...
Latest Answer: ofcourse Ascending ...
Imagine that you joined a company as DBA and your first task is to create test and production database environments for application developers and users. How would you analyze requirements for a new DBMS?
Latest Answer: In simple terminology, combination of S/w(Operating system et all) and hardware(Disk Drives) on which these S/W(OS) are loaded, are vital for smooth runing of system. Failure of any of these tools make a system to crash.now if any software(OS) ...
View page << Previous 1 2 [3] 4 5 6 7 Next >>
Go Top
