Quick one about Standby database

I've read that Oracle does not advise (or may be support) to have a standby database on a plataform different to the original one. I have a database on Solaris and I'd like to create a standby for this db over HP. Can that be done? I KNOW IT'S NOT SUPPORTED. All I want to know is if anyone has

PCTFREE and PCTUSED

How can I calculate the values I should set PCTFREE and PCTUSED for a table that has already been created. can I use the statistics for that? thank you. Pablo ___ Do You Yahoo!? Yahoo! Messenger Comunicación instantánea gratis con

Re: PCTFREE and PCTUSED

I see, Charlie. Thanks for answering. I'm not trying to avoid chained rows, I think that Buffer busy waits may be ocurring in the header of this segment because the gap between the PCTUSED and PCTFREE might be too small. What I want is to check this and all tables as well and set this GAP

Re: PCTFREE and PCTUSED

Thanks for the answer ANJO, Besides that pcfree/pctused will determine when blocks are put on the freelist and when not. So probably what you want is multiple freelists to take care of single freelist contention. Let me ask you something about this. The problem of having a small gap between

How to know gap between PctUsed and PctFree

Hi list Is there a way to know the gap that exists, (in bytes) for each block of a table, between pctused and pctfree? THANKS ___ Do You Yahoo!? Yahoo! Messenger Comunicación instantánea gratis con tu gente.

free buffer waits DISK I/O

