AI 助理
备案控制台
开发者社区 数据库 文章 正文

[20170302]什么是fuzzy.txt

2017-03-02 1047
版权
版权声明：
本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《 阿里云开发者社区用户服务协议》和 《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写 侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
简介： [20170302]什么是fuzzy.txt --如果你数据库正常打开的情况下,查询v$datafile_header视图: SYS@book> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_...

[20170302]什么是fuzzy.txt

--如果你数据库正常打开的情况下,查询v$datafile_header视图:

SYS@book> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE#  , RESETLOGS_CHANGE#,status, CHECKPOINT_COUNT,fuzzy,name,tablespace_name  FROM v$datafile_header;
FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME     CREATION_CHANGE# RESETLOGS_CHANGE# STATUS  CHECKPOINT_COUNT FUZ NAME                             TABLESPACE_NAME
----- ------------------ ------------------- ---------------- ----------------- ------- ---------------- --- -------------------------------- ------------------------------
    1        13276944334 2017-03-02 09:35:34                7       13276911100 ONLINE               862 YES /mnt/ramdisk/book/system01.dbf   SYSTEM
    2        13276944334 2017-03-02 09:35:34             1834       13276911100 ONLINE               851 YES /mnt/ramdisk/book/sysaux01.dbf   SYSAUX
    3        13276944334 2017-03-02 09:35:34           923328       13276911100 ONLINE               772 YES /mnt/ramdisk/book/undotbs01.dbf  UNDOTBS1
    4        13276944334 2017-03-02 09:35:34            16143       13276911100 ONLINE               857 YES /mnt/ramdisk/book/users01.dbf    USERS
    5        13276944334 2017-03-02 09:35:34           952916       13276911100 ONLINE               768 YES /mnt/ramdisk/book/example01.dbf  EXAMPLE
    6        13276944357 2017-03-02 09:35:48      13276257767       13276911100 ONLINE               242 YES /mnt/ramdisk/book/tea01.dbf      TEA
6 rows selected.
--//数据库正常运行一般都是Yes.视乎表示某种状态.
--这里的fuzzy表示什么?查询如下文章

Fuzzy File Warning When Recovering From Cold Backup [ID 103100.1]：

You are doing a restore from a cold backup using a backup controlfile.  On every file you receive the following message:
 
WARNING! Recovering data file <fno> from a fuzzy file. If not the current file it might be an online backup taken
without entering the begin backup command.
 
This message does not make sense as this is a cold backup.
 
This message is issued when you are performing recovery after restoring from a fuzzy backup due to the online fuzzy bit
is set in the file headers.Although this can be set when you do an online backup without issuing begin/end backup, it
can also be set when the system crashes. This is the case here; a shutdown abort had been performed prior
to the cold backup.

http://docs.oracle.com/cd/E11882_01/server.112/e40402/dynviews_1102.htm#REFRN30052
UZZY     VARCHAR2(3)     File is fuzzy (YES | NO)
--//不好理解!!自己先探索一下:

1.环境:
SYS@book> @ &r/ver1
PORT_STRING                    VERSION        BANNER
------------------------------ -------------- --------------------------------------------------------------------------------
x86_64/Linux 2.4.xx            11.2.0.4.0     Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production


2.热备份模式:
SYS@book> ALTER TABLESPACE tea BEGIN BACKUP;
Tablespace altered.

SYS@book> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE#  , RESETLOGS_CHANGE#,status, CHECKPOINT_COUNT,fuzzy,name,tablespace_name  FROM v$datafile_header where file#=6;
FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME     CREATION_CHANGE# RESETLOGS_CHANGE# STATUS  CHECKPOINT_COUNT FUZ NAME                         TABLESPACE_NAME
----- ------------------ ------------------- ---------------- ----------------- ------- ---------------- --- ---------------------------- ---------------
    6        13276944908 2017-03-02 09:44:21      13276257767       13276911100 ONLINE               245 YES /mnt/ramdisk/book/tea01.dbf  TEA

--//依旧是fuzzy=yes.
--//视乎现在的版本与热备份无关.

SYS@book> ALTER TABLESPACE tea END BACKUP;
Tablespace altered.

3.设置表空间只读呢?
SYS@book> ALTER TABLESPACE tea read only;
Tablespace altered.

