Skip to main content

Comparison between count trends

Home > Select Project > Analysis > Counts Trend Comparison

You can check the operation trend of the key metrics of the database over time and trace the performance. You can also check the database operation trend by comparing the count trends on different dates. Through the Active sessions table, you can check active sessions and identify long-running sessions.

Basic screen guide

Counts Trend

  • If you select number 1 Base date, number 2 Comparison date, and Instance, the data is automatically applied to all widgets based on the selected items.

  • To see the meaning of the metric displayed in the widget, select Information icon next to the name or see the following.

    Note

    The tooltip of the Information Icon button is not supported in multiple languages.

  • To change the position with another widget, select and drag the upper part of the widget. However, the size of the widget cannot be changed.

  • The left of the number 3 Active sessions table displays the data for the Base date, and the right of the table displays the data for the Comparison date.

  • In the number 3 Active sessions table, the text colors are changed black → orangeRed, which means that the performance of the session is getting slower.

Selecting a comparison target

Select number 1 Base date and Instance, and then select number 2 Comparison date and Instance. If you hover your mouse over the chart, you can compare the data through the tooltip that appears.

  • The solid line in the graph chart displays the data for the Base date, and the dotted line displays the data for the Comparison date.

  • The items marked with (Comparison) in the tooltip are the data for the Comparison date.

Note
  • In Database, you can select a database for comparison.

  • The colors in Database are the same in the graph chart.

Comparing the active session data

Active Sessions

  • The time zone for data retrieval can be checked in number 4.

  • Active session data is collected every 5 seconds. You can search data for the desired time by selecting the button that moves in 5-second increments on the table.

  • If you select Previous time icon or Next time icon on the upper right, you can see the data in 1-minute increments. To move in increments of 5 seconds, select 5 seconds before icon or 5 seconds after icon.

  • In the Active sessions table list, the text colors are changed black → orangeRed, which means that the performance of the session is getting slower.

  • If you click a specific time point of the graph chart, the (number 3) area appears with a red line and the collected active sessions can be also seen.

Comparing with a specific time

Number of instructions processed per second

You can compare the data by zooming in on a specific time point. Select a desired time zone to anywhere on the widgets and then drag the chart. It displays the data for a specific time zone dragged to all widgets and active session tables.

Preset

In Monitoring a Database Instance, you can load the custom widget settings and the sorted active sessions as presets.

Note

For more information about the Preset configuration, see the following.

Column information guide

For more information about columns, see the link.

ItemDescription
actionTask or command running in the current session.
active_flagWhether the session is active or not.
autocommit_flagWhether automatic commit is active or not.
client_app_infoInformation about the client application.
client_infoCustom information of the client.
client_nlsClient's National Language Support (NLS) setting.
client_package_versionVersion of the client package.
client_pidProcess ID of the client.
client_protocol_versionVersion of the protocol used between the client and server.
client_typeClient type.
comm_nameName of the communication being used in the session.
commit_write_wait_modeData write waiting mode upon commit.
current_stmt_idID of the SQL statement running.
data page getsNumber of accesses to read the data page.
data page readNumber of physical reads to the data page.
db_usernameUser name connected to the database.
dblink_global_transaction_levelGlobal transaction level of the DB link.
dblink_remote_statement_autocommitWhether the DB link remote document is automatically committed or not.
dbnameName of the connected database.
ddl_time_limitTime limit for DDL (Data Definition Language) operations.
default_date_formatDefault date format.
default_tbsidDefault tablespace ID of the session.
default_temp_tbsidDefault temporary tablespace ID of the session.
elapse_timeTime elapsed since the task started.
eventCurrent or last event occurred.
execute success countNumber of successful commands executed.
failover_sourceSource server information upon failover.
fetch_time_limitMaximum time to fetch data.
header_display_modeDisplay mode of the header information.
idUnique ID of the session.
idle_time_limitIdle time limit of the session.
isolation_levelIsolation level of the current transaction.
lob_cache_thresholdThreshold of the LOB (Large Object) cache.
login_timeLogin time of the session.
max_statements_per_sessionMaximum number of statements that can be executed per session.
memory table access countNumber of accesses to the memory table.
moduleName of the running module.
nls_currencyCurrency symbol used in NLS settings.
nls_iso_currencyISO currency code used in NLS settings.
nls_numeric_charactersNumeric characters used in NLS settings.
nls_territoryRegional information used in NLS settings.
onameAgent or instance name.
opened_stmt_countNumber of open SQL statements.
optimizer_modeQuery optimization mode.
p1First parameter of the event.
p2Second parameter of the event.
p3Third parameter of the event.
paralle_dml_modeParallel DML (Data Manipulation Language) mode.
queryExecuted SQL query.
query_hashHash value of the query.
query_paramParameters used for a query.
query_rewrite_enableWhether to enable the query rewrite operation or not.
query_time_limitTime limit for query operation.
rebuild countNumber of rebuild operations.
replication_modeReplication mode setting.
second_in_timeIt represents the time in seconds.
seqnumSequence number of the session.
session_stateCurrent state of the session.
ssl_certificate_issuerIssuer of the SSL certificate.
ssl_certificate_subjectSubject information of the SSL certificate.
ssl_cipherSSL encryption method in use.
stack_sizeStack size of the session.
sysdba_flagIt represents whether to use the SYSDBA role or not.
task_stateCurrent task state.
timeTask operation time.
time_zoneTime zone setting for the session.
trans_idCurrent transaction ID.
transaction_modeTransaction mode.
trx_update_max_logsizeMaximum log size during transaction update.
utrans_time_limitTime limit for user transactions.
wait_timeWaiting time of the session.
xa_associate_flagXA transaction associated flag.
xa_session_flagXA transaction session flag.