ÐÞ¸ÄORACLE×î´ó»á»°Êý
ÐÞ¸ÄORACLE×î´ó»á»°Êý ²é¿´µ±Ç°oracle×î´ó»á»°Êý show parameter Ìõ¼þ Ìõ¼þ¿ÉÒÔʹÓòÎÊýÃûÖаüº¬µÄ¼¸¸ö×Öĸ£¬Èçshow parameter process½«ÏÔʾ NAME TYPE VALUE
------------------------------------ ----------- ------
aq_tm_processes integer 0
db_writer_processes integer 1
gcs_server_processes integer 0
job_queue_processes integer 10
log_archive_max_processes integer 2
processes integer 150 oracle10 spfileÎļþ½á¹¹ pfileºÍspfileΪOracleµÄÆô¶¯Îļþ£¬pfileΪÎı¾Îļþ£¬spfileÓÉpfile±àÒëºóµÄ¶þ½øÖÆÎļþ¡£ Oracle10 pfileÎļþλÖà ¢Ù\product\10.2.0\admin\hide\pfile\init.ora Oracle10 spfileÎļþλÖà ¢Ú\product\10.2.0\db_1\database\init.ora ΪOracle10µÄspfileÎļþ£¬µ«ÆäÖ¸ÏòµÄÈ´ÊÇÁíÒ»¸öÎļþ ¢Û\product\10.2.0\db_1\dbs\spfile.ora ͨ¹ýpfileÉú³ÉspfileµÄ·½·¨ 1£©¿½±´¢Ù\product\10.2.0\admin\hide\pfile\init.ora µ½ \product\10.2.0\db_1\database\init.ora 2)ʹÓÃsystemÒÔsysdba·½Ê½µÇ¼ Ö´ÐÐ create spfile='spfile_init.ora' from pfile='init.ora'; Éú³Éspfile_init.oraºó£¬¿½±´µ½¢Û\product\10.2.0\db_1\dbs\spfile.ora 3)ÖØÐÂÆô¶¯Êý¾Ý¿âºó£¬¼´Ê¹ÓÃеÄÅäÖÃÆô¶¯Êý¾Ý¿â£¬´Ë·½·¨Æðµ½µÄ×÷ÓÃÓëʹÓÃalter system·½·¨ÐÞ¸ÄÊý¾Ý¿â²ÎÊýµÄ¹¦ÄÜÏàͬ ÐÞ¸ÄORACLEÊý¾Ý¿â²ÎÊý alter system set processes=300 scope = spfile; ÖØÐÂÆô¶¯Êý¾Ý¿â
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
Ç°ÃæдÁ˶à·ÝºìÆìDC 4.1ºÍ5.0ÉÏ°²×°Oracle 9i/10gµÄÎĵµ£¬µ«Ò»Ö±Ã»ÓÐÕûÀíDC 5.0ÉÏ°²×°Oracle 10gµ¥»ú·þÎñÆ÷µÄ×ÊÁÏ£¬ÔÒòÊǸùý³Ì·Ç³£¼òµ¥¡£µ«×î½üÏîÄ¿ÖУ¬»¹ÊÇÓÐÓû§Óöµ½Ð©ÎÊÌ⣬½ñÌì¾Í°ÑһЩÐèҪעÒâµÄµØ·½ÕûÀíһϣ¬ÏêϸµÄ¹ý³Ì¾Í²»ÃèÊöÁË¡£
Ò»¡¢ÏµÍ³»·¾³
²Ù×÷ϵͳ£ººìÆì DC 5.0 for x86 »ò x86_64
Ó²¼þ»·¾ ......
http://www.cnblogs.com/ajian/archive/2009/08/25/1421063.html
TO_DATE¸ñʽ(ÒÔʱ¼ä:2007-11-02 13:45:25ΪÀý)
Year:
yy two digits Á½Î»Äê &nbs ......
½ñÌ츴ϰOracleµÄÊý¾Ý×ÖµäºÍ¿ØÖÆÎļþ¡£
Ò»¡¢Êý¾Ý×Öµä
Êý¾Ý×ÖµäÊÇÓÉOracle·þÎñÆ÷´´½¨ºÍά»¤µÄÒ»×éÖ»¶ÁµÄϵͳ±í£¬Êý¾Ý×Öµä·ÖΪÁ½´óÀࣺһÀàΪ»ù±í£¬Ò»ÀàΪÊý¾Ý×ÖµäÊÓͼ¡£ÄÇôÊý¾Ý×ÖµäÖÐÓÖ´æÓÐÄÄЩÐÅÏ¢ÄØ£¿
1¡¢Êý¾Ý¿âµÄÂß¼½á¹¹ºÍÎïÀí½á¹¹
2¡¢ËùÓÐÊý¾Ý¿â¶Ô ......
¡¡¡¡±¾ÎĽéÉÜÁËÔÚOracleÊý¾Ý¿âÖУ¬¶ÔÈÕÆÚ¡¢Ê±¼äµÄ¸÷ÖÖ²Ù×÷£¬°üÀ¨£ºÈÕÆÚʱ¼ä¼ä¸ô²Ù×÷¡¢ÈÕÆÚµ½×Ö·û²Ù×÷¡¢×Ö·ûµ½ÈÕÆÚ²Ù×÷¡¢trunk / ROUNDº¯ÊýµÄʹÓᢺÁÃ뼶µÄÊý¾ÝÀàÐ͵ȡ£
1.ÈÕÆÚʱ¼ä¼ä¸ô²Ù×÷
¡¡¡¡µ±Ç°Ê±¼ä¼õÈ¥7·ÖÖÓµÄʱ¼ä
¡¡¡¡select sysdate,sysdate - interval '7' MINUTE from dual
¡¡¡¡µ±Ç°Ê±¼ä¼õÈ¥7СʱµÄʱ¼ä
¡¡¡ ......