No question at this time
The DBA-Village forum
as RSS feed
Site Statistics| Ever registered users | 48675 | | Total active users | 1330 | | Act. users last 24h | 2 | | Act. users last hour | 0 | | Registered user hits last week | 40 | | Registered user hits last month | 504 |
|
Go up
active dataguard usage
| Message |
Score |
Author |
Date |
   Hi Guys,
I have been investigating the usage of...... |
|
Phuti Tsongayinwe |
Aug 31, 2021, 09:26 |
|
I suggest you download and execute McOptions:
...... |
  |
Michel Cadot |
Aug 31, 2021, 09:36 |
| Thanks for your prompt response Michel. ... |
|
Phuti Tsongayinwe |
Aug 31, 2021, 11:00 |
| Hello Tso,
you mention that "COUNT(*)" gives ro...... |
|
Bruno Vroman |
Sep 01, 2021, 10:53 |
| Thanks Bruno
<pre>
NAME ...... |
|
Phuti Tsongayinwe |
Sep 02, 2021, 15:57 |
|
Generally speaking if DETECTED_USAGES is 0 this ...... |
|
Michel Cadot |
Sep 02, 2021, 20:08 |
| Thanks, Michel
I will install the MacOptions an...... |
|
Phuti Tsongayinwe |
Sep 02, 2021, 21:27 |
| I meant McOptions. ... |
|
Phuti Tsongayinwe |
Sep 02, 2021, 21:28 |
| Subject: |
active dataguard usage |
| Author: |
Phuti Tsongayinwe, South Africa |
| Date: |
Aug 31, 2021, 09:26, 301 days ago |
| Os info: |
solaris 11 |
| Oracle info: |
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production |
| Message: |
Hi Guys,
I have been investigating the usage of active dataguard in our environment and I know for sure that we don't have an active dataguard running or configured.
Now, when I run the below SQL statement on our database, I get the below results:
select count(*) from DBA_FEATURE_USAGE_STATISTICS where name like '%Active Data Guard - Real-Time Query on Physical Standby%';
I get two rows (i.e. the row for 12.1.0.2.0 and 12.2.0.1.0) but the column currently_used is false and the last_sample_date is yesterday.
Now, is this something that I should worry about from the licensing perspective?
Please assist...
Thanks in advance...
|
| Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
| Subject: |
Re: active dataguard usage |
| Author: |
Michel Cadot, France |
| Date: |
Aug 31, 2021, 09:36, 301 days ago |
| Score: |
|
| Message: |
I suggest you download and execute McOptions:
http://www.orafaq.com/forum/t/200328/
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: active dataguard usage |
| Author: |
Phuti Tsongayinwe, South Africa |
| Date: |
Aug 31, 2021, 11:00, 301 days ago |
| Message: |
Thanks for your prompt response 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: active dataguard usage |
| Author: |
Bruno Vroman, Belgium |
| Date: |
Sep 01, 2021, 10:53, 300 days ago |
| Score: |
|
| Message: |
Hello Tso,
you mention that "COUNT(*)" gives rows, that CURRENTLY_USED is false, but what about DETECTED_USAGES, FIRST_USAGE_DATE and LAST_USAGE_DATE?
SELECT NAME, CURRENTLY_USED, DETECTED_USAGES, FIRST_USAGE_DATE, LAST_USAGE_DATE
FROM DBA_FEATURE_USAGE_STATISTICS
WHERE NAME LIKE '%Data Guard%'
;
NAME CURRE DETECTED_USAGES FIRST_USA LAST_USAG
-------------------------------------------------------- ----- --------------- --------- ---------
Active Data Guard - Real-Time Query on Physical Standby FALSE 0
Data Guard TRUE 391 30-SEP-16 29-AUG-21
is OK, but if you have >0 "detected_usages" for "active DG", then it might be that the feature was used "by accident"...
Best regards,
Bruno Vroman |
| Your rating?: |
This reply is Good Excellent |
| Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
| Subject: |
Re: active dataguard usage |
| Author: |
Phuti Tsongayinwe, South Africa |
| Date: |
Sep 02, 2021, 15:57, 299 days ago |
| Score: |
|
| Message: |
Thanks Bruno
NAME CURRE DETECTED_USAGES FIRST_USA LAST_USAG
-------------------------------------------------------------------------------------------------------------------------------- ----- --------------- --------- ---------
Active Data Guard - Real-Time Query on Physical Standby FALSE 0
Active Data Guard - Real-Time Query on Physical Standby FALSE 0
Data Guard FALSE 0
Data Guard FALSE 0
The FIRST_USAGE_DATE and the LAST_USAGE_DATE columns are NULL.
We first installed 12.1.0.2.0 then upgraded to 12.2.0.1.0.
Much appreciated !!!
Thanks |
| Your rating?: |
This reply is Good Excellent |
| Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
| Subject: |
Re: active dataguard usage |
| Author: |
Michel Cadot, France |
| Date: |
Sep 02, 2021, 20:08, 299 days ago |
| Score: |
|
| Message: |
Generally speaking if DETECTED_USAGES is 0 this means Oracle did not detected you use the feature.
McOptions will give you which features you use(d) and which options you have to buy.
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: active dataguard usage |
| Author: |
Phuti Tsongayinwe, South Africa |
| Date: |
Sep 02, 2021, 21:27, 298 days ago |
| Message: |
Thanks, Michel
I will install the MacOptions and have fun.
Thanks
Tso |
| Your rating?: |
This reply is Good Excellent |
| Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
| Subject: |
Re: active dataguard usage |
| Author: |
Phuti Tsongayinwe, South Africa |
| Date: |
Sep 02, 2021, 21:28, 298 days ago |
| Message: |
I meant McOptions. |
| Your rating?: |
This reply is Good Excellent |
| Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
|