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

Oracle Êý¾Ý¿â¹ÜÀí½Å±¾ ÃüÃû¹æ·¶


    
      Oracle ÖеÄÊý¾Ý×ÖµäÊÇÊý¾Ý¿âÖеķdz£ÖØÒªµÄÒ»²¿·Ö£¬ÌṩÁËÏà¹ØÊý¾Ý¿âµÄÐÅÏ¢£¬ËüÊÇËùÓРOracle Óû§£¨´ÓÓ¦ÓõÄ×îÖÕÓû§¡¢Ó¦ÓõÄÉè¼Æ¿ª·¢Õßµ½Êý¾Ý¿â¹ÜÀíÔ±£©µÄ·Ç³£ÖØÒªµÄÐÅÏ¢À´Ô´¡£Êý¾Ý×ÖµäµÄ´´½¨£¬ÊÇÔÚ Oracle Êý¾Ý¿â´´½¨Íê±Ïºó£¬ÔËÐÐһЩÏà¹ØµÄÊý¾Ý¿â¹ÜÀí½Å±¾À´Íê³ÉµÄ¡£µ±²ÉÓàOracle Í³Ò»°²×°Æ÷£¨ Oracle Universal Installer £©´´½¨Êý¾Ý¿âʱ£¬ Oracle ·þÎñÆ÷ÓйصÄ×ÖµäÊÓͼºÍ½Å±¾×îºó»á±»×Ô¶¯°²×°¡£µ«µ±ÐèÒªÉý¼¶Ä¿Ç°µÄ Oracle Êý¾Ý¿â·þÎñÆ÷ʱ£¬Êý¾Ý¿â¹ÜÀíÔ±±ØÐëÒªÊÖ¹¤ÖØÐÂÔËÐд´½¨ÕâЩÊÓͼ»ò½Å±¾µÄ SQL ¡£
°²×°ÍêÊý¾Ý¿âºó£¬ Oracle Êý¾Ý¿â¹ÜÀí½Å±¾¾Í´æ·ÅÔÚ²Ù×÷ϵͳÖС£¶ÔÓÚ UNIX ºÍ NT ²Ù×÷ϵͳ£¬·Ö±ðλÓÚ²»Í¬µÄÎïÀíĿ¼Ï£¬¼û±í 1 Ëùʾ£º
²Ù×÷ϵͳ
½Å±¾Ä¿Â¼Î»ÖÃ
UNIX
$ORACLE_HOME/rdbms/admin
NT
%ORACLE_HOME%\rdbms\admin
¡¡±í 1 Êý¾Ý¿â¹ÜÀí½Å±¾ÔÚ²Ù×÷ϵͳÖеÄÎïÀíλÖÃ
Oracle Öм¸ºõËùÓеÄϵͳ¹ÜÀí½Å±¾¶¼±£´æÔÚ¸ÃÎļþĿ¼Ï£¬¸ÃĿ¼Ïº¬ÓÐÉÏ°Ù¸ö²»Í¬Îļþ¡£ÕâЩ²»Í¬µÄÎļþ¶¼ÓÐʲô×÷ÓÃÄØ£¿±¾ÎĽ«ÏêϸÌÖÂÛ×é³É Oracle Êý¾Ý¿â¹ÜÀí½Å±¾µÄÃüÃû¹æ·¶¡£ÕâÑùÓû§¿´µ½Ä³¸öÎļþ´ó¸Å¾Í¿ÉÒÔÖªµÀ¸ÃÎļþÖ÷ÒªÓÃ;ÊÇʲô¡£¸ÃĿ¼ÏµÄÎļþ°´ÕÕ¹¦Äܲ»Í¬¿É·ÖΪ 4 ´óÀ࣬ Oracle ÎªÁËÈÝÒ×Çø·ÖÕ⼸À಻ͬµÄÎļþ£¬¶ÔÓÚÎļþµÄÃüÃû×ñ´ÓÒ»¶¨µÄ¹æÔò¡£¼û±í 2 Ëùʾ¡£
ÃüÃû¹æÔò
¹¦ÄÜÃèÊö
cat*.sql
¹ØÓÚĿ¼ºÍÊý¾Ý×ÖµäÐÅÏ¢
dbms*.sql
Êý¾Ý¿âÖйØÓÚ°üµÄ˵Ã÷
prvt*.plb
¼ÓÃܹýµÄ°ü´úÂë
utl*.sql
Êý¾Ý¿âÆäËû¹¦ÄܵıíºÍÊÓͼ
±í 2 Êý¾Ý¿â¹ÜÀí½Å±¾ÃüÃû¹æ·¶
ÏÂÃæÀ´Ïêϸ½éÉÜÕâËÄÖÖ²»Í¬ÀàÐ͵Ľű¾¹¦ÄÜ£º
1 ¡¢ cat*.sql ½Å±¾
¸ÃÀà½Å±¾Ö÷ÒªÓÃÓÚ´´½¨Êý¾Ý×ÖµäÊÓͼ¡£ÆäÖУ¬½Å±¾ catalog.sql ºÍ catproc.sql ÊÇ´´½¨Êý¾Ý¿âºó±ØÐëÒªÔËÐеÄÁ½¸ö½Å±¾¡£ÕâÁ½¸ö½Å±¾µÄ¹¦ÄÜ˵Ã÷¼û±í 3 Ëùʾ¡£
½Å±¾
½Å±¾ËµÃ÷
catalog.sql
´´½¨ÏµÍ³³£ÓõÄÊý¾Ý×ÖµäÊÓͼºÍͬÒå´Ê
catproc.sql
ÔËÐзþÎñÆ÷¶ËËùÐèÒªµÄ PL/SQL ½Å±¾
±í 3 ´´½¨Êý¾Ý×ÖµäÊÓͼ½Å±¾ËµÃ÷
(1) catalog.sql
¸Ã½Å±¾´´½¨Ïà¶ÔÓÚϵͳ»ù±íµÄÊÓͼºÍϵͳ¶¯Ì¬ÐÔÄÜÊÓͼÒÔ¼°ËûÃǵÄͬÒå


