Statement writing for Oracle query of user tablespace

How should I write statements for Oracle to query user tablespace? The following describes in detail the statements used to query user tablespace in Oracle. If you are interested in this, take a look.

The following describes how to query user tablespaces in Oracle.

◆ Oracle query user tablespace: select * from user_all_tables

◆ Oracle queries all functions and stored procedures: select * from user_source

◆ Query all Oracle users: select * from all_users.select * from dba_users

◆ Oracle view current user connection: select * from v $ Session

◆ View current user permissions in Oracle: select * from session_privs

◆ Oracle:

Select a. file_id "FileNo", a. tablespace_name
"Tablespace_name ",
A. bytes "Bytes", a. bytes-sum (nvl (B. bytes, 0) "Used ",
Sum (nvl (B. bytes, 0) "Free ",
Sum (nvl (B. bytes, 0)/a. bytes * 100 "% free"
From dba_data_files a, dba_free_space B
Where a. file_id = B. file_id (+)
Group by a. tablespace_name,
A. file_id, a. bytes order by a. tablespace_name;
 

Three methods for Oracle Authentication

Oracle Default User Password Problems

Common Oracle cursor attributes

Use instances of Oracle stored procedures

Oracle command line custom editor vi