 | | | Oracle List | | Jared
That might be a good idea to play around with but 2 DVD 's of info is a
bit much
to download. I didn 't see anyother method of getting the info but from
a download.
The second DVD info conPaula
I don 't have the formula handy for calculating undo retention but a
google should provide it. Have you set your retention period to large
and retaining days/hours of undo info? The defaulthi
are the values of readtim writetim maxiortm maxiowtm in v$filestat(9.2) reliable? In the past prior to 9.2 these values were reported much higher than they were supposed to be. According to m
May sound like a silly question but does Oracle implicitly execute
ALTER SESSION statements for any connection into the database? My suspicion
is it must do to ensure local variables like time I am having a problem starting my database after installing the patchset
10.1.0.3 on Solaris. I am getting a ORA-12560 TNS protocol adapter error.
I am currently working with Oracle to see if therHello list
I was reading an excellent paper written by Mr. Carry Millsap about
when to use indexes and I was very much interested to know more about
block selectivity. Could any one tell me moreHas anybody installed/used Oracle 10g RAC in the
production without using Sun/Veritas Cluster SW and
Veritas VxVM?
That means only with the Oracle clustering SW and ASM.
I cannot try it becausContent-Type text/plain
charset "us-ascii "
Content-Transfer-Encoding quoted-printable
Published December 13 2004
The business software company Oracle
<http //www.nytimes.com/redirect/markCapitulate - Oracle wins.
Good?
Steve
--
http //www.freelists.org/webpage/oracle-l
> EC > But how does Oracle plan to "speed up " sorts?
>
> My guess would be that they 've come up with some new
> algorithms that are more efficient or at least they
> believe those new algorithmsCarel-Jan
Thanks a lot.
Of course I am doing exactly what you said.
Using PL/SQL for the code and passing the table name
to the PL/SQL from the triggers.
With ora_sql_text I can eliminate Raj
>Any pointers to good articles on using and sizing P_A_T? config is
>9204/AIX/RAC. In one of the DBs a sr. dba has PAT enabled but
>occasionally the DB throws ora-4031 and we end up bounciOn Sun 12 Dec 2004 10 23 09 -0600 DENNIS WILLIAMS
<DWILLIAMS@(protected) > wrote
> Thanks David.
>
> The error is
> Exception in thread "main " java.lang.InternalError Can 't connect to X11
Friends
Any of you using LOCK_SGA parameter on HPUX 11.23 in the production?
Are there any pros & cons please share your valuable informtion.
--
Best Regards
Jaffar OCP DBA
Banque SaudiFriends
I dont find patch 9206 for HPUX Itanium. Any idea when it would be
released? If it is already released are there any know issues with
the patch on HPUX Itanium 11.23?
--
Best RegarLast time I carefully tested the new logs were added after the current log
in the rotation. That doesn 't mean your results are wrong just that they
don 't represent all possible orders. So if the cuRight tables have no indexes - they are created later.
Btw is APPEND and PARALLEL hints for DML on tables with indexes working at all?
On Sat 11 Dec 2004 23 35 42 +0100 jaromir nemec <jaromiWell I 've made some progress on this...
The source table had duplicate records in it based on the key structure mentioned in the ON clause. Once those duplicate records were removed the statemenAll our RAC 24x7 DBs are 9.2.0.5 (plus 11 one-off patches). We lived
happily until recently when we seem to hit few bugs regarding library
cache and online index rebuild bug.
List of bugs fixed in
I 'm doing a merge into command where I query a table that holds multiple scenario items in it.
The objective is to transfer the selected scenario items from the "source scenario " to the "destinatWe are an HP shop now and run or DB 's on HP Superdomes. Machines are
working really hard. Unfortunatly we are having far too many hardware
problems and compare to another dept. that uses many Sun 'sIs this on a Pentiium 4 processor?
There was a bug with 8i that it would not function properly on P4 's
unless you put in a 'fix '.....at least the assistant 's would crater
-----Original Message---All
Im running 9.2.0.0 on MS 2000 Advanced Server when I get the
previously mentioned error allong with the following when attempting
to create a materialized view. Here are the tablespace specs "Take a look at utlrcmp.sql "
Yes I saw that utlrp called utlrcmp turning this into a package simply
means adding the create table statements and create view then putting
the whole thing in a sI tried the decode and it works perfectly.
Thanks for the help.
Bill
William Gaston
Systems Designer / Information Technology
USG Corporation
Chicago Il 60606
(312) 606-3851
wgaston@(protected)Hi
>This job runs in under 2 hours on 8.1.7.4 and 6.5 hours on 9.2.0.4
>(both on VMS 7.3-1)
>The data is identical (exact copy of the data files) but the cpu is
>different. It 's possible thatFriday December 10 2004 6 31 51 AM Jose Manuel Quesada (jose.manuelquesada@(protected)) wrote
JMQ > 2.- If I have the INSERT statement within a procedure each time I run
JMQ > the procedure the "Peter
Comments inline...
on 12/6/04 4 12 AM LOMAX Peter Ext ROSI/SIFAC at
plomax.ext@(protected) wrote
> Good morning
>
> I have scurged the documents on this to no avail.
> I Thanks for the description of the *** lines. I should have done more
research before asking this.
Here 's why I originally posted the question just so you know my frame of
mind. I run a problemMy current project has six releases moving in parallel. The company is
followig the RUP methodology. A few of the releases are in development and
we have the same challenge of managing version conr |
|
|
