GaussDB 1.0.1升级到1.0.2及1.0.2相关新功能说明
发表于：2025-11-14 作者：千家信息网编辑
千家信息网最后更新 2025年11月14日，原文链接： https://www.modb.pro/db/22102?xyFILETYPE Output file type: (TXT), BINLOG
千家信息网最后更新 2025年11月14日GaussDB 1.0.1升级到1.0.2及1.0.2相关新功能说明
原文链接： https://www.modb.pro/db/22102?xy
FILETYPE Output file type: (TXT), BINLOG Log file of screen outputCOMPRESS Compress output file (0), only for FILETYPE=BIN, values is 0~9, litter for faster compress speed, 0 is not compressed.CONTENT Specifies data to unload where the valid keyword, values are: (ALL), DATA_ONLY, and METADATA_ONLY. QUERY Predicate clause used to export a subset of a table, eg. "where rownum <= 10" SKIP_COMMENTS Do not add comments to dump file. (N)FORCE Continue even if an SQL error occurs during a table dump. (N)SKIP_ADD_DROP_TABLE Do not add a DROP TABLE statement before each CREATE TABLE statement. (N)SKIP_TRIGGERS Do not dump triggers. (N)QUOTE_NAMES Quote identifiers. (Y)TABLESPACE Default transport all tablespaces except for system reserved. (N)COMMIT_BATCH Batch commit rows, commit once if set 0. (1000)INSERT_BATCH Batch insert rows. (1)FEEDBACK Feedback row count, feedback once if set 0 (10000)PARALLEL Table data export parallelism settings, range 2~16, The default value is 0CONSISTENT Cross - table consistency(N)CREATE_USER Export user definition(N),Used in conjunction with USERS.ROLE Export user roles expect system preset roles (N),Used in conjunction with USERS.GRANT Grant role and pemission to USER (N),Used in conjunction with USERS and ROLE.WITH_CR_MODE Export tables and indexes with CR_MODE options (N)ENCRYPT Export files will be encrypted.REMAP_TABLES Table's name will remapped to another tablename.PARTITIONS Export tables's data within the input partition.
++++++ 新增加的函数：
1) current_local_ScnSQL> SELECT CURRENT_LOCAL_SCN() FROM SYS_DUMMY;CURRENT_LOCAL_SCN() --------------------6755116323168257 1 rows fetched.
2)DBA_FBDR_2PC(从undo表空间中查询已完成的两阶段事务信息)
SQL> select * FROM TABLE(DBA_FBDR_2PC(6755116323168257,1)) ; GLOBAL_TRAN_ID LOCAL_TRAN_ID TLOCK_LOBS TLOCK_LOBS_EXT FORMAT_ID BRANCH_ID OWNER PREPARE_SCN COMMIT_SCN ---------------------------------------------------------------- -------------------- ---------------------------------------------------------------- ---------------------------------------------------------------- -------------------- ---------------------------------------------------------------- -------------------- -------------------- --------------------0 rows fetched.
3）DBA_PAGE_CORRUPTION
这个函数功能非常强大和实用。
SQL> select * from table(dba_page_corruption('DATABASE'));FILE_ID FILE_NAME INFO_TYPE EXAMINED_NUM SUCCEED_NUM CORRUPT_NUM PAGE_ID PAGE_TYPE MARKED_CHECKSUM CALC_CHECKSUM------------ ---------------------------------------- ------------- ------------ ------------ ------------ ------------ ------------------ --------------- -------------0 /opt/gauss/gaussdata/system FILE SUMMARY 2778 2778 0 3 /opt/gauss/gaussdata/undo FILE SUMMARY 66490 66490 0 4 /opt/gauss/gaussdata/user1 FILE SUMMARY 25546 25546 0 5 /opt/gauss/gaussdata/user2 FILE SUMMARY 1 1 0 6 /opt/gauss/gaussdata/user3 FILE SUMMARY 1 1 0 7 /opt/gauss/gaussdata/user4 FILE SUMMARY 1 1 0 8 /opt/gauss/gaussdata/user5 FILE SUMMARY 1 1 0 9 /opt/gauss/gaussdata/temp2_01 FILE SUMMARY 2 2 0 10 /opt/gauss/gaussdata/temp2_02 FILE SUMMARY 1 1 0 11 /opt/gauss/gaussdata/temp2_undo FILE SUMMARY 2 2 0 12 /opt/gauss/gaussdata/sysaux FILE SUMMARY 13798 13798 0 11 rows fetched.SQL> select * from table(dba_page_corruption('TABLESPACE',3));FILE_ID FILE_NAME INFO_TYPE EXAMINED_NUM SUCCEED_NUM CORRUPT_NUM PAGE_ID PAGE_TYPE MARKED_CHECKSUM CALC_CHECKSUM------------ ---------------------------------------- ------------- ------------ ------------ ------------ ------------ ------------------ --------------- -------------4 /opt/gauss/gaussdata/user1 FILE SUMMARY 25546 25546 0 5 /opt/gauss/gaussdata/user2 FILE SUMMARY 1 1 0 6 /opt/gauss/gaussdata/user3 FILE SUMMARY 1 1 0 7 /opt/gauss/gaussdata/user4 FILE SUMMARY 1 1 0 8 /opt/gauss/gaussdata/user5 FILE SUMMARY 1 1 0 5 rows fetched.SQL> select * from table(dba_page_corruption('DATAFILE',3));FILE_ID FILE_NAME INFO_TYPE EXAMINED_NUM SUCCEED_NUM CORRUPT_NUM PAGE_ID PAGE_TYPE MARKED_CHECKSUM CALC_CHECKSUM------------ ---------------------------------------- ------------- ------------ ------------ ------------ ------------ ------------------ --------------- -------------3 /opt/gauss/gaussdata/undo FILE SUMMARY 66490 66490 0 1 rows fetched.SQL> select * from table(dba_page_corruption('PAGE',4,10));FILE_ID FILE_NAME INFO_TYPE EXAMINED_NUM SUCCEED_NUM CORRUPT_NUM PAGE_ID PAGE_TYPE MARKED_CHECKSUM CALC_CHECKSUM------------ ---------------------------------------- ------------- ------------ ------------ ------------ ------------ ------------------ --------------- -------------4 /opt/gauss/gaussdata/user1 PAGE 1 1 0 10 btree_segment 36019 36019 1 rows fetched.- LSCN2GSCN(将本地SCN转换为GTS SCN)
SQL> select current_local_Scn() from sys_dummy;CURRENT_LOCAL_SCN() --------------------6758768140668929 1 rows fetched.SQL> select LSCN2GSCN(6758768140668929) from sys_dummy;LSCN2GSCN(6758768140668929)---------------------------158298313993801729 1 rows fetched.
PENDING_TRANS_SESSION(查询正在执行的两阶段事务信息)
rank(聚合、分析函数)
SQL> select RANK(2) WITHIN GROUP (ORDER BY a) as "rank" FROM roger.test;rank ------------2 1 rows fetched.
7）TO_BIGINT(将数据转换成BIGINT类型)
SQL> select to_bigint(12341) from sys_dummy;TO_BIGINT(12341) --------------------12341 1 rows fetched.
8)TO_INT(将数据转换成INT类型)
SQL> select to_int(99999) from sys_dummy;TO_INT(99999)-------------99999 1 rows fetched.
9)TRY_GET_SHARED_LOCK(为一个会话尝试获取一把锁名为name_expr的共享咨询锁)
++++SQL 操作 （支持交集查询)
SQL> conn roger/Roger007@127.0.0.1:1611connected.SQL> create table test_2 as select * from test limit 5;Succeed.SQL> select a from test intersect select a from test_2;A ----------------------------------------26.531219482421875 605.14545440673828125 645.55263519287109375 710.174560546875 757.1773529052734375
函数
查询
事务
信息
数据
类型
阶段
实用
强大
交集
功能
原文
正在
空间
链接
分析
咨询
尝试
支持
新功能
数据库的安全要保护哪些东西
数据库安全各自的含义是什么
生产安全数据库录入
数据库的安全性及管理
数据库安全策略包含哪些
海淀数据库安全审计系统
建立农村房屋安全信息数据库
易用的数据库客户端支持安全管理
连接数据库失败ssl安全错误
数据库的锁怎样保障安全
apex当前服务器注册人数
北京讯数据库
网络安全基础学
成人用品无人售货机软件开发
腾讯云服务器客服
软件开发签署协议
杭州数字化智慧工厂软件开发
锐捷服务器认证失败
首都网络安全期
信息与数据库关系数据库
管家婆主机换服务器后怎么登陆
软件开发与应用公司
四十大盗网络技术有限公司
服务器网卡千兆变百兆
GUI向数据库添加数据
国外数据库加密厂商
多人生存服务器开放
外卖软件开发工具
打开别人的表格看不了数据库
北京大学网络技术研究
黄浦区智能化软件开发质量
数据库导入微信
软件开发什么才算大型项目
5g对网络安全来说是把双刃剑
oracle数据库锁机制
数据库 scan ip
计算机网络技术的学生自我评价
服务器主板不识别usb键盘鼠标
进入网络安全模式连不上网
梅州天气预报软件开发
