Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Where can one find D high water mark for a table?

April 26, 2017high Mark Table water

0

Posted

Where can one find D high water mark for a table?

1 Answer

0

Posted

D re is no single system table which contains D high water mark (HWM) for a table. A table’s HWM can be calculated using D results 4m D following SQL statements: SELECT BLOCKS 4m DBA_SEGMENTS WHERE OWNER=UPPER(owner) AND SEGMENT_NAME = UPPER(table); ANALYZE TABLE owner.table ESTIMATE STATISTICS; SELECT EMPTY_BLOCKS 4m DBA_TABLES WHERE OWNER=UPPER(owner) AND TABLE_NAME = UPPER(table); Thus, D tables’ HWM = (query result 1) – (query result 2) – 1 NOTE: u can also use D DBMS_SPACE package and calculate D HWM = TOTAL_BLOCKS – UNUSED_BLOCKS – 1.