Most Popular Oracle

About Oracle 12c Cloud Control Credentials

Credentials are the heart of OEM Cloud Control security. When an administrator logs into OEM Cloud Control, they are only allowed to view basic monitoring information that is collected by the Agent. Additional information that is obtained by connecting to the Oracle database instance is done through individual credentials for each user. This allows database […]

Read More

Using Oracle 12c Exalogic Elastic Cloud

You can monitor various aspects of Exalogic Elastic Cloud from OEM Cloud Control 12c. Note that the Exalogic Elastic Cloud is considered a system target, not a group target. Following are the different types of Exalogic Elastic cloud targets you can manage from OEM Cloud Control 12c.   Application deployments WebLogic domains IB switch Coherence […]

Read More

Oracle EM Cloud Control 12c and Change Management

Change management is an important part of lifecycle management. In previous releases of OEM Grid Control this capability was part of the Change Management Pack. This is now part of the Lifecycle Management Pack. Change management allows you to track and report changes that have been made to targets under management of Cloud Control. This […]

Read More

Overview of Oracle VM

In recent years, virtualization has changed the way we look at computing. Instead of using many different computer systems for different tasks, with virtualization, we can use a single system to host many applications. Not only has virtualization increased in popularity, but it has also sparked new hardware CPU innovation, including Intel VT-x and AMD-V […]

Read More

Oracle EM Cloud Control 12c and Compliance Management

Oracle Enterprise Manager Cloud Control Compliance Management has two separate pieces: monitoring of compliance to business best practices and monitoring of real-time configuration changes. Monitoring of compliance to business best practices is a process where the system is regularly analyzed and deviations from compliance to business best practices are reported. This allows for decisions to […]

Read More

Middleware Diagnostics with Oracle 12c Cloud Control

Although there’s no “one size fits all” diagnostic method for all your performance issues, following is the general tuning approach recommended by Oracle to tackle complex middleware application performance problems. 5 Steps recommended by Oracle: 1.   First, rule out all non-middleware infrastructure issues causing the performance problem. 2.   Narrow down the scope of the problem by ascertaining […]

Read More

Oracle EM Cloud Control 12c and Configuration Management

Oracle Enterprise Manager Cloud Control is constantly taking inventory of the configuration of the targets that it is monitoring. This information is saved and available for instant access and comparison. Information is collected on database configuration, host configuration, middleware, storage, and so on. Cloud Control can then be used to search for specific configuration information, […]

Read More

Oracle PL/SQL and VARCHAR2 Memory Allocation

The biggest challenge of explaining efficient ways of using the VARCHAR2 data type is the fact that its table storage implementation is often confused with its PL/SQL implementation. VARCHAR2 is named for the VARiable length of CHARacters, which implies dynamic allocation of storage. This mechanism is usually efficient from the perspective of persistent tables because […]

Read More

Setting up SQL Server 2014 and Oracle 12c Linked Servers

Running multiple SQL Server and Oracle database platforms to support different applications is the norm for many IT organizations today. While in many cases the two different database platforms often operate as independent islands there are also times you might need to integrate the two database platforms to perform lookups, queries and other operations that […]

Read More

About Normalization in Oracle Database Application Design

Relations between countries, or between departments in a company, or between users and developers, are usually the product of particular historical circumstances, which may define current relations even though the circumstances have long since passed. The result of this can be abnormal relations, or, in current parlance, dysfunctional relations. History and circumstance often have the […]

Read More