Database. You want to know what caused this performance difference.
Which method or feature should you use?
Database Replay
Automatic Database Diagnostic Monitor (ADDM) Compare Period report
Active Session History (ASH) report
SQL Performance Analyzer
Media management interface (MMI).
Which two are true about the use of
The RMAN MMI?
You can use it to create proxy copies for database files.
You can use it to create proxy copies for entire file systems.
You can use it to create image copies for entire file systems.
You can use it to create image copies for database files.
Container database (CDB) that contains pluggable databases (PDBs).
Examine the query and its output:
SQL> SELECT * FROM v$PWFILE_users;
USERNAME
SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM CON_ID
---------------------------------------------------------------------
---
SYS
TRUE TRUE
FALSE
FALSE
FALSE
FALSE
0
Which two tasks must you perform to add users with the SYSBACKUP,
SYSDG, and SYSKM prileges to the password file?
Database has significantly degraded. Sometimes you are not able to connect
To the instance because it hangs. You do not want to restart the database
Instance. How can you detect the cause of the degraded performance?
Enable Memory Access Mode, which reads performance data from SGA.
Use emergency monitoring to fetch data directly from SGA for analysis.
Run Automatic Database Diagnostic Monitor (ADDM) to fetch information
From the latest Automatic Workload Repository (AWR) snapshots.
Use Active Session History (ASH) data and hang analysis in regular
Performance monitoring,
Database. You want to know which change caused this performance
Difference. Which method or feature should you use?
Compare Period ADDM report
AWR Compare Period report
Active Session History (ASH) report
Taking a new snapshot and comparing it with a preserved snapshot.
Database (CDB) containing pluggable databases (PDBs).
Examine the query and its output:
Which two tasks must you perform to add users with SYSBACKUP, SYSDG,
And SYSKM privilege to the password file?
Assign the appropriate operating system groups to SYSBACKUP, SYSDG,
SYSKM.
Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege
And the FORCE argument set to No.
Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege,
And FORCE arguments set to Yes.
Re-create the password file in t he Oracle Database 12c format.
我来回答: