Sql

Search

oracle index size

SELECT SEGMENT_NAME, OWNER, round(sum(BYTES) / 1e6, 0) AS SIZE_MB
FROM DBA_SEGMENTS
WHERE TABLESPACE_NAME = 'tbs_name'
GROUP BY SEGMENT_NAME, OWNER
ORDER BY SIZE_MB DESC;

Comment

PREVIOUS	NEXT

Code Example
Sql :: oracle select into
Sql :: opening xampp mysql in cmd ubuntu
Sql :: mysql count by month
Sql :: default number in sql
Sql :: row to json in sql server
Sql :: commit in sql
Sql :: sql precent format
Sql :: calculate percentage in sql
Sql :: sqlite unique multiple columns
Sql :: sql server remove primary key without dropping table
Sql :: how to find average in sql
Sql :: mysql select statement after index
Sql :: sub query in linq
Sql :: sql view talbe columns
Sql :: sqlite insert or update
Sql :: postgresql check total storage
Sql :: sql greater than
Sql :: uppercase sql
Sql :: sql update multiple rows
Sql :: sql select where clause
Sql :: count occurrences sql
Sql :: oracle previous year
Sql :: sqlite3 pragma foreign keys
Sql :: Write an SQL query to print details of the Workers whose SALARY lies between 100000 and 500000.
Sql :: delete * from where id = 1;
Sql :: ERROR 1064 (42000)
Sql :: mysql workbench tutorial
Sql :: postgre query date
Sql :: mysql find db contarint
Sql :: insert select

Search

SQL

oracle index size

ADD CONTENT