OraFAQ Forum: Performance Tuning » Performance issue in oracle 10g database

Home » RDBMS Server » Performance Tuning » Performance issue in oracle 10g database (WINDOW SERVER 2008)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Performance issue in oracle 10g database [message #660640]

Thu, 23 February 2017 06:11

NIJ1611
Messages: 17
Registered: February 2017

Junior Member

I have generated AWR report in our database server. AWR report are attached here.
please give me suggestion for improving performance in our database server .
--------------------------------------------------------------------------------
lease give me mail id , i have sending awr reports in your mail id .There are no option to upload
html format file.

Report message to a moderator

Re: Performance issue in oracle 10g database [message #660643 is a reply to message #660640]

Thu, 23 February 2017 07:18

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

You can upload html files just fine, the forum doesn't care what the file type is.

Report message to a moderator

Re: Performance issue in oracle 10g database [message #660644 is a reply to message #660640]

Thu, 23 February 2017 07:46

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

NIJ1611 wrote on Thu, 23 February 2017 04:11

I have generated AWR report in our database server. AWR report are attached here.
please give me suggestion for improving performance in our database server .
--------------------------------------------------------------------------------
lease give me mail id , i have sending awr reports in your mail id .There are no option to upload
html format file.

What is OS Name & version of DB Server system?
What is full result of SQL below?

SELECT * FROM V$VERSION;

Are you licensed to use the Diagnostic Pack & AWR Reports?

post SQL & results that show some performance problem actually exists.

Report message to a moderator