More than 5 years have passed since last update.

Oracle ハイウォータマーク(HWM)の確認

SQL
oracle

Last updated at 2015-05-09Posted at 2015-01-21

内容

ハイウォータマーク(HWM)確認用SQL

手順

SQL

SELECT 
  S.BLOCKS "確保済み", T.BLOCKS "HWM" 
FROM 
  USER_TABLES T JOIN USER_SEGMENTS S 
ON 
  (T.TABLE_NAME=S.SEGMENT_NAME) 
WHERE 
  T.TABLE_NAME='テーブル名';

結果（例）

  確保済み        HWM
---------- ----------
         8          1

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up