a2zinterviews

21.	What is a user process trace file?
	A user process trace file is a trace file that is produced by user session. However, this is an optional file, which is generated if the user wants to generate the file. This file is generated when the value of SQL_TRACE parameter is set to TRUE for a session. This parameter can be set at database, instance, or session level. If it is instance level, trace file will be generated for all the connected sessions. If it is set at session level, trace file will be generated only for the specified session. The location of user process trace file is specified in the USER_DUMP_DEST parameter. The information in user process trace file is generally used for trouble shooting.
	Discuss Your Name Your Email-ID Your Answer

22.	Which tools are available to monitor performance?
	Oracle offers Oracle Enterprise Manager (OEM) to monitor performance. OEM can also be used to startup and shutdown the instance. In addition, it can be used to manage database in general.
	Discuss Your Name Your Email-ID Your Answer

23.	What is an event?
	An event is an Oracle is an occurrence that substantially alters the way your database executes or performs. There are two types of events in Oracle: wait events and OEM defined events.
	Discuss Your Name Your Email-ID Your Answer

24.	What is the main reason for block corruption?
	Block corruption or physical corruption occurs when a block on a physical disk becomes unreadable or inconsistent to the state that the data is unusable. Block corruption can be caused by many different sources; and therefore, it is difficult to find the exact reason of block corruption. However, it is mostly due to human error with the use of software (patches) firmware, or hardware bugs. You can avoid this by testing all the hardware and software patches thoroughly in the test environment. In addition, you can use mirrored disk to protect your data.
	Discuss Your Name Your Email-ID Your Answer