SYS@book> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE#  , RESETLOGS_CHANGE#,status, CHECKPOINT_COUNT,fuzzy,name,tablespace_name  FROM v$datafile_header where file#=6;
FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME     CREATION_CHANGE# RESETLOGS_CHANGE# STATUS  CHECKPOINT_COUNT FUZ NAME                        TABLESPACE_NAME
----- ------------------ ------------------- ---------------- ----------------- ------- ---------------- --- --------------------------- ---------------
    6        13276945185 2017-03-02 09:48:30      13276257767       13276911100 ONLINE               247 NO  /mnt/ramdisk/book/tea01.dbf TEA
--//fuzzy=NO

SYS@book> ALTER TABLESPACE tea read write;
Tablespace altered.

SYS@book> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE#  , RESETLOGS_CHANGE#,status, CHECKPOINT_COUNT,fuzzy,name,tablespace_name  FROM v$datafile_header where file#=6;
FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME     CREATION_CHANGE# RESETLOGS_CHANGE# STATUS  CHECKPOINT_COUNT FUZ NAME                        TABLESPACE_NAME
----- ------------------ ------------------- ---------------- ----------------- ------- ---------------- --- --------------------------- ---------------
    6        13276945259 2017-03-02 09:49:24      13276257767       13276911100 ONLINE               249 YES /mnt/ramdisk/book/tea01.dbf TEA

4.设置表空间offline:

SYS@book> ALTER TABLESPACE tea offline ;
Tablespace altered.

SYS@book> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE#  , RESETLOGS_CHANGE#,status, CHECKPOINT_COUNT,fuzzy,name,tablespace_name  FROM v$datafile_header where file#=6;
FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME     CREATION_CHANGE# RESETLOGS_CHANGE# STATUS  CHECKPOINT_COUNT FUZ NAME                         TABLESPACE_NAME
----- ------------------ ------------------- ---------------- ----------------- ------- ---------------- --- ---------------------------- ---------------
    6                  0                                    0                 0 OFFLINE                0
--//offline , fuzzy=null

SYS@book> ALTER TABLESPACE tea online ;
Tablespace altered.

SYS@book> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE#  , RESETLOGS_CHANGE#,status, CHECKPOINT_COUNT,fuzzy,name,tablespace_name  FROM v$datafile_header where file#=6;
FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME     CREATION_CHANGE# RESETLOGS_CHANGE# STATUS  CHECKPOINT_COUNT FUZ NAME                         TABLESPACE_NAME
----- ------------------ ------------------- ---------------- ----------------- ------- ---------------- --- ---------------------------- ---------------
    6        13276945505 2017-03-02 09:52:26      13276257767       13276911100 ONLINE               251 YES /mnt/ramdisk/book/tea01.dbf  TEA

5.设置数据文件6 offline:

SYS@book> alter database datafile 6 offline ;
Database altered.

SYS@book> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE#  , RESETLOGS_CHANGE#,status, CHECKPOINT_COUNT,fuzzy,name,tablespace_name  FROM v$datafile_header where file#=6;
FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME     CREATION_CHANGE# RESETLOGS_CHANGE# STATUS  CHECKPOINT_COUNT FUZ NAME                        TABLESPACE_NAME
----- ------------------ ------------------- ---------------- ----------------- ------- ---------------- --- --------------------------- ---------------
    6        13276945505 2017-03-02 09:52:26      13276257767       13276911100 OFFLINE              251 YES /mnt/ramdisk/book/tea01.dbf TEA
--//依旧是fuzzy=yes.
SYS@book> recover datafile 6;
Media recovery complete.

SYS@book> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE#  , RESETLOGS_CHANGE#,status, CHECKPOINT_COUNT,fuzzy,name,tablespace_name  FROM v$datafile_header where file#=6;
FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME     CREATION_CHANGE# RESETLOGS_CHANGE# STATUS  CHECKPOINT_COUNT FUZ NAME                         TABLESPACE_NAME
----- ------------------ ------------------- ---------------- ----------------- ------- ---------------- --- ---------------------------- ---------------
    6        13276945602 2017-03-02 09:53:44      13276257767       13276911100 OFFLINE              252 NO  /mnt/ramdisk/book/tea01.dbf  TEA
--//恢复数据文件后,fuzzy=NO.

SYS@book> alter database datafile 6 online ;
Database altered.

