tech_memo/ORACLE
High Water Mark †
- 下記がかなりわかりやすい。ただしOracle8なので古い。。。
HWM確認方法その1 †
variable total_blocks number
variable total_bytes number
variable unused_blocks number
variable unused_bytes number
variable last_used_extent_file_id number
variable last_used_extent_block_id number
variable last_used_block number
exec dbms_space.unused_space('$DB_USER', '$TAB_NAME', 'TABLE', :total_blocks, :total_bytes, :unused_blocks, :unused_bytes, :last_used_extent_file_id, :last_used_extent_block_id, :last_used_block);
print
HWM確認方法その2 †
最新の20件
2023-01-26
2022-11-11
2022-03-02
2022-02-03
2021-11-18
2021-11-11
2021-10-27
2021-10-04
2021-09-30
2021-08-24
2021-04-01
2021-02-25
2020-08-13
2020-05-22
2020-04-16
2020-04-15
2020-03-23
2020-03-12
2020-02-27
今日の20件
- counter: 365
- today: 1
- yesterday: 0
- online: 1