Quick Search:
 
 Oracle PL/SQL: DBA Tablespaces Jump to:  
Category: >> Oracle PL/SQL >> DBA Tablespaces  

<< lastnext >>

Snippet Name: DBA Tablespaces

Description: Returns tablespace details.

Also see:
» Add PSOUG Search to SQL Developer
» Converting Rows to Columns
» Database Links: CURRENT_USER
» Instant Test Database with DCBA
» Show info on current context
» Lookup Oracle error messages
» Display and release DBMS_LOCK locks
» Display locks and latches
» Show rollback segment stats
» Show active transactions
» List supported INIT.ORA parameters
» Display database SGA statistics
» Measure the Buffer Cache Hit Ratio
» List security related profile informat...
» Find users with deadly privileges
» Audit User Logins (User Login Trigger)
» Block TOAD and other tools
» Kill Session
» Extents
» DBA Users
» DBA triggers
» DBA Sessions
» DBA Roles
» DBA Objects
» DBA Links
» DBA Jobs
» Job Queue
» DBA Free Space
» Data Files
» DBA Extents

Comment: (none)

Language:
Highlight Mode: PLSQL
Last Modified: March 01st, 2009 

SET pages 60
SET lines 80
col tablespace_name format a15
col initial_extent format 999,999,999
col next_extent format 999,999,999
col min_extents format 999
col min_extents heading MIN
col max_extents format 999
col max_extents heading MAX
SELECT * FROM dba_tablespaces
/
 
 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2025 psoug.org