Go up

Next thread:	Can create 2 wallet in oracle 19c? if yes what entries need to give in sqlnet.ora for commutation?
Prev thread:	AWR section

Message	Score	Author	Date
Hi Team, What is this "Database Resource Limits......		Phuti Tsongayinwe	Sep 08, 2022, 17:00
Hi Phuti, These parameters are important for th......		Philip Wisse	Sep 09, 2022, 14:22
In addition, the begin and end are the values of......		Michel Cadot	Sep 09, 2022, 16:09
Thanks, Gentlemen. Much appreciated !!!...		Phuti Tsongayinwe	Sep 13, 2022, 13:41
Good morning, Is using the AMM recommended or o......		Phuti Tsongayinwe	Sep 14, 2022, 09:20
This question would be worthy of a new thread. ......		Philip Wisse	Sep 14, 2022, 09:41
Thanks Philip...		Phuti Tsongayinwe	Sep 14, 2022, 09:59

Follow up by mail

Click here

---

Subject:	AWR section
Author:	Phuti Tsongayinwe, South Africa
Date:	Sep 08, 2022, 17:00, 267 days ago
Os info:	Oracle Solaris 11.4 SPARC.
Oracle info:	Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.13.0.0.0
Message:	Hi Team, What is this "Database Resource Limits" section in AWR represent? Database Resource Limits Begin End CPUs: 32 32 SGA Target: 0 0 PGA Target: 5,367,660,544 5,367,660,544 Memory Target 26,843,545,600 26,843,545,600 and why would the SGA Target value for begin and end be zero...? Please help... Thanks in advance... Thanks P
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here

---

Subject:	Re: AWR section
Author:	Philip Wisse, Netherlands
Date:	Sep 09, 2022, 14:22, 267 days ago
Score:
Message:	Hi Phuti, These parameters are important for the performance of your database. The values are retrievable from your database: 'show param target' The DBA can set the parameters when installing Oracle (defaults are always provided) and change them afterwards. HTH, Philip
Your rating?:	This reply is Good Excellent
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here

---

Subject:	Re: AWR section
Author:	Michel Cadot, France
Date:	Sep 09, 2022, 16:09, 267 days ago
Score:
Message:	In addition, the begin and end are the values of these parameters at the beginning and end of the AWR period you consider. sga_target may be 0 if you want to disable SGA autotuning but often DBAs let it to 0 when using memory_target which enables autotuning of the total SGA+PGAs. Regards Michel
Your rating?:	This reply is Good Excellent
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here

---

Subject:	Re: AWR section
Author:	Phuti Tsongayinwe, South Africa
Date:	Sep 13, 2022, 13:41, 263 days ago
Message:	Thanks, Gentlemen. Much appreciated !!!
Your rating?:	This reply is Good Excellent
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here

---

Subject:	Re: AWR section
Author:	Phuti Tsongayinwe, South Africa
Date:	Sep 14, 2022, 09:20, 262 days ago
Message:	Good morning, Is using the AMM recommended or one should opt to use the sga_target and the pga_target instead of AMM? What is the best practice, is it use the sga_target and pga_target or the AMM? Thanks P
Your rating?:	This reply is Good Excellent
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here

---

Subject:	Re: AWR section
Author:	Philip Wisse, Netherlands
Date:	Sep 14, 2022, 09:41, 262 days ago
Score:
Message:	This question would be worthy of a new thread. As for myself, I like the simplicity of setting a memory_target and let Oracle take care or the rest.
Your rating?:	This reply is Good Excellent
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here

---

Subject:	Re: AWR section
Author:	Phuti Tsongayinwe, South Africa
Date:	Sep 14, 2022, 09:59, 262 days ago
Message:	Thanks Philip
Your rating?:	This reply is Good Excellent
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here