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
Ïà¹ØÎĵµ£º
author:skate
tiime:2009-11-18
ORACLEµÈ´ýʼþÀàÐÍ¡¾Classes of Wait Events¡¿
ÿһ¸öµÈ´ýʼþ¶¼ÊôÓÚijһÀ࣬ÏÂÃæ¸ø³öÁËÿһÀàµÈ´ýʼþµÄÃèÊö¡£¡¾Every wait event belongs to a class of wait event.
The following list describes each of the wait classes.¡¿
1. ¹ÜÀíÀࣺAdministrative
´ËÀàµÈ´ýʼþÊÇÓÉÓÚDBAµÄ ......
ÔÎÄ´«ËÍÃÅ£ºhttp://topic.csdn.net/u/20091019/11/67cd55a3-3f42-4db7-a3f8-91dd52a913cd.html?24122
¾³£Óöµ½·¢ÌûÇóÐÐÁÐת»»µÄ´úÂ룬ÓÃmax(decode(..))»Ø¸´ºó£¬Ê®Óа˾ŻáÔÙÎÊÒ»¾ä£ºÈç¹ûÁÐÃû²»¹Ì¶¨£¬»òÕßÁÐÊý²»¹Ì¶¨Ôõô°ì¡£¾ÍÒªÓô洢¹ý³ÌÀ´Ð´£¬ÕâЩ´æ´¢¹ý³ÌµÄ´úÂ붼´óͬСÒ죬ÎÒ¾ÍÏëÄܲ»ÄÜд¸öͨÓõãµÄ¹ý³Ì
ÊÔÁ ......
Ò». ¸ÅÊö
¡¡¡¡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 µÄÁ¬½Ó ......