黄继生 jisen-CSDN博客

原创 Mysql 5.7 主从复制

安装主从库数据库软件（略）修改密码：ALTER USER 'root'@'localhost' IDENTIFIED BY '@abcd123456'; 开启远程登录 1.1、连接服务器: mysql -u root -p　　1.2、看当前所有数据库：show databases;　　1.3、进入mysql数据库：use mysql;　　1.4、查看mysql数据库中所有的表：show tables;　　1.5、查看user表中的数据：select Host, Use

2022-05-19 00:49:58 306

原创 clickhouse 3节点Distributed架构部署

/etc/hosts192.168.1.14 ch14192.168.1.15 ch15192.168.1.16 ch16zoo.cfg[root@ch14 ~]# cat /home/i2/zookeeper/conf/zoo.cfgtickTime=2000initLimit=10syncLimit=5dataDir= /home/i2/zookeeper/data/zookeeperdataLogDir= /home/i2/zookeeper/

2022-03-21 10:16:04 515

原创 greenplum-db-5.10 for Centos 7.6 分布式安装，使用，备份与恢复

目录1. 准备安装环境... 21.1. 安装依赖包... 21.2. 系统参数配置... 31.3. 禁用SELinux（三台机器都要）... 31.4. 内核参数配置（三台都要）... 41.5. 修改文件打开限制（三台都要）... 41.6. 设置最大进程... 41.7. 修改磁盘预读量（所有机器）... 51.8. 修改调度（所有机器）... 51.9. 修改挂...

2021-08-10 02:00:33 578

原创 RAC VIP修改

[grid@rac1 ~]$ srvctl config nodeapps -a Network exists: 1/19.21.68.0/255.255.255.0/bond0, type static VIP exists: /rac1-vip/19.21.68.107/19.21.68.0/255.255.255.0/bond0, hostin.

2021-07-17 11:52:12 287

原创 Oracle-OS类SQL跟踪语句

查询执行时间最长的前50个SQL，并执行次数大于10次select * from (select sa.EXECUTIONS "执行次数",round(sa.ELAPSED_TIME / 1000000, 2) "总执行时间",round(sa.ELAPSED_TIME / 1000000 / sa.EXECUTIONS, 2) "平均执行时间",sa.COMMAND_TYPE,sa.PARSING_USER_ID "用户ID",u.username "用户名",sa.HASH_VALU

2021-07-17 11:51:34 228

原创 QUESTION 228-Temporal Validity

Which there statements are true about the use of the In-Database Archiving and Temporal Validity features of Oracle Database 12c? A. Temporal Validity spans the time between a row insert and a subsequent update or delete for the same row. B. Both T..

2021-07-15 07:38:46 129

原创 QUESTION 230-AMM

Examine the memory-related parameters of an Oracle database instance:*.memory_max_target=6G*.memory_target=5G*.pga_aggregate_target=500M*.sga_max_size=0*.sga_target=0Which statement is true?A. Memory is dynamically re-allocated between SGA an

2021-07-15 07:38:40 103

原创 QUESTION 229-SQL Tuning Advisor

Identify the category of recommendation that can be implemented automatically by the Automatic SQL Tuning Advisor. A. creating SQL profiles B. partitioning a table C. reducing wait events D. restructuring SQL statementsE) creating invisible inde.

2021-07-15 07:38:34 98

原创 QUESTION 215-Temporal Validity feature

Which three statements are true about the use of the In-Database Archiving and Temporal Validity feature of Oracle Database 12c? A. Temporal Validity spans the time between a row insert and a subsequent update or delete for the same row. B. Bot...

2021-07-15 07:38:29 123

原创 QUESTION 227-DB_CREATE_ONLINE_LOG_DEST_n将会覆盖DB_CREATE_FILE_DEST

Examine these parameter settings: DB_CREATE_FILE_DEST = '/u01/oradata' DB_CREATE_ONLINE_LOG_DEST_1 = '/u02/oradata' DB_CREATE_ONLINE_LOG_DEST_2 = '/u03/oradata' DB_RECOVERY_FILE_DEST = '/u01/app/oracle/flash_recovery_area' DB_RECOVERY_FILE_DEST_S

2021-07-15 07:38:22 179

原创 QUESTION 226-user PDB_ADMIN lacks CREATE SESSION privilege； login denied

Your are connected with SQL*plus to a multitenant container database (CDB) with SYSDBA privileges and execute these sequence of statements: SQL> CREATE PLUGGABLE DATABASE NEW_PDB ADMIN USER PDB_AMDIN IDENTIFIED BY SECRET; SQL> ALTER PLUGGABL...

2021-06-29 10:51:14 298 2

原创 QUESTION 225-removed automatically based on RMAN retention policy settings

You configured the Fast Recovery Area (FRA) for your database, which is in ARCHIVELOG mode. The default location for the archived log files is the Fast Recovery Area. There are no guaranteed restore points defined in the database. Which two file type

