SQL Server ACID Rules
ACID is the four main rules that relational database management systems (RDBMS) must provide. For more detailed information about relational
How To Find Which Groups(OSDBA,OSASM,OSOPER,DBA) have set During Oracle Database Installation
What groups selected during Oracle binary installation may not be remembered after installation. Or it may be necessary to determine
Point-in-time Restore With Database Recovery Advisor
We can easily perform point-in-time recovery with Database Recovery Advisor. For example, we have a Full backup that has taken
Data Dictionary Views For Backup and Recovery
The data dictionary views that contain information about the backups and recovery of Oracle databases are as follows. We can
What is User Defined Function
User Defined Function is a feature of SQL Server that takes parameters like a programming language functions and returns a
How To Find Query History On Oracle
The DBA_HIST_ACTIVE_SESS_HISTORY data dictionary view can be used to find queries executed in the Oracle database. Historical information is available.
Update Your Database with Upgrade Data-tier Application
Before you read this article, I recommend that you read the article “What is Data-Tier Application” to avoid confusion. In
How To Find Process Informations of a Session(Kill Oracle Session)
You can access the process information of a session in the Oracle database with the following query. Sometimes it is
What is Data-Tier Application
Data-Tier Application Version 1.1 (DAC) was introduced with SQL Server 2008 R2. With Data-Tier Application, we are able to transfer
Profile password verify function issue(FROM ROOT)
Even if the password_verify_function limit of a profile is changed in Oracle databases, it does not change as requested and