OracleÅàѵ֮Âà ÉÇÍ·
Õâ´ÎÈ¥ÉÇÍ·ÊǸøÉÇÍ·µçÐŽ²¿Î,Ö÷½²ORACLEÊý¾Ý¿âÐÔÄÜÓÅ»¯,ΪÆÚ4Ìì.´ÓÂÞºþÆû³µÕ¾³ö·¢,×ßÉîÉǸßËÙ,´óÔ¼4,5¸öÖӾ͵½ÉÇÍ·ÁË.
³ö·¢Ê±ÊÇ°øÍí,³µ×ÓÔÚÉîÉǸßËÙÐнø,ϦÑôÎ÷Ï£¬ÂäÈÕµÄÓà»ÔÕÕÓ³ÔÚ¹«Â·Á½±ßµÄÇðÁê,ɽÌÁÉÏ£¬¿´ÉÏÈ¥ºÜÃÀ¡£ÉîÉǸßËٴ󲿷ÖÊÇÑØן£°¶ÏßòêÑÑ£¬ËùÒÔ£¬ÓÐʱÔÚ³µÉϾÍÄܹ»¿´µ½º££¬ÂäÈÕµÄÓà»ÔÕÕÔÚ´óº£ÉÏ£¬²¨¹âÁÛÁÛ£¬¼ÓÖ®º£·çÏ°Ï°£¬ÊÇÎÒϲ»¶µÄÄÇÖָоõ¡£ÎÒûÓÐÐÄ˼¹Û¿´³µÉϵĵçÓ°£¬´ó²¿·Öʱ¼äÎÒ¶¼ÊÇ´ò¿ª³µ´°£¬±¥ÀÀº£°¶·ç¹â¡£¹«Â·Á½±ßºÜ¶àСɽ£¬²»¸ß£¬µ«¿´ÉÏÈ¥ºÜºÃÍ棬ºÃ±È¼ÒÏçºóÃæµÄСɽ£¬Ð¡µÄʱºòÎÒÃǾ³£ÅÀÉÏÈ¥Í棬»òÔÚɽÆÂÀïÍæÈüÅÜ£¬¿´ËµÚÒ»¸ö´ÓɽÏÂÅܵ½É½¶¥£¬´Óɽ¶¥Åܵ½É½ÎÑ¡£Í¯ÄêµÄ»¶ÀÖÏÖÔÚºÜÄÑÖØÊ°£¬ÎÒÖ»ÄÜÒÐ×ųµ´°£¬³Á½ûÔÚͯÄ껶ÀֵĻØÒäÖС£
½øÈëÉÇÍ·ÊÐÇø£¬ÓÃæÒ²ÊÇÒ»×ùбÀË÷´óÇÅ£¬ÉÇÍ·µçÐŵÄÖì¿¡·åÖ÷ÈÎÔÚ³µÕ¾µÈºò¶àʱ£¬Ê±¼äÒÑÊÇÍíÉÏ9µã¶àÁË£¬ÎÒÃÇÔÚÒ»¼Ò²ÍÌü³ÔÍê·¹£¬ÖìÖ÷ÈξͿª³µËÍÎÒµ½Áúºþ±ö¹Ý¡£
ÉÇÍ·µçÐŵÄÅóÓÑ£¬²Î¼Ó´Ë´ÎÅàѵµÄ¶¼±È½ÏÄêÇᣬ¹À¼ÆºÜ¶à´Ó´óѧ±ÏÒµ³öÀ´Ã»¶à¾Ã£¬ËùÒÔÎÊÌâÒ²ÌرðµÄ¶à£¬¿ÎÌÃÆø·ÕÈÈÁÒ£¬ÓÐʱ²îµãû°ÑÎÒ¸ãÃÉ¡£ºÇºÇ£¬ÄêÇáÈË×ÜÊǺÜÓм¤Ç飬¼ÇµÃÔÚ½²ORACLE SQLÓÅ»¯Ê±£¬ºÜ¶àѧԱֱ½Ó½«ËûÃÇƽʱ¾õµÃºÜÂýµÄÎÊÌâSQL·¢¸øÎÒ£¬ÈÃÎÒÇÐÇÐʵʵµØÌå»áµ½ÁËÏÖ³¡×öÓÅ»¯µÄ¹¤×÷Æø·Õ¡£¿É±ðС¿´ÕâЩÄêÇáС»ï×Ó°¡£¬ËûÃǸø³öµÄÎÊÌâÄѶȶ¼²»Ð¡ÍÛ£¬¸Õ´ÓѧУ³öÀ´£¬»¹´ø×ÅÄǹɴòÆÆɳ¹øÎʵ½µ×µÄѧϰ¾¢¶ù¡£ºÇºÇ£¬²»¹ý£¬ËûÃÇÒ²ÓÐһЩ±¦¹óµÄÍæÒâ¶ù£¬ÓÐÒ»¿î¿ÉÒÔÔÚ¾ÖÓòÍøÄÚ·Ö·¢ÎļþµÄÈí¼þ£¬½Ð“·É¸ë´«Ê锣¬ÒÔ¼°Ò»¿î¿ÉÒÔ´Ó¸÷¸öÖն˿´µ½ÀÏʦµÄµçÄÔÆÁÄ»µÄ½ÌѧÈí¼þ£º“HtScreen”,ÎÒ¾õµÃ¾ÍÌرðµÄºÃ£¬ÎÒÌØÒ⿽ÏÂÀ´ÁË£¬ËäÈ»ÊǵÁ°æ£¬µ«ÎÒ¾ö¶¨ÔÚÎÒÒÔºóµÄ¿ÎÌÃÉϲÉÓÃÕâ¿îÈí¼þ(ÎÒ֮ǰ²ÉÓÃNetMeeting£¬µ«Î¢ÈíµÄÕâ¸ö¶«¶«ÔÚÁ¬½ÓÓû§¶àÁ˵ÄÇé¿öÏ£¬²Ù×÷ÌرðµØÂý£¬ÐÔÄܲ»ºÃ¡£¶øHtScreenÔòÊÇÇáÁ¿¼¶µÄ£¬ËüÏ൱ÓÚ½«ÀÏʦµÄÖն˹㲥³öÈ¥£¬¼´Ê¹50¸öѧԱÁ¬½ÓÉÏÄãµÄµçÄÔ£¬Ò²¸Ð¾õ²»µ½±äÂý).
×ÜÌåÀ´½²£¬Õâ´ÎµÄÅàѵʵսЧ¹ûÊÇ×îºÃµÄ£¡Ð¡»ï×ÓÃÇѧµÃÆð¾¢£¬Ïû»¯ÎüÊÕÒ²¿ì¡£µçÐŵÄÖìÖ÷ÈÎÓÐÒâ½øÐеÚ2´ÎÕâÑùµÄÅàѵ¡£
ƽ³£ÎÒÊÇÔÚÁúºþ±ö¹Ý³Ô·¹£¬¾ÆµêµÄ¸÷ÖÖ¸÷ÑùµÄµãÐĵ¹Ê±ºÜ¶à£¬Ê²Ã´Óã½Èѽ£¬ÓãÍèѽ£¬Å£ÈâÍèѽ£¬³¦·ÛµÈµÈ£¬¾Ý˵¶¼ÊÇÉÇÍ·µÄÌØɫС³Ô£¬¿ÉÊÇûÓÐÀ±Î¶£¬ºÜÓе㲻ºÏÎҵĿÚζ¡£ÓÚÊÇÍí²ÍÒ»°ãÊÇÖìÖ÷ÈνÓÎÒµ½ÍâÃæ³Ô¡£ÎÒÃÇ¿ª³µµ½º£±õ·£¬´ó¸Åÿ¸ö±õº£µÄ³ÇÊж¼»áÓйۺ£³¤ÀÈ°É£¬ÉÇÍ·Ò²²»ÀýÍâ¡£ÎÒÃÇÑ¡ÁËÒ»¼Ò¿¿º£±ßµÄ²ÍÌü£¬ÔÚ¶þÂ¥£¬»ù
Ïà¹ØÎĵµ£º
oracle¼¸¸ö³£Óõļà¿ØÊÓͼ
oracle¼¸¸ö³£Óõļà¿ØÊÓͼ
v$processÊÓͼ:
v$processÊÓͼ°üº¬µ±Ç°ÏµÍ³oracleÔËÐеÄËùÓнø³ÌÐÅÏ¢¡£³£±»ÓÃÓÚ½«oracle»ò·þÎñ½ø³ÌµÄ²Ù×÷ϵͳ½ø³ÌIDÓëÊý¾Ý¿âsessionÖ®¼ä½¨Á¢ÁªÏµ¡£
³£ÓÃÁУº
ADDR£º½ø³Ì¶ÔÏóµØÖ·
......
extent--×îС¿Õ¼ä·ÖÅ䵥λ --tablespace management
block --×îСi/oµ¥Î» --segment management
create tablespace james
datafile '/export/home/oracle/oradata/james.dbf'
size 100M ¡¡¡¡¡¡¡¡¡¡¡¡--³õʼµÄÎļþ´óС¡¡
autoextend On¡¡¡¡¡¡¡¡ --×Ô¶¯Ôö³¤
next 10M¡ ......
ÔÎĵØÖ·£ºhttp://www.cnblogs.com/yf520gn/archive/2009/01/12/1374359.html
EXISTSµÄÖ´ÐÐÁ÷³Ì
select * from t1 where exists ( select null from t2 where y = x )
¿ÉÒÔÀí½âΪ:
for x in ( select * from t1 )
loop
if ( exists ( select null from ......
ÐòÁУ¨SEQUENCE£©ÐòÁÐÊÇÒ»Êý¾Ý¿â¶ÔÏó£¬ÀûÓÃËü¿ÉÉú³ÉΨһµÄÕûÊý¡£Ò»¸öÐòÁеÄÖµÊÇÓÉÌØÊâµÄOracle³ÌÐò×Ô¶¯Éú³É£¬Òò´ËÐòÁбÜÃâÁËÔÚÓ¦Óà ²ãʵÏÖÐòÁжøÒýÆðµÄÐÔÄÜÆ¿¾±¡£¸ÃÐòÁÐΪÉÏÉýÐòÁУ¬ÓÉ1¿ªÊ¼£¬ÔöÁ¿Îª1£¬Ã»ÓÐÉÏÏÞ¡£ÔÚÉýÐòʱ£¬ÐòÁпɴӱÈ×îСֵ´óµÄÖµ¿ªÊ¼£¬È±Ê¡ÖµÎªÐòÁеÄ×îСֵ¡£¶ÔÓÚ½µ Ðò£¬ÐòÁпÉÓɱÈ×î´óֵСµÄÖµ¿ªÊ¼£¬È±Ê¡ ......
ʹÓÃOracleÌØÓеIJéѯÓï·¨, ¿ÉÒԴﵽʰ빦±¶µÄЧ¹û
1. Ê÷²éѯ
create table tree (
id number(10) not null primary key,
name varchar2(100) not null,
super number(10 ......