 | | | Oracle List | |
As part of porting an Application from SQL*Server to Oracle when using
SQL/PLSQL etc we need to retrieve Data in UPPER Case "Database-wide "
irrespective of Case of storage of data within the fielI was under the false impression that if you had your remote destination
(log_archive_dest_2) configured with ARCH and OPTIONAL then problems
with transmitting the logs to your standby could not impaHmmm... This is something of a thorny issue...
First off correct me if I 'm wrong (I probably am and I 'm sure somebody
here likely
will) but isn 't CPU_COUNT mainly used by the database to decide t
I think there is a problem with this query. I do not know your where
clause for the inner query but it can update all table_a if it is like
this
Create table table_a(id number number_ordered nHello everyone
I 'm curious how you all are going about backing up your recovery
catalogs. Do you do it through rman backups or logical exports or
both? I 've always done it through logical exporI would guess that the difference in timing had more to do with the physical
access time reduction due to striping across disks due to having multiple
files.
Stephen
On 6/26/06 LS Cheng <exriscer@You 'll rarely get p3 value dbfmrc because several of the blocks will
already be in cache so they are skipped (no need to re-read them from
disk).
Regards
Brandon
Privileged/Confidential InformatFirst
your code shouldn 't compile. And even if it compiles it is doing
exactly what you are telling it to do. You are not doing with any of
the fetches and just outputting a message when cursor doe
On 06/27/2006 08 12 07 AM Lawie Duncan wrote
> Charles
>
> I agree that a row in x$ksmsp should equal a single memory chunk - but is it possible that there is a chunk with an outrageous value? Good day. We 're running PS HR8 on Oracle 92070 RAC / Windooze with a EMC 600
SAN.
I 'm doing some research on the SAN and it 's settings.
Is anyone using a remotely similar config. I 'm interested to sHello
I 've been looking for information about how to secure Oracle 's embedded
pl/sql gateway or even to understand how exactly it works. I found a
lot on the pl/sql gateway available through OracOn 6/26/06 oracle-l-bounce@(protected) <oracle-l-bounce@(protected) >
wrote
>
> We are pretty new to modelling tools and we decided to buy Erwin from
> CA. The deal is now that I need to write doJust to clarify - you can use ALTER TABLE MOVE to rebuild in the same
tablespace also (don 't have to move it to a different one)
>At 9i you can use the dbms_redefinition package and re-create the
t
Want to justify a trip down under? How about East or West coast of
Australia. Well you could if you are
attending/presenting at the AUSOOUG/OAUG conference series.
These are the two dates & venueI 'll take a guess that the bold line is causing the problem possibly due to
the TRUNC. If you have an index on T3.trnsctn_tm the TRUNC will cause the
optimizer to not use the index and likely do a fRTFM - http //download-uk.oracle.com/docs/cd/B19306_01/server.102/b14211/optimops.htm#sthref1394
You can set large hash_area_size and use parallel query.
The best way to speed it up is to avoid it ifpaula
by any chance you dont have a thick client like powerbuilder or microsoft ADO access involved int eh transaction ?
i 've seen this error on access from a thick client becuase of microsoft trans > away (3 hr query vs. 3 second!). Unfortunately one DBA pointed out
> that the scheduled "gather_stats_job " job puts stats back on them every
> night.
Here we come again with this naming confusionBrief? AutoPatch is the utility. But before diving into that I 'd
recommend at least reading the Oracle Applications Concepts Oracle
Applications Maintenance Procedures and Oracle Applications MHello
I 'm supporting an ERP app (SSA BaanIV) that uses bind variables
extensively which is a good thing for the most part but occasionally
I 'm having queries that are suffering from plan instabilI 'm not positive on this but I believe the following parameter setting
log_archive_min_succeed_dest integer 1
And the fact that you don 't explicitly have MANDATORY specified in you
rlog_Hi Rich
The only difference that I know of is that the processstate will not be dumped for processes already spawned before this comand is issued should they encounter the error.
e.g if dbwr eHi All
My company was recently awarded a grant that will allow us to give
some of our developers PL/SQL training. I 've been asked to look for
alternatives such as onsite training. Does anyone haveHi
When you load data into a partitioned table oracle has to check every record
to decide in which partition store it.
When you load data in a heap table oracle hasn 't to check it. All records
are Hi list
A little while ago I 've had an encounter with a (self constructed) test case
situation where certain SQL statements where not reported in 10046
tracefiles
if they were inside a wrapped PL/S
Hi
If you think exporting CLOBs are slow wait till you import! It 's much
much slower.
During imports depending on the size of your clob column you may be
able to get away with COMMIT N. IAssuming you have foreign keys that point to your child records are these
columns indexed ?
Just my 2cents
Stefan
On 6/23/06 A Joshi <ajoshi977@(protected) > wrote
>
> Hi
> In one of my progra On 9i and 10g You can use smenu for that install it and launch a sampler spl -start
It will sample v$session every second but in order to let me analyse the query offline or days after II would recommend looking into the on-line courses - they are $1000 less
than the price of the in-person courses (US$1500 instead of US$2500
IIRC). I took one once because it was a requirement for tSanjay you need to remove those processes at o/s level.
Regards | Jp.
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)] On Behalf Of Sanjay Mishra
Hi
I had killed few se |
|
|
