搜索博文结果_ChinaUnix博客

博客首页博客专家往日推荐博客文集

热搜： iOS Windows JavaScript .net 数据库 ubuntu 移动开发 CCNA

博客首页〉搜索结果

按类别查询搜索结果

操作系统程序设计数据库热点技术综合架构与运维移动开发与应用 Web前端

关于关键词的检测结果，共 2145 条

【Oracle】 Oracle启动过程开启10046事件跟踪启动过程

东北胖子 | 2018-11-12 23:29:24 | 阅读(3220) | 评论(0)

1、启动至nomount状态SYS@orcl> startup nomount;2、查找trace文件目录SYS@orcl> select TRACEFILE from v$process where addr in(select paddr from v$session where sid in(select sid from v$mystat where rownum=1));TRACEFILE ...【阅读全文】

【Oracle】 ruei 网络的配置

brjl | 2018-10-18 17:41:29 | 阅读(2330) | 评论(0)

默认安装完毕后，collector会捕获网卡流量用于分析，通常需要配置一下。用firefox登录ruei后点击 Configuration->Collector profiles->System network data Collectors，然后右键点击System (localhost) -> Assign network interface选择要收集的网卡选择完后，会自动分析其流量了，当然还容易遇到内存不足的问题...【阅读全文】

【Oracle】使用alter system register;”解决动态监听注册缓慢问题

weijun1235 | 2018-09-25 08:24:48 | 阅读(1880) | 评论(0)

SQL*Plus: Release 11.2.0.1.0 Production on Tue Jan 18 20:47:22 2011Connected to an idle instance.LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 18-JAN-2011 20:48:58Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))STATUS of the LISTENER------------------------Al...【阅读全文】

【Oracle】 Oracle中的变量使用-动态变量主要用法

weijun1235 | 2018-09-20 23:03:23 | 阅读(3620) | 评论(0)

Oracle中的变量使用：&、&&、DEIFINE、VARIABLE概念：在oracle 中，对于一个提交的sql语句,存在两种可选的解析过程, 一种叫做硬解析,一种叫做软解析.一个硬解析需要经解析,制定执行路径,优化访问计划等许多的步骤.硬解释不仅仅耗费大量的cpu，更重要的是会占据重要的们闩（latch）资源，严重的影响系统的规模的扩大（...【阅读全文】

【Oracle】 Oracle 11g rac添加删除集群数据库

dbwatcher | 2018-09-13 17:46:43 | 阅读(4300) | 评论(0)

博客文章除注明转载外，均为原创。转载请注明出处。本文链接地址：http://blog.chinaunix.net/uid-31396856-id-5790357.html好记性不如烂笔头，记录添加集群数据库和删除集群数据库的关键步骤：主要是通过srvctl命令来管理集群的配置等，建议详细看下srvctl命令的使用。1、集群中删除数据库删除数据库实例srvctl sto...【阅读全文】

【Oracle】 2018年ocp最新题库：052新加的考试题整理-36

unix_5359 | 2018-08-08 11:48:19 | 阅读(1830) | 评论(0)

36、Which two are true about roles?A) A role can be granted a combination of system and object privileges and other roles.B) The CONNECT role Is granted automatically to a user when It Is created.C) Roles are owned by SYSTEM.D) The RESOURCE role Is granted the CREATE SESSION priv...【阅读全文】

【Oracle】 Oracle9i(9.2.0.4）FOR_linux_32位网盘下载地址

woshiginus | 2018-08-05 00:59:24 | 阅读(2410) | 评论(0)

从官网下载的，通过会员迅雷。。。。国内IP基本被屏蔽了。。。需要64位的官网下试试。https://pan.baidu.com/s/1v3rVMnPSvp7r8idz4rUFtw密码：8hnx原文链接：http://download.oracle.com/otn/linux/oracle9i/9204/ship_9204_linux_disk1.cpio.gzhttp://download.oracle.com/otn/linux/oracle9i/9204/ship_920...【阅读全文】

【Oracle】 2018OCP最新题库052新加考题及答案整理-27

unix_5359 | 2018-07-30 15:06:05 | 阅读(1640) | 评论(0)

27、Examine these facts about a database:1. USERS is the database default tablespace.2. USER1, USER2, AND USER3 have the CREATE SESSION privilege.3. They also have UNLIMITED QUOTA on the default tablespace USERS.4. They have no other privileges.Examine these commands:SQL> c...【阅读全文】

【Oracle】 OCP新题库，052新加的考试题及答案整理-24题

unix_5359 | 2018-07-27 15:00:21 | 阅读(1240) | 评论(0)

24、 YOUR DB_RECOVERY_FILE_DEST_SIZE Is 8G.Currently, 5G of the space Is used of which 4G consists of obsolete backups.You execute this command:SQL> ALTER SYSTEM SET db_recovery_file_dest_size=2G;What is the outcome?A) It changes DB_RECOVERY_FILE_DEST_SIZE to 5G.B) It chan...【阅读全文】

