oracleÊý¾Ý¿â¿ª·¢ÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí
ʹÓÃhibernateÓ³ÉäÎļþÅäÖÃÊý¾Ý¿â±íµÄ¹ØÏµ£¬Ö´ÐÐʱ±¨£ºSQL ÃüÁîδÕýÈ·½áÊø ´íÎó
ºÜÃ÷ÏԵĴíÎó£¬SQLÓï·¨´íÎó£¬Ìù³ö´úÂë²ÅÖªµÀÔΪ¡£
SQLÓï·¨´íÎó --ÌṩµÄÐÅϢ̫ÉÙ£¬Ïë°ïÄãҲûÕÞ
Hibernate: select informatio0_.×ÊѶ±àºÅ as ×ÊѶ±àºÅ2_, informatio0_.ÐÅÏ¢ÀàÐÍ1 as ÐÅÏ¢ÀàÐÍ2_2_, informatio0_.ÐÅÏ¢ÀàÐÍ2 as ÐÅÏ¢ÀàÐÍ3_2_, informatio0_.ÐÅÏ¢±êÌâ as ÐÅÏ¢±êÌâ2_, informatio0_.ÐÅϢͼƬ as ÐÅϢͼƬ2_, informatio0_.·¢²¼ÈË as ·¢²¼ÈË2_, informatio0_.·¢²¼ÈÕÆÚ as ·¢²¼ÈÕÆÚ2_, informatio0_.ÐÅÏ¢ÄÚÈÝ as ÐÅÏ¢ÄÚÈÝ2_, informatio0_.Éϼ¶ÀàÐÍ as Éϼ¶ÀàÐÍ2_, informatio0_.µã»÷ÂÊ as µã»÷ÂÊ2_ from system.wz_information informatio0_ where informatio0_.ÐÅÏ¢ÀàÐÍ2='·þÎñÐÅÏ¢'
Hibernate: select user0_.Óû§±àºÅ as Óû§±àºÅ10_, user0_.Óû§Ãû as Óû§Ãû10_, user0_.ÃÜÂë as ÃÜÂë10_, user0_.ÐÕÃû as ÐÕÃû10_, user0_.½ÇÉ«±àºÅ as ½ÇÉ«±àºÅ10_, user0_.µØÖ· as µØÖ·10_, user0_.״̬ as ״̬10_, user0_.´´½¨ÈÕÆÚ as ´´½¨ÈÕÆÚ10_ from system.wz_user user0_ where user0_.Óû§Ãû='system' and user0_.ÃÜÂë='system'
Hibernate: select userrole0_.½ÇÉ«±àºÅ as ½ÇÉ«±àºÅ13_0_, userrole0_.½ÇÉ«Ãû³Æ as ½ÇÉ«Ãû³Æ13_0_, userrole0_.½ÇÉ«ÃèÊö as ½ÇÉ«ÃèÊö13_0_, userrole0_.½Çɫ״̬ as ½Çɫ״̬13_0_ from system.wz_userrole userrole0_ where userrole0_.½ÇÉ«±àºÅ=?
Hibernate: select sysrolerig0_.½ÇÉ«±àºÅ as ½ÇÉ«±àºÅ1_, sysrolerig0_.ȨÏÞ±àºÅ as ȨÏÞ±àºÅ1_, userright1_.ȨÏÞ±àºÅ as ȨÏÞ±àºÅ11_0_, userright1_.ȨÏÞ¸¸¼¶±àºÅ as ȨÏÞ¸¸¼¶±àºÅ11_0_, userright1_.ȨÏÞÀàÐÍ as ȨÏÞÀàÐÍ11_0_, userright1_.ȨÏÞ as ȨÏÞ11_0_, userright1_.ȨÏÞÁ¬½ÓµØÖ·
Ïà¹ØÎÊ´ð£º
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË
ÒýÓÃ
oracle ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......
ÅäÖû·¾³±äÁ¿oracleÔÚ XP
ÐüÉÍ·Ö£º105 - ½â¾öʱ¼ä£º2008-9-23 23:39
ÎÒÖ»°Ñoracle×°ÔÚÁËE:\oracleÖÐ
»·¾³±äÁ¿²»ÖªµÀÈçºÎÅäÖÃ.
XPϰ²×°ORACLE ûÓÐÐèÒªÅäÖõĻ·¾³±äÁ¿
¿ÉÒÔͨ¹ýEMÅäÖÃÏ·þÎñÃûº ......
¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......