oracle howto avoid query oracle9i database solution 11 rdbms sql 92 tutorial statement 11g ddl search Oracle12c hints ask learn how sqlplus hint tuning dml slow query job max min decode outer join in explained how to example test production examples oracle11g oracle10g instruction command select update insert delete 12c merge pl/sql pl sql 2008 parse tsql convert migrate ora create tips table view tutorial speed find jobs flashback cluster find 12
To check the quota on tablespace for users you can use the following sql:
select username,
tablespace_name,bytes/(1024*1024) as used_mb,
max_bytes/(1024*1024) as max_mb
from dba_ts_quotas;
No comments:
Post a Comment