No question at this time
DBA Top 10
1 M. Cadot 10900
2 B. Vroman 6700
3 A. Kavsek 5100
4 J. Schnackenberg 3200
5 P. Wisse 3100
6 J. Péran 2200
7 T. Boles 600
8 Z. Hudec 400
8 G. Lambregts 400
8 N. Havard 400
8 F. Pachot 400
8 D. Dave 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48581
Total active users1393
Act. users last 24h5
Act. users last hour0
Registered user hits last week165
Registered user hits last month388
Go up

How do we know that an oracle component is in use ...
Next thread: A dataguard question
Prev thread: 11g Database migration to 19C

Message Score Author Date
Hi everyone, I was wondering something and I...... Joël Péran Jan 18, 2021, 15:46
Hi Joel, You can look at feature usage but I do...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Philip Wisse Jan 18, 2021, 17:35
McOptions: a program which allows to know which ...... Score: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 Pts Michel Cadot Jan 18, 2021, 17:47
Hi, Thanks alot for your replies and thanks...... Joël Péran Jan 19, 2021, 08:01
In the wiki page which Michel has given the link t...... Joël Péran Jan 19, 2021, 08:04
I also have this MOS Note which is quite useful bu...... Joël Péran Jan 19, 2021, 08:19
Well, the tool I created wanted to answer the qu...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Michel Cadot Jan 19, 2021, 10:04
The first quick ideas that come into my mind are...... Michel Cadot Jan 19, 2021, 15:48

Follow up by mail Click here


Subject: How do we know that an oracle component is in use ...
Author: Joël Péran, France
Date: Jan 18, 2021, 15:46, 42 days ago
Os info: Windows 2K16 EE
Oracle info: Oracle 19.9 / 12.1.0.2
Message: Hi everyone,

I was wondering something and I can't find anything on MOS (or at last, some parts from here to there ...). When you have a database with a lot of components installed, how can we know if all these components are used in the database ? In order to get rid of some of them (in order to gain some time during the migration process ... the less component you have, the less time it will take to migrate ...).
Best regards,
Joel
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: How do we know that an oracle component is in use ...
Author: Philip Wisse, Netherlands
Date: Jan 18, 2021, 17:35, 42 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Hi Joel,

You can look at feature usage but I don't think it's going to help you.
https://oracle-base.com/articles/misc/tracking-database-feature-usage

Instead, reduce the size of SYSAUX.
https://dba.stackexchange.com/questions/15790/reduce-size-of-sysaux

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

Subject: Re: How do we know that an oracle component is in use ...
Author: Michel Cadot, France
Date: Jan 18, 2021, 17:47, 42 days ago
Score:   Score: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 Pts
Message:
McOptions: a program which allows to know which options are used in a database:
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: How do we know that an oracle component is in use ...
Author: Joël Péran, France
Date: Jan 19, 2021, 08:01, 41 days ago
Message: Hi,

Thanks alot for your replies and thanks Michel for the great tool ... but it's still not what I want ;-)

In fact, I would like to know which of the component listed in DBA_REGISTRY is really used by the database. If it is not, then it can be uninstalled and don't have to be migrated. I already knew that there was an ability to check the features of the database and which ones were used or not. I am looking for component usage ...
Any idea ? :)

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: How do we know that an oracle component is in use ...
Author: Joël Péran, France
Date: Jan 19, 2021, 08:04, 41 days ago
Message: In the wiki page which Michel has given the link to, I have noticed this for example :

select decode(count(*), 0, 'No', 'Yes') Spatial
from ( select 1
from all_sdo_geom_metadata
where rownum = 1 );

to chech if SPATIAL is in use. It's quite what I would like to have for each component (though I don't know whether it is possible for all components to have a query to check).
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: How do we know that an oracle component is in use ...
Author: Joël Péran, France
Date: Jan 19, 2021, 08:19, 41 days ago
Message: I also have this MOS Note which is quite useful but I don't have all I need ...
Information On Installed Database Components and Schemas (Doc ID 472937.1)

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: How do we know that an oracle component is in use ...
Author: Michel Cadot, France
Date: Jan 19, 2021, 10:04, 41 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message:
Well, the tool I created wanted to answer the question: "Am I using some features I don't have a license for? If so which features and what are the options or packages I have to buy?"

So you have the answer in terms of features and options, what is to do now (and this could be an enhancement of my tool) is to relate the features/options to a component. In some cases, this is the same thing as you saw it for "Spatial", in other ones it is more complicated.
Note that this also changes with versions and time.

The other way is to ask yourself, what is modified when I use a component and check this. If you do so then, please, post your findings.

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: How do we know that an oracle component is in use ...
Author: Michel Cadot, France
Date: Jan 19, 2021, 15:48, 41 days ago
Message:
The first quick ideas that come into my mind are to:

1/ compare the created and last ddl dates of objects in the schemas of the components (there are given in DBA_REGISTRY) but they can be updated when applying a PSU without being used by a client so don't forget to exclude dates that match with the latest applied PSU.

2/ count the number of the rows in the tables of the components or some key tables of them as this is done for Spatial

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