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 9i±È8i¶àÁËÄÄЩÐÂÌØÐÔ£¿
¼òҪ˵£º
9i¸üÒ×ÓÚ¹ÜÀí¡£
Ïêϸ˵£º
²¢·¢¼¯Èº£¬8i OPSÉý¼¶Îª9i RAC£¬8i½áµã¼äÓÃÓ²Å̽»»»ÐÅÏ¢£¬9i½áµã¼ä²ÉÓøßËÙÍøÏߵĻº´æÈÛºÏ(Cache Fusion)¼¼Êõ½»»»ÐÅÏ¢£¬½»»»ËÙ¶ÈÌá¸ß100±¶ÒÔÉÏ¡£
9i¿ÉÒÔÔÚÏßÐÞ¸ÄÄں˲ÎÊýºÍÄÚ´æ·ÖÅä£ ......
ʵÏÖ·½·¨£º
1¡¢¿ªÊ¼££¾ÉèÖ㣾¿ØÖÆÃæ°å££¾¹ÜÀí¹¤¾ß££¾·þÎñÍ£Ö¹ËùÓÐOracle·þÎñ¡£
2¡¢¿ªÊ¼££¾³ÌÐò££¾Oracle - OraHome81££¾Oracle Installation Products££¾Universal Installer
жװËùÓÐOracle²úÆ·£¬µ«Universal Installer±¾Éí²»Äܱ»É¾³ý
&nb ......
Ò». ¸ÅÊö
¡¡¡¡Oracle´æ´¢¹ý³Ì¿ª·¢µÄÒªµãÊÇ£º
¡¡¡¡• ʹÓÃNotepadÎı¾±à¼Æ÷£¬ÓÃOracle PL/SQL±à³ÌÓïÑÔдһ¸ö´æ´¢¹ý³Ì;
¡¡¡¡• ÔÚOracleÊý¾Ý¿âÖд´½¨Ò»¸ö´æ´¢¹ý³Ì;
¡¡¡¡• ÔÚOracleÊý¾Ý¿âÖÐʹÓÃSQL*Plus¹¤¾ßÔËÐд洢¹ý³Ì;
¡¡¡¡• ÔÚOracleÊý¾Ý¿âÖÐÐ޸Ĵ洢¹ý³Ì;
¡¡¡¡• ͨ¹ý±àÒë´íÎóµ÷ÊÔ´æ´ ......
ÔÚ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*/
±í ......
left join ºÍ left outer join µÄÇø±ð
ͨË׵Ľ²£º
A left join B µÄÁ¬½ÓµÄ¼Ç¼ÊýÓëA±íµÄ¼Ç¼Êýͬ
A right join B µÄÁ¬½Ó ......