 | | | Oracle List | |
On 05/05/2004 03 37 08 PM Gene Sais wrote
>
> Anyone running 10g in production?
My test database server is in the same room as my production database servers.
That means that my 10g instanAny chance you can speak to his previous workers??
Why is he leaving his current position??
Do you actually have a say about hiring him/her? Or are you just being "empowered "??
How does s/he
I think if you had to do more work in creating
read consistent blocks the trace file would show
the access to the undo blocks as part of the "query "
column which you would have noticed.
If yHi Rajendra
I don 't know wether this helps or not We upgraded a dev db from
9.2.0.4.0 to 9.2.0.5.0 and as you said CASE works fine. We have
rewritten all our DECODE statements to CASE and a
Quick test
alter session set cursor_sharing force
select count(decode(n1 3 1 2 null 4 1 6 null null))
from t1
where decode(n1 6 3 null) 2
Text in v$sql
select
count(decode(n1 "S
pls check this out.
http //metalink.oracle.com/metalink/plsql/showdoc?db 3DNot&id 3D153788.1
doesn 't say a word about corrupt spfile. is a problem with sort_area_size
and might be resolved I also did some research on this recently... The paper the original
poster discusses was published by Sun and in my opinion is really
geared to telling you how wonderful their ufs is and why yoI don 't believe there are any equivalent PL/SQL functions unless
you write your own.
PL/SQL won 't be able to compete with Oracle Media ( is that its name
this month?) in terms of performance.
JWe have a 4 node RAC cluster in production. We have an ETL instance and a production instance on these 4 nodes. Our ETL instance is in noarchivelog mode.
Will I get a performance improvement if I rHi List !
I have a very big problem since my query is hanging for a while.
Description
-Just 1 big table historized_file wich is partitionned by range on
month column (eg 200202 200203...).
Hi Mladen
I gave it a shot since my solution so far was to run a DBD Proxy
server on Windows (same machine ActiveState Perl 5.8.3) and communicate
with Oracle from cygwin (same machine) vi
On 05/05/2004 12 31 28 PM Pete Sharman wrote
> ee for not using one. Even in Niall 's case (which is clearly a bug) it 's r
> ecoverable from simply by opening the SPFILE highlighting the comDear All
I am puzzled with the following
Solaris 8 Oracle 8.1.7.4 64 bit DW environment
The following sql statement runs every 10 mins to retrieve some
tablespace information.Just checked 8.1.5 on NT and 10g on XP.
In both cases default setting for "blank_trimming " is FALSE.
But it could be different in Warren 's installation.
Igor Neyman OCP DBA
ineyman@(protected)That cute little text entry field appears to be back on the main screen at Metalink....
Connor McDonald
Co-author "Mastering Oracle PL/SQL - Practical Solutions "
ISBN 1590592174
web Another method for 8.1.7 20
Create a database trigger to store query outlines then query the
outline tables to see if the index has been used. (Tom Kyte expert
one-on-one Oracle) 20
-----Orig
If you dump a small redo log you should find
that the 4th redo vector of the first redo record
of every transaction is a transaction audit
record. In 8.1.7.3 I think this is still going
to Deen
Here is what Jonathan Lewis wrote about PX Deq Waits
http //www.faqchest.com/prgm/oracle-l/ora-02/ora-0205/ora-020531/ora02051804
_06040.html
Jared - Google strikes again!
Dennis WillHi gurus
We are in the process of buying a new SAN.
Our choice is between the following
- Hitachi Thunder 9570V
- HP EVA3000
Could you give us some pros and cons regarding these two?
- Or
On 05/04/2004 02 43 13 PM ryan.gaffuri@(protected) wrote
>
> what types of cases make hash joins superior to nested loops? I see them alot in batch processing when I need > to join most of the rowsDo you have some comments about this product it works with Oracle
http //www.primasoft.com/dbhtmlp.htm
Juan Carlos Reyes Pacheco
OCP
Database 9.2 Standard Edition
> If you don 't know how to get an execution plan
> my paper could help you
> http //www.geocities.com/juancarlosreyesp/101basictunningonOracle9i.pdf
Juan
There are 29 references to 'execution pYou partitioned the MANAGER table by MGRID not by EMPID. Oracle can 't
perform pruning unless your query is referencing the partition-key column.
on 5/4/04 10 46 AM Sanjay Mishra at smishra_
There is an issue with truncating and dropping small tables
when you have a large db_cache_size - but 30 minutes is
a bit extreme.
When you drop or truncate Oracle first writes all dirty blocThe shortest possible answer to your question is "optimizer ". Slightly longer
answer to your question is the following
0) CBO selects possible plans.
1) CBO looks for histograms and and values inJosh
This utility is there in 10g too. I tried this utility but I believe this
utility does not help in setting up the Oracle Service but it does tell yo
u about the oracle OS users and instaI 'm trying to install Designer (10g) but Oracle has changed the process
since I did it last. I 'm using 9ir2 database HP-UX with separate app server
and database server. I know the client is windowsHi
Where is this paper? Seems to me that the word "large " should have been
"small " but I am willing to learn different.
Regards
Pete
-----Original Message-----
From oracle-l-bounce@(protected)Hi
I agree with you though I do not find theory support(from official
unix vendor document).
Test shows only write can use the kaio os call. Read cannot. And in
most case only dbwList
I am searching for document on metalink for installing RAC on single Linux box. I can only find document for 9i release 1 and the last updated date is way back in 2002. Anyone know a more recen |
|
|
