Parallel Operation in Oracle Server- Does it improve Performance or not pros and cons of parallel execution of Oracle.
Oracle on Windows and Oracle on Unix/Linux details. Difference between Oracle on Windows,Unix,Linux explanation.
http://www.dbametrix.com/ctxsys-context-index-creation.html
Hi friends, In various critical situations Oracle DBA has to decide to kill existing session or kill the background process of Oracle. Then question is raised that in which type of situation remote dba should need to kill session and process. We are explaining those situations and incidences here. When blocking lock occurs and other [...]
RMAN is only option for OMF and Oracle ASM as Backup and Recovery Tool In the field of Oracle backup and recovery, there exist many solutions that are used for applying various strategies. In this article we will introduce some of these solutions to make you familiar with the terms. Recovery Manager (RMAN) There [...]
Oracle Advanced Compression Oracle Advanced Compression is a fresh annexe that has been liberated with the Oracle Database Management version 11g. It fundamentally is a data density extension which categorizes all varieties of data and diminishes the space necessitated in the database for all the informative-data. Because of affecting of arrangement, amorphous and other backup [...]
Transparent Application Failover TAF in Oracle RAC Transparent Application Failover TAF is an automatic database session re-establishment or reconnection characteristic built into Oracle Call Interface (OCI) in Oracle Network. It is principally aimed for Real Application Cluster RAC environments to re-establish database sessions in case of cluster node failure or instance breakdown, but the utility [...]
Hi Friends, Today we are discussing about error “Exception:TNS-04414: file error”. Generally TNS-04414 errors occurred with exception message using GUI tools like DBCA or NETMGR. Cause of TNS-04414 error: Due to found some mysterious character in network file. While DBCA or NETMGR utility is trying to save network file like sqlnet.ora, tnsnames.ora or listener.ora that [...]
What is Oracle Data Mining? “A short and solid introduction of data mining concept in Oracle” Oracle Data Mining is one of the most impressive features of the new Oracle Database system. It has been designed with the purpose of discovering new functionality within the data on the system and thus provides new and unique [...]
Why oracle database is more popular? Oracle is the shining start in computer database solution providers. Their products such as oracle 8i, 9i up to the 11g are designed to provide effective and efficient database management solutions. A number of other solutions providers such as Microsoft with their SQL products are chasing Oracle product for [...]
This is official Blog of Dbametrix Solutions. Dbametrix is group of companies for providing database services and database dba support to global client with exclusive remote support system using strong and transparent SLA and response time matrix with low cost plans.