03-29-2010
Solaris 10 Slowness
Hi,
We have got 2 solaris boxes, since our inhouse application has certified on solaris environment and now we need to certify the performance of that application on Solaris environment.
1 box we have installed websphere and the other box we have installed Oracle 10.2.0.3. both are 64bit.
Now we have created a oracle schema on the Oracle which is on Solaris 10, started executing a batch file for generating Volume data. The batch file execute the sql file to generate the volume data by inserting records in to the tables using simple insert command. We have generated 1Lakh records in 30min on Oracle which is installed on windows 4 CPU with 4GB RAM. but on Solaris it is taking more than 3hrs. The Oracle configuration is same as it is there on Windows. More over our DBA is saying the database wise the configurations and all are fine.
We are not aware anything about the Solaris box. Can some one help us in identifying the problem.
The Solaris box configuration is as follows:
Sun Fire V480 - Processor two dual-processor CPU/Memory Boards 1200-MHz UltraSPARC III Cu - 64-bit, 4-way superscalar SPARC V9
HDD - 250GB
RAM - 16 GB
Thanks & Regards,
Ram
9 More Discussions You Might Find Interesting
1. Linux
Hi,
I have a Linux 8.0 Redhat installed as a server. The samba configuration was done to allowed logging in to the server from windows workstations. I have a LAN, WAN connection. However, any time the workstation is trying to make a WAN connection it slow down all the systems on the network.
Can... (0 Replies)
Discussion started by: kayode
0 Replies
2. SCO
I have attempted to2find answers to this question:
When logging into tty01 the system will take 5 to 10 seconds to display each character typed. Each other terminal will login correctly and display correctly2but not the first terminal. Rebooting was suggested on several sites and this has been... (2 Replies)
Discussion started by: ypanic
2 Replies
3. HP-UX
We recently moved from a Open VMS OS to HP-UX. When printing labels on Intermec 3400 printers we are seeing a delay of up to 3 minutes before labels print. We have printers going through a DEC Term servers and Jet Direct boxes. Any suggestions what might be causing this delay? (4 Replies)
Discussion started by: BIGJIM
4 Replies
4. Solaris
Hi Folks
My Sun Solaris servers are waiting for a long time after keying in the User-ID. There is a big delay in getting to the password prompt. But once the password is keyed in,it goes through in a second.
The servers in which i am facing this issue is an NIS client. But i am facing this... (7 Replies)
Discussion started by: Hari_Ganesh
7 Replies
5. Solaris
Hi
I have a Solaris 10 NIS server and more than 250 NIS clients out of these there are 5 main application servers, and whenever there is any compilation happens on any of the application servers (which are acting as NIS clients) entire NIS performance will come down.Can some one help me to fix... (5 Replies)
Discussion started by: nithnara
5 Replies
6. Solaris
Hi admins,
After changing the ip address(temperorily) ssh to that server is very slow(exactly 25 sec).But from this new ip i can ssh to other servers without any delay problem.
debug1: match: Sun_SSH_1.1.1 pat Sun_SSH_1.1.1*
debug1: Enabling compatibility mode for protocol 2.0
debug1:... (2 Replies)
Discussion started by: newsol
2 Replies
7. Solaris
Hi!
I have a m3000 server with solaris 10. Clients connecting to server using Xmanager. But when they open a Java based application its very slow and some times hanging. But when I tried with VNC it works fine. Is this a BUG in Xmanager? Or Is there any method to solve this?
Thanks,
Charith (3 Replies)
Discussion started by: charith.upendra
3 Replies
8. Solaris
Need assitance in troubleshooting steps . Below is the issue
I have LDOM which has 4 zones on it . One zone logging into the server takes 13sec where as other zones are quick .
Troubleshooting steps which I did
- Checked /var/tmp . Not many files
- We have LDAP but thought that wouldnt be... (7 Replies)
Discussion started by: ajayram_arya
7 Replies
9. AIX
Oracle database is facing slowness issues frequently on AIX server. So can anybody suggest how to fix these issues from OS end? Do we need to tune any parameter in AIX to resolve this issue?
Please post in an adequate forum! (1 Reply)
Discussion started by: vithal
1 Replies
LEARN ABOUT OSX
dbix::class::storage::dbi::oracle::wherejoins
DBIx::Class::Storage::DBI::Oracle::WhereJoins(3) User Contributed Perl Documentation DBIx::Class::Storage::DBI::Oracle::WhereJoins(3)
NAME
DBIx::Class::Storage::DBI::Oracle::WhereJoins - Oracle joins in WHERE syntax support (instead of ANSI).
PURPOSE
This module is used with Oracle < 9.0 due to lack of support for standard ANSI join syntax.
SYNOPSIS
DBIx::Class should automagically detect Oracle and use this module with no work from you.
DESCRIPTION
This class implements Oracle's WhereJoin support. Instead of:
SELECT x FROM y JOIN z ON y.id = z.id
It will write:
SELECT x FROM y, z WHERE y.id = z.id
It should properly support left joins, and right joins. Full outer joins are not possible due to the fact that Oracle requires the entire
query be written to union the results of a left and right join, and by the time this module is called to create the where query and table
definition part of the SQL query, it's already too late.
METHODS
See DBIx::Class::SQLMaker::OracleJoins for implementation details.
BUGS
Does not support full outer joins. Probably lots more.
SEE ALSO
DBIx::Class::SQLMaker
DBIx::Class::SQLMaker::OracleJoins
DBIx::Class::Storage::DBI::Oracle::Generic
DBIx::Class
AUTHOR
Justin Wheeler "<jwheeler@datademons.com>"
CONTRIBUTORS
David Jack Olrik "<djo@cpan.org>"
LICENSE
This module is licensed under the same terms as Perl itself.
perl v5.16.2 2012-08-16 DBIx::Class::Storage::DBI::Oracle::WhereJoins(3)