Oracle Archives - Page 13 of 30

LOG MINER in Oracle

Oracle LogMiner, a component of Oracle Database, provides a SQL interface for querying both live and archived redo log files. The history of activity on a database is stored in redo…

asrblogger April 28, 2023No Comments

Oracle RAC

Manual creation of SQL Profiles in Oracle Database

SQL Profiles are a powerful tool to improve performance of SQL queries in your Oracle Database. A SQL profile is a database object that contains auxiliary statistics specific to a SQL statement.…

asrblogger April 26, 2023No Comments

Oracle

Crontab : Blocking session

Blocking sessions in Oracle are sessions which holds an exclusive lock on an object and doesn’t release it before another sessions wants to update the same data. This will block…

asrblogger April 26, 2023No Comments

Oracle RAC

When we run SQL tuning advisor against a SQL statement or sql_id, it provides tuning recommendations that can be used to improve performance. It might give suggestion to create few indexes or accepting a SQL profile.…

asrblogger April 26, 2023No Comments

Oracle

ORA-04021: timeout occurred while waiting to lock object while dropping Materialized View.

A materialized view, or snapshot as they were previously known, is a table segment whose contents are periodically refreshed based on a query, either against a local or remote table.…

asrblogger April 26, 2023No Comments

DataGuard Oracle

Unable to generate Listener Log in Prod RAC DB

Cause: Looks like ADR is having the issue. Solution: Added the below parameter in the both the nodes and restarted the listener DIAG_ADR_ENABLE_LISTENER=OFF There are 3 parameters associated with ADR:…

asrblogger April 26, 2023No Comments

DataGuard Oracle

Moving datafile from one location to another in Standby

[oracle@localhost ~]$ ps -ef|grep pmon oracle 2113 1 0 Sep20 ? 00:54:32 ora_pmon_prod1 oracle 30032 29996 0 08:50 pts/0 00:00:00 grep --color=auto pmon [oracle@localhost ~]$ [oracle@localhost ~]$ [oracle@localhost ~]$ .…

asrblogger April 26, 2023No Comments

DataGuard Oracle

ORA-16047: DGID mismatch between destination setting and target database

Issue : ORA-16047: DGID mismatch between destination setting and target database alert.log alter database register logfile '/opt/data/oracle3/prod101/FRA/prod101/archivelog/2019_12_01/o1_mf_1_190698_gy5z61jw_.arc' There are 1 logfiles specified. ALTER DATABASE REGISTER [PHYSICAL] LOGFILE Completed: alter database…

asrblogger April 26, 2023No Comments

Linux Oracle

Linux Administration.

A Linux distribution is a collection of (usually open source) software on top of a Linux kernel. A distribution (or short, distro) can bundle server software, system management tools, documentation…

asrblogger April 26, 2023No Comments

Oracle

Basic Performance and Tuning

As a DBA, you are responsible for the performance of your Oracle database. Typically, performance problems result from unacceptable response time, which is the time to complete a specified workload,…