> - Guest Linux SuSE 8 with Oracle 10g. Definition of 2G and
> SGA 1.7G (I know is big, but it's the one with better results)
You don't say how you have Linux paging configured -- VDISK or real disk. If
real disk, I'm not surprised that reducing the size of the machine caused
problems. A 2G virtua
Behalf Of
Glenn Nicholas
Sent: Wednesday, July 27, 2005 10:05 AM
To: LINUX-390@VM.MARIST.EDU
Subject: Re: Oracle 10G POOR performance
Melissa, if you have a DBA, they can analyse what the 3 queries are
doing. Indexes could be missing, the optimiser could be using a
different approach. Your DBA shoul
---Mensaje original---thanx
-Original Message-
From: Linux on 390 Port [mailto:[EMAIL PROTECTED] On Behalf Of
Glenn Nicholas
Sent: Wednesday, July 27, 2005 10:05 AM
To: LINUX-390@VM.MARIST.EDU
Subject: Re: Oracle 10G POOR performance
Melissa, if you have a DBA, they can analyse what the
---Mensaje original---thanx
-Original Message-
From: Linux on 390 Port [mailto:[EMAIL PROTECTED] On Behalf Of
Glenn Nicholas
Sent: Wednesday, July 27, 2005 10:05 AM
To: LINUX-390@VM.MARIST.EDU
Subject: Re: Oracle 10G POOR performance
Melissa, if you have a DBA, they can analyse what the
Jones [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 27, 2005 11:09 AM
To: LINUX-390@VM.MARIST.EDU
Subject: Re: Oracle 10G POOR performance
This web site might have some useful information
http://www.ibm.com/developerworks/linux/linux390/perf/tuning_rec_database_OracleR
ec.html#begin
DJ
nal Message-
From: Perry, Melissa [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 27, 2005 9:59 AM
To: LINUX-390@VM.MARIST.EDU
Subject: Re: Oracle 10G POOR performance
Ray:
Optimizer set at All Rows..Is this what you ended up using?
-Original Message-
From: Linux on 390 Port [ma
Perry, Melissa [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 27, 2005 9:59 AM
To: LINUX-390@VM.MARIST.EDU
Subject: Re: Oracle 10G POOR performance
Ray:
Optimizer set at All Rows..Is this what you ended up using?
-Original Message-
From: Linux on 390 Port [mailto:[EMAIL PROTECTED] On B
thanx
-Original Message-
From: Linux on 390 Port [mailto:[EMAIL PROTECTED] On Behalf Of
Glenn Nicholas
Sent: Wednesday, July 27, 2005 10:05 AM
To: LINUX-390@VM.MARIST.EDU
Subject: Re: Oracle 10G POOR performance
Melissa, if you have a DBA, they can analyse what the 3 queries are
doing
22 AM
>> To: LINUX- [EMAIL PROTECTED]
>> Subject: Re: Oracle 10G POOR performance
>>
>> What kind of processor and DASD? Do you have any monitoring tools?
>>
>> Perry, Melissa wrote:
>>
>>>Looking to take the easy way out by just asking question. W
: Oracle 10G POOR performance
What kind of processor and DASD? Do you have any monitoring tools?
Perry, Melissa wrote:
Looking to take the easy way out by just asking question. We are
running Z/vm 5.1, Suse 8, and Oracle 10GJust starting to test
performance..3 oracle queries will bring the
VM Performance monitor that comes with VM. Looking at optimizer options
right now.
Thanks
-Original Message-
From: Linux on 390 Port [mailto:[EMAIL PROTECTED] On Behalf Of
Rich Smrcina
Sent: Wednesday, July 27, 2005 9:22 AM
To: LINUX-390@VM.MARIST.EDU
Subject: Re: Oracle 10G POOR
Ray:
Optimizer set at All Rows..Is this what you ended up using?
-Original Message-
From: Linux on 390 Port [mailto:[EMAIL PROTECTED] On Behalf Of
Mrohs, Ray
Sent: Wednesday, July 27, 2005 9:32 AM
To: LINUX-390@VM.MARIST.EDU
Subject: Re: Oracle 10G POOR performance
We just went
: Re: Oracle 10G POOR performance
What kind of processor and DASD? Do you have any monitoring tools?
Perry, Melissa wrote:
Looking to take the easy way out by just asking question. We are
running Z/vm 5.1, Suse 8, and Oracle 10GJust starting to test
performance..3 oracle queries will
Running on V960 w/ escon from STK.. Depending on DBA for monitoring
-Original Message-
From: Linux on 390 Port [mailto:[EMAIL PROTECTED] On Behalf Of
Rich Smrcina
Sent: Wednesday, July 27, 2005 9:22 AM
To: LINUX-390@VM.MARIST.EDU
Subject: Re: Oracle 10G POOR performance
What kind of
Port [mailto:[EMAIL PROTECTED] On Behalf Of
Michael MacIsaac
Sent: Wednesday, July 27, 2005 9:30 AM
To: LINUX-390@VM.MARIST.EDU
Subject: Re: Oracle 10G POOR performance
Melissa,
> 3 oracle queries will bring the IFL to 100%
Is this a z990, or is it a smaller box? How much memory (CSTOR:XS
58 AM
To: LINUX-390@VM.MARIST.EDU
Subject: Oracle 10G POOR performance
Looking to take the easy way out by just asking question. We are
running Z/vm 5.1, Suse 8, and Oracle 10GJust
starting to test performance..3 oracle queries will bring the IFL to
100%--the IFL seems to take all o
Melissa,
> 3 oracle queries will bring the IFL to 100%
Is this a z990, or is it a smaller box? How much memory (CSTOR:XSTOR)
does the z/VM LPAR have?
> Linux guest is 750M.
Is Linux swapping at this point? Also, how many other Linuxes are running
and what are their machine sizes?
> I am leanin
What kind of processor and DASD? Do you have any monitoring tools?
Perry, Melissa wrote:
Looking to take the easy way out by just asking question. We are
running Z/vm 5.1, Suse 8, and Oracle 10GJust
starting to test performance..3 oracle queries will bring the IFL to
100%--the IFL seem
Looking to take the easy way out by just asking question. We are
running Z/vm 5.1, Suse 8, and Oracle 10GJust
starting to test performance..3 oracle queries will bring the IFL to
100%--the IFL seems to take all of the expanded storage we give it. The
Linux guest is 750M.
Unfortunately
19 matches
Mail list logo
