This manual describes a lists for some scripts that can be executed to see (some of) the components that should be licensed:
Number of users and CPU/Processors
|
1 |
select * from v$license; |
Please note that the information provided by this command is not trustworthy on multi-threaded, multi-core or virtual systems. It is the number of processors understood to be available by the database – not the number of processors which must be licensed.
Database edition:
|
1 |
select banner from v$version where BANNER like '%Edition%'; |
Oracle Partitioning:
|
1 2 3 4 5 |
select decode(count(*), 0, 'No', 'Yes') Partitioning from ( select 1 from dba_part_tables where owner not in ('SYSMAN', 'SH', 'SYS', 'SYSTEM') and rownum = 1 ); |
Please note – on Enterprise Edition, Partitioning will almost always be installed. It is used by Oracle database itself – this command in isolation will not provide information on license requirement.
Oracle Spatial:
|
1 2 3 4 |
select decode(count(*), 0, 'No', 'Yes') Spatial from ( select 1 from all_sdo_geom_metadata where rownum = 1 ); |
Oracle RAC:
|
1 2 3 4 |
select decode(count(*), 0, 'No', 'Yes') RAC from ( select 1 from v$active_instances where rownum = 1 ); |
Options installed/not installed: (from 9i)
|
1 2 3 4 5 6 7 8 |
Col name format a50 heading "Option" Col value format a5 heading "?" justify center wrap Break on value dup skip 1 Spool option Select parameter name, value from v$option order by 2 desc, 1 / |
Features used/not used: (from 10g)
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
Set feedback off Set linesize 122 Col name format a45 heading "Feature" Col version format a10 heading "Version" Col detected_usages format 999,990 heading "Detected|usages" Col currently_used format a06 heading "Curr.|used?" Col first_usage_date format a10 heading "First use" Col last_usage_date format a10 heading "Last use" Col nop noprint Break on nop skip 1 on name Select decode(detected_usages,0,2,1) nop, name, version, detected_usages, currently_used, to_char(first_usage_date,'DD/MM/YYYY') first_usage_date, to_char(last_usage_date,'DD/MM/YYYY') last_usage_date from dba_feature_usage_statistics order by nop, 1, 2 / |
Please let me know if this manual ‘Oracle license detection’ was usefull to you. If there are errors or you have suggestions regarding this manual, please let me know.
No rights can be derived from this Installation manual
Regards,
Maarten
5 Responses to “Oracle license detection”
Our New Womens Nike Free Run 5.0 V2 Purple Running Come To Buy Now
It’s a shame you don’t have a donate button! I’d most certainly donate to this outstanding blog! I suppose for now i’ll settle for book-marking and adding your RSS feed to my Google account. I look forward to fresh updates and will share this blog with my Facebook group. Talk soon!
vendita nike and new balance
Howdy! I know this is kinda off topic however I’d figured I’d ask. Would you be interested in trading links or maybe guest writing a blog article or vice-versa? My website goes over a lot of the same subjects as yours and I think we could greatly benefit from each other. If you are interested feel free to shoot me an e-mail. I look forward to hearing from you! Superb blog by the way!
toms/nike herre og barn online
This design is spectacular! You obviously know how to keep a reader entertained. Between your wit and your videos, I was almost moved to start my own blog (well, almost…HaHa!) Great job. I really loved what you had to say, and more than that, how you presented it. Too cool!
Loretta
You really make it seem so easy together with your presentation but I to find this matter to be actually something which I believe I would
never understand. It sort of feels too complicated and very extensive for me.
I am looking ahead to your subsequent post, I will try to
get the hang of it!
Danyel
We are a group of volunteers and starting a new
scheme in our community. Your site provided us with
useful information to work on. You have performed an impressive task and our entire community will probably be thankful to you.