ORACLE OMF½éÉÜ
ÏÈ¿´Oracle ¹Ù·½½âÊÍ
Oracle managed file (OMF)
A file that is created automatically by the Oracle database server when it is needed and automatically deleted when it is no longer needed.
ÈçºÎÅжÏÄãµÄÊý¾Ý¿âÊÇ·ñΪ֧³ÖOMF
SQL> show parameter db_create_file_dest;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_create_file_dest string
Èç¹ûValue Ϊ¿ÕÔò²»Ö§³Ö£¬ÓÐÖµÔòÖ§³Ö¡£
ÈçºÎÉèÖÃDB Ö§³Ö£¿
Ð޸ijõʼ»¯²ÎÊýÎļþ
[oracle@itc-test9 dbs]more initOCM.ora
.......
*.user_dump_dest='/disk/oracle/admin/OCM/udump'
db_create_file_dest = '/disk/oracle/oradata'
ʹÓà ALTER SYSTEM ÃüÁ̬ÉèÖÃ
SQL> alter system set db_create_file_dest='/disk/oracle/oradata ;
System altered.
OMFÓÐЩÓÃÄØ£¿
ÎÒ´óÌå×ܽáÒ»¸öһϾÍÏÂÃæ¼¸µã£º
1£º ´´½¨Tablespace ÊDz»ÐèҪдÊý¾ÝÎļþÃû³ÆºÍ´óС £¨default 100M,×Ô¶¯Ôö³¤£¬Autoextend Ϊunlimited)
SQL> create tablespace omf;
Tablespace created.
Os:
[oracle@itc-test9 datafile]pwd
/disk/oracle/oradata/OCM/datafile
[oracle@itc-test9 datafile]ll
total 102512
-rw-r----- 1 oracle dba 104865792 Apr 29 16:13 o1_mf_omf_4zj30b2p_.dbf
´´½¨Êý¾ÝÎļþÊôÐÔ£º
Name /disk/oracle/oradata/OCM/datafile/o1_mf_omf_4zj30b2p_.dbf
Tablespace OMF
Status Online
File Size (KB) 102400
AutoExtend Yes
Increment 100MB
Maximum File Size 32767MB
2: ÏòTablespace Ìí¼ÓÎļþÊÇÖ»ÊÊÓÃadd datafile ¾Í¿ÉÒÔÁË£¬²ÎÊýÈç1.
SQL> alter tablespace omf add datafile;
Tablespace altered.
Os
[oracle@itc-test9 datafi
Ïà¹ØÎĵµ£º
update t_tmprpt_firstreplycosttime t
set (t.firstreplytime,
t.dealstaff,
t.firstreplyfailcontent)
= (select a.suggesttime,
a.suggester,
substr(a.remark,instr(a.remark,'¡¿',1)+2)
from t_wf_suggesthis a
......
select myFunc(²ÎÊý1,²ÎÊý2..) to dual; --¿ÉÒÔÖ´ÐÐһЩҵÎñÂß¼
Ò»:OracleÖеĺ¯ÊýÓë´æ´¢¹ý³ÌµÄÇø±ð:
A:º¯Êý±ØÐëÓзµ»ØÖµ,¶ø¹ý³ÌûÓÐ.
B:º¯Êý¿ÉÒÔµ¥¶ÀÖ´ÐÐ.¶ø¹ý³Ì±ØÐëͨ¹ýexecuteÖ´ÐÐ.
C:º¯Êý¿ÉÒÔǶÈëµ½SQLÓï¾äÖÐÖ´ÐÐ.¶ø¹ý³Ì²»ÐÐ.
ÆäʵÎÒÃÇ¿ÉÒÔ½«±È½Ï¸´ÔӵIJéѯд³Éº¯Êý.È»ºóµ½´æ´¢¹ý³ÌÖÐÈ¥µ÷ÓÃÕâЩº¯Êý.
¶þ:È ......
emctl start dbconsole ÊÇ10gµÄÆô¶¯console·þÎñµÄÃüÁî
½«OEM·þÎñÍ£Ö¹emctl stop dbconsole
emctl start dbconsoleÆô¶¯EM console·þÎñ£¬Ê¹ÓÃǰÐèÒªÏÈÉèÖÃORACLE_SID»·¾³±äÁ¿
emctl stop dbconsoleÍ£Ö¹EM console·þÎñ£¬Ê¹ÓÃǰÐèÒªÏÈÉèÖÃORACLE_SID»·¾³±äÁ¿
¹Ø±ÕÊý¾Ý¿âºóÓ¦¸ÃÊ×ÏÈÓÃsysdbaµÇ½,ÕâÑù¾Í½øÈëÁËsysģʽ. ......
SQLServerºÍOracleÊÇ´ó¼Ò¾³£Óõ½µÄÊý¾Ý¿â£¬Ôڴ˸Ðл×÷Õß×ܽá³öÕâЩ³£Óú¯ÊýÒÔ¹©´ó¼Ò²Î¿¼¡£
Êýѧº¯Êý£º
¡¡1.¾ø¶ÔÖµ
¡¡¡¡ S:SELECT abs(-1) value
¡¡¡¡ O:SELECT abs(-1) value from dual
2.È¡Õû(´ó)
¡¡¡¡ S:SELECT ceiling(-1.001) value
¡¡¡¡ O:SELECT ceil(-1.001) value from dual
3.È¡Õû£¨Ð¡£© ......
pl/sql ÌṩÁËÇ¿´ó¶øÁé»îµÄÊÖ¶ÎÀ´²¶×½ºÍ´¦Àí³ÌÐò²úÉúµÄÒì³££¬´Ó¶øÊ¹ oracle µÄÓû§Ô¶ÀëһЩÁîÈË·³ÄÕµÄ bug ¡£
pl/sql Òì³£´¦ÀíµÄ¸ÅÄîºÍÊõÓï
ÔÚ oracle ÖÐËùÓеĴíÎó¶¼±»ÈÏΪÊDz»Ó¦¸Ã·¢ÉúµÄÒì³£¡£Ò»¸öÒì³£¿ÉÄÜÊÇÒÔÏ 3 ÖÖÇé¿öµÄÒ»ÖÖ£º
u ÓÉϵͳ²úÉúµÄ´íÎó£¨& ......