Thursday, November 11, 2010

Clear Temporary tablespace

›
1) CREATE TEMPORARY TABLESPACE temp2 TEMPFILE 'E:\SNSD1011\TEMP02.ORA' SIZE 5M REUSE AUTOEXTEND ON NEXT 1M MAXSIZE unlimited E...
Wednesday, October 6, 2010

When to Rebuild an Index?

›
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 ...
Friday, September 24, 2010

Corrupted OEM Recreation Error

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

IDLE Session > Sniped Session > Kill > Release Resource

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

User Session Monitoring

›
-------------------Sniped idle session-------------- SELECT DECODE(TRUNC(SYSDATE - LOGON_TIME), 0, NULL, TRUNC(SYSDATE - LOGON_TIME) || ...
Wednesday, September 8, 2010

Listener.log Cleanup

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

LOG_ARCHIVE_MAX_PROCESSES

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

ORA-12518: TNS:listener could not hand off client connection

›
Connection is break again and again and showing following error Error ORA-12518: TNS:listener could not hand off client connection ---------...
Friday, September 3, 2010

MySQL with Oracle SQL Developer

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

Oracle User Login / Error Email Notification

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

DPI and security Enable for IE

›
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...
Friday, August 27, 2010

Delete file from date

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

Oracle Streams Replication

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