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
¸Ã½Å±¾´´½¨Ïà¶ÔÓÚϵͳ»ù±íµÄÊÓͼºÍϵͳ¶¯Ì¬ÐÔÄÜÊÓͼÒÔ¼°ËûÃǵÄͬÒå
Ïà¹ØÎĵµ£º
ÔÚSQLÓï¾äÓÅ»¯¹ý³ÌÖУ¬¾³£»áÓõ½hint,ÏÂÃæÎÒÃÇÀ´½éÉÜÒ»ÏÂÔÚSQLÓÅ»¯¹ý³ÌÖг£¼ûOracleÖÐ"HINT"µÄ30¸öÓ÷¨£º
¡¡¡¡1. /*+ALL_ROWS*/
¡¡¡¡±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ»ùÓÚ¿ªÏúµÄÓÅ»¯·½·¨,²¢»ñµÃ×î¼ÑÍÌÍÂÁ¿,ʹ×ÊÔ´ÏûºÄ×îС»¯¡£
¡¡¡¡2. /*+FIRST_ROWS*/
¡¡¡¡±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ»ùÓÚ¿ªÏúµÄÓÅ»¯·½·¨,²¢»ñµÃ×î¼ÑÏìӦʱ¼ä,ʹ×ÊÔ´ÏûºÄ×îÐ ......
ÏòOracleÊý¾Ý¿â±íÖвåÈëÊ®¼¸ÍòÌõÊý¾Ý£¬¿ÉÊǵ±²åÈë3Íò¶àÌõºó£¬³ÌÐò¾ÍÅ×
Java´úÂë
ORA-01000 maximum open cursors exceeded
ORA-01000 maximum open cursors exceeded
Òì³£ÐÅÏ¢¡£GoogleÁËÒì³£ÐÅÏ¢£¬µÃÖªÕâÑùµÄ´íÎóºÜÈÝÒ׳öÏÖÔÚJava´úÂëÖеÄÖ÷ÒªÔÒòÊÇ£ºJava´úÂëÔÚÖ´ÐÐconn.crea ......
ÎÊÌâ
£¨1£©±íemployeesºÍdepartment´æÔÚ²ÎÕÕÍêÕûÐÔÔ¼Êø£¬ÔÚ±íemployeesÖвåÈë¼Ç¼£¨‘70’£¬‘999’£©department_idΪ‘999’ʱ£¬department±íÖл¹²»´æÔÚdepartment_idΪ‘999’µÄ¼Ç¼£¬ËùÒÔÎ¥±³Á˲ÎÕÕÍêÕûÐÔÔ¼Êø,³öÏÖ“Integrity constraint violation error”ÌáʾÐÅÏ ......
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 ......