From Wikipedia, the free encyclopedia
.^ Oracle Corporation produces and markets the Oracle Database.- Oracle - Oracle Corporation produces and markets the Oracle Database. The relational database management system (RDBMS) offici 9 January 2010 21:021 UTC ostatic.com [Source type: General]
^ Refer to the Oracle Database Recovery Manager Reference for details on recovery catalog views and Oracle Database Reference for details on V$ views.
^ Oracle is the leader in the enterprise database market.- Oracle Monitoring & Management | Hyperic 2 February 2010 16:36 UTC www.hyperic.com [Source type: Reference]
.^ Grid computing is a major initiative at Oracle.- Oracle looking to Linux - CNET News 2 February 2010 16:36 UTC news.cnet.com [Source type: General]
^ As of 2009, Oracle remains a major presence in database computing.- Computer Software: Oracle database administrators system Application Server has implemented 31 January 2010 13:46 UTC computercircuit.blogspot.com [Source type: Reference]
^ On September 15, 2009, Larry Ellison announced Oracle Exadata V2, the first OLTP Database Machine which combines software from Oracle and hardware from Sun.- Oracle and Sun - Overview and Frequently Asked Questions (Oracle PartnerNetwork Portugal) 31 January 2010 13:46 UTC blogs.oracle.com [Source type: General]
[1]
.^ Larry Ellison and his friends and former co-workers Bob Miner and Ed Oates started the consultancy Software Development Laboratories (SDL) in 1977.- Computer Software: Oracle database administrators system Application Server has implemented 31 January 2010 13:46 UTC computercircuit.blogspot.com [Source type: Reference]
^ He founded Oracle in 1977 under the name Software Development Laboratories.- Oracle Corporation - Oracle FAQ 2 February 2010 16:36 UTC www.orafaq.com [Source type: Reference]
^ SDL developed the original version of the Oracle software.- Computer Software: Oracle database administrators system Application Server has implemented 31 January 2010 13:46 UTC computercircuit.blogspot.com [Source type: Reference]
.^ The name Oracle comes from the code-name of a CIA-funded project Ellison had worked on while previously employed by Ampex.- Computer Software: Oracle database administrators system Application Server has implemented 31 January 2010 13:46 UTC computercircuit.blogspot.com [Source type: Reference]
^ Follow along as he builds a working Oracle encyclopedia, sharing his knowledge and experiences, and describing ways to integrate that technology in various projects and business areas.- What is the difference between Oracle, SQL and PL/SQL? 2 February 2010 16:36 UTC it.toolbox.com [Source type: General]
- An Expert's Guide to Oracle Technology 2 February 2010 16:36 UTC it.toolbox.com [Source type: General]
^ The products are a further development of the enterprise content management platform, previously code-named "Tsunami," that Oracle has been talking about for more than 18 months.- Oracle Launches Content Management With Database Tie--In - Past News 9 January 2010 21:021 UTC www.cioinsight.com [Source type: General]
[2]
Physical and logical structures
.^ Oracle Database uses the 'Numeric' data type to identify all numeric data.- Sybase.com 9 January 2010 21:021 UTC www.sybase.com [Source type: Reference]
^ Runtime: Enables applications to connect to an Oracle Database instance on the local system or on a remote system.
^ I have to do a application in Java, connecting with a Oracle Database.- Java Database Connectivity (JDBC) - Problem with SQL in Oracle 9 January 2010 21:021 UTC forums.sun.com [Source type: General]
.^ In Oracle , the instance is the collection of memory structures and processes running on the server .
^ Identify key database memory structures.- Microsoft SQL Server 2008 for the Experienced Oracle Database Administrator 9 January 2010 21:021 UTC www.microsoft.com [Source type: Reference]
^ Check the instance identifier for your system.- Creating an Oracle Database 9 January 2010 21:021 UTC www.cs.umbc.edu [Source type: Reference]
- Creating an Oracle Database 9 January 2010 21:021 UTC www.cs.umbc.edu [Source type: Reference]
.^ Typical processes include PMON (the process monitor) and SMON (the system monitor).- Computer Software: Oracle database administrators system Application Server has implemented 31 January 2010 13:46 UTC computercircuit.blogspot.com [Source type: Reference]
^ Typical operating groups might include some of the following individual processes—(shown along with their abbreviated nomenclature): .- Computer Software: Oracle database administrators system Application Server has implemented 31 January 2010 13:46 UTC computercircuit.blogspot.com [Source type: Reference]
^ The Oracle RDBMS typically relies on a group of processes running simultaneously in the background and interacting to monitor and expedite database operations.- Computer Software: Oracle database administrators system Application Server has implemented 31 January 2010 13:46 UTC computercircuit.blogspot.com [Source type: Reference]
.^ In Oracle , the instance is the collection of memory structures and processes running on the server .
^ Identify memory areas inside the Oracle SGA and their SQL Server equivalents.- Microsoft SQL Server 2008 for the Experienced Oracle Database Administrator 9 January 2010 21:021 UTC www.microsoft.com [Source type: Reference]
^ A guide to installing and configuring the Oracle Database Server on a Linux system .- Oracle Database HOWTO 9 January 2010 21:021 UTC www.faqs.org [Source type: Reference]
.^ These users are typically used to hold the standard data dictionary information for the database.- Oracle Database HOWTO 9 January 2010 21:021 UTC www.faqs.org [Source type: Reference]
- Oracle Database HOWTO: Creating a Database 9 January 2010 21:021 UTC tldp.org [Source type: General]
^ The SGA typically holds cache information such as data-buffers, SQL commands, and user information.- Computer Software: Oracle database administrators system Application Server has implemented 31 January 2010 13:46 UTC computercircuit.blogspot.com [Source type: Reference]
^ The data dictionary contains information such as: 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.- Computer Software: Oracle database administrators system Application Server has implemented 31 January 2010 13:46 UTC computercircuit.blogspot.com [Source type: Reference]
.^ In addition to storage, the database consists of online redo logs (or logs), which hold transactional history.- Computer Software: Oracle database administrators system Application Server has implemented 31 January 2010 13:46 UTC computercircuit.blogspot.com [Source type: Reference]
^ Online redo log groups have been multiplexed.- InformIT: Planning an Oracle Database > System Architecture 9 January 2010 21:021 UTC www.informit.com [Source type: FILTERED WITH BAYES]
^ Also, multiplex the online redo logs.- InformIT: Planning an Oracle Database > System Architecture 9 January 2010 21:021 UTC www.informit.com [Source type: FILTERED WITH BAYES]
.^ Do not place online redo log files and archive log files on the same disk.- InformIT: Planning an Oracle Database > System Architecture 9 January 2010 21:021 UTC www.informit.com [Source type: FILTERED WITH BAYES]
^ Processes can in turn archive the online redo logs into archive logs (offline redo logs), which provide the basis (if necessary) for data recovery and for some forms of data replication.- Computer Software: Oracle database administrators system Application Server has implemented 31 January 2010 13:46 UTC computercircuit.blogspot.com [Source type: Reference]
^ Recovery is the process of applying redo logs to the database to roll it forward.- Oracle database Backup and Recovery FAQ - Oracle FAQ 9 January 2010 21:021 UTC www.orafaq.com [Source type: General]
.^ The cluster configuration meets the requirements for creating a database with Oracle Real Application Clusters, or meets the requirements for a change in database configuration .- What's New in Oracle Database 10 g Oracle Real Application Clusters Installation and Configuration? 9 January 2010 21:021 UTC www.mcs.csueastbay.edu [Source type: FILTERED WITH BAYES]
^ Getting an oracle database administrator job.- Oracle Database Administrator Jobs Forum | Indeed.com 9 January 2010 21:021 UTC www.indeed.com [Source type: FILTERED WITH BAYES]
^ Oracle Database 10g Real Application Clusters Handbook.txt .- Oracle Database 10g Real Application Clusters Handbook ebook Download 31 January 2010 13:46 UTC www.toodoc.com [Source type: FILTERED WITH BAYES]
.^ This scenario offers advantages such as better performance, scalability and redundancy.- Computer Software: Oracle database administrators system Application Server has implemented 31 January 2010 13:46 UTC computercircuit.blogspot.com [Source type: Reference]
^ Database 11g also offers Database Replay and SQL Replay capabilities, which give users a better understanding of how database changes affect SQL performance.
^ Better Performance and Scalability: SQL Data Services, Filtered Indexes, Advanced Sparse Columns, Column Prefix Compression .- Compare SQL Server to Oracle 31 January 2010 13:46 UTC www.microsoft.com [Source type: General]
.^ However, support becomes more complex, and many sites do not use RAC. In version 10g, grid computing introduced shared resources where an instance can use (for example) CPU resources from another node (computer) in the grid.- Computer Software: Oracle database administrators system Application Server has implemented 31 January 2010 13:46 UTC computercircuit.blogspot.com [Source type: Reference]
^ USING VERSION 10g ¶ .- Oracle Spatial — MapServer 5.6.1 documentation 2 February 2010 16:36 UTC www.mapserver.org [Source type: Reference]
^ More on Oracle grid computing .- Oracle Database / Applications information, news and tips - SearchOracle.com 31 January 2010 13:46 UTC searchoracle.techtarget.com [Source type: News]
.^ Home .NET .NET CLR stored procedures within Oracle d...- .NET CLR stored procedures within Oracle database: Another breaking revolution 9 January 2010 21:021 UTC www.aspfree.com [Source type: FILTERED WITH BAYES]
^ The Oracle DBMS can store and execute stored procedures and functions within itself.- Computer Software: Oracle database administrators system Application Server has implemented 31 January 2010 13:46 UTC computercircuit.blogspot.com [Source type: Reference]
^ Creates, modifies and tunes Oracle database stored procedures, triggers, functions, indexes,...- Oracle Database Developer jobs - US News 9 January 2010 21:021 UTC jobs.usnews.com [Source type: Academic]
.^ PL/SQL (Oracle Corporation's proprietary procedural extension to SQL), or the object-oriented language Java can invoke such code objects and/or provide the programming structures for writing them.- Computer Software: Oracle database administrators system Application Server has implemented 31 January 2010 13:46 UTC computercircuit.blogspot.com [Source type: Reference]
^ An Oracle stored procedure is a program stored in an Oracle database.- Oracle Stored Procedures 2 February 2010 16:36 UTC www.devshed.com [Source type: FILTERED WITH BAYES]
^ Identify and administer PL/SQL objects .- Oracle Database 10g: Administration I 9 January 2010 21:021 UTC education.oracle.com [Source type: Reference]
Storage
.^ Define the purpose of tablespaces and data files .- Oracle Database 10g: Administration I 9 January 2010 21:021 UTC education.oracle.com [Source type: Reference]
^ Binary data stored in an external file .
^ Storage The Oracle RDBMS stores data logically in the form of tablespaces and physically in the form of data files.- Computer Software: Oracle database administrators system Application Server has implemented 31 January 2010 13:46 UTC computercircuit.blogspot.com [Source type: Reference]
.^ Use different indexes for different types of data: .- Oracle BI Blog - EPM, Business Intelligence, and OBIEE: DAC, ETL and Database Performance Tuning 9 January 2010 21:021 UTC oraclebiblog.blogspot.com [Source type: Reference]
^ Tablespaces can contain various types of memory segments, such as Data Segments, Index Segments, etc.- Computer Software: Oracle database administrators system Application Server has implemented 31 January 2010 13:46 UTC computercircuit.blogspot.com [Source type: Reference]
^ This feature provides an index type commonly used in data warehouses for columns with low cardinality, such as 'Y' or 'N', to dramatically improve performance gains in a data warehouse application.- 1 Oracle Database Editions 31 January 2010 13:46 UTC stmain.st.utoledo.edu [Source type: FILTERED WITH BAYES]
.^ Segments in turn comprise one or more extents.- Computer Software: Oracle database administrators system Application Server has implemented 31 January 2010 13:46 UTC computercircuit.blogspot.com [Source type: Reference]
^ Parallel DML requires more than one rollback segment.- SET TRANSACTION 2 February 2010 16:36 UTC www.stanford.edu [Source type: General]
^ Each transaction will likely take one (maybe more) extents.- InformIT: Planning an Oracle Database > System Architecture 9 January 2010 21:021 UTC www.informit.com [Source type: FILTERED WITH BAYES]
.^ Extents comprise groups of contiguous data blocks.- Computer Software: Oracle database administrators system Application Server has implemented 31 January 2010 13:46 UTC computercircuit.blogspot.com [Source type: Reference]
.^ Data blocks form the basic units of data storage.- Computer Software: Oracle database administrators system Application Server has implemented 31 January 2010 13:46 UTC computercircuit.blogspot.com [Source type: Reference]
^ In some cases, however, a larger data block size provides greater efficiency in disk and memory I/O (access and storage of data).- Creating an Oracle Database 9 January 2010 21:021 UTC www.cs.umbc.edu [Source type: Reference]
- Creating an Oracle Database 9 January 2010 21:021 UTC www.cs.umbc.edu [Source type: Reference]
^ In its simplest form, it is a way of breaking up or subsetting data into smaller units that can be managed and accessed separately.- Large Database Features In Oracle 9 January 2010 21:021 UTC www.devshed.com [Source type: FILTERED WITH BAYES]
.^ For more information, refer Oracle Management Online Help .- Oracle Management, Oracle Monitoring, Oracle Database Monitoring, Oracle Reports, Oracle Tuning, and Oracle Performance Monitoring Software - ManageEngine Applications Manager 9 January 2010 21:021 UTC www.manageengine.com [Source type: General]
^ An Oracle stored procedure is a program stored in an Oracle database.- Oracle Stored Procedures 2 February 2010 16:36 UTC www.devshed.com [Source type: FILTERED WITH BAYES]
^ Oracle stores year data with the century information.
.^ The SYSTEM tablespace contains the data dictionary—and often (by default) indexes and clusters.- Computer Software: Oracle database administrators system Application Server has implemented 31 January 2010 13:46 UTC computercircuit.blogspot.com [Source type: Reference]
^ The SYSTEM tablespace contains the data dictionary — and often (by default) indexes and clusters.- Oracle - Oracle Corporation produces and markets the Oracle Database. The relational database management system (RDBMS) offici 9 January 2010 21:021 UTC ostatic.com [Source type: General]
^ Since version 8i, the Oracle RDBMS also supports "locally managed" tablespaces which can store space management information in bitmaps in their own headers rather than in the SYSTEM tablespace (as happens with the default "dictionary-managed" tablespaces).- Computer Software: Oracle database administrators system Application Server has implemented 31 January 2010 13:46 UTC computercircuit.blogspot.com [Source type: Reference]
.^ Contains database information from the control file .- 2 Creating an Oracle Database 9 January 2010 21:021 UTC www.stanford.edu [Source type: Reference]
^ These users are typically used to hold the standard data dictionary information for the database.- Oracle Database HOWTO 9 January 2010 21:021 UTC www.faqs.org [Source type: Reference]
- Oracle Database HOWTO: Creating a Database 9 January 2010 21:021 UTC tldp.org [Source type: General]
^ All character data, including data in the data dictionary, is stored in the database character set.- Creating an Oracle Database 9 January 2010 21:021 UTC www.cs.uvm.edu [Source type: Reference]
- 2 Creating an Oracle Database 9 January 2010 21:021 UTC www.stanford.edu [Source type: Reference]
- Creating an Oracle Database 9 January 2010 21:021 UTC www.cs.umbc.edu [Source type: Reference]
- Creating an Oracle Database 9 January 2010 21:021 UTC www.cs.umbc.edu [Source type: Reference]
.^ Create, browse, and manage Oracle databases from version 8i to 11g.- database, and Oracle Corp. news and downloads on CNET 9 January 2010 21:021 UTC www.cnet.com [Source type: General]
^ Locally managed tablespaces provide better performance and greater ease of management than dictionary-managed tablespaces.- 2 Creating an Oracle Database 9 January 2010 21:021 UTC www.stanford.edu [Source type: Reference]
^ Since version 8i, the Oracle RDBMS also supports "locally managed" tablespaces which can store space management information in bitmaps in their own headers rather than in the SYSTEM tablespace (as happens with the default "dictionary-managed" tablespaces).- Computer Software: Oracle database administrators system Application Server has implemented 31 January 2010 13:46 UTC computercircuit.blogspot.com [Source type: Reference]
Disk files
.^ The ability to specify multiple block sizes for your database is especially useful if you are transporting tablespaces between databases.- Creating an Oracle Database 9 January 2010 21:021 UTC www.cs.uvm.edu [Source type: Reference]
- 2 Creating an Oracle Database 9 January 2010 21:021 UTC www.stanford.edu [Source type: Reference]
^ In some cases, however, a larger data block size provides greater efficiency in disk and memory I/O (access and storage of data).- Creating an Oracle Database 9 January 2010 21:021 UTC www.cs.umbc.edu [Source type: Reference]
- Creating an Oracle Database 9 January 2010 21:021 UTC www.cs.umbc.edu [Source type: Reference]
^ Segments in turn comprise one or more extents.- Computer Software: Oracle database administrators system Application Server has implemented 31 January 2010 13:46 UTC computercircuit.blogspot.com [Source type: Reference]
.^ Specify a directory on a file system with sufficient free disk space.- Oracle® Database Quick Installation Guide 9 January 2010 21:021 UTC download-west.oracle.com [Source type: Reference]
- Oracle® Database Quick Installation Guide 9 January 2010 21:021 UTC download.oracle.com [Source type: Reference]
- Oracle® Database Quick Installation Guide 9 January 2010 21:021 UTC download-east.oracle.com [Source type: Reference]
^ Raw disk space.- Oracle Database Machine and Exadata pricing: Part 2 | DBMS2 -- DataBase Management System Services 9 January 2010 21:021 UTC www.dbms2.com [Source type: General]
^ Disk space for software files .- Oracle® Database Quick Installation Guide 9 January 2010 21:021 UTC download-west.oracle.com [Source type: Reference]
- Oracle® Database Quick Installation Guide 9 January 2010 21:021 UTC download.oracle.com [Source type: Reference]
- Oracle® Database Quick Installation Guide 9 January 2010 21:021 UTC download-east.oracle.com [Source type: Reference]
[4]
Control files
The following parameters govern the size of the control files:
* maxlogfiles
* maxlogmembers
* maxloghistory
* maxinstances
* control_file_record_keep_time
Database schema
.^ Create and redesign Oracle database objects.- Oracle Database news and downloads on CNET 31 January 2010 13:46 UTC ces.cnet.com [Source type: General]
^ Control files Size of control files The size of the control files is governed by the following parameters: * maxlogfiles * maxlogmembers * maxloghistory * maxinstances * control_file_record_keep_time Database schema Oracle database conventions refer to defined groups of object ownership (generally associated with a "username") as schemas.- Computer Software: Oracle database administrators system Application Server has implemented 31 January 2010 13:46 UTC computercircuit.blogspot.com [Source type: Reference]
^ Oracle database schema downloads at VicMan .- Oracle database schema downloads at VicMan 31 January 2010 13:46 UTC www.vicman.net [Source type: Reference]
.^ The schemas and installation instructions are described in detail in Oracle Database Sample Schemas .- 2 Creating an Oracle Database 9 January 2010 21:021 UTC www.stanford.edu [Source type: Reference]
^ Welcome to the Oracle Database 10 g Installation .- Oracle® Database Quick Installation Guide 9 January 2010 21:021 UTC download.oracle.com [Source type: Reference]
^ Making the Most of Oracle Database 10g.- InformIT: Oracle Database 10g Insider Solutions 9 January 2010 21:021 UTC www.informit.com [Source type: General]
.^ Those are the basics of setting up an OFA database installation.- InformIT: Planning an Oracle Database > System Architecture 9 January 2010 21:021 UTC www.informit.com [Source type: FILTERED WITH BAYES]
^ Oracle database with sample user (that I unlocked during installation) .- How to install Oracle Database 10g on Mac OS X Intel « ray_apps_blog 9 January 2010 21:021 UTC blog.rayapps.com [Source type: FILTERED WITH BAYES]
^ Note that both a username (scott) and password (tiger) are provided.- Database Security 3.0: Oracle 31 January 2010 13:46 UTC blog.appsecinc.com [Source type: General]
.^ He founded Oracle in 1977 under the name Software Development Laboratories.- Oracle Corporation - Oracle FAQ 2 February 2010 16:36 UTC www.orafaq.com [Source type: Reference]
^ SDL developed the original version of the Oracle software.- Computer Software: Oracle database administrators system Application Server has implemented 31 January 2010 13:46 UTC computercircuit.blogspot.com [Source type: Reference]
^ The name of the SCOTT schema originated with Bruce Scott, one of the first employees at Oracle (then Software Development Laboratories), who had a cat named Tiger.- Computer Software: Oracle database administrators system Application Server has implemented 31 January 2010 13:46 UTC computercircuit.blogspot.com [Source type: Reference]
[5]
.^ JDK 1.5.0 is used in Oracle Database Release 1.- Oracle® Database 9 January 2010 21:021 UTC download.oracle.com [Source type: FILTERED WITH BAYES]
^ Oracle Corporation has de-emphasized the use of the SCOTT schema, as it uses few of the features of the more recent releases of Oracle.- Computer Software: Oracle database administrators system Application Server has implemented 31 January 2010 13:46 UTC computercircuit.blogspot.com [Source type: Reference]
^ In 1983, RSI was renamed Oracle Corporation to more closely align itself with its flagship product.- Oracle Portal and Oracle Directory: Oracle Software, Oracle Tools, Oracle Articles, Oracle Tutorials, Oracle white papers, Oracle scripts, Oracle consultants, Oracle Developers, Oracle Forums and more. 9 January 2010 21:021 UTC www.oracle.databasecorner.com [Source type: Academic]
.^ Most recent examples supplied by Oracle Corporation reference the default HR or OE schemas.- Computer Software: Oracle database administrators system Application Server has implemented 31 January 2010 13:46 UTC computercircuit.blogspot.com [Source type: Reference]
^ Most Oracle database installations traditionally came with a default schema called SCOTT. After the installation process has set up the sample tables, the user can log into the database with the username scott and the password tiger.- Computer Software: Oracle database administrators system Application Server has implemented 31 January 2010 13:46 UTC computercircuit.blogspot.com [Source type: Reference]
^ BI, IX, HR, OE, PM, and SH (expanded sample schemas containing more data and structures than the older SCOTT schema).- Computer Software: Oracle database administrators system Application Server has implemented 31 January 2010 13:46 UTC computercircuit.blogspot.com [Source type: Reference]
Other default schemas
[6] include:
- Computer Software: Oracle database administrators system Application Server has implemented 31 January 2010 13:46 UTC computercircuit.blogspot.com [Source type: Reference]
^ Execute Oracle database queries .- Oracle database (oracle) - PHP Classes 9 January 2010 21:021 UTC www.phpclasses.org [Source type: General]
- Oracle database (oracle) - PHP Classes 31 January 2010 13:46 UTC www.phpclasses.org [Source type: General]
^ OUTLN is an account used to support Oracle’s Query Plan Stability or Stored Outlines feature.- Database Security 3.0: Oracle 31 January 2010 13:46 UTC blog.appsecinc.com [Source type: General]
[7]
BI, IX, HR, OE, PM, and SH (expanded sample schemas[8] containing more data and structures than the older SCOTT schema).
Memory architecture
System Global Area
.^ Oracle stores year data with the century information.
^ Program Global Area The Program Global Area or PGA memory-area of an Oracle instance contains data and control-information for Oracle's server-processes.- Computer Software: Oracle database administrators system Application Server has implemented 31 January 2010 13:46 UTC computercircuit.blogspot.com [Source type: Reference]
^ System Global Area Main article: System Global Area Each Oracle instance uses a System Global Area or SGA—a shared-memory area—to store its data and control-information.- Computer Software: Oracle database administrators system Application Server has implemented 31 January 2010 13:46 UTC computercircuit.blogspot.com [Source type: Reference]
[9]
.^ SQL> shutdown abort ORACLE instance shut down.- Oracle Database Startup and Shutdown Procedure 9 January 2010 21:021 UTC www.thegeekstuff.com [Source type: General]
^ Start up and shut down ASM instances .- Oracle Database 10g: Administration II 9 January 2010 21:021 UTC education.oracle.com [Source type: Reference]
^ SVRMGR> startup ORACLE instance started.- Oracle Database HOWTO 9 January 2010 21:021 UTC www.faqs.org [Source type: Reference]
The information in the SGA consists of the following elements, each of which has a fixed size, established at instance startup:
.^ The information in the SGA consists of the following elements, each of which has a fixed size, established at instance startup: the database buffer cache: this stores the most recently-used data blocks.- Computer Software: Oracle database administrators system Application Server has implemented 31 January 2010 13:46 UTC computercircuit.blogspot.com [Source type: Reference]
^ Sets the character set that stores data in the database .- 2 Creating an Oracle Database 9 January 2010 21:021 UTC www.stanford.edu [Source type: Reference]
^ Nonstandard block size buffer caches .- 2 Creating an Oracle Database 9 January 2010 21:021 UTC www.stanford.edu [Source type: Reference]
.^ These blocks can contain modified data not yet written to disk (sometimes known as "dirty blocks"), unmodified blocks, or blocks written to disk since modification (sometimes known as clean blocks).- Computer Software: Oracle database administrators system Application Server has implemented 31 January 2010 13:46 UTC computercircuit.blogspot.com [Source type: Reference]
^ Suppose these dirty blocks are written while we are copying datafiles from o/s.- Ask Tom "RMAN - Full vs. Incremental - performa..." 31 January 2010 13:46 UTC asktom.oracle.com [Source type: General]
^ And then we clean the buffer cache of any pre-existing dirty blocks for those datafiles.- Ask Tom "RMAN - Full vs. Incremental - performa..." 31 January 2010 13:46 UTC asktom.oracle.com [Source type: General]
.^ Size the redo log buffer appropriately.- InformIT: Planning an Oracle Database > System Architecture 9 January 2010 21:021 UTC www.informit.com [Source type: FILTERED WITH BAYES]
^ The size of a buffer cache affects performance.- Creating an Oracle Database 9 January 2010 21:021 UTC www.cs.uvm.edu [Source type: Reference]
- 2 Creating an Oracle Database 9 January 2010 21:021 UTC www.stanford.edu [Source type: Reference]
^ Nonstandard block size buffer caches .- 2 Creating an Oracle Database 9 January 2010 21:021 UTC www.stanford.edu [Source type: Reference]
.^ Size the redo log buffer appropriately.- InformIT: Planning an Oracle Database > System Architecture 9 January 2010 21:021 UTC www.informit.com [Source type: FILTERED WITH BAYES]
^ The instance writes redo log buffers to the redo log as quickly and efficiently as possible.- Computer Software: Oracle database administrators system Application Server has implemented 31 January 2010 13:46 UTC computercircuit.blogspot.com [Source type: Reference]
^ Oracle will write complete database blocks instead of the normal deltas to redo log files while in backup mode.- Oracle database Backup and Recovery FAQ - Oracle FAQ 9 January 2010 21:021 UTC www.orafaq.com [Source type: General]
.^ System Global Area Main article: System Global Area Each Oracle instance uses a System Global Area or SGA—a shared-memory area—to store its data and control-information.- Computer Software: Oracle database administrators system Application Server has implemented 31 January 2010 13:46 UTC computercircuit.blogspot.com [Source type: Reference]
^ Displays summary information about the system global area (SGA).- 2 Creating an Oracle Database 9 January 2010 21:021 UTC www.stanford.edu [Source type: Reference]
^ The redo log aids in instance recovery in the event of a system failure.- Computer Software: Oracle database administrators system Application Server has implemented 31 January 2010 13:46 UTC computercircuit.blogspot.com [Source type: Reference]
An insufficient amount of memory allocated to the shared pool can cause performance degradation.
Library cache
.^ This function executes the SQL statement: .- Database Security 3.0: Oracle 31 January 2010 13:46 UTC blog.appsecinc.com [Source type: General]
^ Library cache The library cache stores shared SQL, caching the parse tree and the execution plan for every unique SQL statement.- Computer Software: Oracle database administrators system Application Server has implemented 31 January 2010 13:46 UTC computercircuit.blogspot.com [Source type: Reference]
^ Max results & max column retrieval configurable - Text (configurable display of SQL Statement, query statistics, warning headers) - Text History - DBMS_OUTPUT - Grid (configurable alternating colors) and Grid Chart Results - Explain Plan - Client Statistics (Time stats: total processing, client processing, server wait, parse, execution) - Pivot Results (With Pivot Grids and Pivot Charts) .- Oracle management tool w/ administration capabilities and database query tool. 9 January 2010 21:021 UTC www.aquafold.com [Source type: Reference]
.^ If multiple applications issue the same SQL statement, each application can access the shared SQL area.- Computer Software: Oracle database administrators system Application Server has implemented 31 January 2010 13:46 UTC computercircuit.blogspot.com [Source type: Reference]
^ Oracle automatically issues an implicit COMMIT before and after any SQL DDL (Data Definition Language) statement (even if this DDL statement fails) .
^ Use a smaller shared SQL area in favor of a larger database buffer cache.- InformIT: Planning an Oracle Database > System Architecture 9 January 2010 21:021 UTC www.informit.com [Source type: FILTERED WITH BAYES]
.^ Max results & max column retrieval configurable - Text (configurable display of SQL Statement, query statistics, warning headers) - Text History - DBMS_OUTPUT - Grid (configurable alternating colors) and Grid Chart Results - Explain Plan - Client Statistics (Time stats: total processing, client processing, server wait, parse, execution) - Pivot Results (With Pivot Grids and Pivot Charts) .- Oracle management tool w/ administration capabilities and database query tool. 9 January 2010 21:021 UTC www.aquafold.com [Source type: Reference]
^ Explains the process of planning and executing database upgrades on the Oracle Database server.
^ End Users say “I want it all, and I want it now” but Executives need IT to deliver Project Portfolio Management benefits at a reduced price and on a faster time line.
Data dictionary cache
.^ All character data, including data in the data dictionary, is stored in the database character set.- Creating an Oracle Database 9 January 2010 21:021 UTC www.cs.uvm.edu [Source type: Reference]
- 2 Creating an Oracle Database 9 January 2010 21:021 UTC www.stanford.edu [Source type: Reference]
- Creating an Oracle Database 9 January 2010 21:021 UTC www.cs.umbc.edu [Source type: Reference]
- Creating an Oracle Database 9 January 2010 21:021 UTC www.cs.umbc.edu [Source type: Reference]
^ Sets the character set that stores data in the database .- 2 Creating an Oracle Database 9 January 2010 21:021 UTC www.stanford.edu [Source type: Reference]
^ View utilization data on storage structures.- Microsoft SQL Server 2008 for the Experienced Oracle Database Administrator 9 January 2010 21:021 UTC www.microsoft.com [Source type: Reference]
.^ Oracle Database SQL Reference for more information about the conversions .
^ About Oracle Database 11 g .
^ An Oracle stored procedure is a program stored in an Oracle database.- Oracle Stored Procedures 2 February 2010 16:36 UTC www.devshed.com [Source type: FILTERED WITH BAYES]
The data dictionary contains information such as:
- 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
.^ SQL> startup ORACLE instance started.- Oracle Database Startup and Shutdown Procedure 9 January 2010 21:021 UTC www.thegeekstuff.com [Source type: General]
- How to install Oracle Database 10g on Mac OS X Intel « ray_apps_blog 9 January 2010 21:021 UTC blog.rayapps.com [Source type: FILTERED WITH BAYES]
^ Called a lateral SQL injection, the attack could be used to gain database administrator privileges on an Oracle server in order to change or delete data or even install software, Litchfield said in an interview on Thursday.- Researcher finds new way to hack Oracle database 9 January 2010 21:021 UTC www.computerworld.com [Source type: General]
^ Creating NOT NULL Columns in Huge Oracle Tables Databases are often taxed by applying SQL statements to enormous tables.- DBAsupport.com : The Knowledge Center for Oracle Professionals 2 February 2010 16:36 UTC www.dbasupport.com [Source type: FILTERED WITH BAYES]
.^ A Practical Guide to Data Warehousing in Oracle, Part 6 Materialized Views are continually enhanced by Oracle to leverage data warehouse performance and maintainability.- DBAsupport.com : The Knowledge Center for Oracle Professionals 2 February 2010 16:36 UTC www.dbasupport.com [Source type: FILTERED WITH BAYES]
^ Individual tablespaces and/or their data files can be taken offline for maintenance or archiving without affecting access to other subsets of data.- Large Database Features In Oracle 9 January 2010 21:021 UTC www.devshed.com [Source type: FILTERED WITH BAYES]
^ Creating New Database Users Using pre-spawned Oracle connections Auditing User activity Identifying System and Object Privileges Granting and Revoking Privileges Creating and Modifying Roles Displaying user security Information from the Data Dictionary Oracle database management .
.^ Make sure that your hardware is sufficient.- Installing and Configuring Oracle Database 10g on the Solaris Platform 9 January 2010 21:021 UTC www.dbspecialists.com [Source type: FILTERED WITH BAYES]
^ Database programmers should review their code to be sure it is checking to make sure that all of the data it is processing is legitimate, and not injected SQL commands, he said.- Researcher Finds New Way to Hack Oracle Database - CSO Online - Security and Risk 9 January 2010 21:021 UTC www.csoonline.com [Source type: News]
^ This software repairs a corrupted database and inserts recovered data in a new database created by user before initiating recovery process, without making any changes in the corrupted database.- Oracle database recovery software - Stellar Oracle Recovery 31 January 2010 13:46 UTC www.stellarinfo.com [Source type: Reference]
.^ For the application developers and end users, the issues were query performance and data availability.- Large Database Features In Oracle 9 January 2010 21:021 UTC www.devshed.com [Source type: FILTERED WITH BAYES]
^ A data grid infrastructure with clustered caching creates a competitive edge, improves financial performance, and sustains customer loyalty.
^ Thus, Oracle In-Memory Database Cache offers applications the full generality and functionality of a relational database, the transparent maintenance of cache consistency with the Oracle Database, and the real-time performance of an in-memory database.
.^ A data grid infrastructure with clustered caching creates a competitive edge, improves financial performance, and sustains customer loyalty.
^ The SGA comprises a number of memory components , which are pools of memory used to satisfy a particular class of memory allocation requests.- 2 Creating an Oracle Database 9 January 2010 21:021 UTC www.stanford.edu [Source type: Reference]
^ Configuring the shared pool is discussed in Oracle Database Performance Tuning Guide .- 2 Creating an Oracle Database 9 January 2010 21:021 UTC www.stanford.edu [Source type: Reference]
Program Global Area
.^ Contains database information from the control file .- 2 Creating an Oracle Database 9 January 2010 21:021 UTC www.stanford.edu [Source type: Reference]
^ Oracle Database XE is free for runtime usage with the following limitations: Supports up to 4GB of user data (in addition to Oracle system data) Single instance only of Oracle Database XE on any server Only uses and executes on one processor in any server Can use up to 1GB RAM .- OTN Discussion Forums : Oracle Database 10g Express Edition ... 9 January 2010 21:021 UTC forums.oracle.com [Source type: General]
^ Oracle is best known for its 10g database, but the company also offers software for managing, sharing and protecting data and information.- Oracle Tools, Oracle Code, Oracle Tips, Oracle Info 2 February 2010 16:36 UTC www.devarticles.com [Source type: General]
.^ (The first time you install Oracle software on the database server there will be two scripts to run as root, while additional installations only require one script to be run as root.- Installing and Configuring Oracle Database 10g on the Linux Platform 31 January 2010 13:46 UTC www.dbspecialists.com [Source type: General]
^ Hello, i follow your instruction and all it’s OK. But i need to install Oracle Http Server and i don’t see it.- How to install Oracle Database 10g on Mac OS X Snow Leopard « ray_apps_blog 31 January 2010 13:46 UTC blog.rayapps.com [Source type: FILTERED WITH BAYES]
^ OFA allows multiple versions of Oracle to be installed on one server.- InformIT: Planning an Oracle Database > System Architecture 9 January 2010 21:021 UTC www.informit.com [Source type: FILTERED WITH BAYES]
This area consists of the following components:
- stack-space: the memory that holds the session's variables, arrays, and so on.
- session-information: unless using the multithreaded server, the instance stores its session-information in the PGA. (In a multithreaded server, the session-information goes in the SGA.)
- private SQL-area: an area in the PGA which holds information such as bind-variables and runtime-buffers.
- sorting area: an area in the PGA which holds information on sorts, hash-joins, etc.
Dynamic performance views
.^ Oracle Database 10g: Performance Tuning .- Oracle Database 10g Performance Tuning Training | Oracle Database 10g Performance Tuning Boot Camp | Oracle Database 10g Performance Tuning Training Course 9 January 2010 21:021 UTC www.koenig-solutions.com [Source type: General]
- 10g, Database & Grids Training - Oracle Classes 9 January 2010 21:021 UTC www.exitcertified.com [Source type: Reference]
^ Use dynamic performance views (3) .- Oracle Database 10g: Administration I 9 January 2010 21:021 UTC education.oracle.com [Source type: Reference]
^ Oracle tables, views and materialized views .
[15] .^ Controlling and monitoring user access to the database .- Oracle Developers India - Oracle Consulting Service Outsource Oracle Development India Oracle Software Outsourcing India Oracle Database Consultant - Icreon 9 January 2010 21:021 UTC www.icreon.com [Source type: Reference]
^ These admin accounts in the Oracle database usually have the ability to manage user security, maintain database storage, and perform backup and recovery tasks.- Approaches to Monitor Activities in Oracle Database 9 January 2010 21:021 UTC www.isaca.org [Source type: Academic]
^ Change Control : implemented a system to capture snapshots of database structure information, allowing us to track changes over time.- Database Doctor -- Helping People Run Oracle Databases 9 January 2010 21:021 UTC dbdr.com [Source type: FILTERED WITH BAYES]
Process architectures
Oracle processes
.^ Configure and monitor database processes.- Microsoft SQL Server 2008 for the Experienced Oracle Database Administrator 9 January 2010 21:021 UTC www.microsoft.com [Source type: Reference]
^ June 5, 2008 Oracle Database 11g Common Background Processes .- Oracle Database 11g – Common Background Processes — DatabaseJournal.com 31 January 2010 13:46 UTC www.databasejournal.com [Source type: FILTERED WITH BAYES]
^ Monitor the availability of your Oracle database.- Oracle Database news and downloads on CNET 31 January 2010 13:46 UTC ces.cnet.com [Source type: General]
Typical operating groups might include some of the following individual processes—(shown along with their abbreviated nomenclature):
[16]
- archiver processes (ARCn)
- checkpoint process (CKPT) *REQUIRED*
- coordinator-of-job-queues process (CJQn): dynamically spawns slave processes for job-queues
- database writer processes (DBWn) *REQUIRED*
- dispatcher processes (Dnnn): multiplex server-processes on behalf of users
- memory-manager process (MMAN): used for internal database tasks such as Automatic Shared Memory Management
- log-writer process (LGWR) *REQUIRED*
- log-write network-server (LNSn): transmits redo logs in Data Guard environments
- logical standby coordinator process (LSP0): controls Data Guard log-application
- media-recovery process (MRP): detached recovery-server process
- memory-monitor process (MMON): process for automatic problem-detection, self-tuning and statistics-gathering[17]
- memory-monitor light process (MMNL): gathers and stores Automatic Workload Repository (AWR) data
- mmon slaves (Mnnnn—M0000, M0001, etc): background slaves of the MMON process[18]
- process-monitor process (PMON) *REQUIRED*
- process-spawner (PSP0): spawns Oracle processes
- queue-monitor processes (QMNn)
- recoverer process (RECO)
- remote file-server process (RFS)
- shared server processes (Snnn): serve client-requests
- system monitor process (SMON) *REQUIRED*
User processes, connections and sessions
Oracle Database terminology distinguishes different
computer-science terms in describing how end-users interact with the database:
- Oracle Database 11g – Common Background Processes — DatabaseJournal.com 31 January 2010 13:46 UTC www.databasejournal.com [Source type: FILTERED WITH BAYES]
^ The oracle user (the Oracle software owner) .- Oracle® Database Quick Installation Guide 9 January 2010 21:021 UTC download-west.oracle.com [Source type: Reference]
- Oracle® Database Quick Installation Guide 9 January 2010 21:021 UTC download.oracle.com [Source type: Reference]
- Oracle® Database Quick Installation Guide 9 January 2010 21:021 UTC download-east.oracle.com [Source type: Reference]
^ An ActiveServerPages application can connect to an oracle db.- Oracle Database 9 January 2010 21:021 UTC c2.com [Source type: FILTERED WITH BAYES]
[21] Each session within an instance has a session identifier or "SID"
[22] (distinct from the system-identifier SID).
Concurrency and locking
.^ Oracle 9i Database Access .
^ This document supplements Oracle Database Readme .- Oracle® Database 9 January 2010 21:021 UTC download.oracle.com [Source type: FILTERED WITH BAYES]
^ WAND's DataFocus solution adds value in Oracle Database environments by providing a data model for unstructured information, and enhances Oracle Secure Enterprise Search by adding advanced taxonomy metadata to documents for intuitive retrieval and navigation.- Oracle Database Insider Blog: October 2009 Archives 9 January 2010 21:021 UTC blogs.oracle.com [Source type: General]
.^ View utilization data on storage structures.- Microsoft SQL Server 2008 for the Experienced Oracle Database Administrator 9 January 2010 21:021 UTC www.microsoft.com [Source type: Reference]
^ Change Control : implemented a system to capture snapshots of database structure information, allowing us to track changes over time.- Database Doctor -- Helping People Run Oracle Databases 9 January 2010 21:021 UTC dbdr.com [Source type: FILTERED WITH BAYES]
^ Total System Global Area 289406976 bytes Fixed Size 1301536 bytes Variable Size 262677472 bytes Database Buffers 25165824 bytes Redo Buffers 262144 bytes Now, from SQL*Plus, run the following PL/SQL block to restore the file: .- Oracle database Backup and Recovery FAQ - Oracle FAQ 9 January 2010 21:021 UTC www.orafaq.com [Source type: General]
[24]
Configuration
.^ Database Administrator Oracle 10G .- Oracle database administrator jobs - SQL Authority 9 January 2010 21:021 UTC jobs.sqlauthority.com [Source type: FILTERED WITH BAYES]
^ You can also change their values by changing their value in the initialization parameter file and then restarting the instance.- Datetime Datatypes and Time Zone Support 2 February 2010 16:36 UTC download.oracle.com [Source type: FILTERED WITH BAYES]
^ Database Administrator ( Oracle 10G) .- Oracle Database Administrator jobs - washingtonpost.com 9 January 2010 21:021 UTC nationaljobs.washingtonpost.com [Source type: News]
- Oracle database administrator jobs - SQL Authority 9 January 2010 21:021 UTC jobs.sqlauthority.com [Source type: FILTERED WITH BAYES]
[25] .^ Once this is done, copy the init.ora file into a new file named init{SID}.ora into new directory.- Page 3 - Creating a Database in Oracle 9i 9 January 2010 21:021 UTC www.devarticles.com [Source type: FILTERED WITH BAYES]
^ The pfile directory contains the init.ora file for the database.- InformIT: Planning an Oracle Database > System Architecture 9 January 2010 21:021 UTC www.informit.com [Source type: FILTERED WITH BAYES]
^ For this tutorial, we created an init file named inithsconnect.ora.- Accessing SQL Server from Oracle with Database Gateway for ODBC (DG4ODBC) 9 January 2010 21:021 UTC www.easysoft.com [Source type: Reference]
.^ The SPFILE initialization parameter contains the name of the current server parameter file.- Creating an Oracle Database 9 January 2010 21:021 UTC www.cs.uvm.edu [Source type: Reference]
- 2 Creating an Oracle Database 9 January 2010 21:021 UTC www.stanford.edu [Source type: Reference]
^ Server parameter files (spfiles) .
^ CREATE SPFILE FROM PFILE='/u01/oracle/dbs/init.ora'; Another example, below, illustrates creating a server parameter file and supplying a name.- Creating an Oracle Database 9 January 2010 21:021 UTC www.cs.uvm.edu [Source type: Reference]
.^ DBMS_ADVISOR , when the value of the advisor_name parameter is either SQL Tuning Advisor or SQL Access Advisor .
^ Oracle Database SQL Reference for more information about specifying the clauses and parameter values for the CREATE DATABASE statement .- 2 Creating an Oracle Database 9 January 2010 21:021 UTC www.stanford.edu [Source type: Reference]
^ Enter commands similar to the following to view the current values of the kernel parameters: .- Oracle® Database Quick Installation Guide 9 January 2010 21:021 UTC download.oracle.com [Source type: Reference]
1
Internationalization
.^ Separation of Oracle software files from database files .- InformIT: Planning an Oracle Database > System Architecture 9 January 2010 21:021 UTC www.informit.com [Source type: FILTERED WITH BAYES]
^ Good understanding of various database platforms, including Oracle , DB2,...- Oracle database administrator jobs - Quick Online Jobs Search 9 January 2010 21:021 UTC jobs.quickonlinetips.com [Source type: FILTERED WITH BAYES]
^ On September 15, 2009, Larry Ellison announced Oracle Exadata V2, the first OLTP Database Machine which combines software from Oracle and hardware from Sun.- Oracle and Sun - Overview and Frequently Asked Questions (Oracle PartnerNetwork Portugal) 31 January 2010 13:46 UTC blogs.oracle.com [Source type: General]
.^ The date format in the example includes a two-digit number for the day of the month, an abbreviation of the month name, the last two digits of the year, and a 24-hour time designation.- Datetime Datatypes and Time Zone Support 2 February 2010 16:36 UTC download.oracle.com [Source type: FILTERED WITH BAYES]
^ In a time-only entry, the date portion defaults to the first day of the current month.
^ The time zone files contain the valid time zone names and the following information is included for each zone (note that abbreviations are only used in conjunction with the zone names): .- Creating an Oracle Database 9 January 2010 21:021 UTC www.cs.uvm.edu [Source type: Reference]
[29]
.^ High Availability with Oracle Database 11g Release 2 by Oracle Corporation .- Oracle Database Mac White Papers, Oracle Database Mac Software, Oracle Database Mac Research, Hardware and Services - KnowledgeStorm 31 January 2010 13:46 UTC www.knowledgestorm.com [Source type: Academic]
^ (ORCL) Oracle Corporation Takes Over Sun Microsystems The database software giant Oracle Corp.- ORCL Stock Quote - stock news and information - CBS MoneyWatch.com 2 February 2010 16:36 UTC finance.bnet.com [Source type: News]
^ Part I. Out of Memory Errors With Oracle Database On RHEL 4.8 Or OEL 4.8?- Sun Oracle Database Machine: The Million Oracle Database IOPS Machine or Marketing Hype? Part II. « Kevin Closson’s Oracle Blog: Platform, Storage & Clustering Topics Related to Oracle Databases 9 January 2010 21:021 UTC kevinclosson.wordpress.com [Source type: General]
[30]
Oracle Corporation provides database developers with tools and mechanisms for producing internationalized database applications: referred to internally as "Globalization".
[31]History
Corporate/technical timeline
- 1977: Larry Ellison and friends founded Software Development Laboratories.
- 1979: SDL changed its company-name to "Relational Software, Inc." (RSI) and introduced its product Oracle V2 as an early commercially-available relational database system. .^ Standard SQL functionality and database transaction semantics .
^ LewisC "Brian Tkatch" writes: 4/27/2009 # T-SQL is the *SQL Server* version of PL/SQL. MS did not invent it, Sybase did.- What is the difference between Oracle, SQL and PL/SQL? 2 February 2010 16:36 UTC it.toolbox.com [Source type: General]
^ The Multiple Active Result Sets (MARS) feature provided by SQL Server 2005 and 2008 allows these versions of SQL Server to support multiple active statements on a connection.- Accessing SQL Server from Oracle with Database Gateway for ODBC (DG4ODBC) 9 January 2010 21:021 UTC www.easysoft.com [Source type: Reference]
(RSI never released a version 1 - instead calling the first version version 2 as a marketing gimmick.)[32]
.^ The Oracle program used by this SID. .- Accessing SQL Server from Oracle with Database Gateway for ODBC (DG4ODBC) 9 January 2010 21:021 UTC www.easysoft.com [Source type: Reference]
^ JDK 1.5.0 is used in Oracle Database Release 1.- Oracle® Database 9 January 2010 21:021 UTC download.oracle.com [Source type: FILTERED WITH BAYES]
^ Contacting Oracle Corporation for technical support .- Oracle Developers India - Oracle Consulting Service Outsource Oracle Development India Oracle Software Outsourcing India Oracle Database Consultant - Icreon 9 January 2010 21:021 UTC www.icreon.com [Source type: Reference]
.^ Then oracle development and support further necessitate that the production system version be the latest.- Infosys-Oracle Blog 2 February 2010 16:36 UTC www.infosysblogs.com [Source type: FILTERED WITH BAYES]
^ Names of directories, filenames, and environment variables may differ for on other platforms but will probably be the same for all UNIX platforms.- 2 Creating an Oracle Database 9 January 2010 21:021 UTC www.stanford.edu [Source type: Reference]
^ Describes how to install the Oracle Data Mining software and how to perform other administrative functions common to all Oracle Data Mining environments on both UNIX and Windows platforms.
[33]
.^ Partitioning with Oracle Database 11g Release 2 .
^ Oracle stored procedure programming ( Oracle PL/SQL).- Oracle database administrator jobs - SQL Authority 9 January 2010 21:021 UTC jobs.sqlauthority.com [Source type: FILTERED WITH BAYES]
^ Oracle Database SQL Reference for more information about the conversions .
[34]
.^ Then oracle development and support further necessitate that the production system version be the latest.- Infosys-Oracle Blog 2 February 2010 16:36 UTC www.infosysblogs.com [Source type: FILTERED WITH BAYES]
^ Oracle releases mobile database .- Oracle releases mobile database - CNET News 9 January 2010 21:021 UTC news.cnet.com [Source type: General]
^ Create and redesign Oracle database objects.- Oracle Database news and downloads on CNET 31 January 2010 13:46 UTC ces.cnet.com [Source type: General]
.^ MetaLink Integration with Oracle Database 10g .- InformIT: Oracle Database 10g Insider Solutions 9 January 2010 21:021 UTC www.informit.com [Source type: General]
^ Oracle Application Integration Architecture team .- SOA Blogs - Oracle Wiki 31 January 2010 13:46 UTC wiki.oracle.com [Source type: General]
^ Separation of Oracle software files from database files .- InformIT: Planning an Oracle Database > System Architecture 9 January 2010 21:021 UTC www.informit.com [Source type: FILTERED WITH BAYES]
.^ Benefits of Oracle Database 11g by Oracle Corporation .- Oracle Database Mac White Papers, Oracle Database Mac Software, Oracle Database Mac Research, Hardware and Services - KnowledgeStorm 31 January 2010 13:46 UTC www.knowledgestorm.com [Source type: Academic]
^ Partitioning with Oracle Database 11g Release 2 .
^ Database Administrator Oracle 10G .- Oracle database administrator jobs - SQL Authority 9 January 2010 21:021 UTC jobs.sqlauthority.com [Source type: FILTERED WITH BAYES]
(The g stands for "grid"; emphasizing a marketing thrust of presenting 10g as "grid-computing ready".)
- 2005: Oracle Database 10.2.0.1—also known as Oracle Database 10g Release 2 (10gR2)—appeared.
- 2006: Oracle Corporation announces Unbreakable Linux[33]
- 2007: Oracle Database 10g release 2 sets a new world record TPC-H 3000 GB benchmark result[35]
- 2007: Oracle Corporation released Oracle Database 11g for Linux and for Microsoft Windows.
- 2008: Oracle Corporation acquires BEA Systems.
- 2010: Oracle Corporation acquires Sun Microsystems.
Version numbering
.^ Oracle Programmer is a family of the following products: .
^ I have drawn upon the following Oracle 9i Release 2 documentation for the deeper technical details of this article: .- Oracle Database Resource Manager, Part 1:Overview — DatabaseJournal.com 9 January 2010 21:021 UTC www.databasejournal.com [Source type: FILTERED WITH BAYES]
^ To display a list of node names in the cluster, run the following command: CRS_home \bin\olsnodes This issue is tracked with Oracle bug 4523043.- Oracle® Database 9 January 2010 21:021 UTC download.oracle.com [Source type: FILTERED WITH BAYES]
.^ Oracle Applications 11i with Oracle Database 10g .- InformIT: Oracle Database 10g Insider Solutions 9 January 2010 21:021 UTC www.informit.com [Source type: General]
^ Glimpse of Oracle Database 10g Release 2 .- InformIT: Oracle Database 10g Insider Solutions 9 January 2010 21:021 UTC www.informit.com [Source type: General]
^ Please refer to "Oracle Label Security" .- 1 Oracle Database Editions 31 January 2010 13:46 UTC stmain.st.utoledo.edu [Source type: FILTERED WITH BAYES]
Major database-related products and some of their versions include:
Since version 5, Oracle's
RDBMS release numbering has used the following codes:
- Oracle5
- Oracle6
- Oracle7: 7.0.16—7.3.4
- Oracle8 Database: 8.0.3—8.0.6
- Oracle8i Database Release 1: 8.1.5.0—8.1.5.1
- Oracle8i Database Release 2: 8.1.6.0—8.1.6.3
- Oracle8i Database Release 3: 8.1.7.0—8.1.7.4
- Oracle9i Database Release 1: 9.0.1.0—9.0.1.5 (patchset as of December 2003)
- Oracle9i Database Release 2: 9.2.0.1—9.2.0.8 (patchset as of April 2007)
- Oracle Database 10g Release 1: 10.1.0.2—10.1.0.5 (patchset as of February 2006)
- Oracle Database 10g Release 2: 10.2.0.1—10.2.0.4 (patchset as of April 2008)
- Oracle Database 11g Release 1: 11.1.0.6—11.1.0.7 (patchset as of September 2008)
- Oracle Database 11g Release 2: 11.2.0.1 (released 2009-09-01)
.^ This document contains important information that was not included in the platform-specific or product-specific documentation for this release.- Oracle® Database 9 January 2010 21:021 UTC download.oracle.com [Source type: FILTERED WITH BAYES]
^ The default value for the COMPATIBLE parameter is the release number of the most recent major release.- 2 Creating an Oracle Database 9 January 2010 21:021 UTC www.stanford.edu [Source type: Reference]
^ By deploying Oracle we provide specific facilities to allow Forms and Reports applications to co-exist and interoperate with other applications deployed to Oracle Application Server.- Oracle Developers India - Oracle Consulting Service Outsource Oracle Development India Oracle Software Outsourcing India Oracle Database Consultant - Icreon 9 January 2010 21:021 UTC www.icreon.com [Source type: Reference]
.^ Oracle version 10 & 9 databases on Solaris with Data guard, ...
^ The 64 bit versions of Solaris 8, 9, and 10 for SPARC are certified for use with Oracle Database 10g, while the 32 bit versions are not.- Installing and Configuring Oracle Database 10g on the Solaris Platform 9 January 2010 21:021 UTC www.dbspecialists.com [Source type: FILTERED WITH BAYES]
^ Windows Server 2003 64-bit .- Interoperability 2 February 2010 16:36 UTC www.emulex.com [Source type: Reference]
.^ Oracle® Database Administrator's Guide 10 g Release 1 (10.1) Part Number B10739-01 .- 2 Creating an Oracle Database 9 January 2010 21:021 UTC www.stanford.edu [Source type: Reference]
^ Overview Topics: oracle, database, 10g, administration, workshop, 2, release, 2 This course introduces students to the new features in Oracle Database 10g Release 2 - the database for Grid computing.- 10g, Database & Grids Training - Oracle Classes 9 January 2010 21:021 UTC www.exitcertified.com [Source type: Reference]
^ In addition, this guide provides information about compatibility, about upgrading applications to the current release of Oracle, and about important changes in the current release, such as initialization parameter and data dictionary changes.
.^ Automated patching for Oracle database products and the operating system .
^ MacBooks and iMacs use 64-bit Intel Core2 processors and Mac OS X 10.5 (aka Leopard) is 64-bit operating system – so basically there is no major architecture differences between MacBooks / iMacs and Xservers.- How to install Oracle Database 10g on Mac OS X Intel « ray_apps_blog 9 January 2010 21:021 UTC blog.rayapps.com [Source type: FILTERED WITH BAYES]
^ "Oracle 11g has experienced unusually high early adoption rates for a major release, probably due to demand for some of its new features," Olofson wrote.- In Database Market, Oracle Gets Bigger, Others Hang On -- Database -- InformationWeek 9 January 2010 21:021 UTC www.informationweek.com [Source type: News]
List of claimed firsts
Oracle Corporation claims to have provided:
Marketing editions
.^ Under ../product, each version of the Oracle database is installed.- InformIT: Planning an Oracle Database > System Architecture 9 January 2010 21:021 UTC www.informit.com [Source type: FILTERED WITH BAYES]
^ Separation of Oracle software files from database files .- InformIT: Planning an Oracle Database > System Architecture 9 January 2010 21:021 UTC www.informit.com [Source type: FILTERED WITH BAYES]
^ Easily manageable installation and maintenance of different Oracle versions .- InformIT: Planning an Oracle Database > System Architecture 9 January 2010 21:021 UTC www.informit.com [Source type: FILTERED WITH BAYES]
.^ February 28, 2006 Company announces the general release of Oracle Database 10g Express Edition, a free version of its database software.- Oracle Database news on CNET 31 January 2010 13:46 UTC ces.cnet.com [Source type: General]
^ They also introduce a lack of control over physical hardware: neither the end-customer nor Oracle has control of the hardware or the virtualization stack below the OS. This is a new factor in the relationship between Oracle and its customers.- Oracle E-Business Suite Technology 2 February 2010 16:36 UTC blogs.oracle.com [Source type: General]
^ Oracle partitioning was first introduced in Oracle8 and is only available with the Enterprise Edition.- Large Database Features In Oracle 9 January 2010 21:021 UTC www.devshed.com [Source type: FILTERED WITH BAYES]
In approximate order of decreasing scale, we find:
.^ However, the Enterprise Edition is much more expensive than Standard Edition.- Installing and Configuring Oracle Database 10g on the Solaris Platform 9 January 2010 21:021 UTC www.dbspecialists.com [Source type: FILTERED WITH BAYES]
- Installing and Configuring Oracle Database 10g on the Linux Platform 31 January 2010 13:46 UTC www.dbspecialists.com [Source type: General]
^ For now, choose Standard Edition or Enterprise Edition.- Installing and Configuring Oracle Database 10g on the Solaris Platform 9 January 2010 21:021 UTC www.dbspecialists.com [Source type: FILTERED WITH BAYES]
- Installing and Configuring Oracle Database 10g on the Linux Platform 31 January 2010 13:46 UTC www.dbspecialists.com [Source type: General]
^ MySQL enjoys a much larger install-base for two reasons: (1) It’s more flexible and (2) It is required by numerous network-based tools that have become industry standards in their areas.- How will MySQL fare under Oracle? | Linux and Open Source | TechRepublic.com 2 February 2010 16:36 UTC blogs.techrepublic.com.com [Source type: General]
.^ Oracle Database Mobile Server is licensed by CPU. .
^ This product is licensed separately from the Oracle Database products.
^ Oracle Database XE is free for runtime usage with the following limitations: Supports up to 4GB of user data (in addition to Oracle system data) Single instance only of Oracle Database XE on any server Only uses and executes on one processor in any server Can use up to 1GB RAM .- OTN Discussion Forums : Oracle Database 10g Express Edition ... 9 January 2010 21:021 UTC forums.oracle.com [Source type: General]
.^ Oracle Database 11g: RAC Administration .- Database & Grids Training - Oracle Classes 9 January 2010 21:021 UTC www.exitcertified.com [Source type: Reference]
^ Separation of Oracle software files from database files .- InformIT: Planning an Oracle Database > System Architecture 9 January 2010 21:021 UTC www.informit.com [Source type: FILTERED WITH BAYES]
^ Oracle Database 10g: Using OLAP .- Database & Grids Training - Oracle Classes 9 January 2010 21:021 UTC www.exitcertified.com [Source type: Reference]
- 10g, Database & Grids Training - Oracle Classes 9 January 2010 21:021 UTC www.exitcertified.com [Source type: Reference]
.^ Oracle Database Mobile Server is licensed by CPU. .
^ This product is licensed separately from the Oracle Database products.
^ Oracle Database XE is free for runtime usage with the following limitations: Supports up to 4GB of user data (in addition to Oracle system data) Single instance only of Oracle Database XE on any server Only uses and executes on one processor in any server Can use up to 1GB RAM .- OTN Discussion Forums : Oracle Database 10g Express Edition ... 9 January 2010 21:021 UTC forums.oracle.com [Source type: General]
.^ Each user must purchase a Named User Plus license.
^ When Lite Mobile Server is used with Lite Client, customers must purchase at least one CPU license for Lite Mobile Server and a Named User Plus license for each client user.
^ If you wish to use Enterprise User Security in Oracle Database Enterprise Edition, you no longer need to license the Oracle Advanced Security Option for password-based authentication.
.^ The following Oracle Flashback features are not part of Standard Edition or Standard Edition One: Oracle Flashback Table .
^ Oracle Database 10g Express Edition .- OTN Discussion Forums : English 2 February 2010 16:36 UTC forums.oracle.com [Source type: General]
^ Standard Edition – as I don’t need additional features of Enterprise Edition 0.- How to install Oracle Database 10g on Mac OS X Intel « ray_apps_blog 9 January 2010 21:021 UTC blog.rayapps.com [Source type: FILTERED WITH BAYES]
.^ This enables one set of applications to quickly, efficiently, and economically deploy data that may exist in many Oracle and non-Oracle systems to users who can use existing methods to access and update the data.- Accessing SQL Server from Oracle with Database Gateway for ODBC (DG4ODBC) 9 January 2010 21:021 UTC www.easysoft.com [Source type: Reference]
^ Oracle Database XE is free for runtime usage with the following limitations: Supports up to 4GB of user data (in addition to Oracle system data) Single instance only of Oracle Database XE on any server Only uses and executes on one processor in any server Can use up to 1GB RAM .- OTN Discussion Forums : Oracle Database 10g Express Edition ... 9 January 2010 21:021 UTC forums.oracle.com [Source type: General]
^ One of the great strengths of Oracle products is platform portability; our products run with high performance and reliability on many hardware and operating system platforms.- Oracle and Sun - Overview and Frequently Asked Questions (Oracle PartnerNetwork Portugal) 31 January 2010 13:46 UTC blogs.oracle.com [Source type: General]
.^ Database Administrator ( Oracle 10G) .- Oracle database administrator jobs - SQL Authority 9 January 2010 21:021 UTC jobs.sqlauthority.com [Source type: FILTERED WITH BAYES]
^ Oracle Database 10g: Implement Streams .- Database & Grids Training - Oracle Classes 9 January 2010 21:021 UTC www.exitcertified.com [Source type: Reference]
- 10g, Database & Grids Training - Oracle Classes 9 January 2010 21:021 UTC www.exitcertified.com [Source type: Reference]
^ MetaLink Integration with Oracle Database 10g .- InformIT: Oracle Database 10g Insider Solutions 9 January 2010 21:021 UTC www.informit.com [Source type: General]
.^ Oracle’s heterogeneous data sharing solution not only protects your investment in Oracle applications, but also in staff training — there are no new tools for end users to learn how to use or IT staff to support.- Accessing SQL Server from Oracle with Database Gateway for ODBC (DG4ODBC) 9 January 2010 21:021 UTC www.easysoft.com [Source type: Reference]
^ SYSTEM tablespace and the SYSTEM rollback segment creates the data dictionary creates the users SYS and SYSTEM specifies the character set that stores data in the database mounts and opens the database for use .- Creating an Oracle Database 9 January 2010 21:021 UTC www.cs.umbc.edu [Source type: Reference]
^ Think about this: If one used 4 Gb HBAs and you could read at wire speed of 400 MB/s, one would need 185 single port 4 Gbit HBAs.- Oracle Exadata Storage Server and the HP Oracle Database Machine 9 January 2010 21:021 UTC structureddata.org [Source type: General]
.^ How to install Oracle Database… .- How to install Oracle Database 10g on Mac OS X Snow Leopard « ray_apps_blog 31 January 2010 13:46 UTC blog.rayapps.com [Source type: FILTERED WITH BAYES]
^ Install Oracle Database 10 g .- Oracle® Database Quick Installation Guide 9 January 2010 21:021 UTC download-west.oracle.com [Source type: Reference]
- Oracle® Database Quick Installation Guide 9 January 2010 21:021 UTC download.oracle.com [Source type: Reference]
- Oracle® Database Quick Installation Guide 9 January 2010 21:021 UTC download-east.oracle.com [Source type: Reference]
^ Windows Server 2008 supports Oracle Database Lite 10.3.0.2.0 and higher versions.- Oracle® Database 9 January 2010 21:021 UTC download.oracle.com [Source type: FILTERED WITH BAYES]
The
database located on the mobile device can synchronize with a server-based installation.
Host platforms
.^ Copyright © 1996-2001, Oracle Corporation.- Creating an Oracle Database 9 January 2010 21:021 UTC www.cs.uvm.edu [Source type: Reference]
^ Glimpse of Oracle Database 10g Release 2 .- InformIT: Oracle Database 10g Insider Solutions 9 January 2010 21:021 UTC www.informit.com [Source type: General]
^ GRC products and Oracle Database Administration *...- Oracle database administrator jobs - Quick Online Jobs Search 9 January 2010 21:021 UTC jobs.quickonlinetips.com [Source type: FILTERED WITH BAYES]
- Oracle database administrator jobs - SQL Authority 9 January 2010 21:021 UTC jobs.sqlauthority.com [Source type: FILTERED WITH BAYES]
.^ Creation Prerequisites Using an Initial Database Migrating an Older Version of the Database Database creation prepares several operating system files so they can work together as an Oracle database.- Creating an Oracle Database 9 January 2010 21:021 UTC www.cs.umbc.edu [Source type: Reference]
^ Your operating system specific Oracle documentation for details about the default block size.- 2 Creating an Oracle Database 9 January 2010 21:021 UTC www.stanford.edu [Source type: Reference]
^ A SYSAUX tablespace is created, consisting of the operating system file /u01/oracle/oradata/mynewdb/sysaux01.dbf as specified in the SYSAUX DATAFILE clause.- 2 Creating an Oracle Database 9 January 2010 21:021 UTC www.stanford.edu [Source type: Reference]
As of October 2006, Oracle Corporation supported the following operating systems and hardware platforms for Oracle Database 10g[citation needed]:
- Apple Mac OS X Server: PowerPC
- HP HP-UX: PA-RISC, Itanium
- HP Tru64 UNIX: Alpha
- HP OpenVMS: Alpha, Itanium
- IBM AIX5L: IBM POWER
- IBM z/OS: zSeries
- Linux: x86, x86-64, PowerPC, zSeries, Itanium
- Microsoft Windows: x86, x86-64, Itanium
- Sun Solaris: SPARC, x86, x86-64
Related software
Database options
Oracle Corporation refers to some extensions to the core functionality of the Oracle database as "database options".
[46] As of 2008 such options include:
- Accessing SQL Server from Oracle with Database Gateway for ODBC (DG4ODBC) 9 January 2010 21:021 UTC www.easysoft.com [Source type: Reference]
^ Creating a database can also erase information in an existing database and create a new database with the same name and physical structure.- Creating an Oracle Database 9 January 2010 21:021 UTC www.cs.uvm.edu [Source type: Reference]
- Creating an Oracle Database 9 January 2010 21:021 UTC www.cs.umbc.edu [Source type: Reference]
- Creating an Oracle Database 9 January 2010 21:021 UTC www.cs.umbc.edu [Source type: Reference]
^ The Order Entry sample database that is included with Oracle Database uses row-level triggers.- Sybase.com 9 January 2010 21:021 UTC www.sybase.com [Source type: Reference]
Offers optimized solution, with more functionality and better performance than Oracle Generic Connectivity.
Total Recall (optimizes long-term storage of historical data)
Oracle Warehouse Builder (in various forms and sub-options)
-
This list is incomplete; you can help by expanding it.
.^ If you are not licensed to use these options, then you should deinstall them.- Installing and Configuring Oracle Database 10g on the Solaris Platform 9 January 2010 21:021 UTC www.dbspecialists.com [Source type: FILTERED WITH BAYES]
- Installing and Configuring Oracle Database 10g on the Linux Platform 31 January 2010 13:46 UTC www.dbspecialists.com [Source type: General]
^ Although I'm a professional Oracle DBA, I cannot use Oracle for my own personal web applications because my ISP and most others don't offer Oracle as an option.- Oracle to offer free database - CNET News 9 January 2010 21:021 UTC news.cnet.com [Source type: General]
^ If you wish to use Enterprise User Security in Oracle Database Enterprise Edition, you no longer need to license the Oracle Advanced Security Option for password-based authentication.
[49]
Suites
.^ Partitioning with Oracle Database 11g Release 2 .
^ Oracle Database 10g: Implement Streams .- 10g, Database & Grids Training - Oracle Classes 9 January 2010 21:021 UTC www.exitcertified.com [Source type: Reference]
^ Oracle Database 10g: Implementing Database Vault .- 10g, Database & Grids Training - Oracle Classes 9 January 2010 21:021 UTC www.exitcertified.com [Source type: Reference]
For example:
Database "features"
.^ Install the Oracle Database 10 g software on a local file system .- Oracle® Database Quick Installation Guide 9 January 2010 21:021 UTC download-west.oracle.com [Source type: Reference]
- Oracle® Database Quick Installation Guide 9 January 2010 21:021 UTC download.oracle.com [Source type: Reference]
- Oracle® Database Quick Installation Guide 9 January 2010 21:021 UTC download-east.oracle.com [Source type: Reference]
^ Benefits of Oracle Database 11g by Oracle Corporation .- Oracle Database Mac White Papers, Oracle Database Mac Software, Oracle Database Mac Research, Hardware and Services - KnowledgeStorm 31 January 2010 13:46 UTC www.knowledgestorm.com [Source type: Academic]
^ Oracle Database Vault is an option for Oracle Database 10 g .
.^ Oracle 10g Data Guard Overview .- InformIT: Oracle Database 10g Insider Solutions 9 January 2010 21:021 UTC www.informit.com [Source type: General]
^ Overview Topics: oracle, database, 11g, introduction, sql, users In this course students learn new features of SQL and PL/SQL in Oracle Database 11g.- Database & Grids Training - Oracle Classes 9 January 2010 21:021 UTC www.exitcertified.com [Source type: Reference]
^ Oracle version 10 & 9 databases on Solaris with Data guard, ...
Such "features" may include (for example):
.^ Also provides access to recent ADDM findings (license required) and drill-down to performance pages of monitored databases.- Oracle NZ - Francisco Munoz Alvarez 2 February 2010 16:36 UTC oraclenz.com [Source type: FILTERED WITH BAYES]
^ High-Load Databases - Provides a summary of the top 5 databases ordered by the Average Active Sessions performance or load metric.- Oracle NZ - Francisco Munoz Alvarez 2 February 2010 16:36 UTC oraclenz.com [Source type: FILTERED WITH BAYES]
^ Rather than having to immediately merge data from two different database systems, MobiLink can send some data from one database to one group of users and other data to other groups of users.- Sybase.com 9 January 2010 21:021 UTC www.sybase.com [Source type: Reference]
[52]
.^ Oracle Database uses the 'Numeric' data type to identify all numeric data.- Sybase.com 9 January 2010 21:021 UTC www.sybase.com [Source type: Reference]
^ Partitioning with Oracle Database 11g Release 2 .
^ For Oracle Database 10 g Release 1 (10.1), the default value of the COMPATIBLE parameter is 10.0.0.- 2 Creating an Oracle Database 9 January 2010 21:021 UTC www.stanford.edu [Source type: Reference]
[55]
.^ This is a common method of installing Oracle and creating databases in a standardized manner.- InformIT: Planning an Oracle Database > System Architecture 9 January 2010 21:021 UTC www.informit.com [Source type: FILTERED WITH BAYES]
^ Oracle Enterprise Manager Database Control is a Web-based application that you can use to manage a single Oracle database.- Oracle® Database Quick Installation Guide 9 January 2010 21:021 UTC download-west.oracle.com [Source type: Reference]
- Oracle® Database Quick Installation Guide 9 January 2010 21:021 UTC download.oracle.com [Source type: Reference]
- Oracle® Database Quick Installation Guide 31 January 2010 13:46 UTC download-uk.oracle.com [Source type: Reference]
^ I am able to get to SQL> via command line but not via the links.- How to install Oracle Database 10g on Mac OS X Snow Leopard « ray_apps_blog 31 January 2010 13:46 UTC blog.rayapps.com [Source type: FILTERED WITH BAYES]
.^ Then, with the acquisition of Sun, Oracle has control over the underlying technologies of Java and Java EE, plus the primary open-source challenge to their database dominance.
^ Change Control : implemented a system to capture snapshots of database structure information, allowing us to track changes over time.- Database Doctor -- Helping People Run Oracle Databases 9 January 2010 21:021 UTC dbdr.com [Source type: FILTERED WITH BAYES]
^ Advanced iSQL*Plus and SQL*Plus Features in Oracle Database 10g Release 2 .- InformIT: Oracle Database 10g Insider Solutions 9 January 2010 21:021 UTC www.informit.com [Source type: General]
[62]
-
This list is incomplete; you can help by expanding it.
Standalone tools
.^ Describes how to develop applications using Oracle Workflow.
^ PL/SQL can be the application language just like Java or PHP can.- What is the difference between Oracle, SQL and PL/SQL? 2 February 2010 16:36 UTC it.toolbox.com [Source type: General]
^ What is the difference between Oracle, SQL and PL/SQL? .- What is the difference between Oracle, SQL and PL/SQL? 2 February 2010 16:36 UTC it.toolbox.com [Source type: General]
.^ This enables one set of applications to quickly, efficiently, and economically deploy data that may exist in many Oracle and non-Oracle systems to users who can use existing methods to access and update the data.- Accessing SQL Server from Oracle with Database Gateway for ODBC (DG4ODBC) 9 January 2010 21:021 UTC www.easysoft.com [Source type: Reference]
^ In addition, this guide provides information about compatibility, about upgrading applications to the current release of Oracle, and about important changes in the current release, such as initialization parameter and data dictionary changes.
^ Oracle 10g Grid & Real Application Clusters by Mike Ault Discusses: application server instance archive log files Data Guard .- Amazon.com: Oracle Application Server 10g Administration Handbook (Osborne ORACLE Press Series) (9780072229585): John Garmany, Donald K. Burleson: Books 2 February 2010 16:36 UTC www.amazon.com [Source type: General]
.^ Oracle Database 10g: Advanced PL/SQL .- Database & Grids Training - Oracle Classes 9 January 2010 21:021 UTC www.exitcertified.com [Source type: Reference]
^ Runs all scripts required for or used with PL/SQL. .- Creating an Oracle Database 9 January 2010 21:021 UTC www.cs.uvm.edu [Source type: Reference]
^ Oracle Database 10g: Introduction to SQL .- Database & Grids Training - Oracle Classes 9 January 2010 21:021 UTC www.exitcertified.com [Source type: Reference]
It incorporates standard and customized reporting.
Other databases marketed by Oracle Corporation
By acquiring other technology in the database field, Oracle Corporation has taken over:
.^ Push synchronization allows information to be pushed from the central database server to remote databases.- Sybase.com 9 January 2010 21:021 UTC www.sybase.com [Source type: Reference]
^ The new Oracle In-Memory Database Cache option is compatible and integrated with Oracle Database Enterprise Edition, including Oracle Real Application Clusters, and also supports Oracle Enterprise Manager, Oracle SQL Developer, and components of Oracle Fusion Middleware such as Oracle Application Server, Oracle JDeveloper and Oracle TopLink.- Oracle Introduces In-Memory Database Cache Option for Oracle(R) Database Enterprise Edition 31 January 2010 13:46 UTC www2.prnewswire.com [Source type: News]
^ The Oracle In-Memory Database Cache option, which includes the TimesTen In-Memory Database, Replication -- TimesTen to TimesTen, and Cache Connect to Oracle, is priced at $36,000 per processor.- Oracle Introduces In-Memory Database Cache Option for Oracle(R) Database Enterprise Edition 31 January 2010 13:46 UTC www2.prnewswire.com [Source type: News]
It functions as a
real-time infrastructure software product intended for the management of low-
latency, high-volume data, of events and of transactions.
BerkeleyDB, a simple, high-performance, embedded database
Oracle Rdb, a legacy relational database for the OpenVMS operating system
MySQL a relational database purchased as part of its immediate previous owner, Sun Microsystems
Use
.^ Pressing "Install" will do install Oracle on the system.- IBM developerWorks: Wikis - Linux for Power Architecture - Installing Oracle Database 9 January 2010 21:021 UTC www.ibm.com [Source type: FILTERED WITH BAYES]
^ A guide to installing and configuring the Oracle Database Server on a Linux system .- Oracle Database HOWTO 9 January 2010 21:021 UTC www.faqs.org [Source type: Reference]
^ As for Sun's Solaris operating system, Oracle has been focusing on Linux and could now offer better support for Solaris.- Oracle Buys Sun in IBM's Wake - InternetNews.com 2 February 2010 16:36 UTC www.internetnews.com [Source type: News]
. 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.
^ Oracle Corporation has a recommended method of installing and configuring its databases on Unix.- InformIT: Planning an Oracle Database > System Architecture 9 January 2010 21:021 UTC www.informit.com [Source type: FILTERED WITH BAYES]
^ There are several ways to distribute I/O when you install Oracle and create your database.- Creating an Oracle Database 9 January 2010 21:021 UTC www.cs.uvm.edu [Source type: Reference]
^ OFA allows multiple versions of Oracle to be installed on one server.- InformIT: Planning an Oracle Database > System Architecture 9 January 2010 21:021 UTC www.informit.com [Source type: FILTERED WITH BAYES]
[citation needed]
Official support
.^ Oracle’s heterogeneous data sharing solution not only protects your investment in Oracle applications, but also in staff training — there are no new tools for end users to learn how to use or IT staff to support.- Accessing SQL Server from Oracle with Database Gateway for ODBC (DG4ODBC) 9 January 2010 21:021 UTC www.easysoft.com [Source type: Reference]
^ This enables one set of applications to quickly, efficiently, and economically deploy data that may exist in many Oracle and non-Oracle systems to users who can use existing methods to access and update the data.- Accessing SQL Server from Oracle with Database Gateway for ODBC (DG4ODBC) 9 January 2010 21:021 UTC www.easysoft.com [Source type: Reference]
^ Oracle Database SQL Reference for the syntax of the ALTER USER statement used for unlocking user accounts .- 2 Creating an Oracle Database 9 January 2010 21:021 UTC www.stanford.edu [Source type: Reference]
.^ This unique ability provides the user with the advantage of combining the best practices defined for a task, along with user practices, to deliver automated solutions for complex, error-prone manual tasks.
^ I created database through dbca but tnsnames.ora and listener.ora files not get created as its location e.g /Users/oracle/oracle/product/10.2.0/db_a/network/admin.- How to install Oracle Database 10g on Mac OS X Intel « ray_apps_blog 9 January 2010 21:021 UTC blog.rayapps.com [Source type: FILTERED WITH BAYES]
^ Overall, it makes a lot of business sense to continually asses and evaluate the new Rollup patches provided by oracle for application in the production systems and ensure the sustainability of the system.- Infosys-Oracle Blog 2 February 2010 16:36 UTC www.infosysblogs.com [Source type: FILTERED WITH BAYES]
It also integrates with the provision of support tools, patches and upgrades.
.^ Keywords: Oracle command line , Oracle command , Oracle sql command , Oracle batch , Oracle script batch .- Oracle script database downloads at VicMan 31 January 2010 13:46 UTC www.vicman.net [Source type: Reference]
^ Diagnostics Pack features can also be accessed by way of database server APIs and command-line interfaces: .
^ The Diagnostics Pack functionality can be accessed by Enterprise Manager links as well as through the database server command-line APIs.
.^ Automatic data synchronization between the cache and the Oracle database is provided.
^ Oracle database environment.- Oracle database administrator jobs - SQL Authority 9 January 2010 21:021 UTC jobs.sqlauthority.com [Source type: FILTERED WITH BAYES]
^ Oracle provides templates for the following environments: .- Creating an Oracle Database 9 January 2010 21:021 UTC www.cs.uvm.edu [Source type: Reference]
.^ The Installer checks the system to verify that it is configured correctly to run Oracle software.
^ Oracle Universal Installer checks the system to verify that it is configured correctly to run Oracle software.
^ Verify that the Name and Path fields are set to the Oracle home where you just installed Oracle software in the previous steps.- Installing and Configuring Oracle Database 10g on the Linux Platform 31 January 2010 13:46 UTC www.dbspecialists.com [Source type: General]
Database-related guidelines
.^ Installing Oracle Database 10 g Products .- Oracle® Database Quick Installation Guide 9 January 2010 21:021 UTC download-west.oracle.com [Source type: Reference]
- Oracle® Database Quick Installation Guide 9 January 2010 21:021 UTC download.oracle.com [Source type: Reference]
- Oracle® Database Quick Installation Guide 9 January 2010 21:021 UTC download-east.oracle.com [Source type: Reference]
^ Oracle Database 10 g Companion Products .- Oracle® Database Quick Installation Guide 9 January 2010 21:021 UTC download-west.oracle.com [Source type: Reference]
- Oracle® Database Quick Installation Guide 9 January 2010 21:021 UTC download.oracle.com [Source type: Reference]
- Oracle® Database Quick Installation Guide 9 January 2010 21:021 UTC download-east.oracle.com [Source type: Reference]
^ GRC products and Oracle Database Administration *...- Oracle database administrator jobs - Quick Online Jobs Search 9 January 2010 21:021 UTC jobs.quickonlinetips.com [Source type: FILTERED WITH BAYES]
These include:
Oracle Certification Program
.^ Database Administrator ( Oracle 10G) .- Oracle database administrator jobs - SQL Authority 9 January 2010 21:021 UTC jobs.sqlauthority.com [Source type: FILTERED WITH BAYES]
^ Database configurations to include Oracle ...- Oracle database administrator jobs - SQL Authority 9 January 2010 21:021 UTC jobs.sqlauthority.com [Source type: FILTERED WITH BAYES]
^ Oracle Database Administrator to help ...- Oracle database administrator jobs - SQL Authority 9 January 2010 21:021 UTC jobs.sqlauthority.com [Source type: FILTERED WITH BAYES]
It contains three levels:
- Oracle Certified Associate (OCA)
- Oracle Certified Professional (OCP)
- Oracle Certified Master (OCM)
User groups
.^ Prod_1 is an Oracle 7.3.4 production database while dev_2 is an Oracle 8.1.6 development database.- InformIT: Planning an Oracle Database > System Architecture 9 January 2010 21:021 UTC www.informit.com [Source type: FILTERED WITH BAYES]
^ I created database through dbca but tnsnames.ora and listener.ora files not get created as its location e.g /Users/oracle/oracle/product/10.2.0/db_a/network/admin.- How to install Oracle Database 10g on Mac OS X Intel « ray_apps_blog 9 January 2010 21:021 UTC blog.rayapps.com [Source type: FILTERED WITH BAYES]
^ G dba oracle This command creates the oracle user and specifies oinstall as the primary group and dba as the secondary group.
They include:
Market position
Competition
.^ Oracle Database 10g: Introduction to SQL .- Database & Grids Training - Oracle Classes 9 January 2010 21:021 UTC www.exitcertified.com [Source type: Reference]
^ GRC products and Oracle Database Administration *...- Oracle database administrator jobs - Quick Online Jobs Search 9 January 2010 21:021 UTC jobs.quickonlinetips.com [Source type: FILTERED WITH BAYES]
^ Oracle Database 10g: SQL Tuning .- Database & Grids Training - Oracle Classes 9 January 2010 21:021 UTC www.exitcertified.com [Source type: Reference]
.^ Oracle Database Release Notes, 11 g Release 1 (11.1) for Microsoft Windows .- Oracle® Database 9 January 2010 21:021 UTC download.oracle.com [Source type: FILTERED WITH BAYES]
^ This chapter is from the book Oracle DBA on UNIX and Linux .- InformIT: Planning an Oracle Database > System Architecture 9 January 2010 21:021 UTC www.informit.com [Source type: FILTERED WITH BAYES]
^ Windows Server 2008 supports Oracle Database Lite 10.3.0.2.0 and higher versions.- Oracle® Database 9 January 2010 21:021 UTC download.oracle.com [Source type: FILTERED WITH BAYES]
.^ They are not much use to the DBA, but if needed, Oracle Support can analyze them.- InformIT: Planning an Oracle Database > System Architecture 9 January 2010 21:021 UTC www.informit.com [Source type: FILTERED WITH BAYES]
^ For Oracle*Applications, ERP, CRM, and i Support functions create a functional division of the work.- 2 Creating an Oracle Database 9 January 2010 21:021 UTC www.stanford.edu [Source type: Reference]
^ As of May 2006, the supported hardware platforms for Oracle on Linux are as follows: .- Installing and Configuring Oracle Database 10g on the Linux Platform 31 January 2010 13:46 UTC www.dbspecialists.com [Source type: General]
.^ Citing customer demand, Oracle has unveiled a half-size version of the HP Oracle Database Machine, its competitor to high-end data warehousing products such as that sold by Teradata.
^ Software companies aren't always the best at implementing their own software, and some are more expensive than others.- Infosys-Oracle Blog 2 February 2010 16:36 UTC www.infosysblogs.com [Source type: FILTERED WITH BAYES]
^ In part three, I will add auditing to this mix and describe some security best practices, both to protect your data and to meet regulatory requirements.- Oracle | Database Geek Blog 9 January 2010 21:021 UTC database-geek.com [Source type: General]
.^ Open-source Databases Gathering Steam .- Oracle Buys Sun in IBM's Wake - InternetNews.com 2 February 2010 16:36 UTC www.internetnews.com [Source type: News]
^ GRC products and Oracle Database Administration *...- Oracle database administrator jobs - SQL Authority 9 January 2010 21:021 UTC jobs.sqlauthority.com [Source type: FILTERED WITH BAYES]
^ Oracle and MySQL databases on Unix and ...- Oracle database administrator jobs - SQL Authority 9 January 2010 21:021 UTC jobs.sqlauthority.com [Source type: FILTERED WITH BAYES]
.^ Prod_1 is an Oracle 7.3.4 production database while dev_2 is an Oracle 8.1.6 development database.- InformIT: Planning an Oracle Database > System Architecture 9 January 2010 21:021 UTC www.informit.com [Source type: FILTERED WITH BAYES]
^ The combination of Oracle's database technoloy with Sun's MySQL open source database does not pose a threat to competition in the...- Oracle Corp. | Company News & Executive Profiles - ORCL | BNET 2 February 2010 16:36 UTC resources.bnet.com [Source type: FILTERED WITH BAYES]
^ Oracle Database 10 g Products .- Oracle® Database Quick Installation Guide 9 January 2010 21:021 UTC download.oracle.com [Source type: Reference]
.^ Zacks Analyst Blog Highlights: Oracle Corp., SAP AG, Sun Microsystems, International Business...- Oracle Corp. | Company News & Executive Profiles - ORCL | BNET 2 February 2010 16:36 UTC resources.bnet.com [Source type: FILTERED WITH BAYES]
[65]
Pricing
.^ Oracle is not responsible for: (a) the quality of third-party products or services; or (b) fulfilling any of the terms of the agreement with the third party, including delivery of products or services and warranty obligations related to purchased products or services.
^ SQL*Plus: Release 3.3.4.0.0 - Production on Wed Sep 25 18:25:43 2002 Copyright (c) Oracle Corporation 1979, 1996.- Ask Tom "cannot connect to oracle 92 database" 9 January 2010 21:021 UTC asktom.oracle.com [Source type: General]
^ You are welcome to install and evaluate the products included in this media pack for 30 days under the terms of the Trial License Agreement.- Oracle® Database Quick Installation Guide 9 January 2010 21:021 UTC download-west.oracle.com [Source type: Reference]
- Oracle® Database Quick Installation Guide 9 January 2010 21:021 UTC download.oracle.com [Source type: Reference]
- Oracle® Database Quick Installation Guide 9 January 2010 21:021 UTC download-east.oracle.com [Source type: Reference]
It bases the list price for a term-license on a specific percentage of the perpetual license price.
[66]
- Enterprise Edition
- As of March 2006, the database that costs the most per machine-processor among Oracle database editions.
- Standard Edition
- Cheaper: it can run on up to four processors but has fewer features than Enterprise Edition—it lacks proper parallelization,[67] etc; but remains quite suitable for running medium-sized applications.
- Standard ONE
- Sells even more cheaply, but remains limited to two CPUs. Standard Edition ONE sells on a per-seat basis with a five-user minimum. Oracle Corporation usually sells the licenses with an extra 22% cost for support and upgrades (access to MetaLink—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 .^ October 6, 2006 Oracle to offer free database .
- Oracle has yet to prove Linux cred - CNET News 2 February 2010 16:36 UTC news.cnet.com [Source type: General]
^ Enter password: Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production Followup September 26, 2002 - 7am Central time zone: .- Ask Tom "cannot connect to oracle 92 database" 9 January 2010 21:021 UTC asktom.oracle.com [Source type: General]
^ Oracle Secure Backup For environments that consist of many servers, Oracle Secure Backup offers high performance data protection from server to tape.
.^ Setting file permissions as restrictively as possible makes the system more secure, but this makes no sense if permissions are so limiting that the system cannot be used properly.- Installing and Configuring Oracle Database 10g on the Linux Platform 31 January 2010 13:46 UTC www.dbspecialists.com [Source type: General]
^ Typically you use one mount point for the Oracle software and one or more mount points for each database.- Installing and Configuring Oracle Database 10g on the Solaris Platform 9 January 2010 21:021 UTC www.dbspecialists.com [Source type: FILTERED WITH BAYES]
- Installing and Configuring Oracle Database 10g on the Linux Platform 31 January 2010 13:46 UTC www.dbspecialists.com [Source type: General]
^ It is advisable to use more than one of these methods to backup your database.- Oracle database Backup and Recovery FAQ - Oracle FAQ 9 January 2010 21:021 UTC www.orafaq.com [Source type: General]
.^ Oracle Database Quick Installation Guide, 10 g Release 1 (10.1.0.3) for Solaris Operating System (x86) .
^ The operating system that runs Oracle uses a small operating system block size.- Creating an Oracle Database 9 January 2010 21:021 UTC www.cs.uvm.edu [Source type: Reference]
- Creating an Oracle Database 9 January 2010 21:021 UTC www.cs.umbc.edu [Source type: Reference]
^ The operating system that runs Oracle Database uses a small operating system block size.- 2 Creating an Oracle Database 9 January 2010 21:021 UTC www.stanford.edu [Source type: Reference]
.^ (The first time you install Oracle software on the database server there will be two scripts to run as root, while additional installations only require one script to be run as root.- Installing and Configuring Oracle Database 10g on the Linux Platform 31 January 2010 13:46 UTC www.dbspecialists.com [Source type: General]
^ For example, you cannot install Oracle Database 11 g Release 1 (11.1) software into an existing Oracle9 i Oracle home directory.- Oracle® Database 9 January 2010 21:021 UTC download.oracle.com [Source type: FILTERED WITH BAYES]
^ To rectify this problem, run the following command on Red Hat 9 and RHEL 3 and restart dbca : oracle$ export LD_ASSUME_KERNEL=2.4.1 For more information on this issue, see Red Hat 9 .- Installing Oracle 9i on Red Hat Linux (RHEL 4, 3, 2.1, RH 9, 8.0, 7.3, 7.2, 7.1) x86 (Red Hat Enterprise Linux Advanced Server, RHEL AS, Oracle9i Database Installation) 2 February 2010 16:36 UTC www.puschitz.com [Source type: General]
.^ Database Administrator ( Oracle 10G) .- Oracle database administrator jobs - SQL Authority 9 January 2010 21:021 UTC jobs.sqlauthority.com [Source type: FILTERED WITH BAYES]
^ Those are the basics of setting up an OFA database installation.- InformIT: Planning an Oracle Database > System Architecture 9 January 2010 21:021 UTC www.informit.com [Source type: FILTERED WITH BAYES]
^ Oracle Database 11g: RAC Administration .- Database & Grids Training - Oracle Classes 9 January 2010 21:021 UTC www.exitcertified.com [Source type: Reference]
.^ Installing Oracle Database 10 g Products To install Oracle Database 10 g Products, follow these steps: .- Oracle® Database Quick Installation Guide 31 January 2010 13:46 UTC download-uk.oracle.com [Source type: Reference]
^ To install Oracle Database 10 g Products, follow these steps: .- Oracle® Database Quick Installation Guide 9 January 2010 21:021 UTC download-west.oracle.com [Source type: Reference]
- Oracle® Database Quick Installation Guide 9 January 2010 21:021 UTC download.oracle.com [Source type: Reference]
- Oracle® Database Quick Installation Guide 9 January 2010 21:021 UTC download-east.oracle.com [Source type: Reference]
^ Database & Grids Training is certified by Oracle.- Database & Grids Training - Oracle Classes 9 January 2010 21:021 UTC www.exitcertified.com [Source type: Reference]
.^ Database Administrator ( Oracle 10G) .- Oracle database administrator jobs - SQL Authority 9 January 2010 21:021 UTC jobs.sqlauthority.com [Source type: FILTERED WITH BAYES]
^ Oracle Database 11g: RAC Administration .- Database & Grids Training - Oracle Classes 9 January 2010 21:021 UTC www.exitcertified.com [Source type: Reference]
^ Database & Grids Training is certified by Oracle.- Database & Grids Training - Oracle Classes 9 January 2010 21:021 UTC www.exitcertified.com [Source type: Reference]
.^ Database configurations to include Oracle ...- Oracle database administrator jobs - Quick Online Jobs Search 9 January 2010 21:021 UTC jobs.quickonlinetips.com [Source type: FILTERED WITH BAYES]
^ Note that Oracle9i has not been certified on Red Hat 9!- Installing Oracle 9i on Red Hat Linux (RHEL 4, 3, 2.1, RH 9, 8.0, 7.3, 7.2, 7.1) x86 (Red Hat Enterprise Linux Advanced Server, RHEL AS, Oracle9i Database Installation) 2 February 2010 16:36 UTC www.puschitz.com [Source type: General]
^ Related Stories Oracle to offer Red Hat Linux support .- Oracle has yet to prove Linux cred - CNET News 2 February 2010 16:36 UTC news.cnet.com [Source type: General]
.^ How to install Oracle Database… .- How to install Oracle Database 10g on Mac OS X Snow Leopard « ray_apps_blog 31 January 2010 13:46 UTC blog.rayapps.com [Source type: FILTERED WITH BAYES]
^ Install Oracle Database 10 g .- Oracle® Database Quick Installation Guide 9 January 2010 21:021 UTC download-west.oracle.com [Source type: Reference]
- Oracle® Database Quick Installation Guide 9 January 2010 21:021 UTC download.oracle.com [Source type: Reference]
- Oracle® Database Quick Installation Guide 9 January 2010 21:021 UTC download-east.oracle.com [Source type: Reference]
^ Installing Oracle Database 10 g Products .- Oracle® Database Quick Installation Guide 9 January 2010 21:021 UTC download-west.oracle.com [Source type: Reference]
- Oracle® Database Quick Installation Guide 9 January 2010 21:021 UTC download.oracle.com [Source type: Reference]
- Oracle® Database Quick Installation Guide 9 January 2010 21:021 UTC download-east.oracle.com [Source type: Reference]
[69]
See also
References
- ^ "IDC: Oracle Maintains Lead in Database Market". Pcworld.com. 2008-06-27. http://www.pcworld.com/businesscenter/article/147684/idc_oracle_maintains_lead_in_database_market.html. Retrieved 2009-12-19.
- ^ "Welcome to Larryland". Guardian. http://www.guardian.co.uk/g2/story/0,3604,215072,00.html. Retrieved 2009-12-19.
- ^ Bhakthavatsalam, Namrata (August 2008). "Glossary". Oracle Database Client Installation Guide 11g Release 1 (11.1) for AIX Based Systems Part Number B32077-03. Oracle. http://download.oracle.com/docs/cd/B28359_01/install.111/b32077/glossary.htm?type=popup#BABEBJAG. Retrieved 2008-11-17. "The SID automatically defaults to the database name portion of the global database name (sales in the example sales.us.example.com) until you reach eight characters or enter a period. You can accept or change the default value."
- ^ Watkins, Bob (30 January 2007). "Look inside ASM disk groups with Oracle 10gR2's ASMCMD". techrepublic.com. ZDNet. http://articles.techrepublic.com.com/5100-10878_11-6154262.html. Retrieved 2009-07-30. "In 10g, Oracle introduced a new kind of storage for its database product. Automatic Storage Management (ASM) is a logical volume manager that takes physical disk partitions and manages their contents [...] Until ASM, there were only two choices: file system storage and raw disk storage."
- ^ Oracle FAQ
- ^ "Known schemas in Oracle". Adp-gmbh.ch. http://www.adp-gmbh.ch/ora/misc/known_schemas.html. Retrieved 2009-12-19.
- ^ "Optimizer plan stability definition". Adp-gmbh.ch. http://www.adp-gmbh.ch/ora/tuning/cbo/plan_stability.html. Retrieved 2009-12-19.
- ^ "Oracle's sample schemas". Adp-gmbh.ch. http://www.adp-gmbh.ch/ora/misc/sample_schemas.html. Retrieved 2009-12-19.
- ^ "Oracle Architecture, System Global Area". World-class-programme.com. http://www.world-class-programme.com/Oracle-Architecture-2.asp. Retrieved 2009-12-19.
- ^ "Oracle architecture, the library cache section". http://www.world-class-programme.com/Oracle-Architecture-2.asp. Retrieved 2009-12-19.
- ^ "Oracle Architecture, data dictionary cache". World-class-programme.com. http://www.world-class-programme.com/Oracle-Architecture-2.asp. Retrieved 2009-12-19.
- ^ "Oracle architecture, Program Global Area section". World-class-programme.com. http://www.world-class-programme.com/Oracle-Architecture-2.asp. Retrieved 2009-12-19.
- ^ PGA Definition, Oracle Database Master Glossary
- ^ Bell, Mike (2002). "V$ views - don't leave $HOME without them" (PDF). New York Oracle users Group. p. 9-10. http://nyoug.org/Presentations/2002/vviews.PDF. Retrieved 2010-03-09. "X$ tables are fixed tables created in memory at database startup [...] V$ views are created on one or more X$ tables"
- ^ Tony, Morales; et al. (October 2009). "Overview of the Dynamic Performance Views" (PDF). Oracle Database Reference 11g Release 2 (11.2). Oracle Corporation. p. 8-1. http://download.oracle.com/docs/cd/E11882_01/server.112/e10820.pdf. Retrieved 2010-03-09. "V$INDEXED_FIXED_COLUMN displays the columns in dynamic performance tables that are indexed (X$ tables)."
- ^ "Oracle Process architecture concepts". Download.oracle.com. http://download.oracle.com/docs/cd/B28359_01/server.111/b28318/process.htm#i16977. Retrieved 2009-12-19.
- ^ Safaribooksonline.com Niemiec, Richard (25 June 2007) "1.30. New Background Processes in 10g" Oracle Database 10g Performance Tuning: Tips & Techniques Oracle Press p. 967 ISBN 978-0-0722-6305-3 http://my.safaribooksonline.com/9780072263053/new_background_processes_in_10. Retrieved 2009-08-12 "MMON Memory Monitor process is associated with the Automatic Workload Repository new features used for automatic problem detection and self-tuning. MMON writes out the required statistics for AWR on a scheduled basis."
- ^ Safaribooksonline.comNiemiec, Richard (25 June 2007) "1.30. New Background Processes in 10g" Oracle Database 10g Performance Tuning: Tips & Techniques Oracle Press p. 967 ISBN 978-0-0722-6305-3 http://my.safaribooksonline.com/9780072263053/new_background_processes_in_10. Retrieved 2009-08-12 "M000 These are MMON background slave (m000) processes."
- ^ Cyran, Michele; Paul Lane (2005). "Process Architecture". Oracle Database Concepts. Oracle Corporation. http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/process.htm#sthref1481. Retrieved 2008-08-13. "When a user runs an application program (such as a Pro*C program) or an Oracle tool (such as Enterprise Manager or SQL*Plus), Oracle creates a user process to run the user's application."
- ^ Cyran, Michele; Paul Lane (2005). "Process Architecture". Oracle Database Concepts. Oracle Corporation. http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/process.htm#sthref1481. Retrieved 2008-08-13. "A connection is a communication pathway between a user process and an Oracle instance."
- ^ Cyran, Michele; Paul Lane (2005). "Process Architecture". Oracle Database Concepts. Oracle Corporation. http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/process.htm#sthref1481. Retrieved 2008-08-13. "A session is a specific connection of a user to an Oracle instance through a user process"
- ^ Morales, Tony (2008). "V$SESSION". Oracle Database Reference 11g Release 1(11.1). Oracle. http://download.oracle.com/docs/cd/B28359_01/server.111/b28320/dynviews_3016.htm. Retrieved 2008-11-17.
- ^ Chan, Immanuel (July 2008). "Glossary". Oracle Database Performance Tuning Guide 11g Release 1 (11.1). Oracle Corporation. http://download.oracle.com/docs/cd/B28359_01/server.111/b28274/glossary.htm?type=popup#sthref1649. Retrieved 2009-04-29. "enqueue[:] This is another term for a lock."
- ^ "Oracle Database Master Glossary: 11g Release 1 (11.1)". Oracle Corporation. http://download.oracle.com/docs/cd/B28359_01/mix.111/b14388/gloss-l.htm. Retrieved 2009-04-24. "latch[:] A simple, low-level serialization mechanism to protect shared data structures in the System Global Area."
- ^ Strohm, Richard; et al. (October 2008). "Parameter Files". Oracle Database Concepts 11g Release 1 (11.1). Oracle Corporation. http://download.oracle.com/docs/cd/B28359_01/server.111/b28318/intro.htm#sthref23. Retrieved 2009-07-14. "Parameter files contain a list of configuration parameters for that instance and database."
- ^ Strohm, Richard; et al. (October 2008). "Initialization Parameter Files and Server Parameter Files". Oracle Database Concepts 11g Release 1 (11.1). Oracle Corporation. http://download.oracle.com/docs/cd/B28359_01/server.111/b28318/startup.htm#i9633. Retrieved 2009-07-14.
- ^ Morales, Tony; et al. (April 2009). "V$PARAMETER". Oracle Database Reference 11g Release 1 (11.1). Oracle Corporation. http://download.oracle.com/docs/cd/B28359_01/server.111/b28320/dynviews_2.htm#insertedID85. Retrieved 2009-07-14. "V$PARAMETER displays information about the initialization parameters that are currently in effect for the session."
- ^ Morales, Tony; et al. (April 2009). "V$SPPARAMETER". Oracle Database Reference 11g Release 1 (11.1). Oracle Corporation. http://download.oracle.com/docs/cd/B28359_01/server.111/b28320/dynviews_3.htm#insertedID41. Retrieved 2009-07-14. "V$SPPARAMETER displays information about the contents of the server parameter file."
- ^ "Locale Languages". http://download.oracle.com/docs/cd/B19306_01/server.102/b14225/applocaledata.htm#i634428. Retrieved 2008-02-26.
- ^ "Error Message languagues". http://download.oracle.com/docs/cd/B19306_01/server.102/b14225/applocaledata.htm#i634673. Retrieved 2008-02-26.
- ^ Shea, Cathy; et al. (September 2007). "Overview of Globalization Support". Oracle Database Globalization Support Guide 11g Release 1 (11.1). Oracle Corporation. http://download.oracle.com/docs/cd/B28359_01/server.111/b28298/ch1overview.htm#sthref8. Retrieved 2009-02-16. "In the past, Oracle referred to globalization support capabilities as National Language Support (NLS) features. NLS is actually a subset of globalization support. NLS is the ability to choose a national language and store data in a specific character set. Globalization support enables you to develop multilingual applications and software products that can be accessed and run from anywhere in the world simultaneously."
- ^ As Larry Ellison said in an Oracle OpenWorld keynote presentation on 11 November 2007: "Who'd buy a version 1.0 from four guys in California?"
- ^ a b c d e Oracle.com
- ^ Compare Oracle.com
- ^ "Oracle Database 10g Sets New Record for TPC-H Three TB Benchmark". http://www.itmanagement.com/press-releases/oracle-tpc-h-record-060806/. Retrieved 2008-01-31.
- ^ Oracle Database Patch Sets
- ^ a b Greenwald, R., Stackowiak R., & Stern, J. (2001). Oracle Essentials: Oracle9i, Oracle8i & Oracle8 (2nd edition). Cambridge, MA: O'Reilly.
- ^ Oracle.com, but compare Informix's claim to priority: Linuxjournal.com, retrieved 13 February 2008 and that of Polyhedra
- ^ Llewellyn, Bryn (July 2009). "Edition-Based Redefinition" (PDF). Redwood Shores, California: Oracle Corporation. p. 6. http://www.oracle.com/technology/deploy/availability/pdf/edition_based_redefinition.pdf. Retrieved 2010-03-09. "An edition is a [...] nonschema object type, uniquely identified [...] by just its name."
- ^ Enterprise Edition
- ^ Standard Edition
- ^ Standard Edition One
- ^ Express Edition
- ^ "Oracle Data Sheet" (PDF). http://www.oracle.com/technology/products/database/xe/pdf/dbxe_faq.pdf. Retrieved 2009-12-19.
- ^ "Oracle Database Lite 10g". oracle.com. Oracle Corporation. http://www.oracle.com/database/lite_edition.html. Retrieved 2009-06-23. "[...] for developing, deploying and managing applications for mobile and embedded environments."
- ^ Oracle database options
- ^ See download.oracle.com/docs/cd/B28359_01/license.111/b28287/options.htm#CIHBDGAD
- ^ ""Real Application Testing Overview"". Oracle Corporation. August 2007. http://www.oracle.com/technology/products/manageability/database/pdf/wp07/owp_real_application_testing_11g.pdf. Retrieved 2008-05-19.
- ^ See "Term licenses" at http://oraclestore.oracle.com/ for various markets/countries.
- ^ "Oracle Programmer/2000" (PDF). Oracle Corporation. http://www.alise.lv/ALISE/mrktinfo.nsf/6022a43db1063796c22566de00392130/420e0389f8672386c225645e00344ecb/$FILE/Oracle%20Programmer%202000%20data%20sheet%20Feb97.pdf. Retrieved 2009-02-25. "Oracle Programmer/2000 is a suite of programmatic interfaces that allows you to access and manipulate Oracle7 data and schemas. Programmer/2000 provides a rich set of interfaces and supports many programming languages, allowing the programmer to use the programming language and the programming paradigm of choice."
- ^ "Other Ways of Working with Oracle". Oracle Corporation. http://download.oracle.com/docs/cd/A58617_01/server.804/a53717/ch1.htm#index0015. Retrieved 2009-02-25. "Programmer/2000[:] a set of 3GL programming language interfaces"
- ^ Alapati, Sam R. (2005) Expert Oracle database 10g administration Apress p. 845 ISBN 9781590594513 http://books.google.co.nz/books?id=xxx0KAwY_ZMC&pg=PA845&lpg=PA845&dq=ASH++Active+Session+History&source=bl&ots=4DmmvFmU7v&sig=vpOt0kvOidJo-iSC-EJ_kRTyDAI&hl=en&ei=b-EZSo3qBISIkAXKoyk&sa=X&oi=book_result&ct=result&resnum=8#PPA845,M1. Retrieved 2009-05-25 "... ASH records very recent session activity (within the last five or ten minutes)."
- ^ "Oracle Database Workload Performance Measurement and Tuning Toolkit". Issues in Informing Science and Information Technology 3: 371-381. 2006. http://74.125.155.132/scholar?q=cache:uPdNes3VcSAJ:scholar.google.com/. Retrieved 2010-02-05. "Statspack utility consists of a set of Programming Language/Structured Query Language (PL/SQL) scripts, executed against the database, in order to gather, store data and metrics, and generates reports of the database activity".
- ^ "Overview of Oracle Data Pump". Download.oracle.com. http://download.oracle.com/docs/cd/B28359_01/server.111/b28319/dp_overview.htm#SUTIL100. Retrieved 2009-12-19.
- ^ Greenwald, Rick; Robert Stackowiak, Jonathan Stern (November 2007). Oracle Essentials: Oracle Database 11g. O'Reilly. p. 184. ISBN 978-0596514549. "The Database Resource Manager (DRM) was first introduced in Oracle8i [...] to place limits on the amount of computer resources that can be used [...]"
- ^ "Feature Availability by Edition". Oracle Database Licensing Information 11g Release 1 (11.1) Part Number B28287-08. Oracle Corporation. May 2008. http://download.oracle.com/docs/cd/B28359_01/license.111/b28287/editions.htm#CJACGHEB. Retrieved 2008-08-19.
- ^ Nanda, Arup. "Auditing Tells All". Oracle Database 10g: The Top 20 Features for DBAs. Oracle Corporation. http://www.oracle.com/technology/pub/articles/10gdba/week10_10gdba.html. Retrieved 2008-08-19. "...the standard audit (available in all versions) and the fine-grained audit (available in Oracle9i and up ..."
- ^ Oracle.com
- ^ "Oracle Product Accessibility Status: Database Server Enterprise Edition". Oracle Corporation. 2 June 2008. http://www.oracle.com/accessibility/templates/t1286.html. Retrieved 2009-04-14.
- ^ "Oracle Data Provider for .NET". Oracle Corporation. http://www.oracle.com/technology/tech/windows/odpnet/index.html. Retrieved 2009-05-07. "The Oracle Data Provider for .NET (ODP.NET) features optimized ADO.NET data access to the Oracle database."
- ^ "Virtual Private Database" appears listed as a feature available as part of Oracle Enterprise Edition in: Manmeet Ahluwalia; et al. (October 2009). "Feature Availability by Edition". Oracle Database Licensing Information 11g Release 2 (11.2). Oracle Corporation. http://download.oracle.com/docs/cd/E11882_01/license.112/e10594/editions.htm. Retrieved 2010-02-09.
- ^ Kate, Aniket; Menezes, Bernard; Singh, Ashish (December 2005), "Security/Privacy Issues in Providing Database as a Service", Proceedings of 3rd International Conference on E-Governance, ICEG 2005, Lahore: Lahore University of Management Sciences, p. 158-159, http://www.iceg.net/2006/download/E-Governance.pdf, retrieved 2010-02-09, "Oracle's Virtual Private Database (VPD) [...] is a practically implemented model for fine-grained access control wherein one or more security policies are attached to each table and view in the database. These polices are sets of functions coded in PL/SQL, C or Java. A user query that accesses a table or view having a security policy, is dynamically and transparently modified by appending a predicate. This predicate is returned by the policy function for the relation/view and is a function of the user who has fired the query. A secure application context is created for each user at log in."
- ^ "Advanced MetaLink" (PDF). http://www.oracle.com/global/tr/support/051006_ADVANCEDMETALINK_CUSTOMER.pdf. Retrieved 2009-12-19.
- ^ Rea, Stephen (16 September 2008). "Upgrading Oracle 9.2.0.6 to 10.2.0.3 on AIX 5.2". University of Arkansas. http://www.uaex.edu/srea/10gR2_upgrade.txt. Retrieved 2009-08-11. "Run the PreInstall checklist for Oracle 10.2.0 (Metalink Note 250262.1: RDA 4 - Health Check / Validation Engine Guide): The Health Check Validation Engine (HCVE) rule set for Oracle Database 10g R2 (10.2.0) PreInstall (AIX) is described in: Oracle.com"
- ^ About the case in Hungarian
- ^ See the published price list.
- ^ Oracle Database Licensing Information Database Editions
- ^ "Installation centos; official Oracle Wiki". Wiki.oracle.com. http://wiki.oracle.com/page/Installing+Oracle+on+CentOS. Retrieved 2009-12-19.
- ^ "Installation on Debian-based systems; official Oracle Wiki". Wiki.oracle.com. http://wiki.oracle.com/page/Installing+Oracle+on+Debian+%2F+Kubuntu+%2F+Ubuntu. Retrieved 2009-12-19.
Bibliography
.
Wikis
Search
