Tip

Find users who have unlimited quota on a tablespace

Here is a query to find users that have unlimited quota on a tablespace.

Here is a query to find users that have unlimited quota on a tablespace.

select username,tablespace_name,max_bytes from dba_ts_quotas;
If the max_bytes values is -1, that user has unlimited quota on the corresponding tablespace.


Dig Deeper on Oracle database administration

Data Management
Business Analytics
SearchSAP
TheServerSide.com
  • Why WebAssembly? Top 11 Wasm benefits

    Latency and lag time plague web applications that run JavaScript in the browser. Here are 11 reasons why WebAssembly has the ...

  • Why Java in 2023?

    Has there ever been a better time to be a Java programmer? From new Spring releases to active JUGs, the Java platform is ...

  • How developers can avoid remote work scams

    Software developers can find good remote programming jobs, but some job offers are too good to be true. Follow these tips to spot...

Data Center
Content Management
HRSoftware
Close