Skip to Main Content


Question and Answer

Connor McDonald

Thanks for the question, Hasitha.

Asked: September 29, 2021 - 9:06 am UTC

Last updated: October 04, 2021 - 4:48 am UTC


Viewed 100+ times

You Asked

You specified the warning and critical thresholds for a locally managed tablespace to be 60% and 70%,
From the tablespace space usage metrics, you find that the space usage has reached the specified warning
threshold value, but no alerts have been generated.
What could be the reason for this?
A. The event parameter was not set.
B. The sql_trace parameter is set to false.
C. Enterprise Manager was not used.
D. The statistics_level parameter is set to basic.
E. The timed_statistics parameter is set to false.

I think answer should be A please help.

and Connor said...

I think its "D".

From the "Database Reference"

Setting the STATISTICS_LEVEL parameter to BASIC disables the collection of many of the important statistics required by Oracle Database features and functionality, including:

All server-generated alerts
Automatic Database Diagnostic Monitor (ADDM)
Automatic optimizer statistics collection
Automatic SGA Memory Management
Automatic Workload Repository (AWR) Snapshots
Buffer cache advisory
Database time distribution statistics (V$SESS_TIME_MODEL and V$SYS_TIME_MODEL)
End to End Application Tracing (V$CLIENT_STATS)
Monitoring of statistics
MTTR advisory
Object Activity Tracking System (OATS)
Object level statistics
PGA Target advisory
Segment level statistics
Service level statistics
Shared pool sizing advisory
Timed statistics


  (2 ratings)


A reader, October 01, 2021 - 5:51 am UTC

let's take database all control files are lost, but datafiles and online redologs are not harmed my answers are below,

1.if we restore control files from auto backup during the recovery what is the command to use,
recover database or recover database using control file.

then let's take we restored control file with auto backup after that do we need to execute recover database command why do we need to execute it.
Connor McDonald
October 04, 2021 - 4:48 am UTC

This is starting to sound like you want to us to *do* the exam for you

A reader, October 01, 2021 - 5:53 am UTC

Please see the below question where according to my answer no need to execute any recover database command is it correct or not. Please give me a feedback.

One of your databases is in ARRCHIVELOG mode.
You back up the database by using RMAN with a recovery catalog.
One data file and all the control files are corrupt due to corruption in the storage array.
Examine this list of possible actions to recover the database:
1. Restore the control files by using the RESTORE CONTROLFILE command.
2. Mount the database.
3. Restore the data files by using the RESTORE DATABASE command.
4. Open the database with the RESETLOGS option.
5. Recover the data files by using the RECOVER USING BACKUP CONTROLFILE command.
6. Start the target database instance in NOMOUNT state.
7. Connect to the target database and the recovery catalog database instance.
8. Restore the SPFILE by using the RESTORE SPFILE command
9. Restore the corrupt data file.
10. Recover the restored data file.
Identify the minimum required steps in the correct order.
A. 7, 6, 1, 8, 2, 3, 5, 4
B. 7, 6, 1, 2, 3, 5, 4
C. 7, 2, 1, 3, 5, 4
D. 7, 6, 1, 2, 9, 10, 4
E. 7, 6, 1, 2, 3, 10, 4

my answer is D.
Connor McDonald
October 04, 2021 - 4:48 am UTC

This is starting to sound like you want to us to *do* the exam for you

More to Explore


Need more information on Administration? Check out the Administrators guide for the Oracle Database