Tag: databases
Questions Related to databases
-
7 days
-
30 days
-
7 hours
-
Indefinitely
-
Host
-
Session
-
Instance
-
Network
-
Response time
-
Uptime
-
Throughput
-
Runtime
-
The PFILE/SPFILE parameter GATHER_STATS=FALSE.
-
Only databases created using Database Configuration Assistant have automatic statistics
-
The SYSMAN user who owns the AWR is not logged in.
-
The operating system does not support automatic statistics collection.
-
Shut down and restart the database.
-
Use EM Database Control to recompile the object.
-
Export the invalid objects, drop them, and then import them.
-
Use the ALTER FUNCTION … COMPILE and ALTER VIEW … COMPILE commands.
-
You might want a separate baseline metric for each user.
-
You might want a separate baseline metric for daytime usage versus off-hours usage.
-
You might want a separate baseline metric for each schema.
-
You would never want more than one baseline metric, even though it is possible to gather
-
Warning threshold
-
Critical threshold
-
Both A and B
-
Neither A or B
-
In the DBA_ALERTS data dictionary view
-
In the V$ALERTS dynamic performance view
-
In the EM Database Control main screen
-
No alert information is sent or displayed.
-
a is ture
-
b is fasle
-
b is false a is ture
-
a is false b is ture