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

Oracle¶¯Ì¬ÐÔÄܱí

(1) v$sql
¡¡¡¡Ò»ÌõÓï¾ä¿ÉÒÔÓ³Éä¶à¸öcursor,ÒòΪ¶ÔÏóËùÖ¸µÄcursor¿ÉÒÔÓв»Í¬Óû§(ÈçÀý1)¡£Èç¹ûÓжà¸öcursor(×ÓÓαê)´æÔÚ£¬ÔÚV$SQLAREAΪËùÓÐcursorÌṩ¼¯ºÏÐÅÏ¢¡£
Àý1£º
ÕâÀï½éÉÜÒÔÏÂchild cursor
user A: select * from tbl
user B: select * from tbl
´ó¼ÒÈÏΪÕâÁ½ÌõÓï¾äÊDz»ÊÇÒ»ÑùµÄ°¡£¬¿ÉÄÜ»áÓкܶàÈË»á˵ÊÇÒ»ÑùµÄ£¬µ«ÎÒ¸æËßÄã²»Ò»¶¨£¬ÄÇÎªÊ²Ã´ÄØ£¿
Õâ¸ötblA¿´ÆðÀ´ÊÇÒ»ÑùµÄ£¬µ«ÊDz»Ò»¶¨Å¶£¬Ò»¸öÊÇAÓû§µÄ, Ò»¸öÊÇBÓû§µÄ£¬ÕâʱËûÃǵÄÖ´Ðмƻ®·ÖÎö´úÂë²î±ð¿ÉÄܾʹóÁËŶ£¬¸ÄÏÂд·¨´ó¼Ò¾ÍÃ÷°×ÁË:
select * from A.tbl
select * from B.tbl
¡¡¡¡ÔÚ¸ö±ðcursorÉÏ£¬v$sql¿É±»Ê¹Ó᣸ÃÊÓͼ°üº¬cursor¼¶±ð×ÊÁÏ¡£µ±ÊÔͼ¶¨Î»session»òÓû§ÒÔ·ÖÎöcursorʱ±»Ê¹Óá£
¡¡¡¡PLAN_HASH_VALUEÁд洢µÄÊÇÊýÖµ±íʾµÄcursorÖ´Ðмƻ®¡£¿É±»ÓÃÀ´¶Ô±ÈÖ´Ðмƻ®¡£PLAN_HASH_VALUEÈÃÄã²»±ØÒ»ÐÐÒ»ÐжԱȼ´¿ÉÇáËɼø±ðÁ½ÌõÖ´Ðмƻ®ÊÇ·ñÏàͬ¡£
V$SQLÖеÄÁÐ˵Ã÷£º
l         SQL_TEXT£ºSQLÎı¾µÄǰ1000¸ö×Ö·û
l         SHARABLE_MEM£ºÕ¼ÓõĹ²ÏíÄÚ´æ´óС(µ¥Î»£ºbyte)
l         PERSISTENT_MEM£ºÉúÃüÆÚÄڵĹ̶¨ÄÚ´æ´óС(µ¥Î»£ºbyte)
l         RUNTIME_MEM£ºÖ´ÐÐÆÚÄڵĹ̶¨ÄÚ´æ´óС
l         SORTS£ºÍê³ÉµÄÅÅÐòÊý
l         LOADED_VERSIONS£ºÏÔʾÉÏÏÂÎĶÑÊÇ·ñÔØÈ룬1ÊÇ0·ñ
l         OPEN_VERSIONS£ºÏÔʾ×ÓÓαêÊÇ·ñ±»Ëø£¬1ÊÇ0·ñ
l         USERS_OPENING£ºÖ´ÐÐÓï¾äµÄÓû§Êý
l         FETCHES£ºSQLÓï¾äµÄfetchÊý¡£
l         EXECUTIONS£º×ÔËü±»ÔØÈ뻺´æ¿âºóµÄÖ´ÐдÎÊý
l         USERS_EXECUTING£ºÖ´ÐÐÓï¾äµÄÓû§Êý
l         LOADS£º¶ÔÏó±»ÔØÈë¹ýµÄ´ÎÊý
l         FIRST_LOAD_TIME£º³õ´ÎÔØÈëʱ¼ä
l         INVALIDATIONS£ºÎÞЧµÄ´ÎÊý
l &n


