Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

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

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

Oracle³£ÓÃSQLÓï¾ä(PL/SQL developer¹¤¾ßϵÄ)

 ½¨±í
create table users(
id number(4) primary key,
username varchar2(10),
password varchar2(10)
)
²éѯ±í²¢½âËø±í(¼´¿ÉÒÔµã»÷ÊäÈë¿òÏÂÃæµÄ"Ëø"ͼ±ê¹¤¾ß, ¼´"Edit data")
select * from users for update
ɾ³ý±íÖжàÓàµÄÁÐ
alter table mobilephone drop column mobiletype
×ªÔØ
------------------- ......

ORACLE SQLÓï¾äÓÅ»¯×ܽá

ORACLE SQLÓï¾äÓÅ»¯×ܽá
 
1£© Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)£º
ORACLEµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í driving table)½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏÂ,Äã±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í¡£Èç¹ûÓÐ3¸öÒÔÉϵıíÁ¬½Ó²éѯ, Ä ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