No question at this time
DBA Top 10
1 M. Cadot 6500
2 B. Vroman 2700
3 J. PĂ©ran 1600
4 P. Tsongayinwe 1500
5 P. Wisse 1200
6 A. Kavsek 1100
7 D. Walgude 400
7 J. Schnackenberg 400
9 J. Alcroft 200
10 A. Hudspith 100
10 D. Johnson 100
10 B. B 100
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48695
Total active users1320
Act. users last 24h0
Act. users last hour0
Registered user hits last week12
Registered user hits last month347
Go up

AWR section
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...... Score: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 Pts Philip Wisse Sep 09, 2022, 14:22
In addition, the begin and end are the values of...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts 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. ...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts 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, 26 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, 25 days ago
Score:   Score: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 Pts
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, 25 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
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, 21 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, 20 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, 20 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
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, 20 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