RE: a PL/SQL design question.

Thanks a lot ! -Original Message- Sent: Thursday, November 28, 2002 8:04 PM To: Multiple recipients of list ORACLE-L Andrey Bronfin wrote: Dear gurus! I'm looking for a solution to the following problem: I need a way to run a certain stored procedure as soon as a record is inserted

RE: a PL/SQL design question.

Hi ! The problem with this solution is that the row, inserted into my table, will be committed (i.e. seen by other users) only after the completion of the stored procedure called by the trigger. Thanks a lot ! -Original Message- Sent: Thursday, November 28, 2002 9:09 PM To: Multiple

Re: Error on the ORACLE-L list

From home I use kmail on SuSE linux 7.1, and occasionally Pine. Funny, my virus problems are always at work on Windoze. ;) Bruce has to constantly work on the virus protection for the FatCity servers, so a glitch now and then is to be expected. Jared On Saturday 30 November 2002 17:53, Jeff

Re: Views Resources (7.3.4 DB)

Lisa R. Clary wrote: I have 3 individual views (average #records=76,000) with the exact same variable names and datatypes. There is another view that is the union of the 3 individual views. If I use a count(*) operation (in sqlplus) on the view that is the union (or the individual view), I

Re: Views Resources (7.3.4 DB)

Thanks for the input. The individual views are pretty complex , so I will try to reorganize starting from a combined view. I do want try the union all with an outer select distinct to remove duplicates to see if that will help. thanks again, lc - Original Message - To: Multiple

Shared Pool Size

Dear all DBAs, My Oracle 8.0.5(running on Linux 6.4 kernel 2.2.14) is getting slower recently. Every data input output is slow. And the "Server Stat" in Toad showing: Library Cache Get Hit Ratio 51.5540 "May need to increase DB_BLOCK_BUFFERS" Library Cache Pin Hit Ratio 93.6161 "Shared

Win2000 vs. Unix

A few weeks ago someone (I think it was Jared) was looking for the pro's/con's of Win2000 vs. Unix for a SAP back-end. I'm not a WinDoze basher but I do prefer to have larger back-end systems on Unix. I came across the following links this weekend that help support some of the my feelings and

Oracle 9iR2 on Red Hat 8.0

If you've installed Oracle 9i on RH 8.0, please let me know. Also, please let me know of any difficulties and workarounds you may have encountered. Just put a new 40Gig HD in my laptop, and wondering if I can install RH 8.0, or should use 7.2. Thanks Jared -- Please see the official

Re: Shared Pool Size

First what's the db_block_size ? Anyway try to increase db_block_buffers = 5000 --- shuan.tay\(PCI¾G¸R³Ô\) [EMAIL PROTECTED] wrote: Dear all DBAs, My Oracle 8.0.5(running on Linux 6.4 kernel 2.2.14) is getting slower recently. Every data input output is slow. And the Server Stat in

Re: Shared Pool Size

db_block_size is 8192 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 02, 2002 1:48 PM First what's the db_block_size ? Anyway try to increase db_block_buffers = 5000 --- shuan.tay\(PCI¾G¸R³Ô\) [EMAIL PROTECTED] wrote: Dear all