Finding the session causing compile to hang

trying to be able to identify sessions that hold the lock/latch on a stored procedure so I can kill them when sometimes the session is disconnected and just hangs. Thx, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David Turner INET: [EMAIL PROTECTED] Fat

memory swapping and rollback

help performance in any way. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

applying transactions

in the destination table, then all deletes, and then the remaining inserts but thought I should just send an email to see if someone had a better way of getting me the transaction rate I need, about 1000 rec/s. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David

Re: applying transactions

-0700, [EMAIL PROTECTED] wrote: If you're on 8i+ you can use bulk loading. It could save you a lot of time on large loads such as this. Jared David Turner [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/11/2003 04:04 PM Please respond to ORACLE-L

Re: applying transactions

On Wednesday 11 June 2003 19:20, David Turner wrote: NP, yeah I've used bulk binds and they're great but I wish they offered conditional logic within the forall statement. If I could perform conditional logic or assignment of values to variables within the forall it'd really make my life easier

Re: perl timeout

database. The goal is to fool the listener into thinking the database is still up, and creating a server, which should then hang. It's worked for me in the past, but not always 100%. May take a few tries. Jared David Turner [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01

Re: perl timeout

, AutoCommit = 0, } ); }; # the alarm reset must be outside the eval{} alarm 0; I say untested cuz I simplified it a bit after lifting it from a script. HTH, Jared On Monday 13 January 2003 15:49, David Turner wrote: Does anyone have some perl code

Re: perl timeout

, but not always 100%. May take a few tries. Jared David Turner [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/14/2003 10:46 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re

perl timeout

seconds. Any other suggestions are appreciated. Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

Alteon and Oracle

Would someone send me some pointers to using load balancers such as and Alteon and Oracle for serving up primarily readonly data? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- 858

flushing the shared pool

anything. Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

renaming host

applications connecting using the new name. Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Streams

://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

Failover

out failover does not occur. Has anyone had any experience with this and a solution? Thanks, Dave Turner -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

trace file removal

not recreated them so I couldn't get all the info I needed. Thanks , Dave Turner -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

purge log issues

: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself

Classes

ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

Reading dbf files

to help them with this and get my foot in the door for more projects like setting up backups:) I believe it is all of the clients documentation for the last 3 years. Oops:) Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL

dbms_jobs

to finish how can you see how many jobs have queued up? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

DBMS_JOB

dbms_job.broken(job = 359, broken = FALSE, next_date = to_Date(to_char(trunc(sysdate+1) , 'DD-MON-') || ' 02:00:00', 'DD-MON- HH24:MI:SS')); Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- (858

Re: advanced queuing

can contribute their experiences. HTH, -- Anita --- David Turner [EMAIL PROTECTED] wrote: Thanks, yes I spoke with a guy that said they were replicating 250 transactions a second using AQ, which sounded fishy. I have heard of 800 transactions per minute on Oracle as being high

Advanced Queues

I just started looking into Advanced Queues and I'm wondering what types of apps they're used for? What would be their biggest advantage? Dave Turner -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services

advanced queuing

Is anyone out there using advanced queuing for replication? Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

recovery - no backup:)

. Thanks, Dave Turner -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

9i standby

Anyone know if the standby in 9i can be in readonly mode while the logs are being applied? I've heard about this as being the case and also that this isn't the case. Thanks, Dave Turner -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL

Re: 9i standby

: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list

Procedural Replication

. Thanks, Dave Turner -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Interesting query

but it would be cool to know if I can do this on the database side also. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: determining when a refresh has completed

it completed and to how long the refresh actually took. Until then, a workaround is to create your own PL/SQL wrapper to call the appropriate refresh routine and then afterwards populate a table or log with the current time. HTH, -- Anita --- David Turner [EMAIL PROTECTED] wrote

determining when a refresh has completed

Anyone know of the top of their head where I find when a snapshot's refresh completed? I looked at total_time in dba_jobs but this appears to be cummulative. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City

Dumping tables using perl

what is in the field. How should I delimit the file, and can I use sql loader to load the lob info? I've used sqlloader for everything but lobs fine. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network

Re: historical data

Information Services http://www.superpages.com -Original Message- From: David Turner [SMTP:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 5:17 PM To: Multiple recipients of list ORACLE-L Subject:historical data We have to role off partitions of data every

Re: historical data

for your needs. UTL_FILE will probably not work for this due to buffer limitations. Jared On Monday 21 May 2001 15:17, David Turner wrote: We have to role off partitions of data every week and I am writing a script to write the data to comma separated files using utl_file. What I

set term off

://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from

Re: parallel load performance

to load is striped across. Jared On Friday 27 April 2001 04:15, David Turner wrote: I'm getting slower loads using parallel than a serial load. I set up a test case and am pasting it for you to see what I am doing wrong. I'm on a Sun 220R, 2 CPUs, 2 GB Ram, 50GB Raid 5 with Veritas

parallel load performance

FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

Virtual circuits

Bond's watch was cool... http://www.tellme.com Call 1-800-555-TELL for stocks, sports, news... much more! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

SQLTrace

ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

alter session over database link

James Bond's watch was cool... http://www.tellme.com Call 1-800-555-TELL for stocks, sports, news... much more! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

report.txt

... http://www.tellme.com Call 1-800-555-TELL for stocks, sports, news... much more! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California