No question at this time
DBA Top 10
1 M. Cadot 10000
2 B. Vroman 7600
3 A. Kavsek 3900
4 J. PĂ©ran 1500
5 P. Wisse 1300
6 T. Boles 600
6 D. Johnson 600
8 D. Dave 400
9 S. Spb 300
9 J. Schnackenberg 300
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48635
Total active users1396
Act. users last 24h0
Act. users last hour0
Registered user hits last week161
Registered user hits last month583
Go up

active dataguard usage
Next thread: how to find which remote db is accessing source db over db link
Prev thread: About REF datatype

Message Score Author Date
Hi Guys, I have been investigating the usage of...... Tso P Aug 31, 2021, 09:26
I suggest you download and execute McOptions: ...... Score: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 Pts Michel Cadot Aug 31, 2021, 09:36
Thanks for your prompt response Michel. ... Tso P Aug 31, 2021, 11:00
Hello Tso, you mention that "COUNT(*)" gives ro...... Score: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 Pts Bruno Vroman Sep 01, 2021, 10:53
Thanks Bruno <pre> NAME ...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Tso P Sep 02, 2021, 15:57
Generally speaking if DETECTED_USAGES is 0 this ...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Michel Cadot Sep 02, 2021, 20:08
Thanks, Michel I will install the MacOptions an...... Tso P Sep 02, 2021, 21:27
I meant McOptions. ... Tso P Sep 02, 2021, 21:28

Follow up by mail Click here


Subject: active dataguard usage
Author: Tso P, South Africa
Date: Aug 31, 2021, 09:26, 19 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, 19 days ago
Score:   Score: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 Pts
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: Tso P, South Africa
Date: Aug 31, 2021, 11:00, 19 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, 18 days ago
Score:   Score: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 Pts
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: Tso P, South Africa
Date: Sep 02, 2021, 15:57, 17 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
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, 17 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
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: Tso P, South Africa
Date: Sep 02, 2021, 21:27, 17 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: Tso P, South Africa
Date: Sep 02, 2021, 21:28, 17 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