Hey, Are you running the Oracle provided Spacewalk or the upstream project? If the former and you have Oracle Linux support subscription, I'd suggest logging an SR for this, so our development team can evaluate. We've been doing some work with 2.7 to improve the efficiency of the SQL queries, but we have a lot of queries to evaluate. :)
By logging an SR, you can focus our attention on particular queries. :) If not, I would suggest upgrading to Spacewalk 2.7 because that does have SOME improvements for performance, but I can't guarantee that it's in the areas impacting your install. Thanks, Avi > On 18 Apr 2018, at 1:22 pm, Andrason, Jackie <[email protected]> > wrote: > > We currently have over 2,500 systems using spacewalk with 5 proxies in the > data centers. It runs on Oracle Linux 7.4 and uses an external oracle 12c > database. We use it strictly for server patching. Memory got to be an > issue, so we upped memory on the server from 32 to 64g and the DBA increased > the database sga. We also changed the tomcat JAVA_OPTS -Xms4096m -Xmx8192m. > The web interface, when trying to bring up the Systems list, is extremely > slow. It is also slow when bringing up lists of packages in repo, but not as > slow as the Systems. Other things, repo listing, seem to be ok, and server > updates and new registrations are fine. Running the spacewalk-report > inventory returns quickly as well. > > I am thinking this is a java thing, but I don’t know. Anyone have any > experience with this issue? > > > Thanks! > > Jackie > Unix/Linux Server Support > > > > > > ________________________________________ > IMPORTANT - PLEASE READ: This electronic message, including its attachments, > is CONFIDENTIAL and may contain PROPRIETARY or LEGALLY PRIVILEGED or > PROTECTED information and is intended for the authorized recipient of the > sender. If you are not the intended recipient, you are hereby notified that > any use, disclosure, copying, or distribution of this message or any of the > information included in it is unauthorized and strictly prohibited. If you > have received this message in error, please immediately notify the sender by > reply e-mail and permanently delete this message and its attachments, along > with any copies thereof, from all locations received (e.g., computer, mobile > device, etc.). Thank you. > > _______________________________________________ > Spacewalk-list mailing list > [email protected] <mailto:[email protected]> > https://www.redhat.com/mailman/listinfo/spacewalk-list > <https://www.redhat.com/mailman/listinfo/spacewalk-list> -- Oracle <http://www.oracle.com> Avi Miller | Product Management Director | +61 (3) 8616 3496 Oracle Linux and Virtualization 417 St Kilda Road, Melbourne, Victoria 3004 Australia
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
