Code Analyst Options

Go Up to Configuring Feature Options

Code Analyst is a utility that helps you identify time-consuming lines of code. The Code Analyst tab of the Options Editor lets you specify Code Analyst operational parameters.

Note: For information on opening the Options Editor, see Specifying Application Preferences and Feature Options.

Note: For information on using Code Analyst, see Code Analyst.

The table below describes Code Analyst options:

Group	Options and descriptions
Dependency profiling level	All Dependencies	Code Analyst will use all levels of dependencies when profiling the session.
	Dependencies up to level	Lets you specify how many levels of dependencies the Code Analyst will use when profiling the session.
Oracle	List Package objects	Code Analyst lists the procedures within a package and functions that are found in the Oracle database.
	Use SQL Profiler	Code Analyst uses Oracle's DBMS_Profiler package to collect time metrics. Code Analyst displays the actual run time on the database, and does not include the time it takes to get to the server.
Alarms and Thresholds	Lets you set an alarm for each type of object that is collected. For each supported Object Type (procedure, function, package, trigger, type), you can provide the following settings: Alarm % - lets you specify the percentage of total run time a line of code takes when an alarm appears. If the object took more than specified percent of total time, Code Analyst alerts the user by changing the color of the text Ignore 100% - lets you ignore lines of code that take all of the total run time
Show Code Analyst Confirmation Dialog	When you create or execute a session, Code Analyst displays a message that the Code Analyst will run longer than the actual code. You can also select the Please do not show me this dialog again option in the dialog.