 | | | Oracle List | | In private communication with Cary Millsap I was warned about the
undocumented DBI handle attribute called "ora_check_sql " which was
defaults to "1 " and oracle versions 8 and above causes oracle Honestly not sure....
Robert
-----Original Message-----
From ryan.gaffuri@(protected)
To oracle-l@(protected)
Sent 2/5/2004 12 35 PM
Subject **BLOCKED-BY-IHATESPAM** Re RE items i 'll be vi
On 02/05/2004 01 42 42 PM "Vergara Michael (TEM) " wrote
> Hi Gang...sorry about being kinda OT...but...
>
> A long time ago when I used VMS I could scan a file and see
> a set number ofHTH
GovindanK
--
http //www.fastmail.fm - Or how I learned to stop worrying and
love email again
On 02/05/2004 01 39 09 PM "Mercadante Thomas F " wrote
> All
>
> I just noticed something that I think is strange. I am creating a
> new
> Curam
> database in a 9.2.0.4 AIX 5.2 machine. I aNot sure of the info value but here goes
I just learned that transcender updated their Oracle
certification practice tests and now have available
the 4th OCP study practice test (Performance TAnother place to look at is ODBC DataSource parameter called "Preftch
Count ". By default it is set to 10 which means for the query
retrieving 1000 rows ODBC will make 100 trips to the database. DOften on Win2k it is as simple as setting your ORACLE_SID env variable
Mohammad Rafiq <rafiq9857@(protected) >
Sent by oracle-l-bounce@(protected)
02/05/2004 06 44 AM
Please respond to oResponses in-line.
Cary Millsap
Hotsos Enterprises Ltd.
http //www.hotsos.com
* Nullius in verba *
Upcoming events
- Performance Diagnosis 101 2/24 San Diego 3/23 Park City 4/6 SeattlWell it is implemente in pure PL/SQL with lots of loops.
If you want fast regex use Perl.
And yes of course 10g. Coming to a desktop near you
sometime in the 21st century.
Jared
So the unbreakable database requires rsh?
That is quite ironic.
Jared
"Rognes Sten " <Sten.Rognes@(protected) >
Sent by oracle-l-bounce@(protected)
02/04/2004 09 40 PM
Please rYou 've hit the number of concurrently open TCP connections on the box.
You may try cman and connection pooling but it would involve
restarting the database and setting "POOL " parameter for the
disYour view returns rows right? Test that first but I
believe if you issue a "SELECT * FROM userstatus_v2 " you
should get plenty of rows back.
I think the problem with your query in step 3 is tFor all you Java development folks - any recommendations for a Java
Development Tool? I know that Oracle has Jdeveloper out there. But what
else is there? Any good bad or ugly?
thanks
Tom
On 02/04/2004 07 42 44 PM Jared.Still@(protected) wrote
> The site was down earlier due to a UPS issue but I believe it is
> back
> up.
It isn 't.
--
Mladen Gogala
Oracle DBA
-------On 02/04/2004 03 04 49 PM "Fedock John (KAM.RHQ) " wrote
> We are currently running OPFS (oracle parallel failsafe) on Oracle
> 8.1.7.4 using HP-UX. This is an HA system from HP.
>
No problemThis is why statspack is sometimes useless. Your
"db_file_sequential_read " wait is meaningless unless
you know which SQL command(s) cause(s) the largest number
of those read events. Without the par
The Oracle 9 plan is showing you an optimisation
option known as 'table pre-fetching '. Essentially
the plans are the same but Oracle can make a
cost-based decision when using index range scans
You probably need to rebuild index. It looks to me that your index
might not be usable.There is "STATUS " field in the DBA_INDEXES.
If someone moved the table indexes are unusable.
On 02/04/2004 List
I just return from a 10g seminar and I talked to them about hacking
the Disk1/install/linux/orapram.ini file to allow the install on the OS
of choice. If you comment out the [Certified VersiYou need the owa_pattern package. You will find it in OH/rdbms/admin
IIRC.
Here are some test scripts
http //www.cybcon.com/~jkstill/util/zips/owa_pattern_tests.tgz
Jared
"MercadaAre OTN software & documentation downloads off-line?
On 02/04/2004 01 28 58 PM Kirtikumar Deshpande wrote
> From all those 60-100 "database parameters " Patrol monitored we had
> found about 10 or so to be of
> any help to the DBA with Oracle 7 andLong live Automatic Workload Repository (AWR). It even comes with a
package to analyze it so that the poor administrator doesn 't have
think about the question of life universe and instance parametNow just this morning I saw the '10G is here ' Oracle.com page.....now
it 's back to where it was Monday. Did they pull it or was I just having
an out of database experience?
David Phillips
SuppDavid
I don 't think having two LUN 's on the same RAID system was a wise decision. Contention is introduced this way on the same physical devices.
Goran
Date Mon 5 Dec 2005 10 53 22 -0800 (PST)
An analysis of reported bugs via metalink and trend that with analytical
functions provided via 10G SQL....
greg
-----Original Message-----
From Joe Testa [mailto oracle-l@(protected)]
SentOn 02/04/2004 10 36 38 AM George wrote
> Jared
>
> Did you know that Quest purchased TOra?
>
> George
>
Everybody knows that. The problem is what Quest wants to do with it?
Did they purchIsn 't the 4 CPU limit a per-server limit?
On Wed 2004-02-04 at 05 55 Niall Litchfield wrote
> However std edition is limited to a max of 4 processors so it would appear > that you will be able Joe - let me say " I don 't take umbrage regarding puke " - putting jocularity aside
downloaded on Feb 01 2004 - at a "breathtaking " speed. Maybe nobody else did a download
at that time.
Guts feel |
|
|
