OraFAQ Forum: General

Home » Other » General » AWR (Oracle 10g, Win XP)

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

AWR [message #500732]

Wed, 23 March 2011 04:48

gxeon
Messages: 53
Registered: January 2011
Location: Mumbai

Member

Hello Sir

Need one help...i am taking the AWR report 2 times per day on Production Server since last one week due to which my SYSAUX tablespace is getting full. what should i do ?

please let me know is it ok?, to take AWR report on daily basis on Production Server ?

how can i remove the old AWR reports in order to make free space in SYSAUX ?

GG

Report message to a moderator

Re: AWR [message #500733 is a reply to message #500732]

Wed, 23 March 2011 05:28

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

what should i do ?

Either increase the tablespace or purge old awr data

Quote:

is it ok?, to take AWR report on daily basis on Production Server ?

Do you use them? If not, why do you generate them?

Quote:

how can i remove the old AWR reports in order to make free space in SYSAUX ?

To manually purge them, you can use

BEGIN
  dbms_workload_repository.drop_snapshot_range(low_snap_id => <XXX>, high_snap_id=><YYY>);
END;
/

You can use DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS to modify the retention period.

Regards
Michel

[Updated on: Wed, 23 March 2011 05:44]

Report message to a moderator

Re: AWR [message #500737 is a reply to message #500733]

Wed, 23 March 2011 05:42

gxeon
Messages: 53
Registered: January 2011
Location: Mumbai

Member

Sir Thanks for the reply.is this right that after taking each AWR reports , the SYSAUX tablespace size gets increased. because since i started taking AWR reports my SYSAUX tablespace size getting increased.

Report message to a moderator

Re: AWR [message #500738 is a reply to message #500737]

Wed, 23 March 2011 05:45

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Not it is not.
There are some bugs in different versions, have a look at Metalink/My Oracle Support site.

Regards
Michel

Report message to a moderator

Re: AWR [message #502383 is a reply to message #500732]

Wed, 06 April 2011 03:08

gxeon
Messages: 53
Registered: January 2011
Location: Mumbai

Member

hello Sir

In my Production Database, the size of Temporary tablespace is getting reduced day by day? can u please help me to find out the cause behind this. i also used v$tempseg_usage, View to monitor the temporary space usage but it gives no rows selected.

I am new to Oracle DBA, please suggest me how to check why the size of temporary tablespace is getting reduced so frequently, and what will be the ways to manage this.

GG

Report message to a moderator

Re: AWR [message #502387 is a reply to message #502383]

Wed, 06 April 2011 03:18

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Don't care about the "size" of temporary tablespace unless you come short of it (and get error messages).

Regards
Michel

Report message to a moderator

Re: AWR [message #502388 is a reply to message #502387]

Wed, 06 April 2011 03:28

gxeon
Messages: 53
Registered: January 2011
Location: Mumbai

Member

But Sir Users complains sometimes, that the Database performance gets slower sometimes.i took the AWR reports also, i dont know on which section of AWR i have focus more, for improving the performance.

please Help

Report message to a moderator

Re: AWR [message #502395 is a reply to message #502388]

Wed, 06 April 2011 03:37

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

Senior Member

Are the users complaining about the performance of the application or particular bits?
If bits then you should probably look at what those bits are actually doing rather than the awr.

Report message to a moderator

Re: AWR [message #502399 is a reply to message #502395]

Wed, 06 April 2011 03:45

gxeon
Messages: 53
Registered: January 2011
Location: Mumbai

Member

Thanks Sir,

i will check it out, what you said. can you please guide me how to maintain the performance of my Production Database.what are the necessary ways to maintain a good performance. i am new to Oracle DBA.

Report message to a moderator

Re: AWR [message #502434 is a reply to message #502399]

Wed, 06 April 2011 05:03

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Database 2 Day DBA
Database Performance Tuning Guide

Regards
Michel

Report message to a moderator

Re: AWR [message #502460 is a reply to message #502434]

Wed, 06 April 2011 08:26

gxeon
Messages: 53
Registered: January 2011
Location: Mumbai

Member

Hello

I am new to Oracle DBA....today i took the AWR report and i got these 'Top 5 Timed Events'. but i am not understanding it correctly, can anyone please help in this regard.

GG

Top 5 Timed Events Avg %Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
log file sync 22,404 6,638 296 55.1 Commit
LGWR wait on LNS 29,075 6,285 216 52.2 Network
LGWR-LNS wait on channel 439,776 6,285 14 52.2 Other
LNS wait on SENDREQ 29,025 6,283 216 52.2 Network
log buffer space 3,155 2,834 898 23.5 Configurat

Report message to a moderator

Re: AWR [message #502463 is a reply to message #502460]

Wed, 06 April 2011 08:37

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If you want to learn then you have to FIRST read.
The second link will give the explaination of the event you have in your report.

Regards
Michel

[Updated on: Wed, 06 April 2011 08:37]

Report message to a moderator

Previous Topic:	Active Sessions
Next Topic:	No more puzzles?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 16:34:07 CST 2024