SYS@book> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE#  , RESETLOGS_CHANGE#,status, CHECKPOINT_COUNT,fuzzy,name,tablespace_name  FROM v$datafile_header where file#=6;
FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME     CREATION_CHANGE# RESETLOGS_CHANGE# STATUS  CHECKPOINT_COUNT FUZ NAME                         TABLESPACE_NAME
----- ------------------ ------------------- ---------------- ----------------- ------- ---------------- --- ---------------------------- ---------------
    6        13276945744 2017-03-02 09:55:57      13276257767       13276911100 ONLINE               253 YES /mnt/ramdisk/book/tea01.dbf  TEA
--//数据文件online后,fuzzy=YES.

6.shutdown abort关闭数据库后:
SYS@book> shutdown abort ;
ORACLE instance shut down.

SYS@book> startup mount
ORACLE instance started.
Total System Global Area    634732544 bytes
Fixed Size                    2255792 bytes
Variable Size               197133392 bytes
Database Buffers            427819008 bytes
Redo Buffers                  7524352 bytes
Database mounted.

SYS@book> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE#  , RESETLOGS_CHANGE#,status, CHECKPOINT_COUNT,fuzzy,name,tablespace_name  FROM v$datafile_header;
FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME     CREATION_CHANGE# RESETLOGS_CHANGE# STATUS  CHECKPOINT_COUNT FUZ NAME                             TABLESPACE_NAME
----- ------------------ ------------------- ---------------- ----------------- ------- ---------------- --- -------------------------------- ----------------
    1        13276944334 2017-03-02 09:35:34                7       13276911100 ONLINE               862 YES /mnt/ramdisk/book/system01.dbf   SYSTEM
    2        13276944334 2017-03-02 09:35:34             1834       13276911100 ONLINE               851 YES /mnt/ramdisk/book/sysaux01.dbf   SYSAUX
    3        13276944334 2017-03-02 09:35:34           923328       13276911100 ONLINE               772 YES /mnt/ramdisk/book/undotbs01.dbf  UNDOTBS1
    4        13276944334 2017-03-02 09:35:34            16143       13276911100 ONLINE               857 YES /mnt/ramdisk/book/users01.dbf    USERS
    5        13276944334 2017-03-02 09:35:34           952916       13276911100 ONLINE               768 YES /mnt/ramdisk/book/example01.dbf  EXAMPLE
    6        13276945744 2017-03-02 09:55:57      13276257767       13276911100 ONLINE               253 YES /mnt/ramdisk/book/tea01.dbf      TEA
6 rows selected.
--//异常关闭数据库,到mount状态fuzzy=YES.

SYS@book> recover database;
Media recovery complete.

SYS@book> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE#  , RESETLOGS_CHANGE#,status, CHECKPOINT_COUNT,fuzzy,name,tablespace_name  FROM v$datafile_header;
FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME     CREATION_CHANGE# RESETLOGS_CHANGE# STATUS  CHECKPOINT_COUNT FUZ NAME                             TABLESPACE_NAME
----- ------------------ ------------------- ---------------- ----------------- ------- ---------------- --- -------------------------------- ---------------
    1        13276965838 2017-03-02 09:57:27                7       13276911100 ONLINE               863 NO  /mnt/ramdisk/book/system01.dbf   SYSTEM
    2        13276965838 2017-03-02 09:57:27             1834       13276911100 ONLINE               852 NO  /mnt/ramdisk/book/sysaux01.dbf   SYSAUX
    3        13276965838 2017-03-02 09:57:27           923328       13276911100 ONLINE               773 NO  /mnt/ramdisk/book/undotbs01.dbf  UNDOTBS1
    4        13276965838 2017-03-02 09:57:27            16143       13276911100 ONLINE               858 NO  /mnt/ramdisk/book/users01.dbf    USERS
    5        13276965838 2017-03-02 09:57:27           952916       13276911100 ONLINE               769 NO  /mnt/ramdisk/book/example01.dbf  EXAMPLE
    6        13276965838 2017-03-02 09:57:27      13276257767       13276911100 ONLINE               254 NO  /mnt/ramdisk/book/tea01.dbf      TEA
6 rows selected.
--//recover后,FUZZY=NO.从这里也可以看出如果正常关闭数据库,在status=online情况下fuzzy=NO.

7.shutdown immediate关闭数据库后:

