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 users1328
Act. users last 24h0
Act. users last hour0
Registered user hits last week24
Registered user hits last month452
Go up

McOptions
Next thread: SQL Query help
Prev thread: impdp errors

Message Score Author Date
Hi, I wish you a happy and healthy new year. ...... Michel Cadot Jan 31, 2022, 09:56
Done :) Best regards, Joel... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Joël Péran Feb 01, 2022, 08:06
Thanks you. This will help me to help the Oracl...... Michel Cadot Feb 01, 2022, 08:12
Done... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts dattatraya walgude Feb 03, 2022, 09:24
I got it, thanks, it will be useful. Regards ...... Michel Cadot Feb 03, 2022, 16:25
Hello Michel, sorry, our Security mechanisms prev...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Bruno Vroman Feb 04, 2022, 10:21
Thanks for trying. I gave 2 ways: - email me...... Michel Cadot Feb 04, 2022, 11:06
[content removed on request of the author] ... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Bruno Vroman Feb 04, 2022, 11:17
[content removed on request of the author]... Bruno Vroman Feb 04, 2022, 11:17
[content removed on request of the author]... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Bruno Vroman Feb 04, 2022, 11:19
[content removed on request of the author]... Bruno Vroman Feb 04, 2022, 11:19
[content removed on request of the author]... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Bruno Vroman Feb 04, 2022, 11:21
[content removed on request of the author]... Bruno Vroman Feb 04, 2022, 11:22
[content removed on request of the author]... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Bruno Vroman Feb 04, 2022, 11:23
[content removed on request of the author]... Bruno Vroman Feb 04, 2022, 11:25
<i>Ouch! posting a reply on OraFAQ also raised a...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Michel Cadot Feb 04, 2022, 12:16
Thank you Michel.  <<<i>very restrictive</i>>> ...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Bruno Vroman Feb 04, 2022, 18:50

Follow up by mail Click here


Subject: McOptions
Author: Michel Cadot, France
Date: Jan 31, 2022, 09:56, 153 days ago
Oracle info: 10gR2->21c+
Message: Hi,

I wish you a happy and healthy new year.

I'm currently rewriting McOptions (http://www.orafaq.com/forum/t/207891/) to support all environments and not only "On-Premise" ones and better support these later ones when on Engineered Systems (Oracle Database Appliance and Exadata) currently not fully supported.

This new version will also allow you to simulate the options you have to buy if you choose another configuration or, if you want to downgrade to a lower configuration, if this is possible and under which conditions.

As I have not access to all possible configurations and want to be sure to give accurate information, I ask for your help, please execute the following script (record it in a file and execute the file in SQL*Plus or other SQL client), for any version from 10gR2 to 21c+, and send me the spool file with a Private Message on OraFAQ (http://www.orafaq.com/forum/ this will hide your actual email address) or at orafaq@netcourrier.com
set echo off feedback off heading off linesize 160 trimout on trimspool on pagesize 1000

col dt new_value dt
select to_char(systimestamp,'YYYYMMDDHH24MISSFF3') dt from dual
/
spool McOptions_&dt..txt
prompt
select banner from v$version where banner like 'Oracle%'
/
prompt
select banner_full from v$version
/
prompt
select 'ODA_INFRASTRUCTURE -> '||sys_context('SYS_CLUSTER_PROPERTIES','ODA_INFRASTRUCTURE') from dual
/
prompt
select 'ODA_TYPE -> '||sys_context('SYS_CLUSTER_PROPERTIES','ODA_TYPE') from dual
/
prompt
select 'EXADATA -> '||decode(count(*), 0,'NO', 'YES') from (select distinct cell_name from gv$cell_state)
/
prompt
set heading on
select distinct name features from dba_feature_usage_statistics order by 1
/
spool off

It does not matter if some queries return an error, it is even expected depending on the environment.
Note: you need the SELECT privileges on the queried views (v$version, gv$cell_state and dba_feature_usage_statistics) or the SELECT_CATALOG_ROLE role or the SELECT ANY DICTIONARY privilege.

Thank you for your cooperation.

Regards
Michel

http://www.orafaq.com/forum/t/207891/

Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: McOptions
Author: Joël Péran, France
Date: Feb 01, 2022, 08:06, 152 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Done :)
Best regards,
Joel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: McOptions
Author: Michel Cadot, France
Date: Feb 01, 2022, 08:12, 152 days ago
Message:
Thanks you.
This will help me to help the Oracle community. :)

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: McOptions
Author: dattatraya walgude, India
Date: Feb 03, 2022, 09:24, 150 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Done
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: McOptions
Author: Michel Cadot, France
Date: Feb 03, 2022, 16:25, 149 days ago
Message:
I got it, thanks, it will be useful.

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: McOptions
Author: Bruno Vroman, Belgium
Date: Feb 04, 2022, 10:21, 149 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Hello Michel,
sorry, our Security mechanisms prevent me of sending you files:
<<Your requested URL has been blocked by the URL Filter database module of the proxy infrastructure
The HTTP method "POST" is not allowed for the category of this URL via our infrastructure.>>
Do you have an alternative?
I wanted to send you four files: (Oracle 12.1.0.2 + Oracle 19.11) X (Exadata + nonExadata)
Best regards,
Bruno
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: McOptions
Author: Michel Cadot, France
Date: Feb 04, 2022, 11:06, 149 days ago
Message:
Thanks for trying.

I gave 2 ways:
- email me at orafaq@netcourrier.com
- connect on OraFAQ and use Private Messaging feature to send the files.

I see, in your post and OraFAQ PM, you can't do it with the later but can you send them directly?

The last option I see is to go to the OraFAQ topic
http://www.orafaq.com/forum/t/207891/
and put inside a post the content of the files (I will remove it as far as I can). You won't them not use the problematic POST method.

Your files will indeed be most useful for McOptions.

Best 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: McOptions
Author: Bruno Vroman, Belgium
Date: Feb 04, 2022, 11:17, 149 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: [content removed on request of the author]
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: McOptions
Author: Bruno Vroman, Belgium
Date: Feb 04, 2022, 11:17, 149 days ago
Message: [content removed on request of the author]
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: McOptions
Author: Bruno Vroman, Belgium
Date: Feb 04, 2022, 11:19, 149 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: [content removed on request of the author]
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: McOptions
Author: Bruno Vroman, Belgium
Date: Feb 04, 2022, 11:19, 149 days ago
Message: [content removed on request of the author]
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: McOptions
Author: Bruno Vroman, Belgium
Date: Feb 04, 2022, 11:21, 149 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: [content removed on request of the author]
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: McOptions
Author: Bruno Vroman, Belgium
Date: Feb 04, 2022, 11:22, 149 days ago
Message: [content removed on request of the author]
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: McOptions
Author: Bruno Vroman, Belgium
Date: Feb 04, 2022, 11:23, 149 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: [content removed on request of the author]
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: McOptions
Author: Bruno Vroman, Belgium
Date: Feb 04, 2022, 11:25, 149 days ago
Message: [content removed on request of the author]
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: McOptions
Author: Michel Cadot, France
Date: Feb 04, 2022, 12:16, 149 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message:
Ouch! posting a reply on OraFAQ also raised a security alert...

Oh! Your enterprise is very restrictive.
I got the data I'll send a mail to Geert to remove the content of these posts.

Many thanks for them.

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: McOptions
Author: Bruno Vroman, Belgium
Date: Feb 04, 2022, 18:50, 148 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Thank you Michel.

 <<very restrictive>>

yes, we can say so! ;-) Maybe the price to pay for security (or signs of a coming (I'm kind) paranoïa)

Good luck with your tool!

Bruno
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here