Re: Problem doing RMAN backup of Clone?

you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

Problem doing RMAN backup of Clone?

Someone has just told me you can't do an RMAN backup of a clone because it has the same database id as the original. Is this true or not? If so, how to get around it? Thanks, Doug -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: [EMAIL PROTECTED] Fat

sniffing bequeath connections

network volume on the same box? Any ideas? I want to project volume over a switch if they are separated. Thanks, Doug -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

using Net8 through NAT router

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

temporary tablespaces using temp files .. extents?

://www.orafaq.com -- Author: Doug C 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: diagnosing latch free

' temporary tablespace to that permanent tablespace. HTH, -- Anita --- Doug C [EMAIL PROTECTED] wrote: Ok.. it's a sort segment latch.. any way to find out why? It's been sitting around for over an hour ... On Sat, 08 Dec 2001 14:35:18 -0800, you wrote: oops, probably only want

diagnosing latch free

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

Re: diagnosing latch free

, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. On Saturday, December 8, 2001, at 04:05 PM, Doug C wrote: I have a session that seems to be hung on a sql_statment. Here is it's

space used by pinned objects

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

Re: poor parse/execute ratio.. next steps?

and found that there were a few cases, blatent, that bind variables weren't being used. What's the next step? Increase the shared pool? Is there any way I can monitor how often statements are being aged out? Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C

ok..this is funny.. how do you pronounce tuple

Write out of good old relational theory.. So is it (too pul). or (tuh pall).. Thanks, D. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: why shrink rollback segs?

with the balancing act of trying to make them as small as possible without introducing 1555's hth connor --- Doug C [EMAIL PROTECTED] wrote: Thanks.. makes sense... Can I use x$bh or something to determine whether it's nicely squeezed into the buffer at some point in time? On Mon, 12 Nov 2001 02:00

Re: good workaround for a ORA-2016?

the values into a array of number or something. Or, possibly someone else has a better idea.. Thanks, Doug -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Re: blowing out rollbacks on select statements?

SQL COMMIT; Commit complete. SQL SELECT t.xidusn, t.used_ublk 2 FROM v$transaction t, v$session s 3 WHERE t.ses_addr=s.saddr AND s.username='SYSTEM' 4 / no rows selected --- Doug C [EMAIL PROTECTED] wrote: This is Oracle 8.1.7 - Unless I'm getting bad information

Re: blowing out rollbacks on select statements?

is finished, hence the ORA-1555. I would investigate increasing rollbacks at the remote and/or setting optimal to prevent shrinks. Jared Doug C

Re: good workaround for a ORA-2016?

: Doug C 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, send an E-Mail

Re: sequence pool

by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

How can I tell if a procedure/package is running?

How can I tell if a stored procedure or package is in the middle of execution? (for lack of doing what it does)..I've heard of parse locks, is that a way? Thanks, D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: [EMAIL PROTECTED] Fat City Network

perplexing plan?

-- Author: Doug C 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, send

Re: perplexing plan?

bericht- Van: Doug C [mailto:[EMAIL PROTECTED]] Verzonden: vrijdag 5 oktober 2001 16:30 Aan: Multiple recipients of list ORACLE-L Onderwerp: perplexing plan? I'm a little perplexed by this query and it's associated plan. It's also a big performance problem. The problem is the 35 million row table

Windows 2000 pro packet writer errors ?

kinds of issues with Win2Kpro SP2 with packet writer failures or where we can adjust various TCP/IP parameters in Win2K registry to assist in sychronizing what clearly is some sort of repeating blip.. Thanks, Doug -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C

Re: need an 8.0.5 client and an 8.1.7 client on same machine

4.0. Some apps use the 8.1.7 client and some will require the 8.0.5. Any suggestions before I start the surgery? Thanks, Doug -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: [EMAIL PROTECTED

need an 8.0.5 client and an 8.1.7 client on same machine

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

re-link after new kernel extension loaded for different Oracle Home?

and wouldn't be involved in relinking but What do you all think? Relink in this situation? Always? Sometimes? Thanks, Doug -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

one file being relinked in wrong ORACLE_HOME

and found all settings properly referring to this 8.1.7 home. One file however, libagtsh.a, which exists in the 8.1.7.1 home/lib directory, now shows that it is timestamped at the time of this relink. Any ideas? Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C

Waiting for Type 4 lock

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

Re: Permissions on dump logs

Avrami -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

Help! ORA-00164 - autonomous trans problem in 8.1.7 NOT in 8.1.5

FAQ: http://www.orafaq.com -- Author: Doug C 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