SYS@book> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SYS@book> startup mount;
ORACLE instance started.
Total System Global Area    634732544 bytes
Fixed Size                    2255792 bytes
Variable Size               197133392 bytes
Database Buffers            427819008 bytes
Redo Buffers                  7524352 bytes
Database mounted.
SYS@book> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE#  , RESETLOGS_CHANGE#,status, CHECKPOINT_COUNT,fuzzy,name,tablespace_name  FROM v$datafile_header;
FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME     CREATION_CHANGE# RESETLOGS_CHANGE# STATUS  CHECKPOINT_COUNT FUZ NAME                             TABLESPACE_NAME
----- ------------------ ------------------- ---------------- ----------------- ------- ---------------- --- -------------------------------- ---------------
    1        13276966464 2017-03-02 10:01:38                7       13276911100 ONLINE               867 NO  /mnt/ramdisk/book/system01.dbf   SYSTEM
    2        13276966464 2017-03-02 10:01:38             1834       13276911100 ONLINE               856 NO  /mnt/ramdisk/book/sysaux01.dbf   SYSAUX
    3        13276966464 2017-03-02 10:01:38           923328       13276911100 ONLINE               777 NO  /mnt/ramdisk/book/undotbs01.dbf  UNDOTBS1
    4        13276966464 2017-03-02 10:01:38            16143       13276911100 ONLINE               862 NO  /mnt/ramdisk/book/users01.dbf    USERS
    5        13276966464 2017-03-02 10:01:38           952916       13276911100 ONLINE               773 NO  /mnt/ramdisk/book/example01.dbf  EXAMPLE
    6        13276966464 2017-03-02 10:01:38      13276257767       13276911100 ONLINE               258 NO  /mnt/ramdisk/book/tea01.dbf      TEA
6 rows selected.
--//fuzzy=NO.

8.概括:
--//以上测试可以大概猜测fuzzy表示数据文件某种状态.
A.与是否热备无关
B.数据文件为read write ,status=online时，fuzzy=yes
C.数据文件为read only ，status=online时, fuzzy=no
D.数据文件为offline,
alter database datafile 6 offline;  则fuzzy为YES
alter tablespace USERS offline;     则fuzzy为NULL

--//可以这么理解FuzzY=NO表示一致的状态.这也就好理解昨天我恢复时:
--//链接http://blog.itpub.net/267265/viewspace-2134481/,最后为什么不能使用open resetlogs打开.因为我使用恢复时指定scn.
--//recover database using backup controlfile until change 13276911099;
--//oracle并不知道是否恢复结束.也就是有可能FUZZY还是YES.

9.继续测试:
SYS@book> shutdown abort ;
ORACLE instance shut down.

SYS@book> startup mount ;
ORACLE instance started.
Total System Global Area    634732544 bytes
Fixed Size                    2255792 bytes
Variable Size               197133392 bytes
Database Buffers            427819008 bytes
Redo Buffers                  7524352 bytes
Database mounted.

SYS@book> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE#  , RESETLOGS_CHANGE#,status, CHECKPOINT_COUNT,fuzzy,name,tablespace_name  FROM v$datafile_header;
FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME     CREATION_CHANGE# RESETLOGS_CHANGE# STATUS  CHECKPOINT_COUNT FUZ NAME                             TABLESPACE_NAME
----- ------------------ ------------------- ---------------- ----------------- ------- ---------------- --- -------------------------------- ---------------
    1        13276966467 2017-03-02 10:13:04                7       13276911100 ONLINE               868 YES /mnt/ramdisk/book/system01.dbf   SYSTEM
    2        13276966467 2017-03-02 10:13:04             1834       13276911100 ONLINE               857 YES /mnt/ramdisk/book/sysaux01.dbf   SYSAUX
    3        13276966467 2017-03-02 10:13:04           923328       13276911100 ONLINE               778 YES /mnt/ramdisk/book/undotbs01.dbf  UNDOTBS1
    4        13276966467 2017-03-02 10:13:04            16143       13276911100 ONLINE               863 YES /mnt/ramdisk/book/users01.dbf    USERS
    5        13276966467 2017-03-02 10:13:04           952916       13276911100 ONLINE               774 YES /mnt/ramdisk/book/example01.dbf  EXAMPLE
    6        13276966467 2017-03-02 10:13:04      13276257767       13276911100 ONLINE               259 YES /mnt/ramdisk/book/tea01.dbf      TEA
