Especially important for bulkdelete performance.Ī higher value may be required if the directory size exceeds 1 million entries or a high rate of I/O is observed. Table 23-1 Minimum Values for Oracle Database Instance Parameters ParameterĪpplicable when SGA Auto Tuning using sga_target and sga_max_size is being used. Restart Oracle Internet Directory for the change to take effect. ![]() In "cn=dsaconfig,cn=configsets,cn=oracle internet directory", set the orclskiprefinsql attribute to 1, to skip the referral for the search.įor more information, see " Attributes of the DSA Configuration Entry" in Oracle Fusion Middleware Administrator's Guide for Oracle Internet Directory. If there are no referral entries in your environment, you can improve performance by preventing the previous query from being executed, as follows: If this SQL query has fields such as "attrvalue = 'referral'", the query can be skipped from being executed in environments where only one Oracle Internet Directory instance is running and there are no referrals to other Oracle Internet Directory processes. If a query is taking a second or more to execute, it should be investigated in the next step.įor the event that displays the highest "Elapsed Time per Exec (s)", click the value under the "SQL Id" column to show the SQL query that was executed. Under normal conditions, a query should execute in less than one second (shown in milliseconds in the table). In the "SQL Statistics" section, check the "SQL ordered by Elapsed Time" table:Ĭheck the values in the "Elapsed Time per Exec (s)" column. Check the "Waits" and the "Avg wait (ms)" columns and note the event with the highest average wait time. This table can provide information about events that might be causing performance issues. The database generates the AWR report in the directory where you executed the sqlplus command.Īnalyze the AWR report to try to determine the issue causing the performance issue, as described in the next section.Ĭheck the "Top 5 Timed Foreground Events" table. Accept the default report name, or enter a new name. Based on this time period, define the range of snapshots for which AWR data needs to be extracted by specifying a beginning and ending snapshot ID. Identify the time when the performance issue occurred. Each snapshot is assigned a unique snapshot ID.īeginning and ending snapshot ID for the workload repository report. The awrrpt.sql script lists snapshot IDs for the number of days selected. If the issue occurred yesterday, enter 2. For example, if the issue occurred today, then enter 1. ![]() This value should indicate the time period in days when the performance issue occurred. Number of days for which you want to list snapshot IDs. When prompted, specify the following information for the report: Generate the AWR report by running the awrrpt.slq script at the SQL prompt. To generate a specific AWR report, run the awrrpt.sql SQL script:Ĭonnect to the Oracle database as the sysdba user. Some choices might be greyed out, depending upon your previous choices. On each page, specify values for the text fields (or use defaults) and Select Yes or No for each question. The wizard presents the following pages: Sizing, Hardware, Features, Load, Data Characteristics, and Garbage Collection. On the Sizing page, specify values for the text fields (or use defaults) and Select Yes or No for each question. On the Type Selection page, select Sizing. To delete the report, click Delete.įrom the Oracle Internet Directory menu, change the report name, then select Administration, then Tuning and Sizing. To download the report, click Download Report. ![]() The report appears on the bottom right section of the page. Click Back to change your specifications or click Finish to view the report. On the Review page, review the data you entered. Most fields have tool tips that appear when you move the cursor over the field.Ĭlick Next to go to the next page or Back to return to the previous page. The wizard presents the following pages: Hardware, Features, Load, Data Characteristics, and Garbage Collection. On the Type Selection page, change the report name, then select Tuning. If you select Sizing or Both, you can select Basic or Advancedįrom the Oracle Internet Directory menu, select Administration, then Tuning and Sizing.Ĭlick the Create icon to invoke the wizard. Use the wizard to obtain tuning and sizing recommendations for your system. Oracle Enterprise Manager Fusion Middleware Control provides a convenient tool for tuning and sizing Oracle Internet Directory. 23.2.2 Obtaining Recommendations by Using the Tuning and Sizing Wizard
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |