Oracle Apps DBA

Atif Shaikh M.C.S, Pune

Pages

Home
DBA Monitoring Scripts
Privacy Policy
Contact

Contact

atifapps@gmail.com

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

No comments:

Contact Form

Name

Email *

Message *

Popular Posts

ORA-28001: the password has expired (DBD ERROR: OCISessionBegin).

A. Verify if the password is expired. 1.select username,ACCOUNT_STATUS,EXPIRY_DATE from dba_users where username='DBSNMP'; US...
Killing the Inactive forms sessions running for more then 12 hrs

-- Session Killing script--be carefull set pages 200 select 'alter system kill session '''||sid||','||serial#||...
find tablespaces consuming more then 85% space

. ./test.env sqlplus "/as sysdba" set lines 999 set pagesize 999 select tablespace_name, ROUND(bytes_free,2) "Free Space ...
Find inactive forms/toad sessions running for more than 12 hrs

-- Script to identify FORM / TOAD session running for more than 12 hrs ---- set heading on set line 9999 set pages 9999 col status for a...
How to enable a trace for a concurrent program

Login as Sysadmin -> System Administrator -> Concurrent : Program -> Define Press F11 -> Enter the COncurrent Program Name (Eg....
oracle Apps DBA important scripts

The queries mentioned here are for my own purpose , please ensure and be careful before executing any DDL or delete script 1.Database S...
Oracle APPS Basics

What is .dbc file , where its stored , whats use of .dbc file ? dbc as name says is database connect descriptor file which stores database...
R12

In this post I am going to cover R12 architecture. Discernible change from its predecessors is INST_TOP. R12 file system has come up with ...
Usefull daily activities commands

alter system kill session '2405,2664'; find / -name "*.system.log" $Header bomstrc.odf 115.19.115102.3 2005/12/14 21:19...
find the details of concurrent requests from request id

set linesize 900 column RESPONSIBILITY_NAME format a30 column USER_CONCURRENT_PROGRAM_NAME format a30 column MACHINE format a10 column ...

Blog Archive

▼ 2012 (1)
- ▼ July (1)
  - oracle Apps DBA important scripts

► 2011 (14)
- ► May (2)
- ► April (4)
- ► March (8)

About Me

Atif Shaikh: M.C.S,Pune

View my complete profile

Pages

Contact

No comments:

Post a Comment

Blog Archive

About Me