![](https://img-blog.csdnimg.cn/20201014180756919.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
メモリ
小麦粒児
这个作者很懒,什么都没留下…
展开
-
Q2
Q2 Which three statements are true about Flashback Data Archive?A.Flashback Data Archive prevents flashback queries from getting a snapshot too-old error.B.A table enabled for Flashback Data Archive c...原创 2018-06-22 14:57:59 · 209 阅读 · 0 评论 -
D--Q
NO.66 Examine the steps/operations performed during the RMAN backup operation by using Oracle Secure Backup (OSB):1.Start the RMAN client by using the RMAN target / command. 2.Start the RMAN client by...原创 2018-06-26 14:22:17 · 690 阅读 · 0 评论 -
星期二『51-100』
Q.51Which two statements are true when row-archival management is enabled?A. The ORA_ARCHIVE_STATE column is updated manually or by a program that can reference activity tracking columns, to indica...原创 2018-07-04 14:57:02 · 1951 阅读 · 0 评论 -
工作記
select a.SQL_FULLTEXT, a.SQL_ID, a.MODULE, TO_CHAR(a.LAST_ACTIVE_TIME,'yy-mm-dd hh24:mi:ss') from v$sql awhere TO_CHAR(a.LAST_ACTIVE_TIME,'yy-mm-dd hh24:mi:ss') between '17-06-27 09:...原创 2018-07-13 10:03:14 · 150 阅读 · 0 评论 -
循序渐进:Oracle 12c新特性Sharding技术解读
引言数据库构架设计中主要有 Shared Everthting、Shared Nothing 和 Shared Disk: Shared Everthting:一般是针对单个主机,完全透明共享 CPU/MEMORY/IO,并行处理能力是最差的,例如 Oracle 的单机模式。 Shared Disk:各个处理单元使用自己的私有 CPU和 Memory,共享磁盘系统。典型的...转载 2018-07-19 16:29:32 · 1810 阅读 · 1 评论 -
写一个学习过程 如何拿下12C OCP
接触oracle5年 给自己一个交代历时3个月,如愿以偿的拿到了12C ORACLE原创 2018-09-19 14:40:08 · 5109 阅读 · 3 评论 -
星期一『1-50』
Q.1 user_data is a nonencrypted tablespace containing tables with data.You must encrypt all data in this tablespace.Which three methods can do this?A. Use CREATE TABLE AS SELECTB. Use Data Pump.C. Use...原创 2018-06-29 15:09:41 · 3782 阅读 · 2 评论 -
Q3
Which statement is true about the DUPLICATE command?Examine the RMAN commands:RMAN> CONNECT TARGET “sbu@prod AS SYSBACKUP”;RMAN> CONNECT AUXILIARY “sbu@dup_db AS SYSBACKUP”;RMAN> DUPLICATE TA...原创 2018-06-22 15:08:07 · 222 阅读 · 0 评论 -
Q4
Your database is running in ARCHIVELOG mode and flashback is enabled.In which scenario must you use RMAN backups for recovering tables and table partitions?A.when recovering a table to a point in time...原创 2018-06-22 15:12:04 · 289 阅读 · 0 评论 -
Q1
Which three types of backups can be performed for a database running in NOARCHIVELOG mode?A.consistent whole database backupB.backup of noncritical tablespaces without shutting down the instanceC. bac...原创 2018-06-22 15:15:18 · 448 阅读 · 1 评论 -
Q5
In your database, the user SCOTT wants to retrieve the dropped HR.EMPLOYEES table by using the command:SQL> FLASHBACK TABLE HR.EMPLOYEES TO BEFORE DROP;What are three prerequisites for this command...原创 2018-06-22 15:19:35 · 347 阅读 · 0 评论 -
Q6
Which two are prerequisites for performing Flashback Transaction?A.A supplemental log must be enabled for the primary key.B.Undo retention guarantee must be configured for the database.C.Fast Recovery...原创 2018-06-22 15:27:10 · 139 阅读 · 0 评论 -
Q7
You use RMAN to take regular backups for your database.Examine the RMAN commands:RMAN> CROSSCHECK BACKUP;RMAN> DELETE EXPITED BACKUP;Which statement is true?A.All backups and archived redo log f...原创 2018-06-22 15:32:28 · 221 阅读 · 0 评论 -
Q9
Your database is running in archivelog mode. Examine the parameters for your database instance:LOG_ARCHIVE_DEST_l = 'LOCATION=/disk1/arch MANDATORY’LOG_ARCHIVE_DEST_2 = 'LOCATION=/disk2/arch’LOG_ARCHI...原创 2018-06-22 15:58:00 · 481 阅读 · 0 评论 -
Q8
You are performing regular backups of your production database by using a recovery catalog.You add two new tablespaces to your production database after performing a backup. They must be included in f...原创 2018-06-22 15:59:47 · 285 阅读 · 1 评论 -
星期五『201-231』
Q.201Your database is running in archivelog mode. Examine the initialization parameters you plan to set for your database instance.LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch'LOG_ARCHIVE_DEST_2 = 'L0CA...原创 2018-06-29 15:08:34 · 2356 阅读 · 0 评论 -
how to kill jobs in Oracle DB
今天发现数据库一个JOB一直在执行,都执行了5个小时还在执行,所以想办法给删除掉系统环境: ORACLE 10G AIX操作系统操作步骤如下:第一步、查询出来那个job在运行,找个对应的SID字段1、select * from dba_jobs_running--找到job对应的sid第二部、通过以下语句查询出来SID对应的SPID, 其中S...原创 2019-03-26 16:03:37 · 138 阅读 · 0 评论