# oracle-dbautil

**Repository Path**: zdc524/oracle-dbautil

## Basic Information

- **Project Name**: oracle-dbautil
- **Description**: 收集，整理oracle dba常用的sql 脚本
- **Primary Language**: JavaScript
- **License**: Apache-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 3
- **Forks**: 2
- **Created**: 2015-05-08
- **Last Updated**: 2024-05-29

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

#常用数据库SQL
```sql
	SELECT t.tablespace_name,
	ROUND(SUM(bytes / (1024 * 1024)), 0) ts_size
	FROM dba_tablespaces t,
	dba_data_files d
	WHERE t.tablespace_name = d.tablespace_name
	GROUP BY t.tablespace_name;
```