6 rows selected.
--//shut abort关闭数据库,fuzzy=YES.
SYS@book> @ &r/checkpoint
REDO:

                                                       检查点队列
  检查点队列                                           on disk rba                                        检查点队列
    脏块数量                                           时间戳              当前时间                       on disk rba scn    检查点心跳
       CPDRT low_rba              on_disk_rba          CPODT               SYSDATE              DIFF_DATE CPODS                   CPHBT  CURRENT_SCN     DIFF_SCN         INDX
------------ -------------------- -------------------- ------------------- ------------------- ---------- ---------------- ------------ ------------ ------------ ------------
          53 20.531.0             20.666.0             2017-03-02 10:13:10 2017-03-02 10:15:01     111.00 13276966781         937603690            0 -13276966781            0
--//理论on disk rba scn=13276966781.

SYS@book> recover database until change 13276966700;
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/mnt/ramdisk/book/system01.dbf'

SYS@book> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE#  , RESETLOGS_CHANGE#,status, CHECKPOINT_COUNT,fuzzy,name,tablespace_name  FROM v$datafile_header where file#=1;
FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME     CREATION_CHANGE# RESETLOGS_CHANGE# STATUS  CHECKPOINT_COUNT FUZ NAME                           TABLESPACE_NAME
----- ------------------ ------------------- ---------------- ----------------- ------- ---------------- --- ------------------------------ ---------------
    1        13276966700 2017-03-02 10:13:07                7       13276911100 ONLINE               868 YES /mnt/ramdisk/book/system01.dbf SYSTEM
--//fuzzy=YES.   

SYS@book> recover database until change 13276966780;
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/mnt/ramdisk/book/system01.dbf'

SYS@book> recover database until change 13276966781;
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/mnt/ramdisk/book/system01.dbf'

SYS@book> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE#  , RESETLOGS_CHANGE#,status, CHECKPOINT_COUNT,fuzzy,name,tablespace_name  FROM v$datafile_header where file#=1;
FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME     CREATION_CHANGE# RESETLOGS_CHANGE# STATUS  CHECKPOINT_COUNT FUZ NAME                           TABLESPACE_NAME
----- ------------------ ------------------- ---------------- ----------------- ------- ---------------- --- ------------------------------ ---------------
    1        13276966781 2017-03-02 10:13:11                7       13276911100 ONLINE               868 YES /mnt/ramdisk/book/system01.dbf SYSTEM
--//fuzzy=YES.实际上我现在已经到最后的scn.

--//选择until cancel呢?
SYS@book> recover database until cancel;
ORA-00279: change 13276966781 generated at 03/02/2017 10:13:11 needed for thread 1
ORA-00289: suggestion : /u01/app/oracle/archivelog/book/1_20_937478950.dbf
ORA-00280: change 13276966781 for thread 1 is in sequence #20
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/mnt/ramdisk/book/redo02.log
Log applied.
Media recovery complete.

SYS@book> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE#  , RESETLOGS_CHANGE#,status, CHECKPOINT_COUNT,fuzzy,name,tablespace_name  FROM v$datafile_header where file#=1;
FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME     CREATION_CHANGE# RESETLOGS_CHANGE# STATUS     CHECKPOINT_COUNT FUZ NAME                           TABLESPACE_NAME
----- ------------------ ------------------- ---------------- ----------------- ---------- ---------------- --- ------------------------------ ---------------
    1        13276966782 2017-03-02 10:13:11                7       13276911100 ONLINE                  869 NO  /mnt/ramdisk/book/system01.dbf SYSTEM

--//fuzzy=NO,这时scn=13276966782.也就是将只有恢复到结束,oracle才会认为数据文件一致的.

