Home » Other » General » AWR (Oracle 10g, Win XP)
AWR [message #500732] Wed, 23 March 2011 04:48 Go to next message
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
Re: AWR [message #500733 is a reply to message #500732] Wed, 23 March 2011 05:28 Go to previous messageGo to next message
Michel Cadot
Messages: 68042
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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.
Re: AWR [message #500738 is a reply to message #500737] Wed, 23 March 2011 05:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68042
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: AWR [message #502383 is a reply to message #500732] Wed, 06 April 2011 03:08 Go to previous messageGo to next message
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
Re: AWR [message #502387 is a reply to message #502383] Wed, 06 April 2011 03:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68042
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: AWR [message #502388 is a reply to message #502387] Wed, 06 April 2011 03:28 Go to previous messageGo to next message
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
Re: AWR [message #502395 is a reply to message #502388] Wed, 06 April 2011 03:37 Go to previous messageGo to next message
cookiemonster
Messages: 13894
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.
Re: AWR [message #502399 is a reply to message #502395] Wed, 06 April 2011 03:45 Go to previous messageGo to next message
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.
Re: AWR [message #502434 is a reply to message #502399] Wed, 06 April 2011 05:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68042
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database 2 Day DBA
Database Performance Tuning Guide

Regards
Michel
Re: AWR [message #502460 is a reply to message #502434] Wed, 06 April 2011 08:26 Go to previous messageGo to next message
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
Re: AWR [message #502463 is a reply to message #502460] Wed, 06 April 2011 08:37 Go to previous message
Michel Cadot
Messages: 68042
Registered: March 2007
Location: Nanterre, France, http://...
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:
  


Current Time: Tue Nov 30 03:42:42 CST 2021