Sep 20, 2013
given that the launch of Oracle Database 12c, they at Oracle have bought a couple of questions in regards to the new management capabilities built into Oracle enterprise supervisor 12c. here are the answers to some of your more common questions. get pleasure from!
question: How does data masking range from records redaction?
records Redaction, which is a part of Oracle Database 12c advanced safety's product portfolio, offers selective, on-the-fly redaction of sensitive data in query outcomes just before monitor through applications in order that unauthorized clients cannot view the delicate information. It enables consistent redaction of database columns throughout utility modules having access to the same statistics. data Redaction minimizes changes to purposes because it doesn't alter actual facts in internal database buffers, caches, or storage, and it preserves the fashioned facts type and formatting when changed statistics is returned to the application. Whereas data protecting, which is a component of Oracle information overlaying Pack, permits DBAs and testers to "mask" delicate and useful counsel and replace it with useful values for QA and testing functions. This enables production data to be safely used for construction, testing, and outsourced/off-shore partners or different non-construction functions. examine the records Redaction whitepaper and read the Oracle information masking whitepaper.
query: what is EM express?
Oracle business supervisor Database specific, or effortlessly EM specific is embedded internal the database and is auto-configured at the time of installation. With handiest a 20 MB disk footprint, there is no resource utilization when EM specific is not invoked or used. Oracle commercial enterprise supervisor Database express can manage both single example and Oracle actual software Clusters (Oracle RAC) databases. The device additionally has developed-in assist for container databases (CDBs). along with in-depth support for performance administration elements, Oracle enterprise manager Database categorical will also be used for configuration administration, storage management and security administration.
query: Does each pluggable database (PDB) have its own EM express? How do you be certain EM specific is not installed with every 12c database?
sure. that you can setup EM specific for every pluggable database. EM express is installed by default. in case you don't are looking to use it then do not set the XDB http/https port. read the introduction to EM express.
question: How do you utilize EM categorical to monitor pluggable databases?
EM categorical may also be invoked on the root container or inside a PDB. So either a container database administrator (CDBA) or a pluggable database administrator (PDBA) can use EM categorical to video display and manipulate a pluggable database. study the introduction to EM specific.
question: Do you use EM categorical and EM cloud manage at identical time? what is the change?
which you can use both EM express and EM Cloud manage on the equal database. EM categorical is constructed inner the database whereas EM Cloud control makes use of an agent to video display the database. examine the documentation.
question: so as to use EM categorical performance in Oracle Database 12c, do you deserve to have the database packs put in?
although the basic administration facets (configuration, protection, storage administration) are blanketed in EM express, the efficiency administration facets reminiscent of, performance Hub and SQL Tuning guide are licensed one by one by using Oracle Diagnostics Pack and Oracle Tuning Pack.
question: Is EM express obtainable for Oracle Database common edition?
sure. EM categorical is available for Oracle Database 12c usual edition. read extra.
query: can you do metering and chargeback in EM specific?
No. You can't do metering and chargeback in EM specific. Metering and chargeback functionally is constructed into Oracle Cloud administration Pack for Oracle Database and might be used with providing database as a provider (DBaaS). study the offering Database as a service whitepaper for greater particulars.
query: Will EM specific be in a position to manipulate facts defend?
No. There are not any records defend administration capabilities in EM categorical.
question: will they create stories using metric extensions in EM specific?
No. You can not create reports the usage of metric extensions in EM specific.
query: can they use their existing Oracle business manager 11g to computer screen and control Oracle Database 12c?
No. You cannot use Oracle commercial enterprise manager 11g to control Oracle Database 12c. with a purpose to take abilities of the entire new capabilities you're going to need to improve to Oracle enterprise manager 12c (liberate three) and use database plug-in 12.1.0.four.
query: Which previous database types are suitable with Oracle commercial enterprise manager 12c?
Please verify the aid matrix in My Oracle assist because the advice is up to date consistently.
question: Which versions of Oracle Database can also be used with the Consolidated Database Replay characteristic?
that you would be able to use the Consolidated Database Replay on Oracle Database 220.127.116.11.0 and above. Please see My Oracle support be aware 1453789.1.
question: they are the use of each Oracle Database 10g and 11g, they are trying to consolidate onto Oracle Database 12c, what's your recommendation?
We recommend using Oracle real utility checking out to entirely test your consolidation. be taught more about using SQL performance Analyzer to do unit testing of your SQLs' for response time and accept as true with using Consolidated Database Replay to verify your consolidation on Oracle Database 12c for throughput and scalability. that you may seize workload on Oracle Database 10g and 11g and use Consolidated Database Replay on Oracle Database 12c. For more information on upgrading, make certain to visit the Oracle Database 12c upgrade web page on the Oracle expertise community.
question: do they nevertheless need the administration server and agent operating on each container if they improve to Oracle Database 12c?
yes. The structure used with the aid of Oracle business supervisor 12c remains the same and is independent of your upgrade to Oracle Database 12c.
query: When the usage of Oracle commercial enterprise supervisor 12c (now not EM express), is a separate agent still obligatory to video display and compile stats on the cases and hosts?
query: Are there Oracle business manager 12c agents obtainable for Oracle Solaris?
yes. study greater.
query: Is more advantageous actual-time ADDM best for Oracle Database 12c or can you use it for previous models?
more suitable precise-Time ADDM is simply accessible with Oracle Database 12c. study the data sheet.
query: Is ADDM built-in into the database or is it a database choice?
For ADDM you need to license Oracle Diagnostics Pack.
query: a few of their purposes cope with spikes of endeavor as a norm, as an example, they might get a file each 15 minutes after which procedure it. So spikes in their systems are usual. How does the new superior precise-time ADDM work to spot the efficiency spikes?
more suitable true-Time ADDM uses a constructed-in algorithm to detect efficiency spikes. The present state of the database is evaluated towards 9 distinctive criteria (CPU, reminiscence, I/O, and many others.) to determine even if there is a performance problem with your database.
question: what's the change between DBAs, PDBAs, and CDBAs?
The database administrator within the multitenant world has two new roles. The Container Database Administrator (CDBA) is answerable for the total database which holds or carries pluggable databases. The Pluggable Database Administrator (PDBA) is chargeable for individual pluggable databases servicing a particular application. For extra counsel study the Oracle Multitenant whitepaper.
query: To video display batch jobs, where distinctive periods can be created, how is the batch job identified for monitoring?
precise-Time Database Operations monitoring does not’ help multi session yet. although if your batch job makes use of a single session that you would be able to set this job for monitoring via bracketing (i.e. start operation and conclusion operation).
query: For the brand new multitenant structure, how are supplies (i.e. CPU, I/O, memory) handled among pluggable databases? Will there be reminiscence set aside or capped for each PDB? How do you isolate PDBs for one yet another?
that you could allocate CPU resources throughout pluggable databases by means of aid management plans. reminiscence management throughout PDBs is not yet supported. study the documentation.
query: For pluggable databases (PDBs), do you apply database patches to particular PDBs or do you follow the patches to the complete container database?
Database patches may still be utilized to the total container database. examine the Oracle Multitenant whitepaper and watch the Pluggable Lifecycle administration demo for more assistance.