Can we read Control file? If yes, then how?
Latest Answer: Yes, We can read control filefirst we have to transfer it to text file.sql> alter database backup controlfile to trace,we can view the controlfile from user_dump_test. ...
Latest Answer: In oracle 9i we have some limitation with reqard to Backing up entire dataabase in one go. First we will have to take the database in mount stage (not open) in order to take the back up, and that too, one tablespace at a time. like:-sql>alter ...
Latest Answer: select sum(bytes),TABLESPACE_NAME from dba_segments group by TABLESPACE_NAMEorder by sum(bytes) desc/ ...
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 Next >>
Go Top
