|
 |
 |
Oracle |
 |
|
|
|
|
|
Info: Biography, Pictures, Discography of all CDs & DVDs |
|
| Oracle Database 11g Release 1
Oracle Fusion Middleware 11g Technology Previews
Oracle VM Free product
Oracle SQL Developer Free product
Oracle Database XE Free product
Oracle DBA Toolbar New version!To meet Wikipedia's quality standards, this article or section may require cleanup because it is in a list format that may be better presented using prose.Editing help is available.Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is a relational database management system (RDBMS) software product released by Oracle Corporation that has become a major feature of database computing.SDL developed the original version of the Oracle software.Ellison had worked on while previously employed by Ampex.Many widespread computing platforms have come to use the Oracle database software extensively.Editions
4 Host platforms
5 Related software
5.Using Oracle Database software
7 Oracle Database in the market
7.Physical and logical structuring
An Oracle database system comprises at least one instance of the application, along with data storage.SQL commands and user information.The Oracle RDBMS stores data logically in the form of tablespaces and physically in the form of data files.Data blocks form the basic units of data storage.Oracle database management keeps track of its computer data storage with the help of information stored in the SYSTEM tablespace.If the Oracle database administrator has instituted Oracle RAC (Real Application Clusters), then multiple instances, usually on different servers, attach to a central storage array.However, support becomes more complex, and many sites do not use RAC.The Oracle DBMS can store and execute stored procedures and functions within itself.Schemas
Oracle database conventions refer to defined groups of ownership (generally associated with a "username") as schemas.Most Oracle database installations traditionally come with a default schema called SCOTT.The scott schema has fallen out of favor as it uses so few of the features of a modern release of Oracle.Most recent examples reference the default HR or OE schemas.An insufficient amount of memory allocated to the shared pool can cause performance degradation.SQL, caching the parse tree and the execution plan for every unique SQL statement.Data dictionary cache
The data dictionary comprises a set of tables and views that map the structure of the database.Oracle stores information here about the logical and physical structure of the database.The data dictionary contains information such as the following:
User information, such as user privileges
Integrity constraints defined for tables in the database
Names and datatypes of all columns in database tables
Information on space allocated and used for schema objects
The Oracle instance frequently accesses the data dictionary in order to parse SQL statements.The operation of Oracle depends on ready access to the data dictionary: performance bottlenecks in the data dictionary affect all Oracle users.Allocating sufficient memory to the shared pool where the data dictionary cache resides precludes these particular performance problems.Process architecture
The Oracle RDBMS typically relies on a group of processes running simultaneously in the background and interacting to further and monitor database operations.VMS systems to include Unix environments.Business Suite), based on the Oracle relational database.Oracle version 7 appeared with support for referential integrity, stored procedures and triggers.The Oracle 8i database incorporated a native Java virtual machine (Oracle JVM).Oracle9i went into release with 400 new features, including the ability to read and write XML documents.Oracle Parallel Server (OPS) option.Oracle Corporation released Oracle Database 10g.Oracle Corporation released Oracle Database 11g for Linux and for Microsoft Windows.With the Oracle RDBMS 10g release, Oracle Corporation started standardizing all current versions of its major products using the "10g" label, although some sources continued to refer to Oracle Applications Release 11i as Oracle 11i.Oracle Developer Suite 10g (9.Since version 7, Oracle's RDBMS release numbering has used the following codes:
Oracle7: 7.Oracle8i Database Release 1: 8.Oracle8i Database Release 2: 8.Oracle8i Database Release 3: 8.Oracle9i Database Release 1: 9.Latest current patchset as of December 2003)
Oracle9i Database Release 2: 9.Latest current patchset as of April 2007)
Oracle Database 10g Release 1: 10.Latest current patchset as of February 2006)
Oracle Database 10g Release 2: 10.Latest current patchset as of November 2006)
Oracle Database 11g Release 1: 11.October 2007
The version numbering syntax within each release follows the pattern: major.The Oracle Administrator's Guide offers further information on Oracle release numbers.Oracle Corporation licenses this product on the basis of users or of processors, typically for servers running 4 or more CPUs.EE has no memory limits, and can utilize clustering using Oracle RAC software.SE) contains base database functionality.Oracle Corporation licenses this product on the basis of users or of processors, typically for servers running from one to four CPUs.If the number of CPUs exceeds 4 CPUs, the user must convert to an Enterprise license.SE has no memory limits, and can utilize clustering with Oracle RAC at no additional charge.Oracle Corporation markets it for use on systems with one or two CPUs.It has no memory limitations.Oracle Database XE'), introduced in 2005, offers Oracle 10g free to distribute on Windows and Linux platforms (with a footprint of only 150 MB and restricted to the use of a single CPU, a maximum of 4 GB of user data and 1 GB of memory).Oracle Database Lite, intended to run on mobile devices.Host platforms
Prior to releasing Oracle9i, Oracle Corporation ported the database engine to a wide variety of platforms.More recently, Oracle Corporation has consolidated on a smaller range of operating system platforms.Related software
For links to some of Oracle Corporation's software which integrates with Oracle databases, see the Oracle Corporation category and the Oracle software category pages.Oracle Real Application Testing
This list is incomplete; you can help by expanding it.Suites
In addition to its RDBMS, Oracle Corporation has released several related suites of tools and applications relating to implementations of Oracle databases.Oracle Collaboration Suite contains messaging, groupware and collaboration applications.Oracle Developer Suite contains software development tools, including JDeveloper.Business Suite collects together applications for enterprise resource planning (including Oracle Financials), customer relationship management and human resources management (Oracle HR).OEM called "Oracle Enterprise Manager Database Control".Oracle Corporation has dubbed the super Enterprise Manager used to manage a grid of multiple DBMS and Application Servers as "Oracle Enterprise Manager Grid Control".Oracle Corporation sometimes refers to as "features" in a sense subtly different from the normal usage of the word.Such "features" may include (for example):
Automatic Workload Repository (AWR), providing monitoring services to Oracle database installations from Oracle version 10.Prior to the release of Oracle version 10, the Statspack facility provided similar functionality.SQL (using, for example, Oracle Forms and Oracle Reports).Oracle Corporation also endorses certain practices and conventions as enhancing the use of its database products.Using Oracle Database software
Users of Oracle databases may access the online documentation, the Oracle Technology Network site, and the comp.Users who have Oracle support contracts should turn to Oracle's Metalink web site (password required).Users can also check the Oracle FAQ site before posting questions to forums, mailing lists, etc.The Oracle RDBMS has had a reputation among novice users as difficult to install on Linux systems.Oracle Corporation has packaged recent versions for several popular Linux distributions in an attempt to minimize installation challenges beyond the level of technical expertise required to install a database server.Competition
In the market for relational databases, Oracle competes against commercial products such as IBM's DB2 UDB and Microsoft SQL Server.Niche commercial competitors include Teradata (in data warehousing and business intelligence), Software AG's ADABAS, Sybase, and IBM's Informix, among many others.Oracle acquired Innobase, supplier of the InnoDB codebase to MySQL, in part to compete better in the open source market.Pricing
Oracle Corporation offers term licensing for all Oracle products.Oracle Corporation's support site) which customers need to renew annually.Oracle Express Edition (Oracle XE), an addition to the Oracle database product family (beta version released in 2005, production version released in February 2006), offers a free version of the Oracle RDBMS, but one limited to 4 GB of user data and to 1 GB of RAM.As computers running Oracle often have eight or more processors, the software price can rise into the hundreds of thousands of dollars.Because of the product's large installed base and available training courses, Oracle specialists in some areas have become a more abundant resource than those for more exotic databases.On Linux, Oracle's certified configurations include mostly commercial Linux distributions (RedHat Enterprise Linux 3 and 4, SuSE SLES8 and 9, Asianux) which can cost in a range from a few hundred to a few thousand USD per year (depending on processor architecture and the support package purchased).One can avoid paying for those distros by using free alternatives such as any Red Hat Enterprise Linux clones (such as CentOS or White Box Linux).Oracle also runs reliably on unsupported distributions.Ellison (Larry Ellison) has served as Oracle's CEO throughout the company's history.Ellison was inspired by the paper written by Edgar F.Ed Oates, also based on Codd's theories, and wanted Oracle to be compatible with it, but IBM stopped this by keeping the error codes for their DBMS secret.In 1983, RSI was renamed Oracle Systems to more closely align itself with its flagship product Oracle Database with Robert Miner as senior programmer.RDBMS release timeline
1.Oracle Fusion Middleware
2.Oracle Enterprise Manager
2.To meet Wikipedia's quality standards, this article or section may require cleanup because it is in a list format that may be better presented using prose.Editing help is available.Software Development Laboratories (SDL) by Larry Ellison, Bob Miner and Ed Oates.June 1979: SDL is renamed to Relational Software Inc.Umang Gupta joined Oracle Corporation where he wrote the first business plan for the company, and served as Vice President and General Manager of the Microcomputer Products **
February 1981: RSI begins developing tools for Oracle, including the Interactive Application Facility (IAF), a predecessor to Oracle*Forms.Bruce Scott was one of the first employees at Oracle (then Software Development Laboratories).Oracle V1, V2 and V3.He created the sample schema "SCOTT" (containing tables like EMP and DEPT) with the password defaulted to TIGER (apparently named after his cat).March 1983: RSI rewrites Oracle in C for portability and Oracle version 3 is released.RSI is renamed to Oracle to more closely align with its primary product.April 1983: Received additional funding from Sequoia Capital.October 1984: Oracle version 4 released, introducing read consistency
November 1984: Oracle ports the database software to the PC platform.Oracle runs in only 512K of memory.Oracle for MSDOS version 5 was released in 1986 running in Protected Mode on 286 machines using a technique invented by Mike Roberts, among the first products to do so.April 1985: Oracle version 5 released.Oracle acquires TCI for its project management software.In the third quarter, Oracle reports its first ever loss, hundreds of employees are laid off.DEC Rdb (now called Oracle Rdb) from Digital Equipment Corporation (DEC) and development is still going on.Oracle Rdb is only available on the OpenVMS platform (also a former product of DEC).June 21, 1995: Oracle announces new data warehousing facilities, including parallel queries.June 1997: Oracle 8 is released with SQL object technology, internet technology and support for terabytes of data
September 1997: Oracle announces its commitment to the Java platform, and introduces Oracle's Java integrated development environment, which will come to be known as Oracle JDeveloper.January 1998: Oracle releases Oracle Applications 10.All the applications in the business software now run across the web in a standard web browser.May 1998: Oracle Applications 11 is released.April 1998: Oracle announces that it will integrate a Java virtual machine with Oracle Database.September 1998: Oracle 8i is released.October 1998: Oracle 8 and Oracle Application Server 4.May 1999: Oracle releases JDeveloper 2.May 2000: Oracle announces the Internet File System (iFS), later rebranded as Oracle Content Management SDK.June 2000: Oracle9i Application Server released with support for building portals.January 14, 2005: Oracle announces that it will reduce its combined workforce to 50,000, a reduction of approximately 5,000 following the PeopleSoft take over.PeopleSoft product development and product support staff will be retained.March, 2005: Oracle extends its Middle East operations by opening a regional office in Amman, Jordan.September 2005: Oracles announces that it has agreed to acquire Global Logistics Technologies, Inc.October 25, 2006: Oracle announces Unbreakable Linux
November 2, 2006: Oracles announces that it has agreed to acquire Stellent, Inc.MetaSolv Software, a Leading Provider of Operations Support Systems (OSS) Software for the Communications Industry.March 22, 2007: Oracle filed a court case against its major competitor SAP AG in the Californian courts for malpractice and unfair competition.BEA board who felt that the company was worth more than that.October 16, 2007: Oracle confirms impending departure of John Wookey, senior vice president for application development and head of its applications strategy, raising questions in the planned release and future of Oracle's Fusion Applications strategy.Offers full apps implementation methodology.Offers the first database to pass 15 industry standard security evaluations.Introduces what it calls "Enterprise Grid Computing" with Oracle10g.Releases its first free database, Oracle Database 10g Express Edition (XE).Oracle acquisitions
Made obvious with Peoplesoft in January 2005, Oracle has made acquisitions an important component of its growth strategy.Oracle Databases
As of 2004, Oracle Corporation shipped release 10g (g: grid) as the latest version of Oracle Database.Oracle Application Server 10g using Java EE comprises the server part of that version of the database, making it possible to deploy web technology applications.Oracle Rdb is a relational database system running on OpenVMS platforms.Oracle acquired Rdb in 1994 from Digital Equipment Corporation.Oracle has since made many enhancements to this product and development continues today.OEM called "Oracle Enterprise Manager Database Control".Oracle Corporation has dubbed the super Enterprise Manager used to manage a grid of multiple DBMS and Application Servers as "Oracle Enterprise Manager Grid Control".Oracle Secure Enterprise Search
Oracle Collaboration Suite contains messaging, groupware and collaboration applications.Oracle Forms, Oracle Discoverer and Oracle Reports, Oracle JDeveloper, and several more.Oracle database administrator's tasks easier.Application products
Besides databases, Oracle also sells a suite of business applications.The Oracle eBusiness Suite includes software to perform financial (Oracle Financials), manufacturing, enterprise resource planning and HR (Human Resource Management Systems) related functions (Oracle HR).User access to these facilities is provided through a browser interface over the internet or corporate intranet.SQL (using, for example, Oracle Forms and Oracle Reports).Oracle eventually had to restate its earnings twice, and also to settle out of court class action lawsuits arising from its having overstated its earnings.Ellison would later say that Oracle had made "an incredible business mistake."Around this time, Oracle fell behind technically to Sybase.Sybase's 1993 merger with PowerSoft resulted in its losing its focus on its core database technology.In 1994, Informix Software overtook Sybase and became Oracle's most important rival.Ultimately, Oracle defeated Informix in 1997.In November of 2005, a book detailing the war between Oracle and Informix was published."The Real Story of Informix Software and Phil White" provides a detailed chronology of the battle of Informix against Oracle, and how Informix Software's CEO Phil White landed in jail because of his obsession to overtake Ellison.Once Informix and Sybase were defeated, Oracle enjoyed years of industry dominance until the rise of Microsoft's SQL Server in the late 90s and IBM's acquisition of Informix Software in 2000 to complement their DB2 database.Today Oracle's main competition for new database licenses on UNIX, Linux, and Windows operating systems is with IBM's DB2 and with Microsoft SQL Server (which only runs on Windows).IBM's DB2 still dominates the mainframe database market.In 2004, Oracle's sales grew at a rate of 14.March, 2005), with market share estimated at up to 44.Oracle compatibility features at a much lower price point.In the applications arena, their main competitor is SAP.On March 22, 2007 Oracle sued SAP, accusing them of fraud and unfair competition.Oracle's relational database products.Despite the current SAP partnership with Microsoft, and the increasing integration of SAP applications with Microsoft products (such as SQL Server, a competitor to Oracle Database), Oracle and SAP continue their cooperation, and according to Oracle, the majority of SAP's customers use Oracle databases.In 2004 Oracle began to increase its interest in the business of enterprise applications (in 1989, Oracle had already released Oracle Financials).SAP recognized that Oracle was becoming a competitor in a market where SAP had the leadership, and saw an opportunity to lure in customers from those companies that had been acquired by Oracle.SAP customers who chose Oracle.On March 22, Oracle filed a suit against SAP.The complaint alleged that TomorrowNow, which provides discount support for legacy Oracle product lines, used the accounts of former Oracle customers to systematically download patches and support documents from Oracle's website and appropriating them for SAP's use.On July 3, SAP admitted that TomorrowNow employees had made "inappropriate downloads" from the Oracle support web site.However, it claims that SAP personnel and SAP customers had no access to Oracle intellectual property via TomorrowNow.Additionally, SAP announced that it has "instituted changes" in TomorrowNow's operational oversight.Asked how he'd feel if others were looking into Oracle's business activities, Ellison said: "We will ship our garbage to Redmond, and they can go through it.We believe in full disclosure.""Can't break it, can't break in"
Oracle markets many of its products using the slogan "Can't break it, can't break in", or "Unbreakable".Oracle Corporation also stresses the reliability of networked databases and network access to databases as major selling points.However, two weeks after its introduction in 2002, David Litchfield, Alexander Kornbrust, Cesar Cerrudo and others demonstrated a whole suite of successful attacks against Oracle products.But Oracle chief security officer Mary Ann Davidson says the criticism is unfair.Oracle's database server passed.Relationship with John Ashcroft
Former Attorney General John Ashcroft sued Oracle in 2004 to prevent a contract acquisition.Then, in 2005, Oracle hired Ashcroft's recently created lobbying firm, The Ashcroft Group, LLC.Oracle Corporation has its world headquarters on the San Francisco Peninsula in the Redwood Shores area of Redwood City, adjacent to Belmont, near San Carlos Airport (IATA airport code: SQL).Oracle Corporation originally leased two buildings from the site, moving its finance and administration departments from the corporation's former headquarters in Davis Drive, Belmont, California.Eventually, Oracle purchased the complex and constructed a further four main buildings.The Oracle Parkway buildings were prominently featured as the futuristic headquarters of fictional company "NorthAm Robotics" in the Robin Williams film Bicentennial Man (1999).The Oracle Arena
On October 20, 2006 the Golden State Warriors and the Oracle Corporation announced a 10 year agreement in which the Oakland Arena would be known as the Oracle Arena.Trivia sections are discouraged under Wikipedia guidelines.Oracle was referenced in a Saturday Night Live skit on May 14, 2005.Ferrell's character did song parodies that reflected Oracle.Part of Oracle's early success was due to the fact that they used the C programming language to implement their products such that they could be ported to different operating systems (most of which support C).Oracle wrote the first C compiler for the IBM mainframe platform in order to be able to port to that platform.The closest airport to the Oracle World Corporate Headquarters has the call sign of "SQL".In the Movie, Bicentennial Man, NorthAm Robotics' headquarters is Oracle's headquarters in reality.Elements of CNC are may be incorporated into Oracle's Oracle Fusion middleware."Oracle Claims Rival SAP Stole Software and Data (Update4)", Bloomberg, March 22, 2007.Oracle, on its relationship with SAP.This page was last modified 19:53, 18 January 2008.Groups, blogs, wiki and more bundled by topic.If you enter anything into this text box, no search results will be displayed.Business PracticesOracle Buy BEA for 8.Procedures 101No, procedures cannot be used this way in Oracle.Oracle CareerDBA Certification, Recruiters...Oracle Knowledge HubManage and Analyze Data with OracleDiscover more about how Oracle Database 11g and Oracle BI solutions can help improve your business.Spotlight White PapersSimplifying Contact Center TechnologyOracleTaking Remote Support to the Next LevelService Excellence Research Group, LLC3 Building Blocks to a Green IT StrategyVerdiemMore...Information Technology Toolbox, Inc.FORM VALIDATION MINIMUM ELEMENTS OR SUBMIT FUNCTION NAME
hbx.RESPONSE ATTRIBUTE IN REFERRAL QUERY
hbx.SQL language, including the newest Oracle Database 11g features.This Short Cut is written to assist you, an Oracle Clinical Developer, with many of the tasks and decisions you may encounter on an occasional basis.SQL, Oracle's powerful procedural language, has been the cornerstone of Oracle application development for nearly 15 years.The fourth edition is a comprehensive update, adding significant new content and extending coverage to Oracle Database 10g Release 2.This handy reference helps Oracle database administrators make more effective use of their time by presenting a compact summary of DBA tasks.This edition, revised for Toad for Oracle V8.Oracle utilities that database administrators (DBAs) use every day.DBAs looking to maximize use of SQL*Plus.The Oracle Initialization Parameters Pocket Reference provides the information Oracle DBAs need to keep databases operating at peak performance.This new guide provides the perfect introduction to the Oracle Application Server for users of any level.Oracle Data Dictionary Pocket Reference gives DBAs and developers at any level quick and easy access to the data dictionary in Oracle's latest database, Oracle9i.Rick Greenwald, David C.The goal of Oracle in a Nutshell is to pull together the most essential information on Oracle architecture, syntax, and user interfaces.Perl is a very powerful tool for Oracle database administrators, but too few DBAs realize how helpful Perl can be in managing, monitoring, and tuning Oracle9i, Oracle8i, and earlier databases.One of the most important challenges faced by Oracle database administrators and Oracle developers is the need to tune SQL statements so that they execute efficiently.Learn how to leverage JDBC, a key Java technology used to access relational data from Java programs, in an Oracle environment.Oracle RMAN Pocket Reference is ideal for DBAs who require a concise reference to common RMAN tasks.Despite the wide availability and use of SQL*Loader, few Oracle DBAs and developers know how powerful it really is.Oracle DBA Checklists Pocket Reference summarizes the enormous number of tasks an Oracle DBA must perform.Describes everything DBAs need to know to install configure, tune, and troubleshoot Net8, Oracle's networking technology.Based on Oracle8i, release 8.Clearly explains the inner workign of Oracle...What's new, what's hot, what's slipped under the radar, and news you need to know.Get the latest on the why, what, who, and how of Web 2.PDF documents on cutting edge topics.CA) and Club O'Reilly (International) are stores who have joined in partnership with O'Reilly to ensure plentiful stock of current and earlier titles.Time QuotesGet QuotesFinance SearchOracle Corp.ORACLE CORP (NasdaqGS:ORCL) After Hours: 21.Trade Time:4:00PM ETChange: 0.Volume:51,482,306Avg Vol (3m):39,448,700Market Cap:110.VMware undaunted by rival's catty commentsat FT.Oracle adds Akamai chairman to boardbizjournals.CB Richard Ellis named preferred provider for Oracle in Europebizjournals.More Financial Blogs for ORCL...MonopolyCNN NewsAmtrak Avoids A StrikeFOX Business NowThe Real Story Wrap, January 18TheStreet.Oracle Corporation, an enterprise software company, engages in the development, manufacture, distribution, servicing, and marketing of database, middleware, and application software.Quotes delayed, except where indicated otherwise.Delay times are 15 mins for NASDAQ, 20 mins for NYSE and Amex.Financials data provided by Edgar Online.Dividend data provided by Hemscott Americas.Fund summary, fund performance and Morningstar Index data provided by Morningstar.All information provided "as is" for informational purposes only, not intended for trading purposes or advice.Picture sitting in a movie theater, prepared for two hours of entertainment, and suddenly becoming a witness to acts of cruelty and torment so unspeakable that it's hard to imagine people paying to see them.Thursday's Board of Trustees meeting.USF could not end the skid. |
 |
 |
|
|
|
|
|
