How To Find Unused Tables in SQL Server
One of the first steps a good database administrator should take when looking at a database system is to find
How To Find Oracle DB Link User Password
It is possible to forget the passwords of the users in the DB Links created for the communication between Oracle
How To Find Unused Indexes in SQL Server
Index is an object that improves performance in the database in general. Many inexperienced database administrators or application developers create
How To Enable DDL Auditing in Oracle 11g and 12c(enable_ddl_logging)
Enable DDL Auditing in 11g It is possible to enable ddl auditing in a database or shema. In this way,
How To Find Missing Indexes in SQL Server
In the database, especially during the new development phase, indexes are the most important performance providers for us. You should
How To Change the database id and database name in RAC Databases
This article describes how to change the id and name of a database that is running as RAC, what operations
How To Find Most Expensive Queries in SQL Server
One of the first things that we look at to improve performance in systems that have performance problems is the
ORA-27086: unable to lock file – already in use
When nfslock service is turned off, export ends with an ORA-27086 error when trying to backup on a NFS mounted
How To Deny Backup to Database Owners in SQL Server
When you authorize logins as db_owner in the database, your disks may be full at an unexpected time. Because a
RMAN Encrypted Backup
For improved security, RMAN backups can be encrypted. Encrypted backups cannot be read by unauthorized persons. A password or wallet