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
Ïà¹ØÎĵµ£º
http://episode.javaeye.com/blog/183016
±í¿Õ¼ä£º
OracleµÄUNDOTBS01.DBFÎļþÌ«´óµÄ½â¾ö°ì·¨
1¡¢.½ûÖ¹undo tablespace×Ô¶¯Ôö³¤
alter database datafile 'full_path\undotbs01.dbf' autoextend off;
2.-- ´´½¨Ò»¸öеÄС ......
oracle±í¿Õ¼ä²Ù×÷Ïê½â
Ò»¡¢½¨Á¢±í¿Õ¼ä
CREATE TABLESPACE data01
DATAFILE '/oracle/oradata/db/DATA01.dbf' SIZE 500M
UNIFORM SIZE 128k;
¶þ¡¢½¨Á¢UNDO±í¿Õ¼ä
CREATE UNDO TABLESPACE UNDOTBS02
DATAFILE '/oracle/oradata/db/UNDOTBS02.dbf' SIZE 50M
#×¢Ò⣺ÔÚOPEN״̬ÏÂijЩʱ¿ÌÖ»ÄÜÓÃÒ»¸öUNDO±í¿Õ¼ä£¬Èç¹ûÒ ......
¡¾×ªÔØ¡¿£º×Ô¼º½¨Á¢Ò»¸ö´øout²ÎÊýµÄ´æ´¢¹ý³Ì£¬½á¹ûÒ»Ö±½¨Á¢jobÈÎÎñʧ°Ü£¬ºóÀ´ÕÒµ½ÁËÕâÆªÎÄÕ²ÅÖªµÀÔÒòËùÔÚ¡£
Ä¿ ǰ£¬Á÷ÐеÄÖ÷Á÷Êý¾Ý¿â¶¼ÓµÓдËÏÄÜ£¬×î¾ß´ú±íÐÔµÄÊÇMicrosoft SQL Server
7.0¡¢Oracle8i/9iµÈ¡£µ«ÊÇ£¬ÒªÈÃJob¹¤×÷£¬»¹ÐèÒªÎÒÃǼÓÒÔÅäÖòÅÄÜʵÏÖ¡£ÕâЩÅäÖö¼ÓÐGUI²Ù×÷¡£±¾ÎĽéÉÜOracle9iÏÂͨ¹ýÃüÁîÐÐ
ʵ ......
ËäÈ»×Ô¼ºÑ§Ï°JavaÒ²»¹Ò»¶Îʱ¼äÁË£¬Ò²Á¬¹ýһЩÊý¾Ý¿â£¬±ÈÈç˵mysql£¬ÄÇÒÑÊǺó¤Ö®Ç°µÄÊÂÁË£¬µ«ÊÇÄØ£¬OracleÎҾʹÓδÁ¬¹ý£¬¾¡¹ÜÎÒѧϰOracleÒ²ÓÐÒ»¶Îʱ¼äÁË£¬ºÙºÙ£¬½ñÌì¾Í³¢ÊÔÁËÒ»ÅÌ£¬ÕæµÄ¾õµÃ£¬ËùÓеĶ«Î÷£¬¶¼Òª×Ô¼º³¢ÊÔ²ÅÐа¡¡£
Ê×ÏÈÊÇдºÃÁËÁ¬½Ó£º ......
¹ØÓÚµ¼³ö
¡¡¡¡ÔÀí
¡¡¡¡Í¨¹ýsqlplusµÄµÄ±¨±í¹¦ÄÜÉú³ÉÎı¾Îļþ£¬µ«²úÉúµÄÎı¾ÎļþÒò·ÖÎöÔÒò´æÔÚ¿ÕÐÐÏÖÏó£¨Ö»ÓлسµÃ»ÓÐÆäËü£©£¬¿ÉÒÔͨ¹ýµÚÈý·½·½Ê½´¦ÀíÒ»ÏÂÉú³É±ê×¼Îı¾
¡¡¡¡A ѧϰ¹ý³Ì
¡¡¡¡1¡¡½¨±í
¡¡¡¡
¡¡¡¡SQL>CREATE TABLE TESTINOUT(ID NUMBER(10), USERNAME VARCHAR2(10), DATE1 DATE, MONEY NUMBER(6 ......