How to gather the Oracle database information ?

The main components of the database are
1. spfile
2. controlfile,
3. datafile
4. redo log file.
5. Archive log file.

You can gather the information by following steps.

1. login in to the system using oracle.
2. connect to database using sys user

conn /as  sysdba

command	description
sql> show paramter spfile;	1. Location and name of the current spfile.
sql> select name from v$controlfile;	1. Location and name of the controlfile
sql> select name from v$datafile;	1. Location and name of the datafile
sql> select member  from v$logfile;	1. Location and name of the redo log file;
sql> select username from dba_users ordre by username;	list of users in the database
sql> select name from v$database;	name of the database
sql> select name from v$tablespace order by name;	name of the tablespace in the database