oracleÖе÷Óôø²ÎÊýµÄ´æ´¢¹ý³Ì
create or replace procedure proc_test
( a in number, b out number )
as
begin
b:=a+1;
end proc_test;
ÏÖÔÚÒªµ÷Óõϰ¾ÍÊÇÕâÑù
SQL> c number;
SQL>exec proc_test(1,:c);
ǧÍòҪעÒâ±ðÍüÁËдðºÅ
Ïà¹ØÎĵµ£º
orastressÖ÷Òª²âÊÔÊý¾Ý¿âµÄѹÁ¦¡£Ëü¿ÉÒÔ²âÊÔÊý¾Ý¿âµÄCPU»òÕßÄÚ´æµÄѹÁ¦£¨ÒÔÖ»¶Á·½Ê½£©£¬Ò²¿ÉÒÔʹÓðüÀ¨ÆÕͨINSERTºÍÖ±½Ó·¾¶INSERTÁ½ÖÖ·½Ê½²âÊÔÊý¾Ý¿âµÄI/OÄÜÁ¦¡£
orastressÖ»ÄÜÔËÐÐÔÚwindowsÏ£¬µ«ËüÒ²¿ÉÒÔ²âÊÔÔ¶³Ì·þÎñÆ÷µÄѹÁ¦¡£
1¡¢ÏÂÔØ
ÏÂÔØµØÖ·ÊÇ
http://www.linxcel.co.uk/orabm/orastress.zip
2¡¢°²×°
oras ......
OracleÖ±·½Í¼½âÎö
Ò»¡¢ ºÎνֱ·½Í¼£º
Ö±·½Í¼ÊÇÒ»ÖÖͳ¼ÆÑ§ÉϵŤ¾ß£¬²¢·ÇOracleרÓС£Í¨³£ÓÃÓÚ¶Ô±»¹ÜÀí¶ÔÏóµÄij¸ö·½ÃæµÄÖÊÁ¿Çé¿ö½øÐйÜÀí£¬Í¨³£Çé¿öÏÂËü»á±íÏÖΪһÖÖ¼¸ºÎͼÐÎ±í£¬Õâ¸öͼÐαíÊǸù¾Ý´Óʵ¼Ê»·¾³ÖÐËùÊÕ¼¯À´µÄ±»¹ÜÀí¶ÔÏóij¸ö·½ÃæµÄÖÊÁ¿·Ö²¼Çé¿öµÄÊý¾ÝËù»æÖƳɵģ¬Í¨³£»á»³ÉÒÔÊýÁ¿Îªµ×±ß£¬ÒÔÆ ......
Oracle°²×°Æª
°æ±¾£ºwin32_11gR1_database_1013
ϵͳ£ºwin7
Äڴ棺3g£¨Å¼×Ô¼ºµØ-0-£©
1¡¢ÒòΪ²Ù×÷ϵͳѡÔñÁËwin7£¬ËùÒÔÔÚ°²×°Ö®Ñ¡ÐèÒªÐÞ¸ÄÒ»ÏÂÅäÖÃÎļþ£¬database\stage\prereq\db\refhost.xml
2¡¢ÐÞ¸ÄÍêÅäÖÃÎļþºó£¬µãinstall°²×°¼´¿É£¬µÈdos½çÃæ¼ÓÔØÍêºóÌø³öÈçϽçÃæ
3¡¢ÏÂÒ»²½
4¡¢Ñ¡ÔñÆóÒµ°æ£¬È»ºó ......
È«Êý¾Ý¿â±¸·Ý½¨ÒéÓÃoracle×Ô´øµÄ expÃüÁî¡£
µ¼Ä³ÕűíµÄ»°£¬»òÕß±¸·Ýij¸öÓû§µÄÐÅÏ¢£¬¿ÉÒÔµ½
Tool-¡·export table µ¼±í
Tool-¡·export user object µ¼Óû§µÄÊý¾Ý¡£
-----------------------------------------------------------------------------------------
ÔÚoracleÖÐ,Ö´ÐÐsqlÎļþ,¿ÉÒÔдһ¸öÅú´¦ÀíÎļþ
sqlplus& ......