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Êý¾Ý×ֵ䳣Óòéѯ
--²é¿´µ±Ç°Óû§ËùÓÐ±í¼°ÃèÊö
select o.object_name,c.comments
from user_objects o
left outer join user_tab_comments c
on o.object_name=c.table_name
where object_type='TABLE'
and c.comments like '%ÏîÄ¿%'
--²é¿´µ±Ç°Óû§ËùÓÐ×Ö¶ÎÐÅÏ¢¼°ÃèÊö
select c.table ......
×î½üÔÚÂÛ̳ÉÏÒ»Ö±¿´µ½ÓÐÅóÓѶÔÊý¾Ý×ÖµäÀïµÄÄÚÈݸ㲻̫Çå³þ£¬±ÈÈç˵V$¡¢V_$¡¢GV$µÈµÈ£¬µ½µ×ÄĸöÊÇͬÒå´Ê£¬ÄĸöÊÇÊÓͼ£¬Äĸö»ùÓÚÄĸö´´½¨¡£½ñÌìÕýºÃ¿´µ½¸Ç¹úÇ¿µÄ¡¶ÉîÈëdz³öORACLE¡·µÚÈýÕ½²µ½Õâ·½ÃæÄÚÈÝ£¬×ܽáһϣ¬Ò²·½±ã´ó¼Òѧϰ¡£
Êý¾Ý×ÖµäÓÉËIJ¿·Ö×é³É£º
1¡¢ÄÚ²¿RDBMS(X$)±í
X$ÊÇOracleÊý¾Ý¿âµÄºËÐIJ¿·Ö£¬ÕâЩ ......
·½°¸1 ÊÊÓÃÓÚoracle9iÒÔÉÏ£¡
select * from
(select row_number() over(order by sendid desc) rn,m.* from xxt_msgreceive m )
where rn <1010 and rn>=1000
·½°¸2
SELECT * from (SELECT A.*, ROWNUM RN from (SELECT * from xxt_msg where sendstatus=1 order by msgid desc) A WHERE ROWNUM < ......
1.ʹÓòúÆ·£ºarcsde 9.3+oracle 10.2.0.1
2.ÎÊÌâÃèÊö£ºÓÃarcmap·ÃÎÊ¿Õ¼äÊý¾Ý£¬²Ù×÷¼¸·ÖÖÓ£¬arcmapÎÞ·´Ó¦£¬Êý¾Ý¿â·þÎñÆ÷¶ËcpuÕ¼ÓÐÂÊ100%£¬gsrvr.exe½ø³ÌÊý10+¡£
3.½â¾ö°ì·¨£ºÉý¼¶oracle°æ±¾´Ó10.2.0.1Éý¼¶µ½10.2.0.3»òÕß.2.0.4¡£
4.ÔÒò£º¾Ýesri¹¤³ÌʦËù³Æ£¬oracle10.2.0.1°æ±¾´æÔÚÓëarcgis²»¼æÈݵÄÎÞ·¨µ÷½ÚµÄbug¡£Ä¿Ç°Éý ......