Re: Shared_pool

On Wed, Nov 06, 2002 at 04:34:28PM -0800, Jos Someone wrote: > > List, > > How do I find out how full my shared_pool is? -- Diagnosing and Resolving Error ORA-04031 Type: Note Doc ID: 146599.1 Understanding and Tuning the Shared Pool in Oracle7, Oracle8, and Oracle8i Type: Note Doc ID:

RE: RE: Oracle DBA with SAP Needed

I can't believe you people are talking about Toledo residents like this. It's disgusting. --Walt (Go Mudhens!) Weaver Bozeman, Montana -Original Message- Sent: Wednesday, November 06, 2002 5:08 PM To: Multiple recipients of list ORACLE-L I think the official term is "optimizing within

Help: ORA-980 raised if a PLSQL block references a remote public synonym

Title: Help: ORA-980 raised if a PLSQL block references a remote public synonym Hi, Oracle Version 9014 for Tru64 We are encountering the above problem which appears to be an instance of Bug 1698784 which Oracle claims was fix in 9013.  It does not occur for private synonyms.  Can anyone

RE: Shared_pool

Same way I figure out how full my septic tank is. Take the top off. --Walt Weaver Bozeman, Montana On Wed, Nov 06, 2002 at 04:34:28PM -0800, Jos Someone wrote: > > List, > > How do I find out how full my shared_pool is? -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

RE: Data Purging Strategy

Burnt mud ??? You're supposed to say peaty ! Or you could have said : Classic Glenmorangie, matured for 10 years in American white oak then finished in Sherry Butts. Light gold in colour, this product has a complex aroma — full bodied, sherry wine notes with traces of honey. Sherry and nuts are bot

RE: Oracle to Excel

Title: Oracle to Excel there is an ODBC driver you can set up to handle this as I recall.   hth.   mike -Original Message-From: Burton, Laura L. [mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 06, 2002 10:49 AMTo: Multiple recipients of list ORACLE-LSubject: Oracle to Ex

Performance tuning

I have a table in my application . This table gets all inserts during one procedure and select during other . Now if I make an index on this then the first procedure gets slow and if i drop the index then the second procedure gets very slow. Is there some solution to get out of this problem -- P

Re: Performance tuning

Perhaps you should consider disabling / dropping the index during the first procedure and then recreating it. You can use commands like 'execute immediate' within a procedure to issue DDL. Otherwise perhaps you can change the inserts to some kind of bulk insert - depending on how your application

RE: Performance tuning

This is where the balancing comes into picture. If it is a bulk Insert then definitely the performance would degrade to the extent that it has to create an entry in the Index at a particular place. If there are so many indexes on this table you should visualise them in such a manner that a concaten

RE: Performance tuning

Trace the slower procedure. Hit the 10046 paper on www.hotsos.com to see how. This sounds like maybe 'buffer busy wait' waits on the index are causing contention among the procedures. But you need to prove whether it is (and which block it is, if my guess is right) before you can take the right co

Sqlplus feedbk

Hi, Is it possible to change the feedback generated by sqlplus. e.g if a procedure xyz is compiled on sqlplus prompt.it gives message : procedure created . I want to change this to : procedure xyz created. Thanks Manoj. -- Please see the official ORACLE-L FAQ: http://www.orafaq

<    1   2