I will try to explain the identity feature, which is my favorite innovation in Oracle 12c. MS SQL and MYSQL users know the Identitiy …
Read More »dbtut
Policy-Based Management(Check The Databases That Are Not Backed Up-Database Facet)
Policy-Based Management is a feature that introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to …
Read More »Step By Step Oracle Apex Installation
I tried to explain the apex installation step by step. Ensure that the Oracle Text component is also installed before you begin the installation. …
Read More »How To Read SQL Server Audit
You can read the article “How To Create SQL Server Audit” to get more information about Audit and create an audit. You can read …
Read More »How To Enable Archive Log Mode In Oracle RAC Database
Enabling the archive log mode in the RAC database is slightly different from the normal database. You can enable archive log mode in the rac …
Read More »How To Create SQL Server Audit
We will create sql server audit step by step in this article. We need to create an Audit file to record transactions made by people …
Read More »How To Access SESSION Information in Oracle from the Process ID in the Operating System
You can use the following script to access SQL information in Oracle from a PROCESS ID on the operating system. [crayon-674113a62834c676423596/] If your …
Read More »Difference Between Always On Failover Cluster, Database Mirroring, Always On Availability Group, Replication and Log Shipping
I wanted to write this article to make it easier for you to choose between SQL Server’s technologies used for HA (High Availability) and DR …
Read More »Collecting Environment Information
You can use the following script to collect the enviroment information that are set on the user you are connecting to the database. This …
Read More »What is Database Snapshot On SQL Server
Database Snapshot is the creation of an unchangeable image of the database, you can think of it as taking current photo of database. If …
Read More »