报告预览

传统数据库DBA到开源的技能和心理切换——开源数据库专场（32页）.pdf

编号：84373

PDF 32页 138.41MB 下载积分：VIP专享

下载报告请您先登录！

传统数据库DBA到开源的技能和心理切换——开源数据库专场（32页）.pdf

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?

友情提示

1、下载报告失败解决办法
2、PDF文件下载后，可能会被浏览器默认打开，此种情况可以点击浏览器菜单，保存网页到桌面，就可以正常下载了。
3、本站不支持迅雷下载，请使用电脑自带的IE浏览器，或者360浏览器、谷歌浏览器下载即可。
4、本站报告下载后的文档和图纸-无水印,预览文档经过压缩，下载后原文更清晰。

本文（传统数据库DBA到开源的技能和心理切换——开源数据库专场（32页）.pdf）为本站（云闲）主动上传，三个皮匠报告文库仅提供信息存储空间，仅对用户上传内容的表现方式做保护处理，对上载内容本身不做任何修改或编辑。若此文所含内容侵犯了您的版权或隐私，请立即通知三个皮匠报告文库（点击联系客服），我们立即给予删除！

温馨提示：如果因为网速或其他原因下载失败请重新下载，重复下载不扣分。

上海品茶

传统数据库DBA到开源的技能和心理切换——开源数据库专场（32页）.pdf

传统数据库DBA到开源的技能和心理切换——开源数据库专场（32页）.pdf