Log buffer and Shared Pool tuning.

What are the things I should monitor to make sure that Shared Pool and Log buffer are set correctly. On one database I have Shared pool GAB and Log buffer MOB, are these values too high. Thanks DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed,

RE: Unix process tree

Title: Unix process tree Thanks mate! -Original Message-From: Tanel Poder [mailto:[EMAIL PROTECTED]Sent: Tuesday, 5 August 2003 10:19 p.m.To: Multiple recipients of list ORACLE-LSubject: Re: Unix process tree Redhat AS 2.1 at least has something, probably others as

Snapshot too old in undo tablespace in 9i?

Title: Message Hello Group, I just upgraded a database to Oracle 9.2.0.3 from 8.1.7. I created an undo tablespace with 10 (default) undo segments... however, during an export I got the following message: ORA-01555: snapshot too old: rollback segment number 15 with name "_SYSSMU15$" too

RE: URGENT: Trying to duplicate database from cold backup - auxi

Paula - Okay, when you say you brought the database down, copied the files, etc., I presume that had nothing to do with RMAN? You didn't mention RMAN in that post, but your original post was all about RMAN. -Original Message- Sent: Tuesday, August 05, 2003 10:19 AM To: Multiple recipients

RE: Q. To RAC or go vertical

Matt, Brad, Group, Another Bite. My opinion on RAC (after limited nr of trials), I did read Mogens and loads of other articles, ppts etc... The arguments in favour of RAC are : - Scalability (scale out, rather then forklift) - flexibility (capacity on demand, increase and Decrease) -

snapshot too old errors on an analyze table?

What gets me here is that there are no other transactions occurring using that table. Now there are alot of other long running transactions occuring at that time, but they do not involve the table that was being analyzed. any suggestions on what to check for? -- Please see the official

RE: Opatch

I've now gotten opatch to report its version. I had to get the right combination of the perl executable and perl5 libraries. I expect the patch will install tomorrow. I too ended up using per5005_03. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original

RE: FW: your account aacaogro

Joe Testa scribbled on the wall in glitter crayon: linux, you want me to do what with this file? :) i got it too. joe me three. about 6 times so far. might have gotten passed from here, i'm looking at things now. -- Bill Shrek Thater ORACLE DBA BAARF Party member #25

RE: RMAN Script Question

Title: RMAN Script Question David, I have a set of scripts which do various rman backups that I would be happy to send you if you send me your email address ( no attachments to the list). They work because I use them every day. Ruth -Original Message-From: [EMAIL PROTECTED]

RE: More On 10G

I noticed that the new Oracle TPC-C benchmark was 10G ... if that means anything. -Original Message- Heard an Oracle rep last week say that 10G was mostly hype. If you want to watch what's for real at Oracle it's Linux. Only time will tell if he is right, but he has a better

Re: your account aacaogro

I got this e-mail but deleted it. Ken Janusz - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 06, 2003 9:19 AM OK, Who got infected?? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent:

Re: ORA-3113

left over memory segments/shared memory/semaphores? ipcs is your friend, oh and its destructive brother ipcrm :) joe [EMAIL PROTECTED] wrote: No, There is no log generated. Below is the only message I am getting. hp204:NAMES :/home/oracle svrmgrl Oracle Server Manager Release 3.1.6.0.0 -

OT: [stupid] vi question

Suddenly my vi editor is showing ^M at the end of each line. How do I get rid of it? Thanks in advance, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

RE: [stupid] vi question

Type : (to get the command prompt at the bottom of the screen) Then type %s/^M// and press enter. Note that you get ^M by pressing Ctl/V followed by Ctl/M. Regards, Mike Hately -Original Message- Sent: 06 August 2003 17:09 To: Multiple recipients of list ORACLE-L Suddenly my vi

RE: Can't insert into partition

Dennis, Could you plese post the v$session_wait. Do you have a 10046 trace? Henry -Original Message- DENNIS WILLIAMS Sent: Wednesday, August 06, 2003 11:40 AM To: Multiple recipients of list ORACLE-L We have a situation where a process can't insert into a partition of a partitioned

Re: More On 10G

Disney version. Andersen's story rarely end well. Mladen Gogala wrote: You are definitely reading writings of Hans Christian Andersen. -- Mladen Gogala Oracle DBA -Original Message- Boivin, Patrice J Sent: Wednesday, August 06, 2003 1:34 PM To: Multiple recipients of list

