Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¹ØÓÚÐÞ¸ÄoracleµÄ²ÎÊý

Ê×ÏÈÄØ¿Ï¶¨ÊÇÒªÒÔÊý¾Ý¿â¹ÜÀíÔ±µÄÉí·Ý½øÈë Ò²¿ÉÒÔÔÚ·þÎñÆ÷ÉÏÃæÒÔÏÂÃæµÄ·½Ê½Á¬½Óµ½Êý¾Ý¿â:
´ò¿ªcmd´°¿Ú,sqlplus /nolog
½øÈëÃüÁîÐкó,conn / as sysdba
¿ªÊ¼Ð޸IJÎÊý
alter system set key=[value] scope=[scope];
key:  ÒªÐ޸ĵIJÎÊý
[value]:ÒªÉèÖõÄÖµ,ÊýÖµÐ͵ÄÖ±½ÓÌîÈëʹÓÃÊý×Ö,×Ö·ûÐ͵ÄÒªÓõ¥ÒýºÅÀ¨ÆðÀ´
[scope]:ÓÐ3¸öÑ¡ÔñmemoryÖ¸µÄÊÇÖ»Ð޸ĵ±Ç°ÔËÐÐʵÀýµÄ²ÎÊý,ÖØÆôÊý¾Ý¿âºó»Ö¸´ÒÔǰµÄÉèÖÃ;spfileÐ޸ijõʼ»¯ÎļþÖеÄÉèÖÃ,ÖØÆôÊý¾Ý¿âºóÉúЧ;bothͬʱÐÞ¸ÄÔËÐÐʵÀýºÍ³õʼ»¯ÎļþµÄÉèÖÃ.
Ð޸IJÎÊýʱ,¿ÉÄÜ»á³öÏÖÕâ¸ö´íÎó
ORA-02095: ÎÞ·¨ÐÞ¸ÄËùÖ¸¶¨µÄ³õʹ»¯²ÎÊý
ÐÞ¸Ä[scope]ֵΪspfile,¼´¿É
²é¿´²ÎÊý
show parameter %
%:¿ÉÒÔÊäÈëÒª²é¿´²ÎÊýµÄ²¿·ÖÃû³Æ,×Ô¶¯ÏÔʾƥÅäµÄ²ÎÊý


Ïà¹ØÎĵµ£º

28.6 Oracle³£¼ûÎÊÌâ´¦Àí

28.6  Oracle³£¼ûÎÊÌâ´¦Àí
±¾½Ú½éÉÜÔÚRed Hat Enterprise Linux 5.2Éϰ²×°¼°ÅäÖÃOracleÊý¾Ý¿â·þÎñÆ÷ÖУ¬³£¼ûµÄÎÊÌâ¼°½â¾ö·½·¨£¬°üÀ¨ÈçºÎ»ñµÃÊý¾Ý¿â´´½¨¹ý³ÌÖеÄÏêϸÐÅÏ¢£¬·ÃÎÊOEM³öÏÖ“°²È«Á¬½Óʧ°Ü£¬Ê¹ÓÃÁËÎÞЧµÄ°²È«Ö¤Êé”´íÎóÒÔ¼°Íü¼ÇsysÓû§¿ÚÁîºóµÄ´¦Àí·½·¨µÈ¡£ ......

¡¶Í¿Ä¨Oracle£­Èý˼±Ê¼ÇÖ®Ò»²½Ò»²½Ñ§Oracle¡·³ö¯ÊÖ¼Ç

¡öÀÖÖª
  “Ë­ÊÇË­µÄË­”£¬ÕâÊÇΨÃÀÖÐ͸×ÅÓÄÔ¹µÄÒ»Ê׸裬µ«È´»áĪÃûµØµçµ½ÐÄÖеÄÀÛ¡£Ñ§Ï°Ì«ÀÛ£¬¹¤×÷Ì«ÀÛ£¬Éú»îÌ«ÀÛ£¬Á¬¸èÃûÌý×Ŷ¼ÄÇôÀÛ¡£
²ß»®µÄµÚÒ»±¾Êé¡¶´óÏó——Thinking in UML¡·£¬´ÓÔË×÷£¬µ½ÉÏÊУ¬µ½³©Ïú£¬µ½¾­µä£¬µ½¹úÄÚUMLµÚÒ»Ê飬һÄêÖ®ÄÚʵÏÖÁËÒ»¸ö¸öûÓÐÃιýµÄÃÎÏë¡£ÕýÈçÕâÊ׸èÖеÄÒ ......

Oracle job ʹÓÃ

²½Ö裺
(1) ´´½¨×÷Òµ
(2) ´´½¨job
       dbms_job.submit();
       submit ( jobno¡¡OUT binary_ineger,
¡¡¡¡¡¡¡¡¡¡¡¡¡¡What¡¡¡¡¡¡IN¡¡varchar2,
¡¡¡¡¡¡¡¡¡¡¡¡¡¡next_date IN¡¡date,
¡¡¡¡¡¡¡¡¡¡¡¡¡¡interval¡¡IN¡¡varchar2,
¡¡¡¡¡¡¡¡¡¡¡¡  &nb ......

²éѯOracle×Ô´øµÄ·½·¨Ãû×ֺ͹ؼü×Ö

ÈçºÎ²éѯoracleÖеĹؼü×Ö£¬Ö´ÐУº
select * from v$reserved_words
ÆäʵÄÚǶµÄfunction£¬¾ÍÊÇÒ»¸öϵͳµÄpackageÄÚµÄfunction»òÕßprocedure¡£Èç¹ûÖªµÀÕâ¸ö¸ù±¾µÄÔ­Òò£¬ÒªÕÒµ½Õâ¸öÄÚǶµÄ×Ô´øfunction¾ÍºÜ¼òµ¥ÁË¡£
ÕâÀïÄÚǶµÄ×Ô´øµÄfucntionºÍprocedureµÄ¶ÔÏ󣬯äʵ¾ÍÊÇSTANDARDÕâ¸ö°üÀïµÄ¶ÔÏó¡£¶ø
OracleÀï¶ÔÓÚfuncti ......

Oracle 9i/10g pfile/spfile ²ÎÊýÎļþÏê½â


(1)PfileÎļþ
    Pfile£¨Parameter File£©ÎļþÊÇ»ùÓÚÎı¾¸ñʽµÄ²ÎÊýÎļþ£¬º¬ÓÐÊý¾Ý¿âµÄÅäÖòÎÊý¡£
    Oracle 9iÔÚ°²×°Ê±ÎªÃ¿¸öÊý¾Ý¿â½¨Á¢ÁËÒ»¸öPfile£¬Ä¬ÈϵÄÃû³ÆÎª“init+Àý³ÌÃû.ora”£¬ÕâÊÇÒ»¸öÎı¾Îļþ£¬¿ÉÒÔÓÃÈκÎÎı¾±à¼­¹¤¾ß´ò¿ª¡£
ϱíΪÊý¾Ý¿âµÄ³õʼ»¯²Î ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