Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I was asking more information about Operating System. Then I wondered if an generic sql can give this information? Following things come to my mind.

  • SELECT banner from v$version;
  • SELECT LOG_MODE ,PLATFORM_ID,PLATFORM_NAME FROM V$DATABASE;

My output from test database is below.

SQL> SELECT banner from V$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
PL/SQL Release 11.2.0.2.0 - Production
CORE    11.2.0.2.0      Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production


SQL> SELECT LOG_MODE ,PLATFORM_ID,PLATFORM_NAME FROM V$DATABASE;

LOG_MODE     PLATFORM_ID  PLATFORM_NAME
------------ -----------  -------------------
NOARCHIVELOG          10  Linux IA (32-bit)
share|improve this question
    
You would want something more detailed on the OS, e.g. on a Red Hat system, the contents of /etc/redhat-release, or /etc/debian_version on Debian and so on. uname -a output is useful too. –  Gaius Dec 21 '11 at 10:06
    
@Gaius Can I get similar information using SQL query only? –  Atilla Ozgur Dec 21 '11 at 12:04
    
Not that I am aware of –  Gaius Dec 21 '11 at 15:10
add comment

1 Answer

up vote 1 down vote accepted

It depends on what specific problem you are asking. The two queries you provided can give others some general information of your database, which should be provided in almost all your questions.

BTW, I suggest you add *open_mode* column of v$database in your query.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.