Bug 486526

Description of problem:

Listed below would 3 useful additions to satellite-debug - I can break them out into separate bugs, if needed.

1. Usage information:

This is very useful information and frequently requested especially in cases of large deployments and/or performance problems.  The results from the following queries gives a general picture of the deployment size and usage of the Satellite, including the number of servers, packages, channels, etc.. -

select count(*) from rhnpackagename;
select count(*) from rhnpackage;
select count(*) from rhnchannelpackage;
select count(*) from rhnchannel;
select count(*) from rhnserverchannel;
select count(*) from rhnserver;
select count(*) from rhnservergroup;
select count(*) from rhnservergroupmembers;
select count(*) from rhnUserManagedServerGroups;
select count(*) from rhnUserDefaultSystemGroups; 

Additionally, in the case of users who for some reason cannot or prefer not to give this information to be queried, a "--no-usage" option can be added to not run these queries and include results in the satellite-debug tar.

2. The sudoers file and tomcat, apache, and oracle user/group information

There're a significant number and types of problems that are caused by incorrect/missing configuration in /etc/sudoers and/or user/group setup in the /etc/passwd and /etc/group files.  Including /etc/sudoers file, and the output of grepping for tomcat, apache, and oracle in /etc/passwd and /etc/group would be very useful.

3. Oracle configuration

Starting with Satellite 5.2.0, the supported/embedded oracle database version is 10g (from 9i), this in addition to some performance issues that are currently under investigation have resulted in some workaround being applied, to avoid future confusion, it would be very useful to query these configurations in the database for Satellites 5.2.0 and above:

select dbms_stats.get_param('METHOD_OPT') from dual;
select value from v$parameter where name='optimizer_mode';
select value from v$parameter where name='optimizer_index_cost_adj';
SELECT X.KSPPINM NAME, DECODE(BITAND(KSPPIFLG/256, 1), 1, 'TRUE', 'FALSE') SESMOD, DECODE( BITAND(KSPPIFLG/65536, 3), 1, 'IMMEDIATE', 2, 'DEFERRED', 3, 'IMMEDIATE', 'FALSE' ) SYSMOD, KSPPDESC DESCRIPTION FROM SYS.X_$KSPPI X WHERE X.INST_ID = USERENV('INSTANCE') AND X.KSPPINM = '_optimizer_cost_based_transformation' ; 

Version-Release number of selected component (if applicable):
All.

How reproducible:
See above.

Steps to Reproduce:
1.
2.
3.
  
Actual results:


Expected results:


Additional info: