《传统数据库DBA到开源的技能和心理切换——开源数据库专场（32页）.pdf》由会员分享，可在线阅读，更多相关《传统数据库DBA到开源的技能和心理切换——开源数据库专场（32页）.pdf（32页珍藏版）》请在三个皮匠报告上搜索。

1、?o?o?o?o?o?o?o?o?o?o?01?DocumentDocumentKeyKey ValueValueRelationalRelationalDBaaSDBaaSNewSQLNewSQLBigBig tablestablesGraphGraphNonNon-RelationalRelationalOperationalOperationalPiccoloPiccoloNoSQLOLAPOLTPNoSQLNoSQLAnalyticAnalytic?New Future on Cloud02?u:0a=1 s7on,scn,=571s1=or53,=4r1a0=0,=571,7:=:1

2、,=571,0:=:2,scn=:3,scn,wr:=:4,scn,bas=:5,nu7,7a:5n3s=:(,=57,scn,7a:=:)w41r1=4r1a0=0 an0 scn=(s161c=75n(scn 2ro7 s7on,scn,=571 w41r1=4r1a0=0?sc5 select FROM_UNIXTIME(1558519237,%Y-%m-%d%H:%i:%S);+-+|FROM_UNIXTIME(1558519237,%Y-%m-%d%H:%i:%S)|+-+|2019-05-22 18:00:37|+-+1 row in set(0.00 sec)mysql sele

3、ct UNIX_TIMESTAMP(2019-05-22 18:00:37);+-+|UNIX_TIMESTAMP(2019-05-22 18:00:37)|+-+|1558519237|+-+1 row in set(0.02 sec)?1(1(05?738 84537825611)5*67)(1(./.(1(/#!#/0?1(1(05?738 84537825611)5*67)(1(./.(1(/#!#/0?9o;!)?1(1(05?Binlog Event Common Header?mysql SET TIMESTAMP=UNIX_TIMESTAMP(1999-01-01);Query

4、 OK,0 rows affected(0.00 sec)mysql select now(),sysdate(),sleep(3),now(),sysdate();+-+-+-+-+-+|now()|sysdate()|sleep(3)|now()|sysdate()|+-+-+-+-+-+|1999-01-01 00:00:00|2019-09-04 11:27:29|0|1999-01-01 00:00:00|2019-09-04 11:27:32|+-+-+-+-+-+1 row in set(3.00 sec)?New Future on Cloud?New Future on Cl

5、oud?New Future on Cloud03?WAIT#1:nam=direct path read ela=43 p1=1 p2=1 p3=1WAIT#1:nam=direct path read ela=4 p1=2 p2=1 p3=1WAIT#1:nam=direct path read ela=3 p1=3 p2=1 p3=1WAIT#1:nam=direct path read ela=2 p1=4 p2=1 p3=1WAIT#1:nam=direct path read ela=2 p1=201 p2=1 p3=1WAIT#1:nam=db file sequential r

6、ead ela=88 p1=1 p2=417 p3=1WAIT#1:nam=db file sequential read ela=91 p1=1 p2=377 p3=1=PARSING IN CURSOR#2 len=188 dep=1 uid=0 oct=1 lid=0 tim=30977 hv=0 ad=b700de24create table bootstrap$(line#number not null,obj#number not null,sql_textvarchar2(4000)not null)storage(initial 50K objno 56

7、extents(file 1 block 377)END OF STMTPARSE#2:c=0,e=1173,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=30943BINDS#2:EXEC#2:c=0,e=473,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=31638?alter session set events immediate trace name FILE_HDRS level 10 Tablespace#0-SYSTEMrel_fn:1 Creationatscn:0

8、x0000.00000007 04/24/2006 11:34:39Backup taken at scn:0 x0004.6c2d657e 02/12/2007 15:54:52 thread:1reset logs count:0 x24dc1f7d scn:0 x0004.6c432ec0 recovered at 04/07/2007 21:04:11status:0 x4 root dba:0 x004001a1 chkpt cnt:6933 ctl cnt:6932SQL select getbfno(0 x004001a1)from dual;GETBFNO(0X004001A1

9、)-datafile#is:1datablock is:41711g:root dba:0 x0040020812c:root dba:0 x00400208?SQL select segment_name,segment_type,header_file,header_block2from dba_segments where segment_type=CACHE;SEGMENT_NAMESEGMENT_TYPEHEADER_FILE HEADER_BLOCK-1.417CACHE1417Start dump data blocks tsn:0 file#:1 minblk 417 maxb

10、lk 419buffer tsn:0 rdba:0 x004001a1(1/417)Compatibility entry for BOOTSTRP:Dump of memory from 0 x0AA84E4C to 0 x0AA84E50AA84E4000400179 y.SQL select getbfno(00400179)from dual;GETBFNO(00400179)-datafile#is:1datablock is:377SQL select segment_name from dba_extents2 where block_id between 377 and blo

11、cks+377-1;SEGMENT_NAME-BOOTSTRAP$?SQL exec print_table(select*from bootstrap$where rownum 5);LINE#:-1OBJ#:-1SQL_TEXT:8.0.0.0.0-LINE#:0OBJ#:0SQL_TEXT:CREATE ROLLBACK SEGMENT SYSTEM STORAGE(INITIAL 112K NEXT 56K MINEXTENTS 1 MAXEXTENTS 32765 OBJNO 0 EXTENTS(FILE 1 BLOCK 128)-LINE#:20OBJ#:20SQL_TEXT:CR

12、EATE TABLE ICOL$(OBJ#NUMBER NOT NULL,BO#NUMBER NOT NULL,COL#NUMBER NOT NULL,POS#NUMBER NOT NULL,SEGCOL#NUMBER NOTNULL,SEGCOLLENGTH NUMBER NOT NULL,OFFSET NUMBER NOT NULL,INTCOL#NUMBER NOT NULL,SPARE1 NUMBER,SPARE2 NUMBER,SPARE3 NUMBER,SPARE4 VARCHAR2(1000),SPARE5VARCHAR2(1000),SPARE6 DATE)STORAGE(OB

13、JNO 20 TABNO 4)CLUSTER C_OBJ#(BO#)-?WAIT#1:nam=direct path read ela=43 p1=1 p2=1 p3=1WAIT#1:nam=direct path read ela=4 p1=2 p2=1 p3=1WAIT#1:nam=direct path read ela=3 p1=3 p2=1 p3=1WAIT#1:nam=direct path read ela=2 p1=4 p2=1 p3=1WAIT#1:nam=direct path read ela=2 p1=201 p2=1 p3=1WAIT#1:nam=db file se

14、quential read ela=88 p1=1 p2=417 p3=1WAIT#1:nam=db file sequential read ela=91 p1=1 p2=377 p3=1=PARSING IN CURSOR#2 len=188 dep=1 uid=0 oct=1 lid=0 tim=30977 hv=0 ad=b700de24create table bootstrap$(line#number not null,obj#number not null,sql_textvarchar2(4000)not null)storage(initial 50K

15、 objno 56 extents(file 1 block 377)END OF STMTPARSE#2:c=0,e=1173,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=30943BINDS#2:EXEC#2:c=0,e=473,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=31638?WAIT#1:nam=direct path read ela=43 p1=1 p2=1 p3=1WAIT#1:nam=direct path read ela=4 p1=2 p2=1 p3=1WA

16、IT#1:nam=direct path read ela=3 p1=3 p2=1 p3=1WAIT#1:nam=direct path read ela=2 p1=4 p2=1 p3=1WAIT#1:nam=direct path read ela=2 p1=201 p2=1 p3=1WAIT#1:nam=db file sequential read ela=88 p1=1 p2=417 p3=1WAIT#1:nam=db file sequential read ela=91 p1=1 p2=377 p3=1=PARSING IN CURSOR#2 len=188 dep=1 uid=0

17、 oct=1 lid=0 tim=30977 hv=0 ad=b700de24create table bootstrap$(line#number not null,obj#number not null,sql_textvarchar2(4000)not null)storage(initial 50K objno 56 extents(file 1 block 377)END OF STMTPARSE#2:c=0,e=1173,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=30943BINDS#2:EXEC#2:c=0,e=473,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=31638?运用之妙，存乎一心。?举重若轻、运用自如。?New Future on Cloud?