文章标签：
数据库
关系型数据库
Oracle
lfreeali
目录
相关文章
VipSoft
|
4月前
|
自然语言处理 Java 关系型数据库
ElasticSearch 实现分词全文检索 - id、ids、prefix、fuzzy、wildcard、range、regexp 查询
ElasticSearch 实现分词全文检索 - id、ids、prefix、fuzzy、wildcard、range、regexp 查询
VipSoft
125 0
lfreeali
|
SQL Oracle 关系型数据库
[20180510]20 Indexes.txt
[20180510]20 Indexes.txt https://jonathanlewis.wordpress.com/2018/05/08/20-indexes/ --//重复测试: If your system had to do a lot of ...
lfreeali
1056 0
玄学酱
|
移动开发 Windows
5.9. sort - sort lines of text files
玄学酱
1175 0
玄学酱
|
JavaScript Windows 移动开发
27.9. sort - sort lines of text files
玄学酱
1096 0
lfreeali
[20171110]toad 小技巧.txt
[20171110]toad 小技巧.txt --//前几天的事情,一大早要求查询记录操作异常,本来想使用logminer查询,我们redo文件太大,使用logminer分析很慢.
lfreeali
993 0
lfreeali
|
算法 索引 关系型数据库
[20170601]distinct的优化.txt
[20170601]distinct的优化.txt 1.环境: SCOTT@book> @ &r/ver1 PORT_STRING          VERSION    BANNER -------------------- ---------- ...
lfreeali
1095 0
lfreeali
|
数据库
[20170302]fuzzy保存在那里.txt
[20170302]fuzzy保存在那里.txt --参考链接:http://blog.itpub.net/267265/viewspace-2134551/ --提到fuzzy表示某种状态,正常关闭是NO.
lfreeali
1196 0
lfreeali
[20151103]versions伪列.txt
[20151103]versions伪列.txt --经常忘记做一个记录. SELECT versions_starttime, versions_endtime, versions_xid, versions_operation,        versio...
lfreeali
910 0
lfreeali
|
机器学习/深度学习 Java 数据库
[20150604]关于同义词的问题3.txt
[20150604]关于同义词的问题3.txt --前一阵子对服务器的同义词做了一些整理，参考链接： http://blog.itpub.net/267265/viewspace-1621290/ http://blog.itpub.net/267265/viewspace-1612866/ --但是我在检查sys.obj$时发现我好像并没有删除这些同义词。
lfreeali
728 0
lfreeali
|
SQL 数据库 Shell
[20150503]关于同义词问题2.txt
[20150503]关于同义词问题2.txt --节前在做数据库同义词整理时,写了一篇blog --[20150430]同义词使用问题.txt http://blog.
lfreeali
813 0

热门文章

最新文章

  • 1
    基于区块链的机器学习模型创建方案
  • 2
    性能的极致,Rust的加持,Zed-Dev编辑器快速搭建Python3.10开发环境
  • 3
    首届Global VR Hackathon完结 全球前三甲诞生
  • 4
    我的博客即将入驻“云栖社区”，诚邀技术同仁一同入驻。
  • 5
    iptables
  • 6
    DevExpress 10.2.4系列-ASPxListBox根据列值不同设置不同图标
  • 7
    jquery的load加载js页面到指定div中
  • 8
    分享平时工作中那些给力的shell命令（更新版）
  • 9
    如何在ubuntu下用SVN commit
  • 10
    hdu 1800 Flying to the Mars
  • 1
    HelloMeme：开源的面部表情与姿态迁移框架，将视频中的人物表情迁移到静态图像中生成动态视频
    102
  • 2
    VSI-Bench：李飞飞谢赛宁团队推出视觉空间智能基准测试集，旨在评估多模态大语言模型在空间认知和理解方面的能力
    32
  • 3
    CLEAR：新加坡国立大学推出线性注意力机制，使8K图像的生成速度提升6.3倍，显著减少了计算量和时间延迟
    32
  • 4
    Kheish：开源的多智能体开发框架，通过 YAML 配置工作流和多个 Agent 共同协作解决复杂任务
    41
  • 5
    Bamba-9B：基于 Mamba2 架构的仅解码语言模型，旨在提高大型语言模型在推理时的效率
    37
  • 6
    DisPose：清华北大等多所高校联合推出基于人物图像增强视频生成技术，实现对人物动画的准确控制和一致性
    40
  • 7
    InvSR：开源图像超分辨率生成模型，提升分辨率，修复老旧照片为超清图像
    35
  • 8
    Univer：开源全栈 AI 办公工具，支持 Word、Excel、PPT 等文档处理和多人实时协作
    28
  • 9
    《人工智能：驱散新材料数据噪声与填补缺失值的曙光》
    23
  • 10
    《人工智能：解锁新材料最佳掺杂元素及比例的密码》
    18

    • 相关电子书

    更多
  • 低代码开发师（初级）实战教程
  • 冬季实战营第三期：MySQL数据库进阶实战
  • 阿里巴巴DevOps 最佳实践手册
    • 下一篇
    DataWorks售前咨询