Hi Raja,

So, there is no problem with the dbms_pipe functionality, it is creating
issues when you are inserting into the target table. What type of contention
are you finding ? If this is the case, then here are a few things to
remember.

1. Size your pctfree, pctused clauses appropriately since this target table
is getting a lot of inserts.
2. Check for any freelist contention. If there are freelist contention, you
can look at creating more freelist groups / freelists.
3. Are there a lot of indexes on this target table ?
4. Check for the I/O rate on this system by using OS utilities (for eg. on
Unix you can use iostat, vmstat commands) to see if there is any contention
at the OS level.

HTH,

Best Regards,
Dhilip Ranganathan.

-----Original Message-----
From: Rajamanikandan, N.V. [mailto:[Email Address Removed] Thursday, March 28, 2002 4:13 PM
To: 'Ranganathan, Dhilip'; Rajamanikandan, N.V.; LazyDBA.com Discussion
Subject: RE: dbms_pipe(Urgent)


Hi Dhilip,

Production site running in Oracle 8.1.6.
The frequency is quite often. for e.g Exceptions handled via DBMS_PIPE
package. All on-line
transactions and batch transactions are posting erroneous records into a
common table using
DBMS_PIPE package. Since the traffic is very huge, target table is facing
lot of contention.


With Regards,
Raja

-----Original Message-----
From: Ranganathan, Dhilip [mailto:[Email Address Removed] Thursday, March 28, 2002 3:03 PM
To: 'Rajamanikandan, N.V.'; LazyDBA.com Discussion
Subject: RE: dbms_pipe(Urgent)


Hi Raja,

What is your database version? What is the frequency in which you read from
the pipe ?

Regards,
Dhilip Ranganathan.

-----Original Message-----
From: Rajamanikandan, N.V. [mailto:[Email Address Removed] Thursday, March 28, 2002 3:42 PM
To: LazyDBA.com Discussion
Subject: dbms_pipe(Urgent)


Hi All,

In our production site and development sites, we are using DBMS_PIPE package
to
pack all session's error messages. Particularly during peak hours,
most of the time either all the sessions are getting slow or getting hang.
We are now in a critical situation to come up with an alternative
queuing processes to handle all session's error messages.

Is there any other way to do this???
Situation is very urgent. Any suggestions or comments are greatly
appreciated


With Regards,
Raja

--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page