SELECT t$.name, q$.ts#, u$.name, u$.user#, q$.maxblocks, t$.blocksize
FROM sys.ts$ t$, sys.tsq$ q$, sys.user$ u$
WHERE q$.user# = u$.user# AND
q$.ts# = t$.ts# AND
q$.maxblocks != 0 AND
t$.online$ IN (1, 2, 4)
SELECT T$.NAME
, Q$.TS#
, U$.NAME
, U$.USER#
, Q$.MAXBLOCKS
, T$.BLOCKSIZE
FROM SYS.TS$ T$
, SYS.TSQ$ Q$
, SYS.USER$ U$
WHERE Q$.USER# = U$.USER# AND
Q$.TS# = T$.TS# AND
Q$.MAXBLOCKS != 0 AND
T$.ONLINE$ IN (1
, 2
, 4)
|
|
|