Re: OT : Learning curve

I have two or three of Tuftes more well known books. For anyone that creates presentations with graphics, these are a must have. For anyone that feels stupid because they can't understand someone else's charts in an power-point presentation, these are a must have. Hint: It ain't you. It's

RE: Consolidating Servers

Agree. The fewer variables you change the easier it is to figure out what is going wrong. Now depending on the OS that your migrating to you may well have to change block sizes. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, August 06, 2003

RE: Q. To RAC or go vertical

RAC - Intel is not yet proven as far as I can tell. So be very cautious about choosing this path for such a large project. I would probably stick with the big box and concentrate on as fastas IO as possible. No wait please do the RAC with Intel quads, figure out all the bugs and pitfalls

RE: ORA-3113

Did you relink sqlplus? Did you relink client? -Original Message- [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 06, 2003 11:29 AM To: Multiple recipients of list ORACLE-L Applied 250 OS patches on HP-UX 11.11 server and after that getting ORA-3113 error message every time I do

RE: Can't insert into partition

Henry - Thanks. I feel like I'm getting an education today on the Oracle Wait Interface today. Nothing like a live problem for everything to make sense. Thanks for pointing out that I could find the table. It is our WKLYJOBFACT table. Not one we suspected. We have been doing an EXPLAIN PLAN

RE: Can't insert into partition

Dennis, If I understand your question correctly, ... Your 10046 trace file will contain the execution plan that the PL/SQL procedure is seeing, if you let the process close the cursor before you shut off the trace. I think you can also get the plan information you're looking for from the 10053

RE: What books recommended for Data Modeling ?

--_=_NextPart_001_01C35C00.634E5820 Content-Type: text/plain; charset=windows-1256 The most important part of working with databases... Have a look at 'Oracle Design', Dave Ensor Ian Stevenson. But if you have not already, I would urge you to attend a training course. It is a complex,

RE: 9i - Dynamic SGA - SGA_MAX_SIZE

Because you are still using db_block_buffers in init.ora file.. - Kirti --- Roger Xu [EMAIL PROTECTED] wrote: Why I have db_cache_size set to zero in my database? SQL show parameter db_cache_size NAME TYPEVALUE

Re: Log buffer and Shared Pool tuning.

Avnish , As far as log buffer is considered , look at how much redo ur generating . That will be help you in finding optimal size of log buffer . -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 4:54 PM What are the

RE: RMAN Script Question

Title: RMAN Script Question David, I notice that u r using the line format 'data_full_%d_%U_%p_%c.bak' (database); in ur backup script when u r actually performing a database backup including archived logs backup. Try modifying the script as : resync catalog; run { allocate channel

ORA-29838 Error while installing 91R2 ?

Guys, I am installing Oracle 9.2.0.1 on Win2K Adv.Server/SP3. While database configuration asst. is creating the database,i get the error: ORA-29838 insufficient privileges to execute the operator(s) I found from docs that: Cause: User does not have privileges to execute one of the

RE: URGENT: Trying to duplicate database from cold backup - auxi

Paula - Now you've got my attention. Can you describe in more detail what you mean by editing backup controlfile. I use a backup controlfile to create test databases / validate RMAN backups, so this sounds like something I could use. Thanks. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch,

RE: Q. To RAC or go vertical

Thanks for the reply... Good comments all around (except for the monkey bit, I just had to use that...) I should let you know that we are actually dipping our big toe into the chilly RAC waters soon with a test lab system. Were purchasing a couple of boxes to go through the setup and do some

Re: What books recommended for Data Modeling ?

I have not heard installing hundred database instances on same server. Maybe you should think creating one instance, and then hundred schemas in it. Guang On Wed, 6 Aug 2003, Dilip Patel wrote: Hi All, Need some suggestions/Input. My application database is 8.1.7, NOARCHIVELOG, WIN200,

RE: More On 10G

That's 12X -- eXtreme databasing! (eXtra bangs added for eXtra emphasis) I just wish some software company -- ANY software company -- would get the bugs out before feature-creeping and bloating the hell out of a product. sigh Rich Rich Jesse System/Database

RE: drop user

Not Elizabeth Hurley ... :-))) !! -Original Message- Everything looks like a big hammer to you, doesn't it Stephen? ;) \ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services--

oracle 9 IAS

Any good book on oracle 9iAS for beginners which covers installation , configurations etc . There is too much in oracle docs . -Ak