Oracle ±í¿Õ¼ä»ù±¾²Ù×÷
1. ²éѯÊý¾Ý¿âÏÖÔڵıí¿Õ¼ä
select tablespace_name, file_name, sum(bytes)/1024/1024 table_size from dba_data_files group by tablespace_name,file_name;
2. ½¨Á¢±í¿Õ¼ä
CREATE TABLESPACE data01 DATAFILE '/oracle/oradata/db/DATA01.dbf' SIZE 500M;
3.ɾ³ý±í¿Õ¼ä
DROP TABLESPACE data01 INCLUDING CONTENTS AND DATAFILES;
4. Ð޸ıí¿Õ¼ä´óС
alter database datafile '/path/NADDate05.dbf' resize 100M
5.Ôö¼ÓÊý¾ÝÎļþ
ALTER TABLESPACE NEWCCS ADD DATAFILE '/u03/oradata/newccs/newccs04.dbf' SIZE 4896M;
Ïà¹ØÎĵµ£º
½ñÌìÔÚÒ»±¾ÊéÉÏ¿´µ½µÄ£¬¸Ð¾õͦȫµÄ¡£Ó¡ÏóÖÐ×Ô¼ºÒѾ²»ÖªµÀ°Ù¶ÈÁ˶àÉÙ´ÎÕâ¸öÎÊÌ⣬½ñÌì¾Í¼ÇÏÂÀ´°É£¬·½±ãÒÔºó²éѯ¡£
Êý¾Ý¿âд½ø³ÌÔÚÒÔÏÂʼþÖ®Ò»·¢Éúʱ°ÑÊý¾Ý¿â¸ßËÙ»º³åÇøµÄÊý¾Ýдµ½Êý¾ÝÎļþÉÏ:
µ±Ô໺³åÇøµÄÊýÁ¿³¬¹ýÁËËùÉ趨µÄÏÞ¶î
µ±ËùÉ趨µÄʱ¼ä¼ä¸ôÒѵ½
µ±Óнø³ÌÐèÒªÊý¾Ý¿â¸ßËÙ»º³åÇøÈ´ÕÒ²»µ½¿ÕÏеĻº³åÇøʱ
µ±¼ì²éµ ......
1 ÎÊÌâÃèÊö
oracleÊý¾Ý¿âÔÚ·þÎñÆ÷ÉÏÔËÐÐÕý³££¬µ«ÊDz»ÄÜͨ¹ýÍøÂçÁ¬½Ó£¨¼´Ê¹Óÿͻ§¶Ë²»ÄÜÁ¬½ÓÊý¾Ý¿â£¬ÔÚ·þÎñÆ÷¶ËÕý³££¬Õï¶ÏµÄ³õ²½ÔÒòΪ¼àÌýÆ÷ÎÊÌ⣩¡£ÔÚ·þÎñÆ÷¶ËʹÓÃÒÔÏÂÃüÁ
bash-3.1$ cd $ORACLE_HOME/bin
bash-3.1$ ./lsnrctl
LSNRCTL> status
½á¹û³öÏÖ£º
CONNECT (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=E ......
ORACLE´¥·¢CHECKPOINTµÄÌõ¼þ
1.µ±·¢ÉúÈÕÖ¾×éÇл»µÄʱºò
2.µ±·ûºÏLOG_CHECKPOINT_TIMEOUT£¬LOG_CHECKPOINT_INTERVAL£¬fast_start_io_target,fast_start_mttr_target²ÎÊýÉèÖõÄʱºò
3.µ±ÔËÐÐALTER SYSTEM SWITCH LOGFILEµÄʱºò
4.µ±ÔËÐÐALTER SYSTEM CHECKPOINTµÄʱºò
5.µ±ÔËÐÐalter tablespace XXX begin backup£¬e ......
declare
n number(10);
tsql varchar2(100);
begin
select test_seq.nextval into n from dual;
n:=-(n-1);
tsql:='alter ......