what are the necessary steps to be take when server gets down? How can we increase size of a database?
Latest Answer: 1.Bring up the server. 2.Run the profile of the database 3.Bring up the database. 4.In server prompt, check ps- ef | grep pmon - This is used to check whether the database is up or not. 5.Bring up the listener. 6.Check whether the tablespace ...
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: 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 ...
View page [1] 2 3 4 5 6 Next >>

Go Top