Sjmnetx, Hi. Hmm, well the knee jerk reactions are 1) No index to help 2) The data in ordered differently between the two tables causing more page fetches. ...
Allen Shepard
ashepard@...
May 1, 2006 1:47 pm
866
I had no chance to review the trace yet today. However, I checked dba_indexes and dba_ind_columns for the tables that comprise all_constraints view; Namely,...
-- Interjection by listserv moderator: -- Please email Victoria directly at nichollsvi@... -- if you interested in responding to this post (don't -- reply...
Sjmnetx, Hi. Ok, when you get a chance to add the line " set arraysize 1000 ' and re- run the query let us know. Have you analyzed the table? I would think...
Allen Shepard
ashepard@...
May 8, 2006 1:52 pm
869
Hiya All, I posted a note on VOUG a couple of weeks ago asking for help cleaning up a linux box after an failed install, so that I could try to re-install...
Larry Blankenship
lblankenship@...
May 8, 2006 1:52 pm
870
+ Interjection by listserv moderator: + Alrighty folks, I think this is what we've all + been looking for ;) Hi all, Feel free to revert all the quires about...
Hello from a newbie, I've installed 10g DB on one server running Suse Enterptise and now I'm attempting to install the Companion CD on another server. This ...
Folks, We are running Oracle Enterprise Edition 64 bit on Solaris Servers. We have a 220Mg xml file that needs to be parsed and then loaded into Oracle tables....
If you are using Oracle Java libraries to parse the file then check the value for init parameter JAVA_POOL_SIZE. Probably this value needs be set higher....
Ihtesham Uddin
ihtesham_u@...
Jun 13, 2006 4:15 pm
874
There are two models for parsing XML, Document Object Model (DOM) and Simple API for XML (SAX). DOM parsers have the advantage of letting you see your XML...
Hi Everybody, It is interesting. Oracle adopted Document Object Model (DOM) (worked with CLOB data type) for XML in Pre 9I version. It introduced XML DB ,...
If you've worked with prior versions of Oracle, at least back to 7.3, you're probably used to the output from a SELECT with a GROUP BY or from a SELECT...
This was a side-effect of the fact that Oracle was doing a GROUP BY or DISTINCT by sorting the data. Oracle would have told you even back then that they don't...
I just wanted to seek your opinion on a design issue that we're trying to resolve. Basically, users want two tables A and B. Both will be about a terabyte in...
Nana Bonsu
nmbonsu@...
Aug 5, 2006 2:38 am
880
Please verify whether the two tables contain the same data (same column structure, same rows) or if there are any differences between the two tables. Please...
Mark C. Stock
mcstock@...
Aug 7, 2006 5:58 am
881
Has anyone been using Oracle Discoverer? A group that I work with is changing from Oracle Browser to Oracle Discover (with our upgradeto Oracle 10g) and are...
Laureen L Branting
laureen.l.branting@...
Aug 8, 2006 1:58 pm
882
Hi Everyone, The HROUG & GROUG user groups are very excited to announce that registration for OCOJ - the Oracle Conference On The James - is now open. The...
Hi, I am working on configuring Oracle Portal for Discoverer reports. We have a J2EE application that also has reports in Discoverer. We are working on ...
Hiya All, I am testing/learning how to make java and oracle work together. My test system consists of a windows XP based pc that has oracle 10g XE and java sdk...
Larry Blankenship
lblankenship@...
Sep 26, 2006 2:52 pm
885
Phillip - When Discoverer reports that are included in Oracle Portal, you can either invoke them as part of the Discoverer portlets (aka "Drake") interface, or...
Oracle Conference on the James '06 is coming up quickly -- just 5 weeks from tomorrow -- and early bird registration ends this Saturday, September 30th; after...
System ... 2 dual core intel xenon 64 bit RAM 16g OS RHEL 4 update 4 64 bit Database ... This database is 99% read only "star schema" Oracle 10.2 64bit Our...
OCOJ '06 - Oracle Conference on the James, Williamsburg, VA November 2, 2006 at the Great Wolf Lodge. The final speaker agenda for the Nov 2nd OCOJ conference...
As you may've heard, a call for papers is now open for the Ninth Annual SouthEast Oracle User's Conference (SEOUC) meeting next Spring. If you've ever...
VOUG Membership - Just a quick reminder - Friday is the the last day to submit a presentation for the upcoming SEOUC conference. The submission date won't be...
Hello, I am looking for an Oracle Financials User Group - where the focus is not the technical [i.e. setup, updates] but rather using Oracle. I am a Financial...
As you may've heard, the Ninth Annual SouthEast Oracle User's Conference (SEOUC) in Charlotte is only six weeks away - this coming March 1st & 2nd, in fact....
You want to get in touch with the Oracle Applications Users Group (OAUG). Find them at <a href="http://www.oaug.com/">http://www.oaug.com/</a>. By the way - ...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
