a2zinterviews

33.	How can you get the information processed by log miner procedures?
	The information processed by log miner is stored in the v$logmnr_contents view. You can be use the dbms_logmnr.mine_value and dbms_logmnr.column_present procedures with the data in the v$logmnr_contents view to review the information.
	Discuss Your Name Your Email-ID Your Answer

34.	How can you generate profile of PL/SQL applications to identify performance bottlenecks?
	You can use the dbms_profiler package to collect and store profile information about a PL/SQL application.
	Discuss Your Name Your Email-ID Your Answer

35.	How can retrieve object definitions from data dictionary?
	You can use the dbms_metadata package to retrieve object definitions from data dictionary by specifying the following: Types of object, such as tables, indexes or procedures. Optional selection criteria, such as owner or name. Parse items (attributes of the returned objects that are to be parsed and returned separately) Optional transformations on the output in Extensible Markup Language (XML) or Data Definition Language (DDL) format.
	Discuss Your Name Your Email-ID Your Answer

36.	When does an alert gets signaled?
	Alerts are transaction based. Whenever, a transaction causing event of interest commits, the alert is signaled.
	Discuss Your Name Your Email-ID Your Answer