Re: Can someone please verify this for me?

2003-10-11 Thread Nuno Souto
- Original Message - I haven't tried using these before, but I do notice that your 'create role' syntax appears to be incorrect for this usage. Sorry for the late reply, folks. Rugby World Cup got in the way... :D Yeah, found out what the problem was after all. I assumed that

Re: any ever work with Use Cases to model a database?

2003-10-11 Thread Nuno Souto
- Original Message - What experiences have you had? If not what kind of requirements documents do you use? Im particularly interested in people who have worked on projects with relational back ends and object oriented front ends. It seems very difficult to get these two models to

Importing LOB segments

2003-10-11 Thread Joshua Becker
Hi there, I have been importin 2gig of LOBs and it is extremely slow, is there any way how to speed up this process... rgds jbHöstrusk och grå moln - köp en resa till solen på Yahoo! Resor

CBO and cartesian product

2003-10-11 Thread Dilip
Hi List, DB version - 8174. (Oracle Apps 11.5.4). One of the customized report started running very slowly. One query was taking more than 3 GB of TEMP tablespace for 'HASH' type segment and erroring out after 2 hours for a lack of space in TEMP. Tkprof showed that it is doing Cartesian Sort

Weblogic, thin driver and lob segments

2003-10-11 Thread Gunnar Berglund
Hi all, we are facing some serious problems with the following case: we have an application which stores quite a lot of documents to database (average document size is 2mb). Application loads document template from database and when we are having 100-200 hundred users there will be a queue on a

Re: Weblogic, thin driver and lob segments

2003-10-11 Thread Gaja Krishna Vaidyanatha
Hi Gunnar, Can you please turn on event# 10046 at level 8 and trace some of your sessions? You can then run 9i tkprof on the trace files, to determine the most expensive SQL statements, from a resource consumption and wait perspective. I am sure there is enough expertise on this list to figure

Re: CBO and cartesian product

2003-10-11 Thread Tim Gorman
Here is the short answer: = * Set OPTIMIZER_INDEX_CACHING to 90 * Make sure that DB_FILE_MULTIBLOCK_READ_COUNT is not overly high * Also, consider gathering column-level statistics on some of the indexed columns involved, especially if the query in question

Re: Weblogic, thin driver and lob segments

2003-10-11 Thread Stephane Faroult
Gunnar Berglund wrote: Hi all, we are facing some serious problems with the following case: we have an application which stores quite a lot of documents to database (average document size is 2mb). Application loads document template from database and when we are having 100-200 hundred

RAC and Standby Dr

2003-10-11 Thread Rajesh . Rao
Folks, A project team here is flirting with the idea of having standby databases for the two production RAC nodes. The two standy nodes will be at a DR site. Any gotchas with this configuration? Regards Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET:

Re: Optimizer related init parameters

2003-10-11 Thread Gaja Krishna Vaidyanatha
Vivek and list, I don't think any reasonable person will be able to say with a high-level of certainty whether the values that you have suggested, are optimal for your environment. The answer is a huge - IT DEPENDS. Having said that, here are some things you may want to take into consideration:

Re: A funny thing happened today on the way to OraPerf.com ...

2003-10-11 Thread Mogens Nørgaard
Gaja, Anjo - The question was: Is the data that users have uploaded to OraPerf now available to Veritas? It's a fair question that deserves more than a no need for any concern answer :-).. Perhaps it would be good if Anjo explained why and how this happened. You know I love you, Gaja, but why

Re: Desupport of RBO

2003-10-11 Thread Mogens Nørgaard
I'm pretty sure that RBO is still there in 10g :-), but that it will not be enhanced, P2 and beyond issues won't be fixed, etc. But to be certain, I have asked Graham Wood. Mogens Cary Millsap wrote: I'm pretty sure that RBO is *gone* in 10g. If I understood correctly what I learned this

Re: Using ' in Update statement

2003-10-11 Thread Mogens Nørgaard
Tom has a small staff to help him answer the questions. I find the comment from Raj to be less than fair and intelligent - or we all misunderstood what he meant (including me). Mogens [EMAIL PROTECTED] wrote: I don't know whether Tom does all of the asktom site on his own time, but I doubt

Re: FW: Oracle Performance Software from Veritas

2003-10-11 Thread Mogens Nørgaard
It went very well. Gaja was flying, and it was good to see 15 members of the OakTable playing air guitar at the same time on stage. The girls were crazy with Gaja, and for good reasons. I have decided to make a musical next year, too. This massive mass of talent must not be wasted. Mogens