2021-06-29 10:51:08 80

原创 QUESTION 224--SPA

The workload on your database remains the same between 9AM and 6PM on all days of the week. However, you notice performance degradation between 3PM and 5PM on some days. You want to identify regressed statements by comparing the workload between these

2021-06-29 10:51:04 94

原创 QUESTION 223-optimizer_dynamic_sampling

Examine the parameters for your database instance:NAME TYPE VALUE ---------------------------------------------------- ---------- ------------optimizer_adaptive_reporting_only boolean FALSE optimizer_capture_sql_plan_baselines boolean FALSE ..

2021-06-29 10:50:51 132

原创 QUESTION 222- damages data files belonging to the USERS tablespace and the online redo log files.

Your database runs in NOARCHIVELOG mode. Whole database backups are taken daily. A media failure damages data files belonging to the USERS tablespace and the online redo log files. The hardware that is causing this damage is not repairable. You iss

2021-06-29 10:50:47 82

原创 QUESTION 221-SecureFile LOBs

Which tow are true regarding SecureFile LOBs? A. Fragmentation is minimized by using variable-sized chunks dynamically. B. SecureFile LOBs can be used only for non-partitioned tables. C. The volume of undo retained is session controlled. D. SecureF

2021-06-29 10:50:42 86

原创 QUESTION 220- row-archival management is enabled

Which two statements are true when row-archival management is enabled? A. The ORA_ARCHIVE_STATE column may only be updated by users with the DBA role set. B. The ORA_ARCHIVE_STATE column is updated in an overnight maintenance job based on activity ..

2021-06-29 10:50:38 308

原创 QUESTION 219-add users with the SYSBACKUP, SYSDG, and SYSKM privileges to the password file

You upgrade your database from pre-12c to a multitenant container database (CDB) that contains plugable database (PDBSs) Examine the query and its output: SQL> SELECT * FROM V$PWFILE_users; USERNAME SYSDB SYSOP SYSAS SYSDG SYSKM CON_ID -------

2021-06-29 10:50:33 284

原创 QUESTION 218-VIEW_AS_TABLE

Examine this set of commands to perform data pump export and import operation:On the source database:$> expdp sh/sh DIRECTORY=dpdir DUMPFILE=sale1.dmp VIEW_AS_TABLE=sales_q1On the target database:$> impdp sh/sh DIRECTORY=dpdir DUMPFILE=sale1.dmp.

2021-06-29 10:50:28 108

原创 QUESTION 217-ALTER SYSTEM SET STATISTICS_LEVEL=ALL SCOPE=BOTH；

You are connected to a multitenant container database (CDB) with DBA privileges. The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You issue: SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SCOPE=BOTH; What three effects does this have on the CDB AND IT'

2021-06-29 10:50:22 186

原创 QUESTION 216-quick solution(ADDM)

You experience performance degradation in your Oracle 12c database. To investigate, you use Active Session History(ASH) and hang analysis. You do not find any blocking sessions, but the response time is still slow. Which method of feature would you use .

2021-06-28 06:32:46 96

原创 QUESTION 214-REVOKE create table FROM C##A_ADMIN；

In your multitenant container database (CDB) that contains pluggable database (PDBs),you grant the CREATE TABLE privilege to the common user C##A_ADMIN in root and all of PDBs,with one command. You then execute this command from the root container:SQL

2021-06-28 06:32:40 121

原创 QUESTION 213-add a new PDB to the CDB

