How to view Oracle table spaces in Linux?

In Linux systems, you can use the following command to view tablespace information for Oracle databases:

1. Connecting to an Oracle database using sqlplus:
2. Sign in using the given username and password to access the database.
3. Once you enter the SQL*Plus interactive interface, execute the following command to view table space information:
4. Retrieve the tablespace name, file name, size in bytes, maximum size in bytes, and status from the data files in the database.
5. This command will display the name, file name, size, maximum size, and status of the table space.
6. You can use the following command to view the usage of tablespace:
7. Choose the tablespace name, calculate the total size in MB, the used space in MB, and the percentage of used space for each tablespace from the database. Group the results by tablespace name.
8. This command will display the name, size, used space, and usage percentage of each tablespace.
9. Additionally, you can use the following command to view the data files and log files of the table space:
10. Retrieve the tablespace name, file name, size in bytes, and status from the dba_temp_files table.
11. This command will display the name, file name, size, and status of the temporary tablespace.

Please note that executing the above command requires the appropriate permissions.