db2 table size

-1. View the name and size of the Tablespace select T.tablespace_name, round (SUM (Bytes/(1024x768)), 0) Ts_sizefrom dba_tablespaces T, dba_data_file s Dwhere t.tablespace_name = D.tablespace_namegroup by t.tablespace_name;--2, view table space physical file name and size select Tablespace_name, File_id,file_name,round (Bytes/(1024x768), 0) Total_spacefrom Dba_da

Four ways to increase table space sizeMEATHOD1: Adding data files to table spacesALTER tablespace App_Data ADD datafile' D:\ORACLE\PRODUCT\10.2.0\ORADATA\EDWTEST\APP03. DBF ' SIZE 50M;MEATHOD2: Add data file and allow data file to grow automaticallyALTER tablespace App_Data ADD datafile' D:\ORACLE\PRODUCT\10.2.0\ORADATA\EDWTEST\APP04. DBF '

Troubleshoot virtual Box installation Mac OS x when the "Hfs:summary table not allowed on FS with block size of 2048" issue occursThe first thing that happens when you installHfs:summary table not allowed on FS withblock size of 2048Error. Then there isHfs:could not initializc summary

Turn from: http://blog.csdn.net/rocklee/article/details/51251174 invasion and deletionSimple.select pg_size_pretty(pg_relation_size(‘table_name‘));View table size and sortSELECT table_schema || ‘.‘ || table_name AS table_full_name, pg_size_pretty(pg_total_relation_size(‘"‘ ||table_schema || ‘"."‘ || table_name || ‘"‘)) AS sizeFROM information_schema.tablesORDER BY pg_total_relation_size(‘"‘ || table_sche

NEXT from Info_cursorInto @tablenameENDCLOSE Info_cursorDeallocate info_cursorGOIi. execution of stored proceduresEXEC Get_tableinfoThird, query table dataSELECT *From TablespaceinfoOrder BY cast (left (LTrim (RTrim (reserved)), Len (LTrim (RTrim (reserved)))-2 as int) desc************************************************************************************Simple analysis:1. Single tableEXEC sp_spaceused N ' table