DATAGUARD MONITORING ==================== Check DB role(PRIMARY/STANDBY): ================================ SELECT DATABASE_ROLE, DB_UNIQUE_NAME INSTANCE, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, SWITCHOVER_STATUS FROM V$DATABASE; Monitor standby background process: =================================== SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM…
Read MoreOEM CONTROL COMMANDS: ===================== Stop/start and status oms in cloud control =============================== cd $ORACLE_HOME/bin emctl stop oms emctl start oms emctl status oms stop/start agent in oem cloud control =====================================…
Read MoreStep 1: Download and Install Python Step 2: Open CMD prompt and run the following command to install flask and barcode module >> pip install flask >> pip install python-barcode…
Read MoreGenerate QRcode using Python Step 1: Download and Install Python Step 2: Open CMD prompt and run the following command to install flask and pyqrcode module >> pip install flask >>…
Read MoreA histogram is a special type of column statistic that provides more detailed information about the data distribution in a table column. A histogram sorts values into “buckets,” as you might sort…
Read MoreWhat is Flask? Flask is a popular Python web framework, a third-party Python library used for developing web applications. What is the purpose of Web Framework in Python? When a…
Read MoreHASH JOINS Hash joins are used when two larger data sets are joined. Optimizer will look for the smaller one of two datasets and build the hash table based on…
Read MoreYou want to view an alert log by using ADRCI commands. To view an alert log with ADRCI, follow these steps: Invoke ADRCI. $ adrci Set the ADR home with…
Read MoreUse the following query to find out which SQL statement has run for the longest time in your database. SQL> select s.sql_text from v$sql s, v$undostat u where u.maxqueryid=s.sql_id; You…
Read More