Re: Getting Database Name from SQLPlus

gtravis_at_richmond.infi.net (Glenn Travis) wrote:
>
> Is there a way to select the database name in query while using SQLPlus?
>
> I am using net to connect to different servers on different machines to
> produce dba type reports on disk usage ,etc... and would like to list the
> instance name on the header page for the reports (querie output). I can
> spool to $ORACLE_SID but can't use ORACLE_SID in the report heading.
>
> Any ideas?
> --
> Glenn Travis
> DBA
> Circuit City Stores, Inc.
> Richmond, VA USA
> gtravis_at_richmond.infi.net
> gtravis_at_aol.com
>

connect system/manager (or as dba user)
select value from v$parameter where NAME = 'db_name';

                                  """
                                 (o o)
+---------------------------------(_)----------------------------------+
|                                _/ \_                                 |
|                             Vish Gopalan                             |
|                         Information Systems                          |
|                      Architecture & Integration                      |
|                   International Space Station, NASA                  |
|                                                                      |
| E-mail: vgopalan_at_borg24.jsc.nasa.gov           Phone: (713) 280-7473 |
+----------------------------------------------------------------------+