1-ョORACLE琛ㄧ┖寸浣跨ㄦ电存ヤ娇ㄦ碉

SELECt "琛ㄧ┖村瀛", "舵",

( / 1024 / 1024) as "诲卞灏M",

(( - DECODE(, NULL, 0, )) / 1024 / 1024) as "宸茬ㄤ澶灏M",

(DECODE(, NULL, 0, ) / 1024 / 1024) as "╀澶灏M",

(( - DECODE(, NULL, 0, )) / 1024 / 1024)/( / 1024 / 1024) as "╃ㄧ",

DECODE(sign((( - DECODE(, NULL, 0, )) / 1024 / 1024)/( / 1024 / 1024)-),1,'╀涓10%锛璇疯╄〃绌洪','姝ｅ父') as "娓╅Θ绀"

FROM D, $TS_AVAIL A, $TS_FREE F

WHERe =

AND (+) = ;

2ョoracle杩ユ

select count(*) from v$session --杩ユ

Select count(*) from v$session where status='ACTIVE'--骞跺杩ユ

alter system set processes = value scope = spfile;--版搴 淇硅

3涓鸿〃绌洪存╁

--涓鸿〃绌洪村版浠

alter tablespace users add datafile 'c:' size 100M;

--澧琛ㄧ┖村版浠跺昂瀵

alter database datafile 'c:oracleora81oradata\' resize 1000M;

4ヨ㈣〃绌洪村ぇ灏

select tablespace_name,file_id,bytes/1024/1024,file_name

from dba_data_files order by file_id;