You can find detailed information about Contained Database in the article “What is Contained Database” We can create a new Contained Database and create …

  When the catupgrd.sql is run during the manual upgrade process, it ends with “ORA-01722: invalid number” error due to the Database Vault configuration in …

  I would like to write this article because it is a topic that some friends who are interested in SQL Server are usually curious …

enq: TX – row lock contention can be regarded as a row lock conflict wait event in operations. This event indicates that a session is …

We can create a user without login since SQL Server 2005 version. This feature was introduced instead of Application Role. You may want to read …

  Latch free and library cache: mutex X wait events can be seen for the corresponding SQL statements in intensive delete and insert operations in …

  Application Role is a role at the database level. You can use Application Roles to access a database only with specific users from a …

I will tell you below metadata functions in this article. APP_NAME COL_LENGTH DATABASEPROPERTYEX SERVERPROPERTY DB_ID DB_NAME OBJECT_ID OBJECT_NAME SCHEMA_ID SCHEMA_NAME STATS_DATE APP_NAME Function: This function …

In 12c databases, ORA-12805, ORA-07445 [qertqistart] or ORA-600 [15803] errors may occur depending on bug 25694206. User operation cannot be completed due to the closing …

Before you begin this article, I suggest you read my article “How To Create a Login On SQL Server(Manage Logins)” for a detailed review of …