DB스토리

using by user. --1. 만들기 S SYS> create temporary tablespace temp2; Tablespace created. --2. 적용. S SYS> alter user hr temporary tablespace temp2; User altered. --3. 적용 확인 S SYS> select username, temporary_tablespace from dba_users where username='HR'; USERNAME TEMPORARY_TABLESPACE ------------------------------ ------------------------------ HR TEMP2 --4. 사용중인 모든 temp t/s 목록 S SYS> select distinct..

SELECT b.file_name "FILE_NAME", -- DataFile Name b.tablespace_name "TABLESPACE_NAME", -- TableSpace Name b.bytes / 1024 / 1024 "TOTAL SIZE(MB)", -- 총 Bytes ((b.bytes - sum(nvl(a.bytes,0)))) / 1024 / 1024 "USED(MB)", -- 사용한 용량 (sum(nvl(a.bytes,0))) / 1024 "FREE SIZE(KB)", -- 남은 용량 (sum(nvl(a.bytes,0)) / (b.bytes)) * 100 "FREE %" -- 남은 % FROM DBA_FREE_SPACE a, DBA_DATA_FILES b WHERE a.file_id(+) =..

메모리 보기 S SYS> show sga Total System Global Area 268435456 bytes Fixed Size 1218920 bytes Variable Size 201328280 bytes Database Buffers 62914560 bytes Redo Buffers 2973696 bytes S SYS> show parameter db_cache_size S SYS> show parameter sga_max; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ sga_max_size big integer 256M S SYS> show parameter pool;..

SQL> select owner, object_type, count(*) from dba_objects where owner in('SCOTT','HR','OE','PM') and object_type in('TABLE', 'VIEW', 'SEQUENCE','INDEX') group by cube(owner,object_type); OWNER OBJECT_TYPE COUNT(*) ------------------------------ ------------------- ---------- 113 VIEW 16 INDEX 57 TABLE 35 SEQUENCE 5 HR 30 HR VIEW 1 HR INDEX 19 HR TABLE 7 HR SEQUENCE 3 OE 61 OWNER OBJECT_TYPE COUN..