OracleË÷Òý¼¼ÊõµÄÓ¦ÓÃÓëÆÊÎö
Oracle
Ë÷Òý¼¼ÊõµÄÓ¦ÓÃÓëÆÊÎö
×î
½üÕâ¶Îʱ¼ä£¬×ÜÊÇÏëдһЩÓйØÐÔÄܵ÷ÓŵÄÎÄÕ¡£µ«ÊÇ¿àÓÚûÓÐÒ»¸öʵ¼ÊµÄ°¸Àý£¬±¾ÈËÓÖ²»Ô¸¿Õ̸ÀíÂÛ£¬ÒòΪÕâЩÀíÂÛËæ±ãÔÚÍøÉϾÍÄÜÕÒµ½£¬¶øÇÒ»ù±¾ÉÏǧƪһÂÉ£¬
ÒòΪÀíÂÛÉϵÄÄÇЩ¶«Î÷¾ÍÄÇô¶à£¬ÔÙÔõô½²Ò²²»ÈçÒ»¸öʵ¼Ê°¸ÀýÉú¶¯¡£»¹ºÃÉÏÌì²»¸ºÓÐÐÄÈË£¬Ç°Ð©ÌìÈÃÎÒÅöµ½ÁËÒ»¸öʵ¼ÊµÄ°¸Àý¡£Õâ¸öʵ¼Ê°¸ÀýÊÇÕâÑù£¬±¾ÈËËùÔÚµÄ
³ÇÊеÄij¸öÕþ¸®Ö°Äܲ¿ÃÅ£¬ÒªÍƳöÒ»ÏîеķþÎñ£¬ÕâÏî·þÎñ¾ÍÊÇÒªÏòÉç»á·¢·ÅÒ»ÕŹ¦ÄÜÍ걸µÄ
CPU
¿¨
Ƭ£¬Í¨¹ýÕâÕÅ¿¨Æ¬¿ÉÒÔ¾°ì¸ÃÕþ¸®²¿ÃÅËù¸ºÔðÏà¹ØÒµÎñ£¬ÔÚijÖ̶ֳÈÉÏΪ¹ã´óÊÐÃñÌṩÁ˺ܴ󷽱㡣ÔÚÖÆ×÷ÕâÕÅ¿¨Æ¬¹ý³ÌÖУ¬ÐèÒª½«Óû§µÄÉí·ÝÖ¤£¬ÐÕÃûÒÔ¼°¸öÈËÕÕ
Ƭ´òÓ¡ÔÚ¿¨Æ¬ÉÏ£¬²¢ÇÒÒªÔÚ¿¨Æ¬µÄоƬÄÚдÈëһЩÐÅÏ¢¡£Òò´Ë³öÏÖÁËÁ½¸öÎÊÌ⣬µÚÒ»¡¢¸ÃÕþ¸®Ö°Äܲ¿ÃŵÄ×ÔÉíµÄÒµÎñϵͳÊý¾Ý¿âÖУ¬Ã»Óй«Ãñ¸öÈËÕÕƬÐÅÏ¢ÒÔ¼°¿¨Æ¬
ÄÚ²¿ËùÐèµÄһЩÐÅÏ¢£»µÚ¶þ¡¢ÔÚ¸ÃÕþ¸®Ö°Äܲ¿ÃŵÄÊý¾Ý¿âÄÚ£¬´æÔÚ×ÅһЩ´íÎóÐÅÏ¢£¬±ÈÈ磺Éí·ÝÖ¤ºÅÂë´íÎó¡¢ÐÕÃû´íÎóµÈµÈ¡£ÎªÁ˽â¾öÕâ¸öÎÊÌ⣬¸ÃÕþ¸®²¿ÃÅÓû§Ìá
³öÁËÒ»¸ö·½°¸£¬ÄǾÍÊÇÄñ¾ÏµÍ³ÖеĸöÈË»ù±¾ÐÅÏ¢Óëµ±µØ¹«°²ÏµÍ³µÄÈË¿ÚÐÅϢͨ¹ýÉí·ÝÖ¤ºÅÂë½øÐбȶԣ¬²¢ÇÒ½«Äܹ»±È¶ÔÉϵÄÈËÔ±ËùÐèµÄ²¢ÇÒ±¾ÏµÍ³Ã»ÓеĸöÈ˹ؼü
ÐÅÏ¢£¬´ÓÈË¿ÚÊý¾Ý¿âÖÐÈ¡µÃ£¬Í¬Ê±½«Ã»ÓбȶÔÉϵĸöÈËÐÅÏ¢½øÐбê¼Ç£¬ÒÔ±ãÏ·¢Óɵ±ÊÂÈ˵½Ïà¹Ø²¿ÃÅÈ¥ÐÞÕý¡£ÓÉÓÚ¸ÃÕþ¸®²¿ÃŵÄËùÓÐÒµÎñϵͳ£¬¶¼ÊÇÓɱ¾ÈËËùÔڵĹ«
˾ȷÇеÄ˵ÊÇÓɱ¾ÈËÉè¼Æ²¢×éÖ¯¿ª·¢µÄ£¬Òò´ËÀíËùµ±È»±¾ÈËÓÐÐҳнÓÕâ¸ö“ÉñÊ¥¶øΰ´ó”µÄÈÎÎñ¡£
¸ÕÄõ½Õâ¸öÐèÇóʱ£¬¾õµÃÕâ¸öÐèÇó»¹ÊDZȽϼòµ¥µÄ£¬¾ÍÊÇÒ»¸ö¶ÔÕձȶԣ¬È»ºó½«Äܹ»Æ¥ÅäµÄ¼Ç¼ËùÐèÒªµÄÊý¾ÝÄõ½¡£Òò´ËÎÒ½«±¾ÏµÍ³ÖеÄÊý¾Ýµ½Ò»ÕűíÖУ¬¸Ã±íÉè¼Æ½Å±¾ÈçÏ£º
create
table
TEDA_RYXX
(
AAC002 VARCHAR2
(18),
AAC001 VARCHAR2
(14) not
null
,
AAC003 VARCHAR2
(20),
AAC004 VARCHAR2
(3),
AAC005 VARCHAR2
(3),
AAC006 DATE
,
AAC009 VARCHAR2
(3),
AAB003 VARCHAR2
(15),
AAB004 VARCHAR2
(50),
FL
Ïà¹ØÎĵµ£º
Ò»¡£²é¿´oracleÊý¾Ý¿âÊÇ·ñΪ¹éµµÄ£Ê½£º[1]
¡¡¡¡1.select name,log_mode from v$database;
¡¡¡¡NAME LOG_MODE
¡¡¡¡------------------ ------------------------
¡¡¡¡QUERY NOARCHIVELOG
¡¡¡¡2.ʹ ......
ÓÃoracleÊý¾Ý¿âµÄ´æ´¢¹ý³ÌʵÏÖ·µ»Ø½á¹û¼¯²¢ÊµÏÖ·ÖÒ³µÄ¹¦ÄÜ¡£
Óû§´«Èë²ÎÊý
Ò»ÏÂÊÇת±ðÈ˵ĴúÂë
--°üÉùÃ÷
create or replace package p_page is
-- Author : PHARAOHS
-- Created : 2006-4-30 14:14:14
-- Purpose : ·ÖÒ³¹ý³Ì
TYPE type_cur IS REF CURSOR; &n ......
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 C ......
1¡¢µÇ¼·½·¨:£ºsys or systemµÇ¼
Õ˺ţºsystem
ÃÜÂ룺system as sysdba---------¡·ÃÜÂë+as sysdba
conn system/password as sysdba
ʹÓÃÃüÁ
sql>alter user scott account unlock;
sql> commit;
Í ......