Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Oracle¿ØÖÆÎļþ³£ÓòÙ×÷

ÏÞÖÆ¿ØÖÆÎļþµÄ´óС
a.)²éѯ¿É¸´Óò¿·ÖµÄ±£´æÌìÊý(²»ÄÜÖ±½Ó¿ØÖÆ´óС,±£´æÌìÊýÔ½´óÊý¾ÝÔ½¶à)
SELECT name,value from v$parameter WHERE name = 'control_file_record_keep_time';

b.)ÉèÖÿɸ´Óò¿·Ö±£´æʱ¼ä
ALTER SYSTEM SET CONTROL_FILE_RECORD_KEEP_TIME = 14;

c.)ÉèÖò»¿É¸´Óò¿·ÖµÄ´óС.ÔÚCREATE DATABASE»òCREATE CONTROLFILEÓï¾äÖиø¶¨ÏÂÁвÎÊý,ÒÔ¼ä½Ó¿ØÖÆ´óС.
MAXDATAFILES
MAXINSTANCES
MAXLOGFILES
MAXLOGHISTORY
MAXLOGMEMBERS
×¢ÒâÕâЩ²ÎÊý»áÏÞÖÆÊý¾Ý¿âµÄÍØÕ¹ÐÔ.ÀýÈçMAXDATAFILES = 100ʱ,×î¶àÖ»ÄÜÓÐ100Êý¾ÝÎļþ. ²é¿´¿ØÖÆÎļþÅäÖÃ
SELECT type, record_size, records_total, records_used from v$controlfile_record_section; ²é¿´¿ØÖÆÎļþλÖÃ
SELECT value from v$parameter WHERE name = 'control_files';
              »ò
SELECT * from v$controlfile; Ìí¼Ó»òÒƶ¯¿ØÖÆÎļþ,ÐèÒªÖØÆôÊý¾Ý¿â. ×¢Òâ±ä¸üÇ°ºó×Ðϸ¼ìÑé,È·ÈÏ.
SPFILEģʽ:                    ALTER SYSTEM SET CONTROL_FILES = ·¾¶\ÎļþÒ»','·¾¶¶þ\Îļþ¶þ', '·¾¶Èý\ÎļþÈý' SCOPE = SPFILE;
PFILEģʽ:                      Ö±½ÓÐ޸IJÎÊýÎļþµÄCONTROL_FILES
È·Èϵ±Ç°PFILEģʽ:      show parameter pfile; ±¸·Ý¿ØÖÆÎļþ
ALTER DATABASE BACKUP CONTROLFILE TO '·¾¶\Îļþ'; 
»ò
ALTER DATABASE BACKUP CONTROLFILE TO TRACE           ±¾Ä£Ê½»áÔÚºǫ́¸ú×ÙµµÎļþ¼ÐÖÐÉú³ÉÒ»¸ö×îеĸú×ÙÎļþ,ÄÚº¬Éú³É¿ØÖÆÎļþµÄSQL


Ïà¹ØÎĵµ£º

oracle 8i,9iºÍ10g µÄÇø±ð

Oracle 9i±È8i¶àÁËÄÄЩÐÂÌØÐÔ£¿
 ¼òҪ˵£º
    9i¸üÒ×ÓÚ¹ÜÀí¡£
Ïêϸ˵£º
    ²¢·¢¼¯Èº£¬8i OPSÉý¼¶Îª9i RAC£¬8i½áµã¼äÓÃÓ²Å̽»»»ÐÅÏ¢£¬9i½áµã¼ä²ÉÓøßËÙÍøÏߵĻº´æÈÛºÏ(Cache Fusion)¼¼Êõ½»»»ÐÅÏ¢£¬½»»»ËÙ¶ÈÌá¸ß100±¶ÒÔÉÏ¡£
    9i¿ÉÒÔÔÚÏßÐÞ¸ÄÄں˲ÎÊýºÍÄÚ´æ·ÖÅä£ ......

Íêȫɾ³ýOracle


ʵÏÖ·½·¨£º
     1¡¢¿ªÊ¼£­£¾ÉèÖã­£¾¿ØÖÆÃæ°å£­£¾¹ÜÀí¹¤¾ß£­£¾·þÎñÍ£Ö¹ËùÓÐOracle·þÎñ¡£
     2¡¢¿ªÊ¼£­£¾³ÌÐò£­£¾Oracle - OraHome81£­£¾Oracle Installation Products£­£¾Universal Installer
жװËùÓÐOracle²úÆ·£¬µ«Universal Installer±¾Éí²»Äܱ»É¾³ý
  &nb ......

ÈçºÎ¿ª·¢ORACLE´æ´¢¹ý³Ì

 Ò». ¸ÅÊö
¡¡¡¡Oracle´æ´¢¹ý³Ì¿ª·¢µÄÒªµãÊÇ£º
¡¡¡¡• ʹÓÃNotepadÎı¾±à¼­Æ÷£¬ÓÃOracle PL/SQL±à³ÌÓïÑÔдһ¸ö´æ´¢¹ý³Ì;
¡¡¡¡• ÔÚOracleÊý¾Ý¿âÖд´½¨Ò»¸ö´æ´¢¹ý³Ì;
¡¡¡¡• ÔÚOracleÊý¾Ý¿âÖÐʹÓÃSQL*Plus¹¤¾ßÔËÐд洢¹ý³Ì;
¡¡¡¡• ÔÚOracleÊý¾Ý¿âÖÐÐ޸Ĵ洢¹ý³Ì;
¡¡¡¡• ͨ¹ý±àÒë´íÎóµ÷ÊÔ´æ´ ......

³£¼ûOracle HINTµÄÓ÷¨ SQLÓÅ»¯

ÔÚSQLÓï¾äÓÅ»¯¹ý³ÌÖУ¬ÎÒÃǾ­³£»áÓõ½hint,ÏÖ×ܽáÒ»ÏÂÔÚSQLÓÅ»¯¹ý³ÌÖг£¼ûOracle HINTµÄÓ÷¨£º
1. /*+ALL_ROWS*/
±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ»ùÓÚ¿ªÏúµÄÓÅ»¯·½·¨,²¢»ñµÃ×î¼ÑÍÌÍÂÁ¿,ʹ×ÊÔ´ÏûºÄ×îС»¯.
ÀýÈç:
SELECT /*+ALL+_ROWS*/ EMP_NO,EMP_NAM,DAT_IN from BSEMPMS WHERE EMP_NO=’SCOTT’;
2. /*+FIRST_ROWS*/
±í ......

Introduction to Oracle9i: SQL

left join ºÍ left outer join µÄÇø±ð
ͨË׵Ľ²£º  
  A   left   join   B   µÄÁ¬½ÓµÄ¼Ç¼ÊýÓëA±íµÄ¼Ç¼Êýͬ  
  A   right   join   B   µÄÁ¬½Ó ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