Small knowledge, big challenge! This article is participating in the creation activity of “Essential Tips for Programmers”.

Oracle database files are divided into the following types:

  • Table space data files (including temporary and UNDO table Spaces)
  • The control file
  • Log files (including redo logs and standby logs)

This can be queried using SQL:

set line222
col pagesize1000
select name from v$datafile 
union all
select name from v$tempfile 
union all
select member from v$logfile 
union all
select name from v$controlfile;
Copy the code

This is the end of sharing ~

If you think the article is helpful to you, please like it, favorites it, pay attention to it, comment on it, and support it four times with one button. Your support is the biggest motivation for my creation.

❤️ technical exchange can follow the public number: Lucifer think twice before you do ❤️