Oracle Scripts
open-menucloseme
Home
All Oracle Scripts
Scripts & Commands
Links icon
Oracle Database Documentation Oracle Enterprise Manager
About
Contact Us
Privacy Satement
🌐
English Português
rss

  • Identifying User Tablespaces and Space Usage in Oracle

    calendar Feb 4, 2024 · 3 min read · database administration resource optimization performance monitoring data management tablespace dba_extents user space user  ·
    Share on: twitter facebook linkedin copy

    Query to Display All Tablespaces Used by A Specified User and The Total Space Occupied (rounded to MB) Sample SQL Command 1select tablespace_name 2, ceil(sum(bytes) / 1024 / 1024) "MB" 3from dba_extents 4where owner like '&user_id' 5group by tablespace_name 6order by tablespace_name 7/ Sample Oracle …


    Read More

OracleScripts.com

Your Source for Oracle Database SQL Scripts
Read More

Recent Posts

  • Identifying Oracle Database Hot Blocks using Oracle table v$system_event: A Comprehensive Guide
  • Analyzing Oracle 'Data Block' Waits with v$waitstat
  • Analyzing Oracle 'Buffer Busy Waits' with v$session_wait
  • Analyzing Oracle Performance Statistics with v$statname and v$sysstat
  • Oracle Segment Waits In-Depth Code Analysis and Insights using v$segment_statistics
  • Oracle Performance Tuning Analyzing Latch Contention with Time Waited for Latches Using Oracle Tables v$system_event and v$sysstat
  • Top 10 Hottest Objects in Oracle by Touch Count using tables x$bh obj$ and user$
  • Identify Waits by Datafile in Oracle using tables v$datafile and x$kcbfwait

Categories

SCRIPTS 111 ORACLE ADMINISTRATION RAC 12 ORACLE STRUCTURE TABLESPACE 11 ORACLE STRUCTURE FILES 10 ORACLE STRUCTURE OBJECTS 10 ORACLE ADMINISTRATION SESSION 9 ORACLE PERFORMANCE GENERAL 8 ORACLE PERFORMANCE WAITS 8 ORACLE ADMINISTRATION ASM 7 ORACLE ADMINISTRATION STATUS 7 ORACLE STRUCTURE CONSTRAINTS 7 ORACLE ADMINISTRATION USER 5 ORACLE PERFORMANCE LOCKS DML 4 ORACLE STRUCTURE UNDO 4 ORACLE ADMINISTRATION INIT PARAMETERS 3
All Categories
ORACLE ADMINISTRATION ASM7 ORACLE ADMINISTRATION INIT PARAMETERS3 ORACLE ADMINISTRATION RAC12 ORACLE ADMINISTRATION SESSION9 ORACLE ADMINISTRATION STATUS7 ORACLE ADMINISTRATION USER5 ORACLE PERFORMANCE GENERAL8 ORACLE PERFORMANCE LOCKS DML4 ORACLE PERFORMANCE WAITS8 ORACLE STRUCTURE CONSTRAINTS7 ORACLE STRUCTURE FILES10 ORACLE STRUCTURE INDEXES2 ORACLE STRUCTURE OBJECTS10 ORACLE STRUCTURE REDO LOGS3 ORACLE STRUCTURE TABLESPACE11 ORACLE STRUCTURE UNDO4 SCRIPTS111 SQL1
[A~Z][0~9]

Series

ADMIN GUIDE 111

Tags

