Database Administrator

Following Steps to perform. SYSAUX tablespace SELECT *  FROM dba_jobs WHERE SCHEMA_USER='SYSMAN'; SELECT *  FROM SYSMAN.mgmt_m...

If user does not logout properly / kill task / services restarted then record of that user will present in tblrklogindetails table. We...

BEGIN   DBMS_SCHEDULER.create_job (     job_name        => 'Test',     job_type        => 'PLSQL_BLOCK',     job_...

1)      Recycling Application Pool Daily they have to restart IIS to clear the application pool. An application pool is a set of...

Improve windows networking (especially if hosting webservers) First of all, I forgive you for having to use windows to host your w...

Create Oracle External users in Windows 1. Create the Windows user: start --> settings --> control panel --> administrative to...

1. Start a sqlplus session to the database, and enable sql tracing with this command: alter session set events '10046 trace name co...

We will need to trace a connection on both CLIENT ,SERVER and Listener endpoints to see what is happening. Please collect traces for the ...

set pagesize 0 set linesize 30000 set long 500000 set longchunksize 500000 set trimspool on set feed off ------------Drop Database...

ORACLE 11G work with IPv6 addresses in addition to IPv4 These are the simple steps that will make your DB 11g instance work with IPV6 env...

in 11g UTL_INADDR.GET_HOST_ADDRESS gives me IPv6, while I need IPv4 SELECT  UTL_INADDR.GET_HOST_ADDRESS  FROM DUAL; disable ipv6 on OS ...

ORA-12839: cannot modify an object in parallel after modifying it Affects: Product (Component)  Oracle Server (Rdbms) Range of versi...

Resolving common Oracle Wait Events Wait Event Possible Causes Actions Remarks db file sequential reads Use of an unsel...