Ïà¹ØÎĵµ£º

oracle hints

 ÔÚSQLÓï¾äÓÅ»¯¹ý³ÌÖУ¬¾­³£»áÓõ½hint,ÏÂÃæÎÒÃÇÀ´½éÉÜÒ»ÏÂÔÚSQLÓÅ»¯¹ý³ÌÖг£¼ûOracleÖÐ"HINT"µÄ30¸öÓ÷¨£º
¡¡¡¡1. /*+ALL_ROWS*/
¡¡¡¡±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ»ùÓÚ¿ªÏúµÄÓÅ»¯·½·¨,²¢»ñµÃ×î¼ÑÍÌÍÂÁ¿,ʹ×ÊÔ´ÏûºÄ×îС»¯¡£
¡¡¡¡2. /*+FIRST_ROWS*/
¡¡¡¡±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ»ùÓÚ¿ªÏúµÄÓÅ»¯·½·¨,²¢»ñµÃ×î¼ÑÏìӦʱ¼ä,ʹ×ÊÔ´ÏûºÄ×îÐ ......

OracleÖдò¿ªÓα곬³ö×î´óÖµ

 ÏòOracleÊý¾Ý¿â±íÖвåÈëÊ®¼¸ÍòÌõÊý¾Ý£¬¿ÉÊǵ±²åÈë3Íò¶àÌõºó£¬³ÌÐò¾ÍÅ×
Java´úÂë
ORA-01000 maximum open cursors exceeded  
ORA-01000 maximum open cursors exceeded
Òì³£ÐÅÏ¢¡£GoogleÁËÒì³£ÐÅÏ¢£¬µÃÖªÕâÑùµÄ´íÎóºÜÈÝÒ׳öÏÖÔÚJava´úÂëÖеÄÖ÷ÒªÔ­ÒòÊÇ£ºJava´úÂëÔÚÖ´ÐÐconn.crea ......

С²ËÄñÎÊ£ºoracleÖеÄÒ»¸ö´¥·¢Æ÷ÎÊÌâ

ÎÊÌâ
£¨1£©±íemployeesºÍdepartment´æÔÚ²ÎÕÕÍêÕûÐÔÔ¼Êø£¬ÔÚ±íemployeesÖвåÈë¼Ç¼£¨‘70’£¬‘999’£©department_idΪ‘999’ʱ£¬department±íÖл¹²»´æÔÚdepartment_idΪ‘999’µÄ¼Ç¼£¬ËùÒÔÎ¥±³Á˲ÎÕÕÍêÕûÐÔÔ¼Êø,³öÏÖ“Integrity constraint violation error”ÌáʾÐÅÏ ......

Oracle job ¹ÜÀí£¨×ªÔØ£©


Oracle job ¹ÜÀí
 
 
SVRMGR> select * from dba_jobs;
³õʼ»¯Ïà¹Ø²ÎÊýjob_queue_processes
alter system set job_queue_processes=39 scope=spfile;//×î´óÖµ²»Äܳ¬¹ý1000  ;job_queue_interval = 10  //µ÷¶È×÷ҵˢÐÂƵÂÊÃëΪµ¥Î»
DBA_JOBS describes all jobs in the database.
USER_JO ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