ASH情報取得(ACTIVE_SESSION_HISTORY)

## ASH情報取得(ACTIVE_SESSION_HISTORY)
## DB：{Instance}

sqlplus -s -L {account}/{passwd}@{sid} << EOF > {log_filename}
SET FEEDBACK OFF
SET MARKUP CSV ON
ALTER session set NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS';

SELECT * FROM v\$active_session_history
WHERE
SAMPLE_TIME BETWEEN TO_TIMESTAMP ('2025-11-20 11:40:00','YYYY-MM-DD HH24:MI:SS')
            AND     TO_TIMESTAMP ('2025-11-20 12:01:00','YYYY-MM-DD HH24:MI:SS')
ORDER BY 1,2;
exit
EOF

## ASH情報取得(ACTIVE_SESSION_HISTORY)

## DB：{Instance}

sqlplus -s -L {account}/{passwd}@{sid} << EOF > {log_filename}

SET FEEDBACK OFF

SET MARKUP CSV ON

ALTER session set NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS';

SELECT * FROM v\$active_session_history

WHERE

SAMPLE_TIME BETWEEN TO_TIMESTAMP ('2025-11-20 11:40:00','YYYY-MM-DD HH24:MI:SS')

AND TO_TIMESTAMP ('2025-11-20 12:01:00','YYYY-MM-DD HH24:MI:SS')

ORDER BY 1,2;

exit

EOF

ASH_待機イベントカタログ

テンプレートサイト

－サンプル、テンプレート－

コメントを残す