oracle sql

select tbl_OFFDBSPACE.OFFICENAME,tbl_OFFDBSPACE.DBNAME,tbl_OFFDBSPACE.TABLESPACENAME,tbl_OFFDBSPACE.OFFICEDBNAME,
        tbl_OFFDBSPACE.OFFICEDBTABNAME,time10,AVG_TABSPACEUSAGE,MAX_TABSPACEUSAGE,MIN_TABSPACEUSAGE
          from (select NMSGUEST.NBBamTabEx.DEVIPADDR as DEVIPADDR,NMSGUEST.NBBamTabEx.OFFICENAME as OFFICENAME,
          NMSGUEST.DB2INFO.DBNAME as DBNAME,NMSGUEST.DB2TABLESPACE.TABLESPACENAME as TABLESPACENAME,
          NMSGUEST.DB2INFO.DBINDEX as DBINDEX,NMSGUEST.DB2TABLESPACE.TABLESPACEINDEX as TABLESPACEINDEX,
          NMSGUEST.NBBamTabEx.OFFICENAME ||'|'|| NMSGUEST.DB2INFO.DBNAME as OFFICEDBNAME,
          NMSGUEST.NBBamTabEx.OFFICENAME ||'|'|| NMSGUEST.DB2INFO.DBNAME ||'|'|| NMSGUEST.DB2TABLESPACE.TABLESPACENAME as OFFICEDBTABNAME
          from NMSGUEST.NBBamTabEx,NMSGUEST.DB2INFO,NMSGUEST.DB2TABLESPACE
          where NMSGUEST.NBBamTabEx.DEVIPADDR=NMSGUEST.DB2INFO.DEVIPADDR and NMSGUEST.NBBamTabEx.DEVIPADDR=NMSGUEST.DB2TABLESPACE.DEVIPADDR) tbl_OFFDBSPACE,
          (select devid,HWDB2DATABASEID,HWDB2TBSID,round(avg(TABSPACEUSAGE),4) as AVG_TABSPACEUSAGE,
          round(max(TABSPACEUSAGE),4) as MAX_TABSPACEUSAGE,roun