Oracle Streams. Archive log space management. This feature includes built-in advisories that do the following: Show Shared Pool usage for improving parse time and minimizing CPU usage. Query execution statistics. Access statistics. XML DB. XDK Improvements. Server side debugging. Globalization enhancements. Java improvements. Text improvements. Workspace manager improvements. Enhanced Optimizer Statistics. Materialized view improvements.
Data Compression. Data Mining Enhancements. Inverse group support. VPD Enhancements. DBA grant, revoke.
DBA auditing. ASO enhancements. Oracle Fail Safe improvements. VLM support. Provides automated parallel query optimization based on system utilization. Includes rank, moving average, and ratio-to-report.
Descending indexes. Function-based indexes. Long operations monitor. Materialized views. Optimizer statistics management. Parallel load. Sample scan. This algorithm utilizes B-tree indexes not bitmap indexes. Database Features. Database event triggers. Drop column. Fine-grained access control. Index coalesce. Provides triggers that execute instead of the DML transaction execution.
Locally managed tablespaces. Objects and extensibility. Online index build. Provides password expiration, complexity, and security policy management. Provides mechanism to deploy logic directly in the database.
Plan Stability. Temporary tables. Basic replication. Queries can include tables from multiple databases. Provides multiplexing, multi-protocol connectivity, and network access control. Program Interfaces. Autonomous transactions. COM cartridge NT only. Is the lowest level API interface to the Oracle database. Easily allows C programs to use SQL to access data. System Management. From the Oracle database or cluster database target home page, click the Oracle Database menu, then Provisioning.
From the Oracle cluster database target home page, click the Oracle Database menu, then Provisioning. From the database home page, click on Oracle Database , Configuration. All features, functions, links, buttons, and drill-downs on this menu, excluding Topology, are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.
All features, functions, links, buttons, and drill-downs on this page are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database. When viewing comparison results differences as described in the Configuration Compare feature, select the configuration specification in the tree on the left. Select Enable File Synchronization. From the database home page, click on Schema , Change Management.
All features, unctions, links, buttons, and drill-downs on this menu are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database. From the Enterprise Manager home page, click the Enterprise menu and Compliance. All reports in each of these sections are licensed as part of this pack.
The following compliance views within the repository schema are licensed under Oracle Database Lifecycle Management Pack for Oracle Database:. The following provisioning and patching views within the repository schema are licensed under Oracle Database Lifecycle Management Pack for Oracle Database:.
The following patching views within the repository schema are licensed under Oracle Database Lifecycle Management Pack for Oracle Database:. The following configuration views within the repository schema are licensed under Oracle Database Lifecycle Management Pack for Oracle Database:.
The following Oracle home patching views within the repository schema are licensed under Oracle Database Lifecycle Management Pack for Oracle Database:. The following security views within the repository schema are licensed under Oracle Database Lifecycle Management Pack for Oracle Database:.
The following client configuration views within the repository schema are licensed under Oracle Database Lifecycle Management Pack for Oracle Database:.
Supporting functionality to perform per stream bottleneck detection and per component top wait event analysis. In order to use the features listed above, you must purchase licenses for Oracle Diagnostics Pack. This parameter can be set to one of three values:. To determine which links in Enterprise Manager are part of Oracle Diagnostics Pack, click the Setup link on the top right-hand part of the Enterprise Manager Home page.
When you click the Setup link, the navigation bar contains the Management Pack Access link. Click this link. This will take you to the Management Pack Access page, which allows you to grant and remove access from all the management packs. This procedure disables all the links and tabs associated with Oracle Diagnostics Pack in Enterprise Manager.
All the disabled links and tabs are part of Oracle Diagnostics Pack and therefore require a pack license. Oracle Diagnostics Pack features can also be accessed by way of database server APIs and command-line interfaces:.
They can be used without the Oracle Diagnostics Pack license. This procedure disables all the links and tabs associated with Oracle Tuning Pack in Enterprise Manager. All the disabled links and tabs are part of Oracle Tuning Pack and therefore require a pack license. Oracle Tuning Pack features can also be accessed by way of database server APIs and command-line interfaces:. This script lists, in two distinct sections:. If you are not a My Oracle Support registered user, then click Register and follow the registration instructions.
You can manually run the script on an individual database or use Oracle Enterprise Manager Job System to automatically run the script on multiple databases. The information obtained from this script will provide you an overview of the licensable Oracle Database options and Oracle management packs that were identified as used by your organization.
This is to be used for informational purposes only and this does not represent your license entitlement or requirement. The far sync instance can be installed and used on a server different from the server where the Oracle Database is installed and used. It is not necessary to obtain a separate license for the server running the far sync instance. The GSM listener can be installed and used on a server different from the server where the Oracle Database is installed and used.
It is not necessary to obtain a separate license for the server running the GSM listener. It may not be used or deployed for other uses. Enterprise Edition must be used for the infrastructure repository database s.
Oracle will provide support services for Oracle ACFS only if the server it operates on also operates an Oracle product, which may include Oracle Linux or Oracle Solaris, which is under an Oracle support contract. Oracle Clusterware provides cluster membership and high availability monitoring and failover. Oracle Clusterware may be used to protect any application restarting or failing over the application in the event of a failure on any server, free of charge.
Oracle will provide support for Clusterware only if the server is running an Oracle product that is under a valid Oracle support contract. Oracle Connection Manager can be installed and used on a machine different from the machine where the Oracle Database is installed and used. It is not necessary to obtain a separate license for the machine running Oracle Connection Manager. You can install the broker command line interface DGMGRL and run the observer software on computer systems that are separate from the Oracle Data Guard primary and standby systems.
It is not necessary to obtain a separate license for a system hosting the observer. Oracle Database Backup Cloud Service includes use of the following two features from the Oracle Advanced Security option or the Oracle Advanced Compression option at no additional cost:. To use additional features of the Oracle Advanced Security option or the Oracle Advanced Compression option, you must license those options separately.
If you want to create Oracle Label Security policies, then you must purchase a full-use license for Oracle Label Security. The functionality available on Oracle9 i Database Release 2 is as follows:. Database Replay : Only the Workload Capture feature is supported, and the captured workload may only be replayed only on Oracle Database 11g. This feature can be used only to facilitate upgrades from Oracle 9 i Database Release 2 to Oracle Database 11g or higher.
Database Replay : Only the Workload Capture feature is supported, and the captured workload may be replayed only on Oracle Database 11g. This feature can be used only to facilitate upgrades from Oracle Database 10g Release 2 to Oracle Database 11g. Support for Oracle Secure Backup Express is provided exclusively through a free Oracle Discussion Forum monitored by Oracle employees as well as community experts.
Oracle Secure Backup Express can back up an Oracle database as well as Oracle home files and other file system data requiring tape protection. These Oracle Spatial and Graph components can be installed and used on a server different from the server where the Oracle Database is installed and used without a separate license:. The Oracle database secure external password store feature stores passwords in an Oracle Wallet for password-based authentication to the Oracle database.
The shard directors can be installed and used on a server different from the server where the Oracle Database is installed and used. It is not necessary to obtain a separate license for the server running the shard directors. These data changes can be shared between Oracle databases and other systems, such as filesystems and non-Oracle databases. XStream is licensed via the Oracle GoldenGate product.
Please contact your Oracle sales representative for additional information. Restricted use of Oracle Partitioning is allowed on all offerings, free of charge, for the sole purpose of supporting AQ Sharded Queues. All other uses of Oracle Partitioning require a license for the Oracle Partitioning option, where available. Restricted use licenses for Oracle Advanced Compression and Oracle Advanced Security are granted when performing either of the following migrations:.
These restricted use licenses are in effect only while the migration is being performed and apply solely for the purposes of the migration operation. Oracle Advanced Security includes a restricted use license for the following Oracle Enterprise Manager features:. If you want to use the Oracle Enterprise Manager features listed above not solely for the purposes of Oracle Advanced Security, then you must purchase a full-use license for Oracle Data Masking and Subsetting Pack. These options may be used only to support Oracle Applications Unlimited and may not be used or deployed for any other purpose.
No other objects may be created in this Oracle Database. Oracle Database Mobile Server is a powerful tool for controlling networks of mobile or embedded devices from a centralized management console. It provides a secure, scalable method for connecting applications running locally on mobile or embedded devices to an Oracle enterprise backend. The synchronization system is robust and fault tolerant.
It is able to successfully synchronize over unreliable or intermittently available networks. Oracle Database Mobile Server provides management for applications, users, and devices. On the client device side, it is designed to work with Oracle Berkeley DB as a data store, providing efficient, reliable, and secure data management running locally on mobile and embedded devices.
It is also compatible with SQLite, a widely used open source data store. Oracle Database Vault includes a restricted use license for the following Oracle Enterprise Management features:. If I get time I will generate these and if I catch you accepting questions I will post these. Many Thanks. May 20, - am UTC. CPU time DBA needs to know so they can backup that unrecoverable operation. Should I look at parallel execution? June 29, - pm UTC. Hello tom, I want to know which query is taking lot of resources like cpu utilization, memory etc.
July 06, - am UTC. A reader, July 06, - am UTC. Some sort of benchmark Thanks! Look at the bigger picture. That last one has probably condemned me to a stoning! July 06, - pm UTC. Need Guidance!!!!!!!!!!!!! A reader, August 11, - pm UTC. I did a statspack report in the morning when the problem was there. Is that a bad thing? Also the Top 5 show me enqueue. I understood that, but what are the waits starting with PX. Can you explain them a bit. Also the Buffer Gets and Physical Reads seem normal to me.
There is a huge one but b'coz it lacked an index which I have created. Also any guides as to what should be my approach in identifying the bottleneck and reducing the CPU utilization to acceptable limits. Thanks in advance as always. August 11, - pm UTC. Hi again Tom, I know I must focus on Enqueues more than anything else.
But where do I start from. Any area in the statspack report deserves special attention. Also these blocks started occurring from last night. So that put me in a bit of a worry. Any advise is welcome as always. August 12, - am UTC.
I'd look to a level 12 trace on my most important, criticial application s and work from there. If these locks "just started happening" and never happened before -- it should be simple to correct. Back out whatever you added to your system last night. Sean, November 05, - pm UTC. Hi Tom, We allow analysts to query production db and give some developers more privilege such as "create table as select " to migrate data a few millions rows.
Analysts are supposed to use tuned sql statement and developer are supposed to run "create table as " as a batch job during off peak hour night. Sometimes, end users complained that application is slower than usual. The problems are always like this: 1 Some analysts query million rows table without index. Thanks so much for your help. November 06, - am UTC. Using LIO to find the session which uses a lot of cpu.
Sean, November 06, - pm UTC. It seems that statspack report are not good and fast enough to do this job? November 06, - pm UTC. November 07, - pm UTC. Hi Tom, I am sorry to bother you again. I should have dropped cpu term in my question. But it must be a way to find current running sql which uses a lot of resource, or which slows down the whole application.
Here is scenario: The server is slow, let us find which sql are culprit. You must have something like this. I myself use statspack.
Take a snap, get a cup of coffee, take another snap and generate the report. These are interesting links in the discussion of running at high CPU percentages.
Andrew, You want your system using as much resources as possible. Also bear in mind that for most OLTP applications the server side processing is not the biggest chunk of processing time, you have networking, client processing, crazy waits, You want to burn that beast of hardware to the ground -joking of course : Regards, Zoran.
So simply, how does cpu starvation manifest itself in a trace, or does it? November 20, - am UTC. Hi Tom, I am facing a problem, in our application for a batch job we are seeing a lot of enqueue waits when I turn on the trace level The process in itself is broken down into 8 threads using "business logic", not by the rowid logic you would recommend. These 8 threads are all started at the same time but by the tkprof it appears to me that each of threads is queued and is waiting till the previous one completes, so the overall time is actually a summation of all 8 threads if run serially not parallely as was desired.
The process is a actually a single insert into I ran the selects separately and all the 8 threads complete in 9 minutes. But if all the 8 threads with inserts are run, then it takes more than 60 minutes. A sample tkprof output of the wait events is below, this is for 2nd thread, I have noticed the subsequent threads have more enqueue waits. Wait Total Waited Waited enqueue 3. And at the same time I was observing the waits and the locks, and observed there were a lot of enqueue waits and the exclusive row level locks were been held for the table to which we were inserting data.
The inserted table is partitioned and I have increased the freelists and initrans value to 15 and 8. The only difference in the two environments i. November 22, - pm UTC. More info Insert Scripts We are running 8 of this inserts parallely using different data range we use a splitting logic based on fiscal month key. Unfortunately all of them wait and only 1 runs at a time, and once it completes the next one is spawned. Could you let me know what was the reason for the behaviour seen earlier?
November 23, - pm UTC. Prashant, November 23, - pm UTC. Also the logic for insert is fairly straightforward, divide the data that is been fetched into 8 unique sets by passing a number for the spawned thread and generating either one or max 3 months data which will not overlap with other threads, and each of the threads works on their own data for insert into the target table which is only one.
One of the select tables which is quite huge i. Let me know if this information is not sufficient. November 24, - am UTC. So tell me -- do you run 8 of these inserts concurrently, each of them attempting to do concurrent parallel direct path loads? Concurent Inserts Prashant, November 24, - am UTC. Hi Tom, Thanks for the observations. Thanks Prashant. November 24, - pm UTC. You want the best plan possible for each and every single query in your system.
You are running queries that take seconds. You are not running many queries per second. Getting closer The table was created with a parallel clause default degree. And before we run this query we alter the session. Which parameter is it? Thanks a lot A reader, January 03, - am UTC. PX Deq: Execute Reply 2. Can you please help me on this.. Should i have to redo the gather table stats? Thanks for your time and consideration. January 03, - am UTC. I didnt get you.. I dont want the PQ process..
Did a lot for me in a system which faced a heavy wait events on redo activity. Additional drill down into redo log activity had proved that the problems was too much buffers scaned to find a free redo log buffer to use, on avg. Just a little clarification from above. Thanks Steve. January 20, - am UTC. A call is for example "a stored procedure invoked by a client".
About 7, cpu seconds assuming it got all of the cpu it wanted Now, at 2pm, I take a snapshot. At pm I take another snapshot When I generate the report, I will show at least 7, cpu seconds used - that stored procedure will have "dumped" it's cpu time into my window of observation. Thanks man! But I loved your explanation of how we can get more cpu used seconds than snapshot period!! That's cool. Thanks man. Hi Tom, Say an application is running slow time to time.
Now, how can we decide that the application is written badly or the server needs another CPU added? At which point we can say that, OK.. You have to add another CPU to the server? Thanks in advance. February 03, - am UTC. Maybe this doesn't apply to this thread I wanted to get an idea what are the usefull stats that could be provided to upper management to show them that the DBA's are kicking butt.
They requested some stats from us, but they really don't represent anything as far as we're concerned. Maybe some other DBA's already provide numbers to their upper execs. February 24, - am UTC. I think 42 is the best number of all.
In all seriousness -- report "hours of uninterrupted uptime". If you suffer hardware failure, the time to repair look we lost 50 disks in that water pipe bursting fiasco, you were down for 5 hours -- this is what we did and if we hadn't practiced it times -- it would have taken days.
Upper management has no idea what a soft parse ratio is, a library cache hit, how optimal you've set memory. But they probably cannot because they probably didn't build in any sort of audit trails sigh Those are numbers you cannot report, for you have only the database -- not the end to end transaction information. It matters not that you processed 5 billion sql statements in a day, it only matters that the transaction response time including network and all was more than acceptable.
There are only seconds in 10 minutes! Is this good, bad or indifferent? Users are complaining about slow reponse time Thanks. March 01, - am UTC. But -- how many CPU's do you have Are you running "batch" or long running processes during this period. I have 4 CPUs on the box. System Configuration: Sun Microsystems sun4u Sun Fire System clock frequency: MHz Memory size: Megabytes Batch processes are supposed to be run overnight, but today they "spilled over" into the daytime.
We have a lot of DW-type queries using BI-tools that cannot use bind variables, so not much I can do about that. You would need 18 of the busiest data miners ever to sustain that rate no pauses -- just query query query So, you need to look to the transactional apps, are they present on this system? A reader, March 01, - am UTC. Most of these BI things are long-running queries, not fast and rapid little queries.
Transactional apps -- just a handful. March 01, - pm UTC. Why in some reports, cpu time is showing lager than elapsed time? Can you specify the reasons? March 09, - pm UTC. You timed 50 events. Each event seemed to have taken 2 seconds according to the stop watch. That means you had seconds of time elapsed during these events right? Well, probably not. Suppose each event really took 2. So, when the event started, you would look at the stopwatch and then when the event finished, you would look again and subtract the two numbers.
How so? Well, when the event started, the clock was really at time 2. When the event completed, the stopwatch reported 4 and the real time was 4. Now, over time these discrepancies can accumulate in the aggregate total.
The rule of averages would have them effectively cancel each other out more or less but over time, a small error can creep in. At the lowest level, Oracle is gathering statistics for timing at either the millisecond or microsecond level. In general, this error is not so large as to send you looking down the wrong path, but it can be confusing the first time you see it.
Hi Tom, I was reading this article and the discussion you had with some one about how much cpu one should have in spare. I agree with both of you, however we have to look at the problem in a practical way and not in theoretical way.
More than that is warning threshold for us. I am saying this becuase for those site that run complex env like they have sql servers, sybase, mainframe and then the architecture is open systems where you got middlewares like tuxedo, hrms, payroll, financials and then the company has actually done server consolidation using ibm regatta boxes.
With our experience what we have seen is that in oprn systems architecture we always have had unfortunate incidents. For example, our internet application is using oracle 9ias servers and one day the cpu consumption went high, becuase there was a change in the java code and there was a bug in the oracle application thay we find out after so much of arguments between oracle and microsoft and no to mention the ibm aix, every one seems to point at each other until we havbe a consultant who found out and fix the problem.
Yes the problem was application code but the bottom line is we had enough cpu available to survive that day with less users connected. I think the problem lies in the complexity we are witnessing in it today, lots of different parameters. As systems manager I have done the best in acquiring a machine say with 8 cpus based on the understanding and figures we have from our development for the laod wof say 1 year.
I hope this is inline for this thread. This happens for me with updates and deletes when I compare a 8. The striking thing is that the 9. This happens with simple deletes, simple updates or updates using joins. CTAS seem to be equally fast like normal selects on tables. April 12, - pm UTC. Infact I used runstats you showed it at the seminar in Utrecht. That showed me te large number of library cache latches needed.
CPU used when call star 23, 2, Column 2 is the slow system and 3 is the fast system. April 13, - am UTC. Since you cannot runstat across versions, I don't know what I'm looking at here. Can we see the entire test case you can remove unneeded runstats lines but let me see what you see -- your test. Infact what I do is 1. This happens without any other background activities. When I start this it consumes 1 entire cpu of 4.
I discovered that in a test database the same update takes hsecs in a 32k tablespace but only hsecs in an 8k tablespace created in the same database. I did this a couple of times and this is repeatable. I have ouputs available. April 14, - am UTC. At first I compared a 8. The same job was 5 times faster at 4 times slower cpu. I found out in a test database that if you run the same update in 9. So yes you need a 32k tablespace.
It seems to reproduce on 16k. The results are somewere between the 8k and the 32k tests. One specific test showed 8k : 1 minute 28s 16k: 3 minutes 35s 32k: 7 minutes 20s I have already contacted Oracle Support. Hi Tom, It seems not to be reproducible in 9. Hello Tom, I also asked Harald van Breederode to look at it.
I put it on false and the problem was gone. April 15, - am UTC. That makes total sense, bigger block, infinitely more time consuming to have block checking done. Reader, June 07, - am UTC. Dear Tom, Im not sure if im posting this in the right section, but I hope to see your responce.
I have never done this and tried to search asktom. Is there a way to test the hardware? What is the method used by oracle to come up with number i. XXX transaction per second? Or let me put it in the other way, can I run some sort of SQL query or procedure to test my hardware to get numbers Transaction per second?
My manager wants to know on what level it will distress the hardware and wants to do this by dummy transactions. From the database home page, click on Schema , Change Management.
All features, unctions, links, buttons, and drill-downs on this menu are licensed as part of the Database Lifecycle Management Pack. From the Enterprise Manager home page, click the Enterprise menu and Compliance. All features, functions, links, buttons, and drill-downs associated with the Library, Results and Real-Time Observations pages are licensed as part of the Database Lifecycle Management Pack. All reports in each of these sections are licensed as part of this pack.
The following reporting areas, reports, and sub-reports under Information Publisher Reports are licensed as part of the Database Lifecycle Management Pack:. The following compliance views within the repository schema are licensed under Oracle Database Lifecycle Management Pack for Oracle Database:.
The following provisioning and patching views within the repository schema are licensed under Oracle Database Lifecycle Management Pack for Oracle Database:. The following patching views within the repository schema are licensed under Oracle Database Lifecycle Management Pack for Oracle Database:.
The following configuration views within the repository schema are licensed under Oracle Database Lifecycle Management Pack for Oracle Database:. The following Oracle home patching views within the repository schema are licensed under Oracle Database Lifecycle Management Pack for Oracle Database:. The following security views within the repository schema are licensed under Oracle Database Lifecycle Management Pack for Oracle Database:.
The following client configuration views within the repository schema are licensed under Oracle Database Lifecycle Management Pack for Oracle Database:. Supporting functionality to perform per stream bottleneck detection and per component top wait event analysis. In order to use the features listed above, you must purchase licenses for Oracle Diagnostics Pack. This parameter can be set to one of three values:. To determine which links in Enterprise Manager are part of Oracle Diagnostics Pack, click the Setup link on the top right-hand part of the Enterprise Manager Home page.
When you click the Setup link, the navigation bar contains the Management Pack Access link. Click this link. This will take you to the Management Pack Access page, which allows you to grant and remove access from all the management packs. This procedure disables all the links and tabs associated with Oracle Diagnostics Pack in Enterprise Manager. All the disabled links and tabs are part of Oracle Diagnostics Pack and therefore require a pack license.
Oracle Diagnostics Pack features can also be accessed by way of database server APIs and command-line interfaces:. They can be used without the Oracle Diagnostics Pack license. This procedure disables all the links and tabs associated with Oracle Tuning Pack in Enterprise Manager. All the disabled links and tabs are part of Oracle Tuning Pack and therefore require a pack license. Oracle Tuning Pack features can also be accessed by way of database server APIs and command-line interfaces:.
This script lists, in two distinct sections:. If you are not a My Oracle Support registered user, then click Register and follow the registration instructions.
You can manually run the script on an individual database or use Oracle Enterprise Manager Job System to automatically run the script on multiple databases. The information obtained from this script will provide you an overview of the licensable Oracle Database options and Oracle management packs that were identified as used by your organization. This is to be used for informational purposes only and this does not represent your license entitlement or requirement.
The far sync instance can be installed and used on a server different from the server where the Oracle Database is installed and used. It is not necessary to obtain a separate license for the server running the far sync instance.
The GSM listener can be installed and used on a server different from the server where the Oracle Database is installed and used. It is not necessary to obtain a separate license for the server running the GSM listener. It may not be used or deployed for other uses. Enterprise Edition must be used for the infrastructure repository database s. If Data Guard is used for the infrastructure database, then an Enterprise Edition license for the standby server is required.
Oracle will provide support services for Oracle ACFS only if the server it operates on also operates an Oracle product, which may include Oracle Linux or Oracle Solaris, which is under an Oracle support contract. Oracle Clusterware provides cluster membership and high availability monitoring and failover. Oracle Clusterware may be used to protect any application restarting or failing over the application in the event of a failure on any server, free of charge.
Oracle will provide support for Clusterware only if the server is running an Oracle product that is under a valid Oracle support contract.
Oracle Connection Manager can be installed and used on a machine different from the machine where the Oracle Database is installed and used. It is not necessary to obtain a separate license for the machine running Oracle Connection Manager. You can install the broker command line interface DGMGRL and run the observer software on computer systems that are separate from the Oracle Data Guard primary and standby systems. It is not necessary to obtain a separate license for a system hosting the observer.
To use additional features of the Oracle Advanced Security option or the Oracle Advanced Compression option, you must license those options separately. Oracle Database Express Edition may be used for free, for the purposes of developing, prototyping and running applications. It can also be used for free to provide demonstrations and training.
It may also be distributed for free with any applications. However, any use of the Oracle Database Express Edition is subject to the following limitations:. Express Edition may be installed on a multiple CPU server, but may only be executed on one processor in any server.
Express Edition may be used only to support up to 11 GB of user data not including Express Edition system data. The Oracle technical support organization will not provide technical support, phone support, or updates for Oracle Database Express Edition.
If you want to create Oracle Label Security policies, then you must purchase a full-use license for Oracle Label Security. Refer to Oracle Automatic Storage Management Administrator's Guide for a comprehensive list of all database file types.
No Oracle-maintained copies of any non-database files can exist in any other locations, with the following exceptions:. No other cluster software can be installed on the system, including OCFS, OCFS2, third-party clusterware, third-party cluster volume managers, and third-party cluster file systems.
The functionality available on Oracle9 i Database Release 2 is as follows:. Database Replay : Only the Workload Capture feature is supported, and the captured workload may only be replayed only on Oracle Database 11 g. This feature can be used only to facilitate upgrades from Oracle 9 i Database Release 2 to Oracle Database 11 g or higher. The functionality available on Oracle Database 10 g Release 2 is as follows:. Database Replay : Only the Workload Capture feature is supported, and the captured workload may be replayed only on Oracle Database 11 g.
This feature can be used only to facilitate upgrades from Oracle Database 10 g Release 2 to Oracle Database 11 g. These features can be used only to facilitate upgrades from Oracle9 i Database Release 2 and Oracle Database 10 g Release 1 to Oracle Database 10 g Release 2 or higher. Support for Oracle Secure Backup Express is provided exclusively through a free Oracle Discussion Forum monitored by Oracle employees as well as community experts.
Oracle Secure Backup Express can back up an Oracle database as well as Oracle home files and other file system data requiring tape protection. The Oracle database secure external password store feature stores passwords in an Oracle Wallet for password-based authentication to the Oracle database.
These data changes can be shared between Oracle databases and other systems, such as filesystems and non-Oracle databases. XStream is licensed via the Oracle GoldenGate product.
Please contact your Oracle sales representative for additional information. Restricted use licenses for Oracle Advanced Compression and Oracle Advanced Security are granted when performing either of the following migrations:. These restricted use licenses are in effect only while the migration is being performed and apply solely for the purposes of the migration operation.
Oracle Advanced Security includes a restricted use license for the following Oracle Enterprise Manager features:. If you want to use the Oracle Enterprise Manager features listed above not solely for the purposes of Oracle Advanced Security, then you must purchase a full-use license for Oracle Data Masking and Subsetting Pack. Oracle Database Mobile Server is a powerful tool for controlling networks of mobile or embedded devices from a centralized management console.
It provides a secure, scalable method for connecting applications running locally on mobile or embedded devices to an Oracle enterprise backend. The synchronization system is robust and fault tolerant. It is able to successfully synchronize over unreliable or intermittently available networks. Oracle Database Mobile Server provides management for applications, users, and devices. On the client device side, it is designed to work with Oracle Berkeley DB as a data store, providing efficient, reliable, and secure data management running locally on mobile and embedded devices.
It is also compatible with SQLite, a widely used open source data store. Oracle Database Vault includes a restricted use license for the following Oracle Enterprise Management features:. If you want to use the Oracle Enterprise Management features listed above not solely for the purposes of Oracle Database Vault, then you must purchase a full-use license for Oracle Data Masking and Subsetting Pack. OID may not be used or deployed for other uses. Oracle Label Security includes a restricted use license for the following Oracle Enterprise Manager features:.
If you want to use the Oracle Enterprise Manager features listed above not solely for the purposes of Oracle Label Security, then you must purchase a full-use license for Oracle Data Masking and Subsetting Pack.
Oracle Multitenant. A restricted use license for Oracle Multitenant is included with all editions. This license permits you to use the multitenant architecture with one user-created pluggable database single tenant without licensing the Oracle Multitenant option.
Oracle Programmer provides application programmers with a programmatic interface to any edition of Oracle Database. However, in order to user Oracle Programmer, you must purchase a separate Oracle Programmer license.
Oracle Secure Backup Express is a centralized tape backup management solution that provides data protection for single-server Oracle Database environments. Oracle Secure Backup Express is limited to a single host with one direct-attached tape drive and has some restrictions on advanced feature usage. All other uses of Oracle Partitioning require a license for the Oracle Partitioning option, where available. Commercial software products or components distributed in Oracle Database 12 c Release 1 See Figure Anychart is a flexible Macromedia Flash-based solution that enables developers to create animated, compact, interactive flash charts.
Flash charts are rendered by a browser and require Flash player 8 or later. Flash charts used in interactive reports require Flash Player 9 or later. For more information about Anychart, go to:. Any attempt to unbundle the AnyChart Flash Chart Component from an Oracle product, or to use the AnyChart Flash Chart Component outside of the Oracle product will be in violation of this license and will result in the immediate termination of this license.
Required notices for open source or other separately licensed software products or components distributed in Oracle Database 12 c Release 1 Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met:.
Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer. Neither the name of the author nor the names of its contributors may be used to endorse or promote products derived from this software without specific prior written permission.
Neither the name of the JXLayer project nor the names of its contributors may be used to endorse or promote products derived from this software without specific prior written permission.
These products are licensed under the Apache 2.
0コメント