No question at this time
DBA Top 10
1 M. Cadot 6600
2 B. Vroman 3400
3 J. PĂ©ran 2200
4 A. Kavsek 1400
5 P. Tsongayinwe 900
6 P. Wisse 600
7 T. Boles 400
7 D. Walgude 400
7 D. Johnson 400
10 J. Alcroft 200
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48675
Total active users1330
Act. users last 24h2
Act. users last hour0
Registered user hits last week40
Registered user hits last month504
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...... Phuti Tsongayinwe 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. ... Phuti Tsongayinwe 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 Phuti Tsongayinwe 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...... Phuti Tsongayinwe Sep 02, 2021, 21:27
I meant McOptions. ... Phuti Tsongayinwe Sep 02, 2021, 21:28

Follow up by mail Click here


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:   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: 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:   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: Phuti Tsongayinwe, South Africa
Date: Sep 02, 2021, 15:57, 299 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, 299 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: 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