Description of problem:
On embedded-database Satellites, "db-control report" run as oracle user reports tablespace usage for all relevant tablespaces except TEMP_TBS. Since in satellite 5.3.0 it can be extended via "db-control extend", db-control report should included it as well.
Version-Release number of selected component (if applicable):
Satellite 5.3.0 (and earlier)
Steps to Reproduce:
1. su - oracle
2. db-control report
TEMP_TBS not included in output, even though it can be extended with "db-control extend".
TEMP_TBS to be included in output.
rhn-upgrade will include a query to report TEMP_TBS usage, so maybe db-control report can call the same script or use the same query?
As a matter of fact, in Satellite 5.4, db-control shows all the tablespaces:
$ db-control report
Tablespace Size Used Avail Use%
DATA_TBS 23G 19.8G 3.2G 86%
SYSAUX 500M 384.6M 115.3M 77%
SYSTEM 400M 273.1M 126.8M 68%
TEMP_TBS 1.5G 0B 1.5G 0%
UNDO_TBS 2.9G 419.6M 2.5G 14%
USERS 256M 1024K 255M 0%
$ rpm -qf `which db-control`
It went to Spacewalk master as commit 85563a21e26eb2d087c3a847a2712b7e064fc8c5.
Closing, resolved in Satellite 5.4.0.