Tuesday, April 10, 2012

RAC-aware AWR report

Как аггрегировать AWR по всем узлам кластера ?

Начиная с 11.1 появились скрипты $OH/rdbms/admin/awrg*.sql :
- awrgrpt.sql  - Workload Repository RAC Report
- awrgdrpt.sql - Workload Repository RAC Compare Periods report
которые делают необходимую аггрегацию.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Does DEALLOCATE UNUSED or SHRINK SPACE will free space occupied by LOB segment?

Lets check how it works. My env is DB 19.20@Linux-x64 1) I created the table with 4 LOB columns of 4 different LOB types: BASICFILE BLOB, BA...