【Oracle】 OCP认证052考试，新加的考题还有答案整理-23题

unix_5359 | 2018-07-26 11:07:52 | 阅读(1020) | 评论(0)

23、Which two are true about data dictionary and dynamic performance views (v$ views)?A) All database users have access to ALL_* views.B) Data dictionary view output is subject to read consistency.C) The defining queries for Oracle supplied dynamic performance views are stored In the...【阅读全文】

【Oracle】 OCP题库更新，052新加的考试题及答案整理-22题

unix_5359 | 2018-07-26 10:46:09 | 阅读(880) | 评论(0)

22、You are planning a software installation for both Oracle Database 11g Release 1 and Release 2.You plan to have at lease one database for each release managed by Grid Infrastructure for a Standalone Server.Which three are true in this scenario?A) Oracle 11g Release 1 databases mus...【阅读全文】

【Oracle】 Centos配置oracle开机自启动

hxl | 2018-07-26 09:46:12 | 阅读(0) | 评论(0)

1.修改/etc/oratab[root@lenovo ~]# more /etc/oratab# # This file is used by ORACLE utilities. It is created by root.sh# and updated by either Database Configura...【阅读全文】

【Oracle】 OCP认证考试052新加的考题及答案收集整理-21题

unix_5359 | 2018-07-25 11:36:05 | 阅读(960) | 评论(0)

21、Which two are true about roles?A) A role can be password-protected.B) A role can be granted to another role.C) Only one default role can be granted to a user.D) A role can be granted only multiple system privileges not multiple object privileges.E) A role can be created on...【阅读全文】

【Oracle】 OCP 052新加的考试题收集整理-第20题

unix_5359 | 2018-07-25 11:22:13 | 阅读(770) | 评论(0)

20、 Which is true about the SYSTEM and SYSAUX tablespaces?A) The SYSAUX tablespace can be made read-only but the SYSTEM tablespace cannot.B) Both tablespaces can be used for temporary storage if no temporary tablespace is defined.C) Only the SYSTEM tablespace contains data dictionar...【阅读全文】

【Oracle】 OCP考试新题整理-052新加的考题及答案-18

unix_5359 | 2018-07-24 11:43:05 | 阅读(800) | 评论(0)

18、You want to Install Oracle 11g database software and create a database on ASM Immediately after the Install.Your plan is to install both Oracle database and Grid Infrastructure.Which two are true in this scenario?A) Grid Infrastructure must be installed first.B) Both products ...【阅读全文】

【Oracle】 OCP换考题了，052新加的题库及答案整理-第17题

unix_5359 | 2018-07-23 12:05:03 | 阅读(810) | 评论(0)

17、Which two statements are true about tablespaces?A) A database can contain multiple undo tablespaces.B) A database can contain only a single temporary tablespace.C) A database instance stores undo data In the SYSTEM tablespace If no undo tablespace exists.D) A database instance...【阅读全文】

【Oracle】 OCP考试换题库了，052新加的考题及答案整理-第16题

unix_5359 | 2018-07-23 11:57:00 | 阅读(980) | 评论(0)

16、Your database Is configured In archivelog mode.The USERS01 tablespace Is currently online.You are required to take the tablespace offline.Which clause or clauses ensure that no media recovery is requiredwhen the tablespace Is brought back online?A) either the NORMAL or the ...【阅读全文】

【Oracle】【OCP-052】新版题库更新，052又加新题了-第14题

unix_5359 | 2018-07-17 11:58:57 | 阅读(810) | 评论(0)

14、Which command is used to display files that no longer conform to the backup retention policy?A) REPORT OBSOLETEB) SHOW DATAFILE BACKUP COPIESC) CROSSCHECK BACKUPD) LIST EXPIRED BACKUPAnswer:A【阅读全文】

【Oracle】【OCP|052】OCP换题库，052新加考题整理-第10题

unix_5359 | 2018-07-12 10:13:47 | 阅读(870) | 评论(0)

10、Which two are true about consistent database backups?A) They can only be taken when a RECOVERY CATALOG is used.B) They can only be taken if the database Is in ARCHIVELOG mode.C) They can only be taken If shutdown NORMAL, TRANSACTIONAL, or IMMEDIATE shutdown has been performed and ...【阅读全文】

【Oracle】【OCP-052】OCP更换题库，052新加考题解析-第6题

unix_5359 | 2018-07-10 14:17:56 | 阅读(600) | 评论(0)

6、You are installing Oracle Grid Infrastructure by using the Oracle Universal Installer (OUI).You select the "Install and Configure Grid Infrastructure for a Standalone Server" option.Which task is performed by OUI as part of this installation?A) creation and configuration of Enterp...【阅读全文】

首页
<<
1
2
3
4
5
6
7
8
9
10
>>
末页

网络110 报警服务