Oracle Database Interview Question Set-30
My DBA Community,
My today’s post is very important for those who are looking for a job and preparing for an Interview. I am writing Oracle Database interview questions.
I hope these IQ will help you.
If your standby database is lagging relative to the primary database, you should focus on which areas?
How You Determining transport or apply lag is done on the standby database?
How you Find local time on the standby database when the datum used to compute the metric was received it means (the lag metrics are computed based on data that's periodically received from the primary database)?
How you will Find out the history of apply lag values since the standby instance was last started?
How to monitor and assess redo apply performance?
What are the RECOVERY PROCESS WAIT EVENTS in Data Guard?
Which Script creates the standby statspack schema to hold the standby snapshots?
Which script generates the standby statistics report?
Which script is used to purge a set of snapshots in the Data Guard?
Which script drops the stdbyperf user and tables?
With Best Wishes!!!!
Oracle Database Consultant
Certified in-: | 1XAzure | 6XOCI | 1XOCS (GG) | 1XOCE (RAC) | 3XOCP (11g,10g,9i) | 1XOCA (9i) |
YouTube Channel: https://www.youtube.com/c/OracleRide