HI list. I was tuning a database (Oracle 7.3.4) that was waiting for free buffer waits mostly. I tuned DBWn batch size properly (increased it till 4MB) as well as buffer cache size (it's 600MB now) too and I got some improvement but I didn't get a major improvement. But some weeks ago, when we

Distribution of 4 DB in a Symmetrix Box -- URGENT

Hi everybody I've 4 DB (Oracle 7.3.4- HPUX- Filesystem based) that reside in a Symmetrix box. Sym disks are configurated as follows: 8 DISKS (36GB) RAID1, SO I SEE ONLY 4 DISKS 36GB 8 DISKS in RAID-S (2 RAID-S groups) I've done this distribution: 1st RAID 1 -redo (db1)

RE: Arch configuration -- I/O stuck

- From: Pablo ksksksk [mailto:[EMAIL PROTECTED]] Sent: Thursday, 1 November 2001 5:45 To: Multiple recipients of list ORACLE-L Subject: Arch configuration -- I/O stuck Hi list, Oracle 7.3.4 HP-UX log_archive_buffer_size=32 (redo log blocks = 1K) log_archive_buffers=4

Arch configuration -- I/O stuck

Hi list, Oracle 7.3.4 HP-UX log_archive_buffer_size=32 (redo log blocks = 1K) log_archive_buffers=4 Filesystem based (no direct I/O) I've been detecting that my box gets stucked eventually for some time. When this happens I can't do even a ls (it actually executes it but it takes

session_cached_cursors parameter

Does anyboby know how this parameter really works? Does it use PGA memory to cache parsed statements or it uses SHARED_POOL memory for that. If the case is the first one, imagine that cursor1 is flushed out from the Shared Pool, and the session A has it cached (in its PGA I assume), then, in

OPS: Where's the installer

!! Please do not post Off Topic to this List !! Hi again I've got Oracle 8.1.6 EE for AIX. I run the installer but I don't see any option named Parallel Server Do I have the correct CD? Where is OPS? TIA ___ Do You Yahoo!?

Stripe size for RAID 0+1

!! Please do not post Off Topic to this List !! Hi AIX 4.3 and Oracle 8, OLTP system. db_block_size=8K The question is: What stripe size should I use to configure the RAID 0+1? and why? TIA ___ Do You Yahoo!? Yahoo!

RE: Where's the installer

!! Please do not post Off Topic to this List !! Hi Brian and Gerardo: But in this case, after installing the product and creating my database I execute: select * from v$option; And I see this: ... Partitioning TRUE Objects

RE: Stripe size for RAID 0+1

!! Please do not post Off Topic to this List !! Thanks Christopher, I haven't installed the application and database yet ! so I can't do any monitoring. I think that I could start with a standard value and start monitoring from there. My question is, what would it be that value? (I

RE: Stripe size for RAID 0+1

!! Please do not post Off Topic to this List !! Hi Christopher: 32K, 64K is good safe bet, you have write-back caching controller? I don't know yet, but I'll find it out. Thanks for the paper Deshpande ___ Do You Yahoo!?

OPS instalation - pretty urgent

Hi it's the first time I'm going to install an OPS (Oracle 8.1.6 and AIX 4.3). What things should I take care of? (patches, some tips, etc) Where can I find some documentation (besides Oracle Concept Manual), can someone point me good docs? TIA

RE: How can I read this dump

Henry, Cristopher thanks for the answers ___ Do You Yahoo!? Yahoo! Messenger: Comunicación instantánea gratis con tu gente - http://messenger.yahoo.es -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

RE: OPS instalation - pretty urgent

Sorry I forgot to ask this one too: In the manual says that one OPS advantage is High Avaiability, now, in a client-server application,if node1 goes down, how do clients that ussually connect to node1 access the DB now? How do they know that node1 is down and that now they have to connect

RE: OPS instalation - pretty urgent

Hi Mladen Thanks for the answer. I'm already doing some reading... I'd like to ask you some questions about your answer Here I go. Please be nice if I'm wrong 1)Log threads have to be private to each instance, right? there's no Public thread I think. 2)Is it usual to use PUBLIC rollback

How can I read this dump

Hi list I've done a sql_trace_in_session of a user process and I'm getting a big dump. I'm just curious about this line in particular: PARSE #34:c=7,e=8,p=0,cr=8,cu=2,mis=1,r=0,dep=0,og=3,tim=1236949953 What does tim mean? How can I read it? TIA

Theorical question about DBWR and Buffer Cache lists

Hope someone can answer this one. I'd just like to know how many lists are there in the SGA to administrate the buffer cache? (LRUW, LRU, hash chain list, etc) And how are they used by the DBWR ? TIA ___ Do You Yahoo!? Yahoo!

Re: Performance analysis (enqueue and buffer busy waits)

Enqueue waits cannot cause buffer busy waits, but the absence of indexes (and you point out missing FK indexes) can result in excessive tablescanning, and tablescanning can result in buffer busy waits. Jonathan Lewis Hi Jonathan, thanks for answering. there's something I'd like to know, hope

Performance analysis (enqueue and buffer busy waits)

Hi list: I've been analyzing an instance's performance for some time. I found a lot of enqueue and a lot of buffer busy waits. Tracing the instance's sessions for some time I found that enqueue waits are mostly because of FK not being indexed. This of course generated shared locks (level 4)

Re: Performance analysis (enqueue and buffer busy waits)

Hi Deepak: thanks for answering, I've already identified the objects incurring into BBW but I also know that the p3 parameter for the BBW is 0 !! (this means that the session A had to wait because the block that session A needed, was being read from disk to Buffer Cache by session B). I

Some other Oracle list

I'd like to subscribe to another list too. Does anyone know if there's some other list as good as this one? thanx ___ Do You Yahoo!? Yahoo! Messenger: Comunicación instantánea gratis con tu gente - http://messenger.yahoo.es -- Please

Re: Some other Oracle list

Thanx everybody. Does anyone know if Steve Adams and Gaja are still on this list, I haven't seen any answer from them in the last month and I quite enjoy their answers. I learn a lot from them. thanx Pablo ksksksk wrote: I'd like to subscribe to another list too. Does anyone know

How does Oracle store NUMBER datatypes internally?

Can someone point me a document or something that explains how does Oracle store NUMBER datatypes internally? TIA ___ Do You Yahoo!? Yahoo! Messenger: Comunicación instantánea gratis con tu gente - http://messenger.yahoo.es -- Please

test -- please ignore

___ Do You Yahoo!? Yahoo! Messenger: Comunicación instantánea gratis con tu gente - http://messenger.yahoo.es -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Pablo=20ksksksk?= INET:

How many lists are there in the buffer cache?

Hi list, I'd like to know how many lists are there in version 8.1.7 in the buffer cache that control buffer's aging. And how does server processes and DBW0 interact with them. TIA ___ Do You Yahoo!? Yahoo! Messenger: Comunicación

Buffer Cache Lists and DBWR

Hi List, I'd just like to know exactly how many lists are there in the SGA to administrate the buffer cache? (LRUW, LRU, hash chain list, etc) And how they are used by the DBWR. thanks a lot. ___ Do You Yahoo!? Yahoo! Messenger:

Public Synonyms Performance

HI all, I think someone ask this question before, but I don't have any mails about this. What are the performance implications in the use of PUBLIC synonyms ? (What about private synonyms?) How does Oracle resolve internally a public synonym use? TIA

Fwd: RE: Would you increase the shared pool? --URGENT

syntax for the same SQLs. Is there another way to check this ? TIA --- Pablo ksksksk [EMAIL PROTECTED] escribió: Fecha: Tue, 29 May 2001 22:19:09 +0200 (CEST) De: Pablo ksksksk [EMAIL PROTECTED] Asunto: RE: Would you increase the shared pool? --URGENT Para: Steve Adams [EMAIL

RE: Would you increase the shared pool? --URGENT

://www.christianity.net.au/ -Original Message- From: Pablo ksksksk [mailto:[EMAIL PROTECTED]] Sent: Friday, 18 May 2001 2:01 To: Multiple recipients of list ORACLE-L Subject: Would you increase the shared pool? --URGENT Hello Gurus, I need help in this performance issue. Oracle 7.3.4 HPUX

Index Block Dumps

Hi list, Oracle 7 // HP-UX How can I generate an Index Dump? And how can I read this data? TIA ___ Do You Yahoo!? Enva mensajes instantneos y recibe alertas de correo con Yahoo! Messenger - http://messenger.yahoo.es -- Please

Re:v$session and v$process -- Simple one

Thanks Dick, may be your right, it could be the same user (same unix pid) with two sessions. thanks again --- [EMAIL PROTECTED] escribi: Looks to me like you've either got two users connected to the database from Windows or one user with two sessions. And if I'm not totally mistaken I

v$session and v$process -- Simple one

Hello List, I've a simple question. Why do I see this output when I execute the following query: SQL l 1 select a.USERNAME,a.SPID "unix pid",b.SID,b.serial#,b.osuser,b.program,a.program 2 from v$process a, v$session b 3 where a.spid='unixpid' 4* and a.addr=b.paddr SQL USERNAME

RE: Enqueue waits

u can find it at http://www.evdbt.com/event.pdf @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message----- From: Pablo ksksksk [mailto:[EMAIL PROTECTED]] Sent: Thursday, 5 April 2001 0:26 To: Multiple recipients of list ORACLE-

library cache load lock latch

I've some waits on this latch. I've read that a sesion has to get this latch for a database object (always in exclusive mode) in order to LOAD this object (to the LC I assume). And when this latch is busy the session has to wait on the "library cache loda lock event" Does anybody know what can

DBMS_JOB -- urgent !!!

Hi list, I need to cron a job every day at 10pm except sundays, how do I acomplish this ? I need the INTERVAL field. I also need to cron another job every day except sundays an saturdays too, can you please help me with this? thanks in advance.

obj$ table -- type column

Just a simple question. what does represent the column "type=11" and "type=0" from obj$ table? I know what these numbers mean: 1 = index 2 = tables 3 = clusters 4 = views ... up to ... 9 = packages 12 = triggers But what do the other numbers mean?

RE: Scripts -- Scripts -- Scripts (One more time)

Thank you all people. Greetings ___ Do You Yahoo!? Enva mensajes instantneos y recibe alertas de correo con Yahoo! Messenger - http://messenger.yahoo.es -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

RE: Scripts -- Scripts -- Scripts

Thanks Chana, your scripts are great Thanks Mark, I already know Steve Adams' site, the problem is that the kind of scripts I'm looking for are not there. I need simple scripts that generate table creation commands, procedure creation, etc.. TOAD does it, but I need the scripts !!! thanks

Scripts -- Scripts -- Scripts

Hi List, Does anyone have some sql scripts to share that shows things such as table structure, index structure, triggers (their code), procedures code, etc. I'm on a migration and I want to make sure I'm not forgetting anything. Any help would be appreciated. Thanks