 | | | Oracle List | | Well established company in the Nashville Tennessee area has a
position available for
an Oracle DBA to support their SAP and SAP BASIS environment.
Salary up to 95k and great benefits.
Will provid
Folks
For an Upcoming benchmark with Oracle 10.2 what is the
minimum/recommended patch number (i.e. Oracle 10.2.?)
NOTE - O.S. Version is Solaris 10.
Thanks indeed
**************** I have successfully used your approach 2. (see example below). One problem is that your dynamic sql statement has to be a PL/SQL block if you are calling a procedure but I wouldn 't expect the error tSteve Adams our esteemed moderator is coming to Ann Arbor MI to
speak at the local user group and present a two-day seminar.
For details see http //bobak.net/~mjb/SAdams.html
-Mark
--
Mark I believe you have already identified your root cause and you need to
figure out how to proceed from generating the .csv file to loader or
datapump in an automated fashion.
Trying *everything* toHave a look on CPAN lotsa PERL modules to parse SQL
http //search.cpan.org/search?query sql&mode all
Stefan
On 9/25/06 Adi Hirschtein <adi@(protected) > wrote
>
> Hi Guys
>
> Does anyone kno
Greetings All
Firstly apologies if this is not an appropriate forum for this kind of
emails but I saw a HOTSOS symposium advertised by Cary (Hi Cary!) so I
thought that it may be ok for me to dHi Deray
It appears to be pretty rare that all data is updated continuously in a
database. Only s small part is used/changed on a daily database the
rest is historical data. So my approach in situ
Every session gets its private copy of the table
in the temporary tablespace (make sure it 's
big enough) and knows its own HWM.
If you are using 10g consider using tablespace
groups - just in casePeople
I just walked through an install of Oracle 10g 10.2.0.2 on Solaris 10 x86.
You will find a description here
<http //bikle.com/protected/o10gR2_solaris10x86 >
http //bikle.com/protected/o10gGene
There are a few "must " use patches for Streams on 10.2.0.2. In case you have
not applied those patches I 'd suggest first applying those. I have a list
of patches for Solaris 10. Since your OS So you assume it 's just buggy. Fair enough. -)
I guess you already though of ALTER SYSTEM CHECKPOINT before your
operation with direct IO. Not exactly old behavior (flushing all dirty
blocks instead Scott
Have you tried going beyond just explain & autotrace and running a full
10046 level 12 trace to see where the slower version is spending its
time? This might shed some light on the subject pSteve
Do you think it matters that your insert statement looks incorrect? You
have
I could be wrong - but it looks unbalanced.
<price type "US " >10.00 </price >
Tom
Hello
Has anyone managed to get an SMF manifest for oracle working on solaris 10?
I have tried using a simple one that starts 1 named database but need to
write one that uses dbstart and dbshut (forI patched my production system last night and now am having a problem
with I guess jdbc. We have a little java program which runs and loads
GIS point data. It no longer seems to be able to connecWhat is really causing the insert to fail? My object name is 4 characters
long max lenght is 30 characters. Oracle 10.2 on RHE rel 4.
This is from a back-end pl/sql process that is called by a perl Amonte
Hmm . . . last I checked 25% of 3600 was 900 but I 'm being picky.
As Cary Millsap (Optimizing Oracle Performance) points out it is hard to
predict where the bottlenecks are. Either scaling
Folks
Qs 1 When using COMMIT_WRITE BATCH NOWAIT After a database crash if
the respective Application has the capability to check within the
database for
volume of transactions lost after compYou could try orasnap its hosted on a yahoo group for a starting point
or plato from dba-village
http //www.dba-village.com/village/dvp_plato_pub.main
If not what you are looking for might give you s SELECT *
FROM TITULO
WHERE TITULO_ESCENA_CODIGO___ 'REAL ' AND
TITULO_PORTAF_CODIGO___ 'OBL ' AND
TITULO_TIPTIT_CODIGO___ 'TES_TF ' AND
(TITULO_INDTITGAR IS NULL ORIs there a way for me to do this
DBMS_STATS.GATHER_SCHEMA_STATS(ownname > 'SYSADM ' degree > 8 cascade >
TRUE )
so that It will run all available nodes/processors of the cluster ?
FYI we are usinAnyone have an "audit "(sox) document on recovery? We could use a
template. Every shop is different but still most points should be
similar.
We figure we are ONLY going to do RMAN since that is oVersion?
On Thu 2006-09-21 at 14 45 -0500 Roger Xu wrote
> Hi List
>
> To start up a physical standby database you use "startup nomount " and
> "alter database mount standby database " ....
> Wh
> > >I 'm testing 10gR2 on a new Linux box. I decided to fiddle
with enabling async IO. To test the async IO I imported a table and I
also ran several queries . I ran these tests one at a time (e.g.Hi
We are using Oracle E-business suite 11.5.10.2 with UTF8 Characterset on
SunSolaris.
We have some custom reports with text as output format and they work fine.
Now
I changed the output format I have been asked to port an 8i database from solaris to windows 2000.
When trying to install the software and seed database the install hangs
on the net configuration assistant piece. ....and when IOne of our developers is noticing that several of his views have become
invalid each day over the past serveral days. He claims that no ddl is
occuring on the base tables and that know functions the Murtuja
To start log into SQL*Plus as system and execute the command
SHOW PARAMETER
This will show you all the current settings on your instance.
Now you need to study in order to determine just don 't try this with a DDL though ...
Raj
On 9/21/06 Adi Hirschtein <adi@(protected) > wrote
> Hi guys
> I checked it and it 's great !!!
> Thanks a lot.
>
--
http //www.freelists.org/webpage |
|
|
