Sep 20, 2013
considering the launch of Oracle Database 12c, they at Oracle have received a few questions in regards to the new administration capabilities constructed into Oracle business supervisor 12c. listed here are the answers to some of your greater general questions. get pleasure from!
query: How does facts covering differ from statistics redaction?
records Redaction, which is a component of Oracle Database 12c superior security's product portfolio, gives selective, on-the-fly redaction of delicate information in query results ahead of reveal by functions in order that unauthorized users can not view the sensitive information. It allows for constant redaction of database columns throughout application modules getting access to the identical records. facts Redaction minimizes alterations to purposes since it does not alter actual records in internal database buffers, caches, or storage, and it preserves the usual information type and formatting when transformed records is again to the application. Whereas data covering, which is a part of Oracle facts covering Pack, permits DBAs and testers to "mask" delicate and positive tips and exchange it with practical values for QA and trying out applications. This allows creation information to be safely used for building, testing, and outsourced/off-shore partners or other non-construction functions. examine the statistics Redaction whitepaper and read the Oracle information masking whitepaper.
question: what's EM specific?
Oracle business supervisor Database specific, or with ease EM express is embedded inside the database and is auto-configured on the time of installing. With only a 20 MB disk footprint, there isn't any aid utilization when EM express isn't invoked or used. Oracle business supervisor Database express can manipulate each single example and Oracle true utility Clusters (Oracle RAC) databases. The tool also has built-in help for container databases (CDBs). together with in-depth support for performance management elements, Oracle enterprise manager Database express can be used for configuration management, storage administration and protection administration.
query: Does every pluggable database (PDB) have its personal EM categorical? How do you make sure EM specific isn't put in with every 12c database?
sure. which you could setup EM express for every pluggable database. EM specific is installed via default. in case you don't need to use it then don't set the XDB http/https port. study the introduction to EM specific.
query: How do you utilize EM categorical to video display pluggable databases?
EM express can also be invoked on the root container or inside a PDB. So both a container database administrator (CDBA) or a pluggable database administrator (PDBA) can use EM express to video display and manage a pluggable database. study the introduction to EM specific.
question: Do you employ EM categorical and EM cloud manage at identical time? what is the change?
which you could use both EM specific and EM Cloud manage on the same database. EM express is built inner the database whereas EM Cloud manage makes use of an agent to video display the database. read the documentation.
query: with a view to use EM categorical functionality in Oracle Database 12c, do you deserve to have the database packs installed?
youngsters the basic administration aspects (configuration, safety, storage administration) are blanketed in EM categorical, the efficiency administration elements corresponding to, efficiency Hub and SQL Tuning marketing consultant are licensed one by one by way of Oracle Diagnostics Pack and Oracle Tuning Pack.
question: Is EM categorical attainable for Oracle Database average edition?
sure. EM specific is purchasable for Oracle Database 12c standard edition. study greater.
query: can you do metering and chargeback in EM express?
No. You cannot do metering and chargeback in EM categorical. Metering and chargeback functionally is built into Oracle Cloud management Pack for Oracle Database and can be used with delivering database as a provider (DBaaS). study the offering Database as a provider whitepaper for extra particulars.
query: Will EM categorical be capable of manipulate information guard?
No. There aren't any records preserve administration capabilities in EM specific.
question: can they create stories the use of metric extensions in EM categorical?
No. You can not create reviews the use of metric extensions in EM specific.
question: will they use their current Oracle enterprise supervisor 11g to monitor and manipulate Oracle Database 12c?
No. You can not use Oracle enterprise supervisor 11g to control Oracle Database 12c. in an effort to take knowledge of all of the new capabilities you'll should upgrade to Oracle business manager 12c (unlock three) and use database plug-in 126.96.36.199.
question: Which old database versions are suitable with Oracle enterprise supervisor 12c?
Please check the support matrix in My Oracle aid as the advice is up-to-date continuously.
query: Which types of Oracle Database will also be used with the Consolidated Database Replay characteristic?
you can use the Consolidated Database Replay on Oracle Database 188.8.131.52.0 and above. Please see My Oracle assist notice 1453789.1.
query: they are the use of both Oracle Database 10g and 11g, they are trying to consolidate onto Oracle Database 12c, what's your suggestion?
We advocate using Oracle real software checking out to utterly look at various your consolidation. be taught more about using SQL efficiency Analyzer to do unit testing of your SQLs' for response time and accept as true with using Consolidated Database Replay to test your consolidation on Oracle Database 12c for throughput and scalability. that you would be able to catch workload on Oracle Database 10g and 11g and use Consolidated Database Replay on Oracle Database 12c. For more counsel on upgrading, make certain to discuss with the Oracle Database 12c upgrade web page on the Oracle technology network.
query: can they nonetheless need the management server and agent running on every box if they upgrade to Oracle Database 12c?
yes. The architecture used by way of Oracle business manager 12c continues to be the identical and is unbiased of your upgrade to Oracle Database 12c.
question: When the usage of Oracle business supervisor 12c (no longer EM express), is a separate agent still obligatory to computer screen and compile stats on the cases and hosts?
query: Are there Oracle business manager 12c brokers obtainable for Oracle Solaris?
yes. examine greater.
question: Is stronger actual-time ADDM simplest for Oracle Database 12c or can you use it for outdated models?
more desirable precise-Time ADDM is only obtainable with Oracle Database 12c. examine the statistics sheet.
query: Is ADDM built-in into the database or is it a database alternative?
For ADDM you need to license Oracle Diagnostics Pack.
question: a few of their functions deal with spikes of recreation as a norm, for example, we'd get a file every quarter-hour and then method it. So spikes in their methods are normal. How does the brand new stronger true-time ADDM work to spot the efficiency spikes?
better actual-Time ADDM makes use of a developed-in algorithm to observe performance spikes. The current state of the database is evaluated towards 9 distinct criteria (CPU, memory, I/O, etc.) to determine whether there is a performance difficulty with your database.
query: what's the difference between DBAs, PDBAs, and CDBAs?
The database administrator within the multitenant world has two new roles. The Container Database Administrator (CDBA) is chargeable for the whole database which holds or carries pluggable databases. The Pluggable Database Administrator (PDBA) is chargeable for individual pluggable databases servicing a selected utility. For greater counsel examine the Oracle Multitenant whitepaper.
query: To display screen batch jobs, the place varied classes could be created, how is the batch job recognized for monitoring?
actual-Time Database Operations monitoring does not’ guide multi session yet. besides the fact that children if your batch job makes use of a single session you can set this job for monitoring by way of bracketing (i.e. start operation and end operation).
query: For the new multitenant structure, how are supplies (i.e. CPU, I/O, reminiscence) dealt with among pluggable databases? Will there be memory set aside or capped for every PDB? How do you isolate PDBs for one a further?
which you can allocate CPU elements throughout pluggable databases by way of aid administration plans. memory administration across PDBs is not yet supported. read the documentation.
query: For pluggable databases (PDBs), do you apply database patches to specific PDBs or do you apply the patches to the total container database?
Database patches may still be utilized to the whole container database. read the Oracle Multitenant whitepaper and watch the Pluggable Lifecycle management demo for extra assistance.