SELECT
NAME,
TO_CHAR(SPACE_LIMIT, '999,999,999,999') AS SPACE_LIMIT,
TO_CHAR(SPACE_LIMIT - SPACE_USED + SPACE_RECLAIMABLE,
'999,999,999,999') AS SPACE_AVAILABLE,
ROUND((SPACE_USED - SPACE_RECLAIMABLE)/SPACE_LIMIT * 100, 1)
AS PERCENT_FULL
FROM V$RECOVERY_FILE_DEST;
This Blog is dedicated to administration of Oracle database, Oracle E-Business Suite, Linux, Windows, Weblogic and other miscellaneous Oracle and non-oracle products...
Ознаке
- Administration (6)
- Alias (1)
- Apex (2)
- Apps Tables (1)
- Archiving (1)
- Clean (2)
- Concurrent Managers (3)
- Configuration (1)
- DB_Link (1)
- DataDictionary (2)
- EM (3)
- Files (7)
- Filesystem (1)
- Forms (2)
- Fra (1)
- FreeSpace (2)
- Hardware (1)
- Index (1)
- Install (1)
- Invalids (3)
- Keypar (1)
- Lock (2)
- Log (4)
- Mail (1)
- Memory (2)
- Mount (4)
- Network (6)
- OUI (1)
- Parameters (3)
- Patching (6)
- Performance (2)
- Port (1)
- Process (1)
- RMAN (3)
- Runlevels (1)
- Samba (1)
- Script (2)
- Selinux (1)
- Session (5)
- Tablespace (2)
- Tablespaces (3)
- Tar (3)
- Users (4)
- Version (3)
- Vnc (2)
- Workflow (1)
- Xen (3)
- Zip/Unzip (2)
четвртак, 12. фебруар 2015.
Пријавите се на:
Објављивање коментара (Atom)
Нема коментара:
Постави коментар
Напомена: Само члан овог блога може да постави коментар.