Your multitenant container database (CDB) contains two pluggable databases (PDBs). Which three tools can be used to add a new PDB to the CDB? A. Oracle Universal Installer (OUI) B. Enterprise Manager Cloud Control C. Database Upgrade Assistant (DBU

2021-06-28 06:32:35 60

原创 QUESTION 212-BACKUP PLUGGABLE DATABASE“CDBSROOT“,pdb2_1；

Your multitenant container database (CDB) is running in ARCHIVELOG mode. Examine this command and its output: SQL>SELECT con_id,open_mode FROM V$PDBS; CON_ID NAME OPEN_MODE ┄┄┄┄ ┄┄┄┄┄┄┄┄┄┄ ┄┄┄┄┄┄┄┄┄ 2 PDB$SEED READ ONLY 3 PDB2_1 READ WRITE

2021-06-28 06:32:29 118

原创 QUESTION 211-GRANT create tablespace to C##A_ADMIN；

Your multitenant container database (CDB) contains several pluggable databases (PDBs). A common user C##A_ADMIN, is created with connect privileges. You execute this command from the root container: SQL> GRANT create tablespace to C##A_ADMIN; Wh

2021-06-28 06:32:24 98

原创 QUESTION 210- reference partitioning in Orade Database 12c

Which two partitioning methods are suitable for a parent table when using reference partitioning in Orade Database 12c. A. interval partitioning B. system partitioning C. hash partitioning D. list partitioning E. range partitioning Corre...

2021-06-28 06:32:20 120

原创 QUESTION 209- SQL*Loader Express Mode

Which two statements are true regarding SQL*Loader Express Mode in an Oracle 12c database? A. The DEGREE_OF_PARALLELISM parameter is set to AUTO. B. If no data file is specified, it uses table-name.dat and assumes it is in the current directory. ..

2021-06-28 06:32:15 389

原创 QUESTION 208-UNIFIED_AUDIT_TRAIL

While investigating a possible security breach, you realized that some audit records were not retrieved when the UNIFIED_AUDIT_TRAIL view was queried. How can you ensure that all available audit records are returned when the audit trail is queried? A..

2021-06-28 06:32:10 277

原创 QUESTION 207-concerning compression during an Online Datafile Move

Which statement is true concerning compression during an Online Datafile Move?A. Uncompressed data files may be moved online to compress the entire file with Hybrid Columnar CompressionB. Only tables may be compressed during the Online Datafile Move.C.

2021-06-28 06:32:05 114

原创 QUESTION 206-CDB/PDB container=

Your multitenant container database (CDB) contains several pluggable databases (PDBs). Users c##A_ADMIN and B_ADMIN have only connect privileges. You create a common role c##_ROLE1 with common privileges CREATE TABLE and SELECT ANY TABLE.You then exe

2021-06-28 06:32:01 113

原创 QUESTION 205 -AMM

An Automatic Database Diagnostic Monitor (ADDM) finding in your production database reports that the shared pool is inadequately sized. You diagnose that this is due to the different kinds of workloads and this occurs only during peak hours. Examine th..

2021-06-26 22:31:13 90

原创 QUESTION 204-RMAN recovery catalog automatically resynchronized

In which two scenarios is an RMAN recovery catalog automatically resynchronized?A. when a registered database is opened with the RESETLOGS optionB. when the backup retention policy configuration is changed for a registered databaseC. when backup metadat

2021-06-26 22:31:08 64

原创 QUESTION 203-SHARED_SERVERS/ SHARED_SERVER_SESSIONS

Your database instance has Automatic Memory Management enabled, and has the large pool configured. You issue this command: SQL> ALTER SYSTEM SET SHARED_SERVERS = 5; Which statement is true about the shared server configuration? A. It is enabled.

2021-06-26 22:31:02 77

原创 QUESTION 202-latch:row cache objects、Cursors are not being shared./The shared pool size is too small

Examine the details of the Top 5 Timed Events from an Automatic Workload Repository (AWR) report:Top 5 Timed Foreground EventsEvent Waits Time(s) Avg wait(ms) %DB time Wait ClassDBCPU 67 98.21db file sequential read 8371 0 0 0.52 User l/Olatch:row c

2021-06-26 22:30:56 98

原创 QUESTION 201- Response file mode

Which two statements are true about the installation modes in Oracle Database 12c? A. In response file mode, you can include responses for some or all prompts. B. In interactive mode, parameter values are read from a response file and can be changed.

2021-06-26 22:30:51 85

原创 QUESTION 200-DB_CREATE_FILE_DEST

You issue these commands: SQL>ALTER SYSTEM SET DB_CREATE_FILE_DEST=’/u01/app/oracle/oradata/orcl’; SQL>CREATE TEBLESPACE august_sales DATAFILF‘/u01/app/oracle/mydata/mysales.dbf’SIZE 10M; SQL>CREATE TEMPORARY TABLESPACE temp101 TEMPFILE...

2021-06-26 22:30:46 81

原创 QUESTION 199 -ASMM

Examine these parameters for a database instance: memory_max_target big integer 6G memory_target big integer 6G pga_aggregate_target big integer 1000M sga_target big integer 4480M java_pool_size big integer 0 large_pool_size big integer 0 .

2021-06-26 22:30:41 107

原创 QUESTION 198 - undo the effects of the FLASHBACKTABLE command.

The current system change number (SCN) for a live database is 663571.You decide to use the FLASHBACK TABLE statement to flash back the CUSTOMERS table to SCN 662116.After flashing back the customers TABLE, you query it and decide to undo the effects of th

2021-06-26 22:30:34 111

原创 QUESTION 197- read blocks/ read blocks

Examine the portition of this Active Session History (ASH) report that is marked with a red rectangle: Activity Over Time Analysis period is devided into smaller time slots Top 3 events are reported in each of those slots "Slot Count" shows the .

2021-06-26 22:30:29 249

原创 QUESTION 196-minimal impact rebalance

You are administratoring a database stored in ASM. One of the ASM disks is dropped because of hardware failure.You replace the failed disk and want the resulting rebalance operations to occur with minimal impact on database performance.Which two setting.

2021-06-26 22:30:22 73

空空如也

空空如也