搜索博文结果_ChinaUnix博客

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

热搜： Windows 网络安全 cISCO 存储 C语言 PHP Mysql FTP

博客首页〉搜索结果

按类别查询搜索结果

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

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

【Oracle】 HINTS:使用LEADING、ORDERED、SWAP_JOIN_INPUTS控制表连接顺序

dingjun123 | 2020-07-13 16:59:22 | 阅读(2790) | 评论(0)

使用LEADING、ORDERED、SWAP_JOIN_INPUTS控制表连接顺序【阅读全文】

【Oracle】连接问题报错：ORA-28040: No matching authentication protocol

jackson198574 | 2020-05-22 17:21:00 | 阅读(6077) | 评论(0)

??ORA-28040: No matching authentication protocol报错，来自于升级数据库引发的问题。
【阅读全文】

【Oracle】 Oracle数据库安装（五）

zc12058 | 2020-02-04 10:58:56 | 阅读(10060) | 评论(0)

oracle安装【阅读全文】

【Oracle】索引字段不能过长

a943981045 | 2019-09-23 13:04:23 | 阅读(2380) | 评论(0)

oracle 索引【阅读全文】

【Oracle】查看表空间的大小及使用情况sql语句

Frank_China | 2019-09-19 16:35:43 | 阅读(9830) | 评论(0)

--1、查看表空间的名称及大小 SELECT t.tablespace_name, round(SUM(bytes / (1024 * 1024)), 0) ts_size FROM dba_tablespaces t, dba_data_files d WHERE t.tablespace_name = d.tablespace_name GROUP BY t.tablespace_name; --2、查看表空间物理文件的名称及大小 SELECT tablespace_name...【阅读全文】

【Oracle】查看日志文件组状态信息+切换日志文件组+手动切换日志文件组+清空日志文件组

Frank_China | 2019-09-19 16:09:58 | 阅读(1960) | 评论(0)

查看日志文件组状态信息 select group#,status from v$log; inactive:非活动状态 current:当前正在被使用 active：活动的非当前日志，该日志可能已经完成归档，也可能没有归档，活动的日志文件在crash恢复时会被用到 unused：日志从未被使用上图表名数据库正在使用日志文件组3...【阅读全文】

【Oracle】清理共享池游标

brjl | 2019-09-03 18:06:57 | 阅读(1380) | 评论(0)

清理共享池执行计划游标 oracle【阅读全文】

【Oracle】 PLSQL Developer连接12c配置

hxl | 2019-05-10 10:39:50 | 阅读(5560) | 评论(0)

安装好oracle 12c后，通过工具PLSQL Developer连接报如下错误:解决办法,添加红色部分:[oracle@localhost admin]$ more sqlnet.ora # sqlnet.ora Network Configuration File: /u01/app/oracle/product/12.2.0.1/db_1/network/admin/sqlnet.ora# Generated by Oracle configuration tools.NAMES.DIRECTORY_P...【阅读全文】

【Oracle】 OCP新题，2019题库出现大量新题，062-第22题

unix_5359 | 2019-04-29 13:30:57 | 阅读(1900) | 评论(0)

Your database is running in ARCHIVELOG mode.Which two statements are true in this scenario?B) The database must be in MOUNT state to take consistent RMAN backups.D) The database instance must be shut down to take a user-managed consistent backup.Answer：BD【阅读全文】

【Oracle】 OCP 12c题库出现大量新题，062新题-第21题

unix_5359 | 2019-04-29 10:14:11 | 阅读(1710) | 评论(0)

Which three statements are true about Oracle checkpoint processing?B) Frequent thread checkpoints can degrade database performance.D) It reduces the recovery time from instance failures.Answer：BCD【阅读全文】

【Oracle】 OCP 12c考试题，062题库出现大量新题-第20道

unix_5359 | 2019-04-29 09:27:26 | 阅读(1670) | 评论(0)

Your database is configured for ARCHIVELOG mode, and a daily full database backup is taken.In which three scenarios do you need media recovery?B) abnormal termination of the database instanceD) loss of a data file that belongs to the active undo tablespaceF) loss of all the copies ...【阅读全文】

