Using the Code Analyst
Go Up to Code Analyst
When working with database code stored in database objects, it is sometimes difficult to pinpoint bottlenecks within the code. When situations like this arise, Code Analyst can assist in identifying the trouble spots. Code Analyst can be used to analyze one object or a group of objects. You select one or multiple objects, execute them, view the results, and save those results for later viewing or comparing.
Common Tasks
- Creating a Code Analyst Session
- Identifying and Fixing Bottlenecks Using Code Analyst
- Comparing Code Analyst Sessions
- Cloning a Code Analyst Session
- Deleting a Code Analyst Session
- Stopping a Code Analyst Session Execution
- Executing a Code Analyst Session
- Scheduling a Code Analyst Session
- Unscheduling a Code Analyst Session
- Refreshing a Code Analyst Session
- Saving Results in Code Analyst
- Printing Results in Code Analyst
- Viewing Run Details in Code Analyst
- Viewing Unit Summary Information in Code Analyst
- Viewing Unit Details in Code Analyst
- Setting View Options for the Unit Detail Tab in Code Analyst
- Extracting SQL Text in Code Analyst
- Executing SQL in Code Analyst