Ïà¹ØÎĵµ£º

oracle £º´æ´¢¹ý³ÌºÍº¯ÊýµÄ¼¸ÖÖд·¨

¹ØÓÚ´æ´¢¹ý³ÌºÍº¯ÊýµÄ¶¨ÒåÍøÉÏÒ»ËÑÒ»´ó°Ñ£¬ÕâÀï¾Í²»ÌØÊâ½éÉÜÁË£¬ÕâÀï¾ÍÖ»¶ÔÎÒ×Ô¼ºÐ´µÄ¼¸ÖÖ¸ñʽµÄ´æ´¢¹ý³ÌºÍº¯Êý×öһЩ×ܽᣬϣÍû¶Ô´ó¼ÒÓеã°ïÖú¡£
 Ò»£º´æ´¢¹ý³Ì
  
1£º×îÆÕͨµÄÒ»ÖÖ¡££¨´«²Î£¬²éѯÓαִ꣬ÐУ¬Ñ­»·Óαê×ö²åÈ붯×÷£©¡£
create or replace procedure zy2040_sirole(rolekey in varchar2) ......

Oracle´æ´¢¹ý³ÌµÄÖ´ÐÐ

declare
msg varchar(1000);    --¶¨ÒåÒ»¸ö±äÁ¿ÓÃÓÚÏÔʾ´«³öµÄÐÅÏ¢
begin
PRO_TACCOUNT_RECOUNT ('B9D2B59A955541298D59EA8C35668CFD',msg);   --Ö´Ðд洢¹ý³Ì
dbms_output.put_line(msg);   --Êä³ö±äÁ¿
end; ......

Oracle JOB Ó÷¨Ð¡½á

Ò»¡¢ÉèÖóõʼ»¯²ÎÊý job_queue_processes
¡¡¡¡sql> alter system set job_queue_processes=n;£¨n>0£©
¡¡¡¡job_queue_processes×î´óֵΪ1000
¡¡¡¡
¡¡¡¡²é¿´job queue ºǫ́½ø³Ì
¡¡¡¡sql>select name,description from v$bgprocess;
¡¡¡¡
¡¡¡¡¶þ£¬dbms_job package Ó÷¨½éÉÜ
¡¡¡¡°üº¬ÒÔÏÂ×Ó¹ý³Ì£º
¡¡¡¡
¡¡ ......

OracleÊý¾Ý¿âÃæÊÔÎÊÌ⼯ºÏ¼°¼¼ÇÉ

 
ÕâÆªÎÄÕÂÊÇORACLEÃæÊÔµÄÎÊÌâ½õ¼¯£¬ËäÈ»²»È«Ã棬µ«ÊÇÕâÆªÎÄÕ»áÈÃÄãÖªµÀÈçºÎÈÃÃæÊÔ¿¼¹ÙÁ˽âÄã¶ÔORACLE¸ÅÄîµÄÊìϤ³Ì¶È¡£
 
1.½âÊÍÀ䱸·ÝºÍÈȱ¸·ÝµÄ²»Í¬µãÒÔ¼°¸÷×ÔµÄÓŵã
 
½â´ð£ºÈȱ¸·ÝÕë¶Ô¹éµµÄ£Ê½µÄÊý¾Ý¿â£¬ÔÚÊý¾Ý¿âÈԾɴ¦ÓÚ¹¤×÷״̬ʱ½øÐб¸·Ý¡£¶øÀ䱸·ÝÖ¸ÔÚÊý¾Ý¿â¹Ø±Õºó£¬½øÐб¸·Ý£¬ÊÊÓÃÓÚËùÓÐÄ£Ê ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