[Building Sakai] Performance problem

[Jon Gorrono]

 some suggestions from our DBA :

Hi,

We can make some suggestions. Please run the below reports and send us
the output.

sakai_params.lis
sakai_awr_report.log

Thanks,
Prabhu

====================oracle parameters====at sql prompt===

spool sakai_params.lis

show parameters

spool off;


==================AWR report during poor performance======at sql prompt======

EXECUTE DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT();

---With a 10 min gap create another snapshot---------

EXECUTE DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT();


select max(snap_id) from dba_hist_snapshot;

MAX(SNAP_ID)
------------
11451


select max(snap_id - 1) from dba_hist_snapshot;

MAX(SNAP_ID-1)
--------------
11450

@$ORACLE_HOME/rdbms/admin/awrrpt.sql


Enter value for report_type: text


Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 11450
Begin Snapshot Id specified: 11450

Enter value for end_snap: 11451
End Snapshot Id specified: 11451



Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrrpt_1_11450_11451.txt. To use this name,
press <return> to continue, otherwise enter an alternative.

Enter value for report_name: sakai_awr_report.log

===================================================================================




On Tue, Sep 29, 2009 at 8:31 PM, Joshua Swink <jswink at ucmerced.edu> wrote:
> We have about a maximum of 600 concurrent users and our performance is
> pretty poor. The application servers aren't working very hard so I
> suspect the database server. It's running Oracle 10 on a Sun V880 with
> 8 GB RAM and 8 750MHz CPUs. We also store the resources in the
> database. The database is about 100 GB in size right now.
>
> What's the best way to configure Oracle in this situation? What memory
> settings should we use?
>
> Thanks for any help.
>
> --
> Joshua Swink
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
>



-- 
Jon Gorrono
PGP Key: 0x5434509D -
http{pgp.mit.edu:11371/pks/lookup?search=0x5434509D&op=index}
Thawte Notary - https{www.thawte.com/cgi/personal/wot/directory.exe?node=312}
GSWoT Introducer - {GSWoT:US75 5434509D Jon P. Gorrono <jpgorrono - gswot.org>}
http{ats.ucdavis.edu}

Sent from Davis, CA, United States