Single Client Access Name (SCAN) is a feature used in Oracle Real Application Clusters environments that provides a single name for clients to access any Oracle Database running in a cluster. The benefit is that the client’s connect information does not need to change if you add or remove nodes or databases in the cluster. … Read more
Materialized views are query results that have been stored or “materialized” in advance as schema objects. The FROM clause of the query can name tables, views, and materialized views. Collectively these objects are called primary tables (a replication term) or detail tables (a data warehousing term). Materialized views are used to summarize, compute, replicate, and … Read more
Components: The primary components in the Splunk architecture are Forwarders, the Indexers and the Search Head. Forwarders:The forwarder is an agent you deploy on IT systems, which collects logs and sends them to indexers. Splunk has two types of forwarders:* Universal Forwarders: forwards the data without any prior treatment. This faster and requires less resource … Read more
What is the shared pool ? Oracle keeps SQL statements, packages, object information and many other items in an area in the SGA known as the shared pool. This sharable area of memory is managed as a sophisticated cache and heap manager rolled into one. It has 3 fundamental problems to overcome: The unit of … Read more
When you are taking backups regularly to a specified disk then after some period of time the backup disk will get full and you will need to delete old backups to make space for new backups. Usually you delete the old backups manually by following a particular rule like, deleting all the backups taken before … Read more
While trying to rollback the conflicting patch 18893947 applying patch 21967332 Following executables are active <dir>/product/12.1.0/12c/lib/libclntsh.so.12.1 The file libclntsh.so.12.1 will be present when emagent is running on the node and will periodically use the library libclntsh.so.11.1 Follow below steps: As root user 1. Run grep command to check and find process id active executable libclntsh.so … Read more
The undo tablespace can have many datafiles, but if it has at least 1 datafile with autoextend=on then the tablespace will use the first approach, it will set the undo retention time based on statistics of the database gathered. MMON will calculate the value of “tuned_undoretention” based on the “maxquerylen” that checks every 30 sec … Read more
Determine if a Specific MVIEW is Being Refreshed: Determine if a Refresh Group is Being Refreshed There are two possible ways of refreshing a refresh group: -> refresh is being run by a job queue process in the background. -> refresh is being run manually inside Sql*Plus or another tool. Given the name of the … Read more
Maximum Protection Mode 1. No data loss 2. Redo has to be written to both Primary redo logs and standby redo logs (of atleast one standby database) before transaction commits 3. Primary database shuts down if redo stream is prevented to write at standby redo logs of atleast one standby database 4. Configure standby redo … Read more