Home » RDBMS Server » Performance Tuning » Performance issue in oracle 10g database (WINDOW SERVER 2008)
Performance issue in oracle 10g database [message #660640] Thu, 23 February 2017 06:11 Go to next message
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.
Re: Performance issue in oracle 10g database [message #660643 is a reply to message #660640] Thu, 23 February 2017 07:18 Go to previous messageGo to next message
cookiemonster
Messages: 13917
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.
Re: Performance issue in oracle 10g database [message #660644 is a reply to message #660640] Thu, 23 February 2017 07:46 Go to previous messageGo to next message
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.
Re: Performance issue in oracle 10g database [message #660648 is a reply to message #660640] Thu, 23 February 2017 08:19 Go to previous messageGo to next message
NIJ1611
Messages: 17
Registered: February 2017
Junior Member
Database version: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64biT

Os version : Microsoft server 2008
Re: Performance issue in oracle 10g database [message #660649 is a reply to message #660648] Thu, 23 February 2017 08:26 Go to previous message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
So now you need to supply the awr report.
Previous Topic: Query is taking longer duration
Next Topic: Oracle 12c -Query CPU Cost is very high
Goto Forum:
  


Current Time: Thu Mar 28 11:59:26 CDT 2024