Database Administrator

When to Rebuild an Index? It is important to periodically examine your indexes to determine if they have become skewed and might need to be ...

emca -deconfig dbcontrol db -repos drop drop taking more time and hang the server not able to create oem because sysman already exist emca -...

Making Idle Session SNIPED: An idle session can be setup to become sniped after x minutes by setting the initialization parameter resource_l...

-------------------Sniped idle session-------------- SELECT DECODE(TRUNC(SYSDATE - LOGON_TIME), 0, NULL, TRUNC(SYSDATE - LOGON_TIME) || ...

------------------- @echo lsnrctl stop rename d:\oracle\product\10.2.0\db_1\network\log\listener.log listener1.log lsnrctl start move d:\ora...

Oracle LOG_ARCHIVE_MAX_PROCESSES parameter specifies the number of active ARCH processes (ARC0-ARCn) initially invoked by Oracle. The value ...

Connection is break again and again and showing following error Error ORA-12518: TNS:listener could not hand off client connection ---------...

Issue Trying to connect to MySQL database using Oracle's SQL-Developer receiving the following error message: Status: Failure -com.mys...

connect sys as sysdba user and run two scripts for install and configure utl_mail package SQL> conn sys@orcl as sysdba Enter password: **...

Do one time setting into one PC export that setting to IE_Security_Settings.reg and Dpi.reg copy /Y "%~dp0regdpi.dll" c:\windows\s...

forfiles only work in windows 2000 /2003/ vista Folder Location C:\Test\arch file older than 5 days *.* all file extension (*.txt, ........

Set up below parameters on both databases (db1, db2) 1. Enable ARCHIVELOG MODE on both database 2. Create Stream administrator User Source D...

set heading off verify off feedback off echo off term off linesize 200 wrap on spool c:\temp\Recreate_Users.sql SELECT distinct 'create ...