| discrepancies in SYS/SYSTEM object counts after migration [message #453982] |
Mon, 03 May 2010 05:34  |
reym21
Messages: 241
Registered: February 2010
Location: Philippines
|
Senior Member |
|
|
Sir/ Ma'am,
Pls advise me on this... I'm a newbie dBA.
We had a new outsourcer who completed migration of 1 of our system running under Oracle10g-Solaris 10. We created an inventory script that will list all objects counts of SYS, SYSTEM and ORACLE and all other schemas. This script will be ran before (old server) and after migration (to new server). After migration to the new & bigger server, we noticed from the output of the inventory script for SYS/SYSTEM object counts had been reduced compared from the original/actual value (from the old server). Our outsourcer said that this is not an issue since
SYS/SYSTEM objects are not transactional and cannot be controlled.
Is this true? Are there any impact on this? As we will conform that the migration was completed successfully by our new outsourcer.
Thanks in advance.
|
|
|
|
|
|
|
|
|
|
| Re: discrepancies in SYS/SYSTEM object counts after migration [message #453993 is a reply to message #453991] |
Mon, 03 May 2010 06:20  |
reym21
Messages: 241
Registered: February 2010
Location: Philippines
|
Senior Member |
|
|
Most of values (count) are in a 5-digit whole numbers
Ex.
SYS object count (old server) for:
- WRH$_SQLSTAT 18481
SYS object count (new server) for:
- WRH$_SQLSTAT 18359
excerpts from the inventory script...
prompt ===============================================
prompt COUNT OF ALL OBJECTS (OTHER,ORACLE,SYS,SYSTEM)
prompt ================================================
break on owner on report
compute sum of cnt on owner
compute sum of cnt on report
select owner, object_type, count(*) cnt, status
from dba_objects
where owner in ('OTHER', 'ORACLE', 'SYS', 'SYSTEM')
group by owner, object_type, status;
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
