oracle¸ü¸Ä¹éµµÂ·¾¶
1.¸ü¸Ä¹éµµÂ·¾¶
ÔÚORACLE10GÖУ¬Ä¬ÈϵĹ鵵·¾¶Îª$ORACLE_BASE/flash_recovery_area¡£¶ÔÓÚÕâ¸ö·¾¶£¬
ORACLEÓÐÒ»¸öÏÞÖÆ£¬¾ÍÊÇĬÈÏÖ»ÄÜÓÐ2GµÄ¿Õ¼ä¸ø¹éµµÈÕ־ʹÓ㬿ÉÒÔʹÓÃÏÂÃæÁ½¸öSQLÓï¾äÈ¥²é¿´ËüµÄÏÞÖÆ
1. select * from v$recovery_file_dest;
sql >show parameter db_recovery_file_dest(Õâ¸ö¸üÓѺÃÖ±¹ÛһЩ)
µ±¹éµµÈÕÖ¾ÊýÁ¿´óÓÚ2Gʱ£¬ÄÇô¾Í»áÓÉÓÚûÓиü¶àµÄ¿Õ¼äÈ¥ÈÝÄɸü¶àµÄ¹éµµÈÕÖ¾»á±¨ÎÞ·¨¼ÌÐø¹éµµµÄ´íÎó¡£
È磺
RA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 10017792 bytes disk space from 2147483648 limit
ARC0: Error 19809 Creating archive log file to '/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_30/o1_mf_1_220_0_.arc'
ÕâʱÎÒÃÇ¿ÉÒÔÐÞ¸ÄËüµÄĬÈÏÏÞÖÆ£¬±ÈÈç˵½«ËüÔö¼Óµ½5G»ò¸ü¶à£¬Ò²¿ÉÒÔ½«¹éµµÂ·¾¶ÖØÐÂÖõ½±ðµÄ·¾¶£¬¾Í²»»áÓÐÕâ¸öÏÞÖÆÁË¡£
¸ü¸ÄÏÞÖÆÓï¾äÈçÏ£º
alter system set db_recovery_file_dest_size=5368709102 (ÕâÀïΪ5G 5x1024x1024x1024=5G)
»òÕßÖ±½ÓÐ޸Ĺ鵵µÄ·¾¶¼´¿É
SQL> alter system set log_archive_dest_1='location=/u01/archivelog' scope =both;
2.¸ü¸Ä¹éµµÄ£Ê½
sql> archive log list;
sql> shutdown immediate;
sql> startup mount;
sql> alter database archivelog;
sql> alter database open;
sql> archive log list;
Ïà¹ØÎĵµ£º
ÎÄÕÂÌáµ½£¬ÓÃCache hit ratioµÄ·½·¨À´¼ì²éORACLEÐÔÄÜÎÊÌâ¹ýʱÁË£¬ÀïÃæÓоä·Ç³£ÐÎÏóµÄ»°£ºÕâÎÞÒìÓÚÒ»¸öÒ½ÉúÖ»ÖªµÀ¸ù¾ÝѪѹµÄÀ´ÖÎÁƲ¡ÈË£¬¶ø²¡ÈËÓÉÓÚÌÛÍ´£¬Éñ¾ÐË·Ü£¬ÑªÑ¹ÔÚÒ»¸öºÏÀíµÄ·¶Î§ÄÚ£¬Ò½ÉúÈ´¸æËß»¼Õߣ¬Äãû²¡£¬µÈÄãѪѹµÍµÄʱºòÔÙÀ´¡£Í¬ÑùµÄ£¬ÎÒÃDz»Äܽö½ö¸ù¾ÝCache hit ratioÀ´ÅжÏORACLEÊ ......
oracle ·½·¨ & ......
1.Ê×ÏÈÐèÒª½¨Á¢plan table,·ñÔò²»ÄÜʹÓÃ
½¨Á¢·½·¨£º
$oracle\rdbms\adminÏÂÓиö
utlxplan.sql
ÆäÄÚÈÝΪ:
create table PLAN_TABLE (
statement_id varchar2(30),
timestamp date,
remarks varchar2(80),
operat ......
Êý¾Ý¿âµÄÆô¶¯ÓÐÈýÖÖ£º
1
£º
startup nomount
ÕâÖÖ¹ý³ÌÓÖ³ÆÎª£º·Ç°²×°Æô¶¯
Æô¶¯¹ý³ÌΪ£ºÆô¶¯
oracle
ʵÀý£¬²»¼ÓÔØÊý¾Ý¿â£¬²»´ò¿ªÊý¾Ý¿â¡£ÔÚÕâ¸ö¹ý³ÌÖÐÖ»ÐèÒª
init.ora
³õʼ»¯²ÎÊýÎļþ£¬Öؽ¨¿ØÖÆÎļþ£¬¼´Æô¶¯ ......
ת×ÔijµØ,¶Ô×÷ÕߺÜÀ¢¾Î- -!²»ÏþµÃµØÖ·ÁË..
ORACLE¶à±í²éѯÓÅ»¯
ÕâÀïÌṩµÄÊÇÖ´ÐÐÐÔÄܵÄÓÅ»¯,¶ø²»ÊǺǫ́Êý¾Ý¿âÓÅ»¯Æ÷×ÊÁÏ:
²Î¿¼Êý¾Ý¿â¿ª·¢ÐÔÄÜ·½ÃæµÄ¸÷ÖÖÎÊÌâ,ÊÕ¼¯ÁËһЩÓÅ»¯·½°¸Í³¼ÆÈçÏÂ(µ±È»,ÏóË÷ÒýµÈÓÅ»¯·½°¸Ì«¹ý¼òµ¥¾Í²»ÁÐÈëÁË,ºÙºÙ):
Ö´Ðз¾¶:ORACLEµÄÕâ¸ö¹¦ÄÜ´ó´óµØÌá¸ßÁËSQLµÄÖ´ÐÐÐÔÄܲ¢½ÚÊ¡ÁËÄÚ´æµÄʹÓÃ: ......