method-r.com

Contents

1. Select Help > Check for Updates...
   
2. If the Welcome dialog appears, click Next.
3. If you are updating a prior installation of Profiler Extension, make sure the Method R Extension box is checked and skip to step 8. If you are installing for the first time, continue with the next step.
4. Click Add. The Update Center dialog appears.
5. In the Name field, enter: Method R Extension.
6. In the Location field, enter: http://www.method-r.com/extension/
7. Click OK. The 'Source' dialog appears.
8. Click Next. The 'Updates' dialog appears.
9. Click the checkbox next to the Method R Extension you want to install, then click Next. The 'Download' dialog will appear that will display progress status. Once the download completes the 'Summary' dialog appears.
10. Click Finish. The Preferences dialog appears.
11. Click OK. The Confirm Restart dialog appears.
12. Click Yes to restart SQL Developer.

• Select Method R Profiler > Profile Statements. A check mark next to Profile Statements indicates the Profiler Extension is enabled.
  
• Click the Method R icon in the toolbar. The icon appears in color when the Extension is enabled and is gray when it disabled.

1. Enter the statements you want to profile in a SQL Worksheet.
2. Click the Run Script icon. The Profiler Extension will begin processing and the log panel will display any status or error messages.
3. If the Profiler completes successfully, the following actions will occur:
   • An HTML document opens in your default web browser, if you have selected that option in your preferences.
   • An entry appears in the Profiler History panel.
   • The HTML output will be stored in the trace files directory as specified in the preferences panel.

When this dialog appears:

1. Select one of the following options:

   DBA has executed script manually.

   Select this option if your DBA has already granted the required access.

   Grant access to PUBLIC (all accounts).

   Select this option if you want to grant the required access to all accounts.

   Grant access to account only.

   Select this option if you want to grant the required access only to the specified user.

2. Enter the password for the SYS account if you have selected one of the Grant access options.
3. Click OK.

DECLARE
  v_schema VARCHAR2(40) := '"PUBLIC"';
  v_user_dump_dest VARCHAR2(2000);
BEGIN
  select value into v_user_dump_dest
  from v$parameter
  where name = 'user_dump_dest';

  EXECUTE IMMEDIATE 'CREATE OR REPLACE DIRECTORY "METHODR_UDUMP_DEST" AS ''' || v_user_dump_dest || '''' ;
  IF v_schema != '"SYS"' THEN
    EXECUTE IMMEDIATE 'GRANT READ ON DIRECTORY METHODR_UDUMP_DEST TO ' || v_schema ;
    EXECUTE IMMEDIATE 'GRANT ALTER SESSION TO ' || v_schema ;
    EXECUTE IMMEDIATE 'GRANT SELECT ON SYS.V_$INSTANCE TO ' || v_schema ;
    EXECUTE IMMEDIATE 'GRANT SELECT ON SYS.V_$SESSION TO ' || v_schema ;
    EXECUTE IMMEDIATE 'GRANT SELECT ON SYS.V_$PROCESS TO ' || v_schema ;
    EXECUTE IMMEDIATE 'GRANT SELECT ON SYS.V_$MYSTAT TO ' || v_schema ;
    EXECUTE IMMEDIATE 'GRANT EXECUTE ON DBMS_UTILITY TO ' || v_schema ;
    EXECUTE IMMEDIATE 'GRANT EXECUTE ON DBMS_LOB TO ' || v_schema ;
  END IF;
END;

To open one or more Profile output files from the history, select the desired files in the History panel, then click Open. The files will open in your default browser.

To clear files from the history, click Clear in the History panel. All history records will be cleared from the table. This does not delete the files from the drive.

1. Select Tools > Preferences. The Preferences dialog appears.
2. Select the Method R Profiler tree item. The Method R Profiler preferences appear displaying a panel with 2 tabbed pages. The first tabbed pane contain the Extension Preferences and the second contain the Profiler Parameters.

Extension Preferences

Enable Profiler on startup

Check this box if you want the Profiler Extension to be enabled when you start SQL Developer.

Directory to save trace files

Enter a directory path or click Browse to find a directory. All trace files generated with the Method R Profiler Extension will be stored in the specified directory.

Maximum trace file size (MB)

Enter or select the maximum trace file size you want to automatically download when you profile code. If the trace file that is generated exceeds this size, you will be asked to confirm the download, or the download will be skipped without confirmation, depending on the setting for Confirm if limit is exceeded.

Confirm if limit is exceeded

If this box is checked, you will be asked to confirm the trace file download if the file exceeds the value specified in Maximum trace file size (MB). If this box is not checked, the download will be skipped without a confirmation if the limit is exceeded.

Logging Level

This is the Java logging level that controls the type of messages that displayed for the Method R Profiler extension. Each log message is associated with a level to indicate the importance and urgency of the message. Changing this setting will result in increasing or decreasing the amount of messages that are displayed to the logging window.

Profiler Parameters

Automatically open HTML output in default web browser

Check this box if you want the Profiler output to automatically open in your default web browser when you profile code.

Call definitions

Enter a call definitions file location or click Browse to find a call definitions file. The Profiler User Guide contains more information about specifying call definitions. To see the Profiler User Guide, select Start > All Programs > Method R > Profiler > User Guide.

Transform parameters

Enter a transform parameters file location or click Browse to find a transform parameters file. The Profiler User Guide contains more information about specifying transform parameters. To see the Profiler User Guide, select Start > All Programs > Method R > Profiler > User Guide.

Maximum Java heap size (MB)

Select a maximum size for the Java heap during execution of the Method R Profiler.

Nanoseconds per 'microsecond'

Set the number of nanoseconds per Oracle “microsecond.”

Property Files

Setting Up Logging

Saving Log Messages to a File

1. Select Tools > Preferences. The Preference dialog appears.
2. Select the Environment > Log tree items. The Environment:Log dialog opens.
3. Check Save Logs to File, then enter a Log Directory or click Browse to find a directory.
4. Select any other desired options, then click OK.

1. Select Method R > Profile Input File...
   
2. A form will appear as shown below:
   

Select a file to profile

The first parameters is the input file that can selected by clicking the Browse button next to the text field. This can be a Trace file or a Zip file containing trace files.

Profiler Parameters

The other fields are exactly the Profiler Parameter as described in the Preferences section.

Results

The Results text area is the location where the logging data will be collected about the execution of the Profiler status.