This is a multi-part message in MIME format.
--=002_Dragon373150002168_=
Content-Type: text/plain;
charset=GB2312
Content-Transfer-Encoding: quoted-printable
Khedr, Waleed=A3=AC=C4=FA=BA=C3=A3=A1
=A1=A1=A1=A1Use rule hint gives out the answer most fast,according to my=
test in
Hussain Ahmed Qadri wrote:
Hi
Would moving the temporary tablespace, rollback tablespace and Archive
files location to a hard drive other than the hard drive which
contains the datafiles, improve performance of the server?
Index and Datafiles are already placed on different hard
Hi Igor,
Glad you enjoyed Jonathan's talks! Next time, you'll have to join us at
his seminar which followed AAOUG and wrapped up yesterday! I'm actually
heading over to the hotel to pick him up and take hime to the airport in
a few minutes. It was a really great three days. I think all 24
Muru - I agree with Richard. This is the time to investigate a Web interface
for this application. Otherwise you're just starting down the path of a long
headache that will only get worse with time. As to your direct question, the
only interface that I am aware of that bypasses the SQL*Net
How big was the OS process ?
Monitor what the process is doing, any memory
allocation in a loop ?
I had this error once and it was an Oracle bug (804 on
hpux 10.20), Oracle was having a problem releasing
memory so after 100 000 calls of a function the
process was crashing (ora-4030) because it
Jared
And just think, if you'd given it a snappy name like ODS, you'd be
jetting around to big conventions and big corporate clients, hosting the
greatest technical advice line on the Internet . . . oh, wait you already do
those things. Never mind!
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
Title: RE: OT- Improving server performance
Hi Stephane,
I'll double-check the stats from the queries you mentioned and then decide about the location of datafiles.
Thanks for the useful info.
Regards,
Hussain
-Original Message-
From: Stephane Faroult [mailto:[EMAIL
Hi All,
I have a problem executing the function in oracle through JDBC.
I have written a select statement inside which I am calling a function.
The query is something like
select
OSP_CRM_EXCHANGE_CASE_VIEW.OS_CASE_ID as
CASE_MSG__OS_CASE_ID,
OSP_CRM_EXCHANGE_CASE_VIEW.OS_CUSTOMER_ID
as