Database Blog

Enabling HTTP Header Trace from Firefox

Live HTTP headers is a public add-in for Mozilla browsers that captures HTTP information during navigation, including URLs, cookies, and other headers. Information gathered using this tool can be saved…

Read More

Enabling HTTP Header Trace from Internet Explorer

HTTPHeaders is an Explorer Bar for Microsoft Internet Explorer that will display the HTTP Headers sent and received by Internet Explorer as you surf the web. It can be useful…

Read More

Enabling IAS debug in R12 Applications

1. cd $ORA_CONFIG_HOME/10.1.3/j2ee/oacore/config 1. vi oc4j.properties 2. Add: values AFLOG_ENABLED=true AFLOG_LEVEL=statement AFLOG_MODULE=% AFLOG_FILENAME=/tmp/1.log 2. Copy the $INST_TOP/ora/10.1.3/Apache/Apache/conf/httpd.conf to a backup file. 3. Edit the $INST_TOP/ora/10.1.3/Apache/Apache/conf/httpd.conf and change Apache to run…

Read More

Procedure for generating the DDL statements of the database objects.

There are two parameters used in the specified object,   1. Object Type        ==> eg: FUNCTION,PROCEDURE,PACKAGE,TABLE,VIEW etc., 2. Directory Name  ==> Specify the directory name where the output to be…

Read More

How to Tell if the Oracle Software is 32-Bit or 64-Bit

How to find if the Oracle Client Software is 32-Bit or 64-Bit ? here you can have some ways to find it. You can find whether Oracle Client Software is…

Read More

Data Guard Log Shipping Fails With Error Ora-16191 In 11g

Issue: PING[ARC1]: Heartbeat failed to connect to standby ‘STANDBY’. Error is 16191. Sat Aug 06 02:06:52 2011 Error 1017 received logging on to the standby ———————————————————— Check that the primary…

Read More

REP-3000: Internal error starting Oracle Toolkit

Issue: Recently we had issue with Concurrent requests which having print format of PDF or XML, and the exact error is “REP-3000: Internal error starting Oracle Toolkit” Solution: 1. Log…

Read More

Provides a report on the top segments (in bytes) grouped by Segment Type

— +==================================================================+ — PURPOSE: Provides a report on the top segments (in bytes) grouped by Segment Type — +==================================================================+ SET LINESIZE 155 SET PAGESIZE 9999 SET VERIFY   OFF BREAK ON segment_type…

Read More

To check for index fragmentation

 — +——————————————————————————+ — | PURPOSE  : To check for index fragmentation. As a rule of thumb if 10-15%  | — |            of the table data changes, then you should consider…

Read More

Backup Schedule Template

Read More