No question at this time
DBA Top 10
1 M. Cadot 5400
2 P. Wisse 1300
3 P. Tsongayinwe 1100
4 B. Vroman 500
4 J. Schnackenberg 500
6 M. Pagac 400
7 A. Deledda 200
7 D. Walgude 200
7 B. M 200
10 J. Alcroft 100
10 G. Trivedi 100
10 A. Hudspith 100
10 V. Sharma 100
10 L. Ywema 100
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48742
Total active users1337
Act. users last 24h1
Act. users last hour0
Registered user hits last week108
Registered user hits last month471
Go up

AWR section
Next thread: AWR section
Prev thread: index stale_stats

Message Score Author Date
Hi Team, What is this "Database Resource Limits...... Phuti Tsongayinwe Sep 08, 2022, 17:00
Thread is double please do not reply... Philip Wisse Sep 09, 2022, 14:14

Follow up by mail Click here


Subject: AWR section
Author: Phuti Tsongayinwe, South Africa
Date: Sep 08, 2022, 17:00, 268 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:14, 267 days ago
Message: Thread is double please do not reply
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here