Database Administrator

Change SID name after Creating Database Recreate the Control file to achieve this . 1. SVRMGR>Alter Database backup controlfile to trace;...

select * from DICTIONARY; use following query from sys user select kqfvinam name from x$kqfvi order by kqfvinam; select * from PUBLICSYN whe...

Sql Server System Stored Procedures --provide list of all database objects exec sp_help --provide list of all columns , there datatype and s...

SQL Server DBCC(DataBase Console Commands) DBCC CACHESTATS displays information about the objects currently in the buffer cache, suc...

Step 1: Decide on Your Instance Identifier (SID) Step 2: Establish the Database Administrator Authentication Method Step 3: Create the...