In your test database, you find that a user’s session is executing a lot of SQL statements, resulting in the generation of a large number of trace files. While investigating the reason, you find that SQL trace has been enabled at the instance level. You want to disable SQL trace, remotely, only for that user session to reduce the volume of trace data being generated. How do you achieve this objective?()
A、by setting the SQL_TRACE parameter to FALSE in the parameter file
B、by using DBMS_MONITOR.SESSION_TRACE_DISABLE to disable the tracing for the user session
C、by setting the SQL_TRACE parameter to FALSE by using the ALTER SYSTEM command in the user session
D、by setting the SQL_TRACE parameter to FALSE by using the ALTER SESSION command in the user session
相关问题推荐
-
关于类和对象描述错误的是()。
A.对象(Object)是现实世界中的客观事物,对象具有确定的属性
B.类是具有相同属性和行为的一组对象的集合
C.对象是类的抽象,类是对象的实例
D.类是对象的抽象,对象是类的实例
-
Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table: ERROR at line 1: ORA-01654: unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES.While investigating, you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available. Which two actions could you perform to overcome this error without affecting the queries that are currently being executed?()
ADrop and re-create the inbox.
BCoalesce the ORDERS_IND index.
CCoalesce the INDEXES tablespace.
DDrop and re-create the ORDERS table.
ERebuild the index online and move it to another tablespace.
-
Your business has departmental reports that are generated every day. Each department must use the same set of queries, but accesses a different subset of data in the tables, depending on which department generates the report. The format of the reports is being developed; currently, the format changes daily. How would you configure the database to ensure that each department generates its report (based on its target data) using the most recent report format every day?()
A、by having each user run the report generation procedure at the scheduled time, supplying the necessary input variables
B、by creating a program using DBMS_JOB that accepts one or more variables, and creating a job that calls this program using DBMS_JOB
C、by having each user schedule a job using DBMS_JOB that accepts one or more input variables and calls a procedure that generates the report
D、by having each user create a job using DBMS_SCHEDULER that includes all the information and commands necessary to generate the report
E、by creating a program using DBMS_SCHEDULER that accepts one or more variables, and creating a job that calls this program using DBMS_SCHEDULER
-
You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query?()
A、 VERSIONS_STARTSCN
B、 VERSIONS_STARTTIME
C、 VERSIONS_XID
D、 VERSIONS_OPERATION
-
You execute the following RMAN command in the order shown below: BACKUP VALIDATE DATABASE; BLOCKRECOVER CORRUPTION LIST; What will these commands do?()
A、 Create a backup of the database and recover all corrupted blocks found in the backup.
B、 Run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database.
C、 Run a backup validation to populate V$COPY_CORRUPTION view, and then list any corrupt blocks recorded in the view.
D、 Run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view, and then repair any corrupt blocks recorded in the view.
E、 Run a backup validation, repair any corrupt blocks found during the validation process, and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired.