OracleÃâ·ÑµÄÊý¾Ý¿â¿ª·¢¹¤¾ß
֮ǰ¿ª·¢OracleÒ»°ãÊÇʹÓÃPL/SQL Developer»òÕßÊÇTOAD£¬ÓÉÓÚÏÖÔÚ¹«Ë¾¶Ô°æÈ¨ÎÊÌâ¿´µÃ±È½ÏÖØ£¬ËùÒÔÎÒÒ²Ö»ÄܶÔÕâЩÊìϤµÄ¿ª·¢¹¤¾ß˵Éù°Ý°ÝÁË£¡ÔÚOracle¹Ù·½ÍøÕ¾Õ¾¿´µ½ÁËOracleÒѾÓÐÁËÒ»¸öOracle SQL Developer£¬²¢ÇÒÊÇÃâ·ÑµÄ£¡
ÒÔÏÂÊÇOracle¹Ù·½¶ÔOracle SQL DeveloperµÄ½éÉÜ
³ÌÐò´úÂë
oracle SQL Developer is a free and fully supported graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks.
µ±Ç°Oracle SQL DeveloperµÄ×îа汾ÊÇ1.5£¬ÏÂÔØÏÂÀ´ºó£¬Ò»ÔËÐУ¬ÏÅÁËÒ»Ìø£¬×÷Ϊһ¿îÃâ·ÑµÄSQL ¿ª·¢¹¤¾ß£¬¹¤¾ß¾¹Èç´ËÇ¿´ó£¡ÊµÔÚÊǶÔOracleµÄ¹²Ïí¾«ÉñÅå·þ£¡
ÏÂÃæÊÇÕâ¿î²úÆ·µÄÔËÐнØÍ¼
ÓÐÐËȤµÄÅóÓÑ¿ÉÒÔÏÂÔØÏÂÀ´ÓÃһϣ¡
ÏÂÔØµØÖ·ÊÇ£ºhttp://www.oracle.com/technology/products/database/sql_developer/index.html
Ïà¹ØÎĵµ£º
COMMITÊÇÒ»¸ö·Ç³£¿ìµÄ²Ù×÷£¬µ±ÎÒÃÇ·¢²¼commitÃüÁîʱ£¬ÕæÕýÀ§Äѵ͝×÷ÒѾÍê³É£¬
ÔÚÊý¾Ý¿âÖÐÒѾִÐÐÁËÊý¾Ý¸ü¸Ä£¬ËùÒÔÒѾÍê³ÉÁË99%µÄÈÎÎñ£¬ÀýÈ磺ÏÂÁвÙ×÷ÒѾ²úÉú£º
1.ÔÚSGA(Buffer Cache)ÖÐÒѾÉú³ÉÁËundo¿é£»
2.ÔÚSGA(Buffer Cache)ÖÐÒѾÉú³ ......
½ñÌìÔÚ»úÆ÷ÉÏ×°Oracle 10g£¬°²×°Íê³ÉÒÔºó³öÏÖ´íÎóÌáʾ¡°ORA-00988: ¿ÚÁîȱʧ»òÎÞЧ¡±£¬È»ºó¾ÍÎÞ·¨½øÈë¿ØÖÆÌ¨½øÐÐÏàÓ¦µÄ²Ù×÷ºÍ¹ÜÀí£¬ÎÒÒÔǰÔÚ°²×°Oracle 9ʱ²¢Ã»ÓгöÏÖ¹ý
Õâ¸ö´íÎó¡£È»ºóÐ¶ÔØºóÖØÐ°²×°£¬ÎÊÌâÒÀ¾É£¬ÕÛÌÚÁ˺ôóÒ»ÕóÖÕÓÚŪÃ÷°×ÊÇÔõôһ»ØÊÂÁË¡£
ÕâÖÖÇé¿öͨ³£·¢ÉúÓÚ´´½¨ Oracle Àý³Ìʱָ¶¨ÁË·ÇÕý³£µÄÈ«¾ÖÊý¾Ý¿ ......
1¡¢±¸·ÝÖ¸¶¨µÄ±í¿Õ¼ä
Ê×ÏÈ£¬ÄãҪȷÈÏ×Ô¼ºµçÄÔÉÏÓÐexp.exeÕâ¸ö¶«¶«£¬²ÅÄܽøÐб¸·Ý¹¤×÷¡£
ÎÒÏëÒª±¸·ÝµÄÊÇÓû§ÃûΪcyyµÄ±í¿Õ¼ä£¬±¸·ÝÎļþ´òËã·ÅÔÚDÅÌ£¬²¢ÒÔbackup_oracle.dmpÃüÃû£¬Ë³±ã°ÑÈÕÖ¾ÎļþÒ²±¸·ÝһϺÃÁË¡£
ÔÚÃüÁîÐÐÇÃÈ룺
C:\Documents and Settings\Administrator>exp cyy/cyy@bsrs file=D:\backup_oracle.dmp ......
An introduction to Mutexes in 10gR2
By Connie Green, Kumar Rajamani
from meetings with: Kumar Rajamani, Russell Green, Saureen Shah, Cecilia Gervasio and Connie Green
Introduction
This paper is intended as an introduction to mutexes. It describes new concepts associated with mutexes, when ......
ÿÌì1µãÖ´ÐеÄoracle JOBÑùÀý
DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => X,
what => 'ETL_RUN_D_Date;',
next_date => to_date('2009-08-26 01:00:00','yyyy-mm-dd hh24:mi:ss'),
interval => 'trunc(sysdate)+1+1/24',
no_parse => FALSE
);
SYS.DBMS_OUTPUT.PUT_LINE('Job Number ......