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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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;

My output from test database is below.

SQL> SELECT banner from V$version;

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


------------ -----------  -------------------
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
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

Your Answer


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.