DJ메탈짱™의 Free Style

1. DataBase SizeSELECT SUM(bytes)/1024/1024 FROM dba_data_files; 2. Table Size SELECT SUM(bytes)/1024/1024 FROM dba_extents WHERE segment_name='CORP_NEWS_TB'; 3.=================================================================The biggest portion of a database"s size comes FROM the datafiles. To find out how many megabytes are allocated to ALL datafiles: --> SELECT SUM(bytes)/1024/1024 "Meg" FROM..

-- 데이터베이스에 존재하는 모든 프로시저에서 사용된 테이블, 함수를 추출한다.WITH sp_list AS ( SELECT o.name AS proc_name , oo.name AS table_name , Row_number() OVER(partition by o.name, oo.name ORDER BY o.name, oo.name) AS row FROM sysdepends d INNER JOIN sysobjects o ON o.id = d.id INNER JOIN sysobjects oo ON oo.id = d.depid WHERE o.xtype = 'P')SELECT proc_name, table_nameFROM sp_list aWHERE row = 1 ORDER BY proc_name, table_..

1. Procedure Create/************************************************************************************* ' Procedure Name : sp_SelectTableColumnInfo_Second ' Written date : 2007.03.27 ' Writer : Bo H. Choi ' Contents : Table Information Select ( Column Name, Data Type, Column Length ) ' Updated by : ' Updated date : ' Updated contents : ' Sample : exec sp_SelectTableColumnInfo_Second 'Authors',..