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

ORACLE checkpoint cntºÍcheckpoint scn

¸Õ²ÅÉÏÍøËÑcheckpoint cnt£¬¿´µ½EYGLEдµÄһƪÎÄÕ£¬Ð´µÃ²»´í£¬´æÆðÀ´·½±ãÒÔºóѧϰ¡£
=========================================================================
ͨ¹ýÊÔÑé˵Ã÷checkpoint cnt ºÍcheckpoint scnµÄ¹ØÏµ
1.ÔÚ²»Í¬Ìõ¼þÏÂת´¢¿ØÖÆÎļþ
 
SQL> alter session set events 'immediate trace name CONTROLF level 10';
Session altered.
SQL> alter tablespace system begin backup;
Tablespace altered.
SQL> alter session set events 'immediate trace name CONTROLF level 10';
Session altered.
SQL> alter system checkpoint;
System altered.
SQL> alter session set events 'immediate trace name CONTROLF level 10'
2 /
Session altered.
SQL> alter tablespace system end backup;
Tablespace altered.
SQL> alter session set events 'immediate trace name CONTROLF level 10';
Session altered.
 
notes:
alter session set events 'immediate trace name CONTROLF level 10';
ÓÃÓÚת´¢¿ØÖÆÎļþ.
 
2.»ñµÃÒÔϸú×ÙÎļþÐÅÏ¢(½öÑо¿system±í¿Õ¼ä¼Ç¼,Çë×¢ÒâºìÉ«²¿·Ö):
a.Õý³£Çé¿öÏÂת´¢¿ØÖÆÎļþ
 
***************************************************************************
DATA FILE RECORDS
***************************************************************************
(blkno = 0x6, size = 180, max = 100, in-use = 24, last-recid= 574)
DATA FILE #1:
(name #4) /opt/oracle/oradata/hsjf/system01.dbf
creation size=32000 block size=8192 status=0xe head=4 tail=4 dup=1
tablespace 0, index=1 krfil=1 prev_file=0
unrecoverable scn: 0x0000.00000000 04/23/2004 01:20:52
Checkpoint cnt:1567 scn: 0x0000.0148181c 06/22/2004 18:58:46
Stop scn: 0xffff.ffffffff 06/22/2004 18:58:05
Creation Checkpointed at scn: 0x0000.000000ae 07/16/2003 03:40:10
thread:1 rba:(0x1.3.10)
enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
Offline scn: 0x0000.013b46fd prev_range: 0
Online Checkpointed at scn: 0x0000.013b46fe 05/28/2004 23:37:17
thread:1 rba:(0x1.2.0)
enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
00000000 000


Ïà¹ØÎĵµ£º

CentOS5.2Éϰ²×°Oracle 10g 10.0.2.1.0

×¢Ò⣺ΪSWAP·ÖÅäµÄ¿Õ¼äÒª³¬¹ý1G£¬Òª²»È»ºóÃæ×°Oralce»áÒòΪ¿Õ¼ä²»×ã¶øÎÞ·¨°²×°¡£²¢ÇÒÒª¹Ø±Õ·À»ðǽ£¬¹Ø±ÕSELIINUX
ÐÞ¸ÄhostÎļþ
Hosts File
# vi /etc/hosts
192.168.10.10 oracle oracle.localdomain oracle
127.0.0.1 oracle localhost.localdomain localhost
×¢Ò⣺ÄãÒª°Ñ192.168.10.10¸Ä³ÉÄã×Ô¼ºµÄIP£¬ÎÒÕâÀïÖ»ÊÇ ......

OracleÊý¾Ýµ¼³öµ½DBFµÄÎÊÌâ

 OracleÊý¾Ýµ¼³öºÜ¼òµ¥£¬µ«ÎªÁËÌá¸ßËÙ¶È£¬ÎÒÒ»°ã²»Ö±½Óµ¼³ö³ÉDBF£¬¶øÊÇÏȵ¼³ö³ÉCSV¸ñʽµÄÎı¾Îļþ¡£
½ñÌì¾ÍÓöµ½Ò»¸öÎÊÌ⣬µ¼³öµÄcsvÔÚת»»³Édbfʱ³öÏÖÁ˺ܶà¿ÕÐС£¾­¹ý²éÕÒÎÊÌ⣬·¢ÏÖÊÇ×Ö¶ÎÖк¬Óл»Ðзûµ¼Ö¡£
ʹÓÃ
select Replace(zsyj,chr(13)||chr(10),'')  as SXPD  from TableName
½â¾öÎÊÌâ¡£ ......

Oracle Partitionά»¤Ö®

·ÖÇø±íά»¤µÄ³£ÓÃÃüÁ
ALTER TABLE
-- DROP -- PARTITION
-- ADD |
-- RENAME |
-- MODIFITY |
-- TRUNCATE |
-- SPILT |
-- MOVE |
-- EXCHANGE |
·ÖÇøË÷ÒýµÄ³£ÓÃά»¤ÃüÁ
ALTER INDEX
-- DROP -- PARTITION
-- REBUILD |
-- RENAME |
-- MODIFITY |
-- SPILT |
-- PARALLEL
-- UNUSABLE
1¡¢ALTER ......

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

oracleÎı¾Îļþµ¼Èëµ¼³ö(sqlldr&&spool)

 ¹ØÓÚµ¼³ö
¡¡¡¡Ô­Àí
¡¡¡¡Í¨¹ýsqlplusµÄµÄ±¨±í¹¦ÄÜÉú³ÉÎı¾Îļþ£¬µ«²úÉúµÄÎı¾ÎļþÒò·ÖÎöÔ­Òò´æÔÚ¿ÕÐÐÏÖÏó£¨Ö»ÓлسµÃ»ÓÐÆäËü£©£¬¿ÉÒÔͨ¹ýµÚÈý·½·½Ê½´¦ÀíÒ»ÏÂÉú³É±ê×¼Îı¾
¡¡¡¡A ѧϰ¹ý³Ì
¡¡¡¡1¡¡½¨±í
¡¡¡¡
¡¡¡¡SQL>CREATE TABLE TESTINOUT(ID NUMBER(10), USERNAME VARCHAR2(10), DATE1 DATE, MONEY NUMBER(6 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