 | | | Oracle List | | Hi
Can someone explain what might be the possible reasons for Oracle to use a
merge join in the following query?
The query below is an extraction from a more complex query with 5 table
joins anOn 01/30/2004 01 13 34 PM "Goulet Dick " wrote
> Well if optimiser_mode rule with stats doesn 't invoke CBO then I > wonder why OEM is providing me with cost data??
It 's advertising tax breaks foMark
this may be as simple as selecting the correct doc_id column. Is the
CPAG_CNST_UK01 index in the COMPRESSED_AGREEMENTS table? If not then
change your select statement (within the view) tOn 01/30/2004 03 46 04 PM Tim Gorman wrote
> One further question though...
>
> > > Of course if someone knows a utility to un-flag a block I 'm all
> ears.
>
> Why would anyone want to "unfInteresting. I didn 't realize that DBA_JOBS stored NLS parms.
Learn something every day here.
In that case it appears that the NLS parms are being taken from
the client. The two clients you hav
Have you tried querying V$SESSION_LONGOPS ?
{It requires TIMED_STATISTICS TRUE and the table having been analyzed}
Hemant
At 04 42 PM 30-01-04 +0200 you wrote
>Dear Nelson
>
>Oracle releaTest msg. Pl ignore
Justin (and Jonathan)
I removed the Trunc on both sides. I realized a run time of 19 mins now.
Still heavy but faster -)
Referring to your sugg. with the SQL version...... I am not quite sure
Your cursor truncates the input date
trunc(tmov.sellt) SELLT
Your only (PK) index is
(Sellt RateInc Facility)
Your update statement uses a predicate
that makes the index unavailabLarry Walls 's books from O 'reilly. He is the inventor of perl. At least
he knows the concepts. BUT many other people contibuted and still do on
several other places eg google for CPAN. As regards tIn this ?mutual supporting? configuration you don?t need additional
instances just to house the ?recovery catalog? database? Your idea to house
them inside the ?business? instances is quite viable OS Windoze NT 4.0 SP6
Oracle 8.1.7.4
Though I have already fixed this problem via brute force I would like to
find
out why this happened. ( I recreated the snapshot log and snapshot )
For So what is the main wait event you 'r waiting on?
On 01/29/2004 06 54 46 PM Jordi Adame V wrote
> Hi!
>
> I have this table with ~4 000 000 entries
>
> When i do a SELECT COUNT(*) FROM TABLEHi everyone
I thought people here should be aware of this issue. I came across some
pseudo code for the toplink workbench encryption algorithm and sample
code on a website to do the encryption m
As a speculative thought
If the ref cursor is created through a text string
with dynamic execution perhaps the parser is taking
out the hints because it mistakenly recognises them
as commentsThat is a natural consequence of using Outlook. When the message is
encoded in another character set and is improperly converted you get
lovely characters like that. Outlook is a part of a very sin
> Oracle 5 - 1986
> - Client Server
> - Cluster support (VAX)
Nope. Cluster wasn 't supported with V5. Cluster support
came with Oracle 6.2. That was the first OPS version and
was VAX/VMS- Here is an interview that gives hints about what Oracle is up to with 10g.
http //www.computerworld.com/databasetopics/data/software/story/0 10801 8952
7 00.html?nas AM-89527
< <Oracle eyes WIt depends. If you can create sort_area_size that can dynamically
autoallocate larger and larger chunks of memory then go ahead create
autoallocate temporary tablespace. If your sort_area_size is
8.1.7.4
Windows 2000 Server
ca.200 sessions about 30 active.
About a dozen sessions go into waits
for Library Cache Lock for the best
part of 300 seconds. (At which they
probably all get OEd - I 'm not a SAN expert. But the one thing that we are working on/striving
for with the DB 's here are two file systems presented to the Host.
We 'll use one *mount pointA* for the use of Data FilesWell the best books about perl are
Learning Perl
Perl Programming
Advanced Perl Programming
Before reading Jared 's book you want to read "Learning Perl " and
introductory few chapters of th
I have started to look at using OEM alerts and have encountered the
following issue.
I 've created an alert for tablespace full for one of the discovered
databases.
When the alert runs for the If you don 't want to use DBA_JOBS* views to determine
if a job has completed you will need to modify the
job to alert you somehow.
Do this via UTL_SMTP insert a row in a table that
you check pHi
We(I) configured ~20 ODBC connections using Oracle
Generic Heterogeneous Services (HS). I hated it
because we were dynamically adding-dropping
connections every couple weeks which is a manuSet the parameter recovery_parallelism to 0 (default). In 8.1.7 there
is a lovely "feature " which occasionaly breaks recovery if it 's done in
parallel.
On 01/29/2004 01 00 24 PM Raghu Kota (WBTQSuch a simple but valuable suggestion. Create a test database and migrate
it first to see how the process works.
Can 't say it enough. The simple suggestions are sometimes the most elegant.
To
I had the list in digest mode and either my mail program or the list
admins chopped the concatenated emails message.
(I 've unset the digest mode).
> > > Carmen Rusu 1/28/2004 2 16 46 PM > > >
----------------------------------------------------------------
Please see the official ORACLE-L FAQ http //www.orafaq.com
----------------------------------------------------------------
To unsu
|
|
|
