Цитата: OlegON ➤ А какого рода нагрузка? Куда стучится, что напрягает?
Вот кусок админского отчета:
Цитата: inding 1: Top SQL Statements
Impact is ,87 active sessions, 47,29% of total activity.
--------------------------------------------------------
SQL statements consuming significant database time were found. These
statements offer a good opportunity for performance improvement.
Recommendation 1: SQL Tuning
Estimated benefit is ,6 active sessions, 32,49% of total activity.
------------------------------------------------------------------
Action
Run SQL Tuning Advisor on the SELECT statement with SQL_ID
"0w01bv2446ynj".
Related Object
SQL statement with SQL_ID 0w01bv2446ynj.
Select nvl(max(EnqSeq),-1) from Supermag.SMObjectChange where
ObjType='MG' and ObjID='SMMESSAGES'
Rationale
The SQL spent 99% of its database time on CPU, I/O and Cluster waits.
This part of database time may be improved by the SQL Tuning Advisor.
Rationale
Database time for this SQL was divided as follows: 100% for SQL
execution, 0% for parsing, 0% for PL/SQL execution and 0% for Java
execution.
Rationale
SQL statement with SQL_ID "0w01bv2446ynj" was executed 81383 times and
had an average elapsed time of 0.23 seconds.