a2zinterviews

9.	What is row migration?
	Whenever a row length increase, as a result of an update and the current block is unable to provide additional space, the row has to be moved to another block with sufficient space. In such situation , the original location of the row holds the rowid of the new location.
	Discuss Your Name Your Email-ID Your Answer

10.	Explain the steps of creating copy of a control file?
	Following are the steps to create a copy of control file. Shutdown the database using the shutdown normal, shutdown immediate, or shutdown transactional command. Copy the control file to another disk using operating system's file copy command. Modify the CONTROL_FILE parameter in initialization parameter file to include additional control file. Restart the instance
	Discuss Your Name Your Email-ID Your Answer

11.	What is freelist?
	Freelist is a bitmap kind of structure in the header of every segment in which every bit maps to a block in the segment. This list can be used to determine which blocks are available to insert new rows.
	Discuss Your Name Your Email-ID Your Answer

12.	Can you change SHARED_POOL_SIZE online?
	Yes, you can change SHARED_POOL_SIZE online by using the following statement: SQL> alter system set SHARED_POOL_SIZE = 200M scope =spfile and restart.
	Discuss Your Name Your Email-ID Your Answer