当前位置:网站首页>Active Data Guard 备用数据库可以运行查询操作或只读应用程序吗?
Active Data Guard 备用数据库可以运行查询操作或只读应用程序吗?
2022-07-20 12:54:00 【刘贵宾】
Active Data Guard 备用数据库可以运行查询操作或只读应用程序吗?
采纳答案1:
可以的,官方文档有说明
下面的功能是允许在read-only的数据库上执行的:
• Issue SELECT statements, including queries that require multiple sorts that leverage TEMP segments
• Use ALTER SESSION and ALTER SYSTEM statements
• Use SET ROLE
• Call stored procedures
• Use database links (dblinks) to write to remote databases
• Use stored procedures to call remote procedures via dblinks
• Use SET TRANSACTION READ ONLY for transaction level read consistency
• Issue complex queries (such as grouping SET queries and WITH CLAUSE queries)
下面的功能是不允许在read-only的数据库上执行的:
• Any DMLs (excluding simple SELECT statements) or DDLs
• Query accessing local sequences
• DMLs to local temporary tables
其他答案1:
可以的,官方文档有说明
下面的功能是允许在read-only的数据库上执行的:
• Issue SELECT statements, including queries that require multiple sorts that leverage TEMP segments
• Use ALTER SESSION and ALTER SYSTEM statements
• Use SET ROLE
• Call stored procedures
• Use database links (dblinks) to write to remote databases
• Use stored procedures to call remote procedures via dblinks
• Use SET TRANSACTION READ ONLY for transaction level read consistency
• Issue complex queries (such as grouping SET queries and WITH CLAUSE queries)
下面的功能是不允许在read-only的数据库上执行的:
• Any DMLs (excluding simple SELECT statements) or DDLs
• Query accessing local sequences
• DMLs to local temporary tables
边栏推荐
- Chapter3 : Fighting COVID-19 with Artificial Intelligence
- SAP Spartacus - Progressive Web Applications,渐进式 Web 应用程序
- Lazy to the bone, I am too lazy to write articles in CSDN. I write articles based on selenium simulation
- VH6501学习系列文章
- Four redis cluster schemes you must know and their advantages and disadvantages
- Codevs - 2750 is concerned about the southern disaster area
- 内核结构与设计
- Laravel realizes bidirectional synchronization of database and migrated files
- The committee member information page of the registration conclusion at the roadshow
- Interview question: Queen eight question (Queen n question) [suggestions collection]
猜你喜欢
[machine learning] model selection (cross validation) principle and Practice
CAPL脚本中关于相对路径/绝对路径操作的几个傻傻分不清的内置函数
ProSci 14-3-3(磷酸 Ser58)抗体说明书
Characteristics and performance parameters of the sensor
UML sequence diagram / sequence diagram / sequence diagram
内存对齐的前因后果
海思多媒体芯片选型
Worthington羧基转移丨碳酸酐酶的应用和文献参考
【c ++ primer 笔记】第8章 IO库
Five coquettish projects were born!
随机推荐
sql 盲注
Locate the kernel code through vmlinuz
SAP Spartacus 服务器端渲染的三种可能情形
除了定时器,真的没法在Simulation Node 类型的CAPL节点中实现延时了吗?
CANoe下載地址以及CAN Demo 16的下載與激活,並附錄所有CANoe軟件版本
CAPL脚本中关于相对路径/绝对路径操作的几个傻傻分不清的内置函数
The method of using postman to test the interface and send the request with cookie
从0到1 拿下C语言—程序结构及使用示例
物联网常用的无线通信技术
selenium从本地上传文件到网页
Examples illustrate the division basis of code segment (.Text), data segment (.Data), BSS segment, read-only data segment (.Rodata) and stack
给1万帧视频做目标分割,显存占用还不到1.4GB,代码已开源 | ECCV 2022
gcc入门手册
阿里面试Redis常考问题,你略知多少?
Visual Studio Code 安装包下载慢&&安装&&环境配置&&新建一条龙详解
北京市场监管人员现场检查必胜客,抽检食用油产品等
stap命令行小技巧(笔记,持续更新)
3.rsync备份案例
C语言数组详解
在CANoe中通过Panel面板控制Test Module 运行(高级)