【Oracle】 OCP考试062题库出现大量新题-19

unix_5359 | 2019-04-28 14:52:09 | 阅读(1650) | 评论(0)

Which three statements are true about Oracle Data Pump?B) IMPDP can be used to change target data file names, schemas, and tablespaces during import.D) EXPDP and IMPDP are the client components of Oracle Data Pump.Answer：BCD【阅读全文】

【Oracle】 OCP考试062题库出现大量新题-18

unix_5359 | 2019-04-28 13:56:34 | 阅读(1480) | 评论(0)

Examine this command executed on a client that is remote from the database server.Which two are required for this command to connect the SQLPLUS client to a database instance?B) An orcl TNS entry must be defined in the client-side tnsnames.ora file.D) The service name orcl must be defi...【阅读全文】

【Oracle】【062有新题】OCP 12c 062出现大量之前没有的新考题-16

unix_5359 | 2019-04-26 15:46:07 | 阅读(990) | 评论(0)

Which users are created and can be used for database and host management of your DBaaS database servers?B) root, oracle and cloud usersD) opc and oracle usersAnswer：B用户对云计算的交付能力已经不再满足于单纯的基础设施(IaaS)交付，他们希望数据中心中的更多传统 IT 服务能以云服务模式进...【阅读全文】

【Oracle】【062新题】OCP 12c 062出现大量新题-15

unix_5359 | 2019-04-26 14:52:25 | 阅读(970) | 评论(0)

In your Oracle 12c database, you plan to execute the command:The u02 file system has 1 GB of free space available.A) It raises an error because extent management is not specified.C) It creates a dictionary-managed tablespace with manual segment space management enabled.Answer：B...【阅读全文】

【Oracle】【有新题】OCP 12c 062出现大量新考题-14

unix_5359 | 2019-04-26 14:17:02 | 阅读(970) | 评论(0)

choose twoYou plan to upgrade your Oracle Database 9i to Oracle Database 12c.Which two methods can you use?A) Perform a direct upgrade by manually running the catctl.pl and catupgrd.sql scripts before issuing the STARTUPUPGRADE command.B) Upgrade your current database to Oracle Database release ...【阅读全文】

【Oracle】 OCP 062大量考试新题（2019年）-12

unix_5359 | 2019-04-26 13:07:28 | 阅读(860) | 评论(0)

12. Your database is configured in archivelog mode.Examine the RMAN configuration parameters:CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # defaultCONFIGURE BACKUP OPTIMIZATION OFF; # defaultCONFIGURE CONTROLFILE AUTOBACKUP OFF; # defaultCONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO CO...【阅读全文】

【Oracle】【2019年OCP新题】OCP题库更新出现大量新题-11

unix_5359 | 2019-04-25 14:44:05 | 阅读(1090) | 评论(0)

You want to disable archiving for the database. Examine these steps:2. Execute shutdown immediate.4. Set the db_recovery_file_dest parameter to $ORACLE_HOME/dbs/.6. Open the database.Identify the required steps in the correct sequence.B) 1, 2, 3, 4, 6D) 2, 3, 1, 6...【阅读全文】

【Oracle】【2019年OCP新题】OCP题库更新出现大量新题-10

unix_5359 | 2019-04-25 13:04:23 | 阅读(1060) | 评论(0)

10.Which two statements are true about SQL*Loader Express Mode in an Oracle 12c database?A) It can load data in parallel.B) No data file needs to be specified.C) It loads data faster than conventional SQL*Loader.D) lt loads data more efficiently than conventional SQL*Loader.E) It requires Enter...【阅读全文】

【Oracle】【OCP 062新题】OCP题库更新出现大量新题-9

unix_5359 | 2019-04-25 11:44:08 | 阅读(950) | 评论(0)

9.You ran this command on a source database:$> expdp hr/hr DIRECTORY=dumpdir DUMPFILE=empl.dmp VIEWS_AS_TABLES=emp_deptOn the target database, you run this command:impdp hr/hr DIRECTORY=dumpdir DUMPFILE=empl.dmp VIEWS_AS_TABLES=emp_deptWhich two statements are true?A) The expdp operation export...【阅读全文】

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

网络110 报警服务