10

My question is fairly simple. Is Java used internally by Oracle in their DBMSs?

Jonas
  • 29,165
  • 26
  • 57
  • 64
Boris Pavlović
  • 203
  • 2
  • 7

1 Answers1

19

No.

All (standard) packages are written in PL/SQL. The DBMS engine itself is written in C

Edit:
Oracle does include a JVM which runs on the same machine as the database itself, but that is not used to run any "DBMS related" code.

It's only there to run stored procedures/functions written in Java.

a_horse_with_no_name
  • 69,148
  • 13
  • 135
  • 173
  • Wow, did not no know about the C part. +1. – StanleyJohns Sep 13 '11 at 10:17
  • 5
    Check out their "History Timeline": http://www.oracle.com/us/corporate/timeline/index.html: 1983: "Oracle releases Version 3 of its database, with server code written in the C programming language" – a_horse_with_no_name Sep 13 '11 at 10:24
  • My guess is Java is not exists then. I think first Java came at Oracle 8i. – Richard Sayakanit Sep 13 '11 at 16:59
  • Oracle has [an internal JVM](http://en.wikipedia.org/wiki/Oracle_Database#Corporate.2Ftechnical_timeline) and many of its tools [are written in Java](https://forums.oracle.com/forums/thread.jspa?threadID=665002). – Nick Chammas Sep 13 '11 at 18:24
  • 4
    The internal JVM is not used to run any "DBMS related" code. It's only there to run stored procedures/functions written in Java. – a_horse_with_no_name Sep 13 '11 at 18:27
  • Just spent a good 5 minutes researching this... You're right. You'll have to edit your answer somehow so I can take my down vote back. :) – Nick Chammas Sep 13 '11 at 18:29
  • @Nick: I added my comment as an answer ;) – a_horse_with_no_name Sep 13 '11 at 19:05
  • Great. Vote reversed. – Nick Chammas Sep 13 '11 at 19:29
  • 7
    @a_horse_with_no_name - I guess it depends on what you mean by "standard" packages. Oracle ships a number of packages that are built in Java (anything that uses XDB, for example, including many of the XMLQuery packages, depend on the internal JVM). These aren't "standard" in the sense of packages that most developers use frequently. But they are "standard" in the sense that they are installed when you do a default installation of the Oracle database. – Justin Cave Sep 13 '11 at 20:30