ORACLE 94 DATABASE 47 SQL 34 ADMINISTRATION 27 DATABASE-ADMINISTRATION 20 PERFORMANCE 20 OPTIMIZATION 15 DBA 11 MANAGING 10 ORACLE CLUSTERWARE 10 TROUBLESHOOTING 10 V$SESSION 10 ORACLE CRS 9 MANAGEMENT 8 PERFORMANCE TUNING 8
All Tags
$DATAFILE1 ACCOUNT1 ADMINISTRATION27 ALTER SESSION1 ASM2 ASM DISK UTILIZATION1 BACKUP1 CHARACTER-SET1 CLUSTER5 CONNECTED USERS3 CONSTRAINTS3 DATA INTEGRITY3 DATA MANAGEMENT7 DATABASE47 DATABASE SIZE1 DATABASE START-UP1 DATABASE-ADMINISTRATION20 DATAFILES5 DBA11 DBA_CONS_COLUMNS1 DBA_CONSTRAINTS7 DBA_DATA_FILES5 DBA_ERRORS1 DBA_EXTENTS1 DBA_FREE_SPACE1 DBA_IND_COLUMNS1 DBA_INDEXES1 DBA_LOCK1 DBA_OBJECTS5 DBA_ROLES1 DBA_ROLLBACK_SEGS1 DBA_SEGMENTS6 DBA_SOURCE1 DBA_TAB_COLUMNS1 DBA_TABLESPACES1 DBA_TEMP_FILES1 DBA_TS_QUOTAS1 DBA_USERS1 DBMS_METADATA1 DDL1 DEVELOPMENT1 DISK GROUP CREATION1 DISK INFORMATION5 DISK SPACE ANALYSIS1 DISKGROUP4 EXTERNAL REDUNDANCY1 FEATURES1 FREE SPACE1 HOT BACKUP1 I/O1 INDEXING1 INSTALLED3 JAVA1 LAST ACTIVITY1 LATCH1 LATCH CONTENTION1 MAINTENANCE1 MANAGEMENT8 MANAGING10 MODIFY1 MONITORING4 OBJ$1 OBJECTS6 OIFCFG1 OPTIMIZATION15 ORACHECK1 ORACLE94 ORACLE ASM6 ORACLE CLUSTERWARE10 ORACLE CRS9 ORACLE DATABASE6 OSUSER1 PARAMETERS2 PEFORMANCE1 PERFORMANCE20 PERFORMANCE MONITORING3 PERFORMANCE OPTIMIZATION1 PERFORMANCE TUNING8 PL SQL1 PLSQL1 PROCEDURE2 QUERY1 QUOTAS1 RAC7 RECOVERY3 RESOURCE OPTIMIZATION2 ROLE_SYS_PRIVS1 ROLE_TAB_PRIVS1 SCHEMA SPACE USED1 SCRIPTING1 SCRIPTS1 SECURITY1 SEGMENTS3 SESSION PID1 SESSIONS1 SESSIONS SORTED1 SHOW ROLES1 SHOW TABLE ROLE PRIVLEDGES1 SHOW USER PRIVLEGES1 SHOW USER SQL6 SPACE USAGE1 SPACE USED1 SPFILE1 SQL34 SQL COMMANDS1 SQL TUTORIAL1 SQL-QUERIES1 SRVCTL3 START4 START-UP TIME1 STOP4 STORAGE2 STORAGE CAPACITY MONITORING1 STORAGE MANAGEMENT5 TABLESAPCE5 TABLESPACE4 TEMP2 TRACING2 TRANSACTIONS1 TROUBLESHOOTING10 TUNING1 UNDO_RETENTION1 USAGE1 USED SPACE1 USER2 USER SPACE1 USER$1 USERS2 V$ASM_OPERATION1 V$BACKUP1 V$CONTROLFILE3 V$DATAFILE8 V$DB_CACHE_ADVICE1 V$FILESTAT1 V$LOCK2 V$LOCKED_OBJECT1 V$LOG2 V$LOGFILE4 V$PARAMETER2 V$PROCESS1 V$SEGMENT_STATISTICS1 V$SESSION10 V$SESSION_LONGOPS1 V$SESSION_WAIT`1 V$SESSTAT1 V$SQLAREA5 V$STATNAME2 V$SYSSTAT2 V$SYSTEM_EVENT2 V$TEMPFILE2 V$TRANSACTION1 V$WAITSTAT1 X$BH1 X$KCBFWAITV1
[A~Z][0~9]
OracleScripts.com

Copyright 2003-  ORACLESCRIPTS.COM. All Rights Reserved

to-top