Tag: Database

DBaaS, (Database as a Service) is a newer EM12c cloud feature that has many DBAs scratching their heads and wondering what it's all about and how it fits in their changing world as we head to the cloud. DBaaS, especially with Database 12c will have DBAs focus less on building databases, but more on managing…

DBaaS, (Database as a Service) is a newer EM12c cloud feature that has many DBAs scratching their heads and wondering what it's all about and how it fits in their changing world as we head to the cloud. DBaaS, especially with Database 12c will have DBAs focus less on building databases, but more on managing…

AWR and ASH are the cornerstone of performance data in the database and used heavily in the new Enteprise Manager 12c. Knowing how to read these reports, when to use the reports and how to step through the reports can be daunting for those new to this valuable performance collection feature in Oracle. This deep-dive…

Join the Oracle Database Security Product team to learn about a new declarative and granular authorization model provided by the Oracle Database 12c Real Application Security (RAS) for Oracle Application Express (APEX). RAS enforces row and column level security based upon the application end user, application roles, and even application-specific privileges. Oracle Database 12c transparently…

Join the Oracle Database Security Product team to learn about a new declarative and granular authorization model provided by the Oracle Database 12c Real Application Security (RAS) for Oracle Application Express (APEX). RAS enforces row and column level security based upon the application end user, application roles, and even application-specific privileges. Oracle Database 12c transparently…

Reviewing execution plans is a common task for most DBAs, SQL developers, and performance experts. Each execution plan details the steps and operators necessary to execute a SQL statement. A solid understanding the operators and their order of execution makes a big difference in deciding the best execution plan - and ultimately how it effects…

This session presents a customer use case for low overhead virtualization of Oracle Database 11gR2 on Oracle SuperCluster using Oracle Solaris Zones . It includes a general overview of the technology, a specific use case, and best practices, followed by discussion and Q&A. The use case profiles an actual customer implementation of database zones on…

Learn how you can use Oracle 12c Multitenant Database? How will it help you ease in management of your database and reduce complexity and cost the to manage you databases. Get a jump start on how to manage Oracle Container and Plugin databases. Learn how to connect to CDB's and PDBS's, shutdown and restart them…

Do Japanese, Chinese, Russian, or Arabic characters not display correctly when stored in your Oracle database? If so, it’s time to migrate your database to Unicode. Database migrations to support storage of international, multi-byte characters can be a daunting task. Oracle’s free Database Migration Assistant for Unicode (DMU) tool can make the work a lot…

When Performance problem is reported by database users, DBA’s tend to rely just in what they are reporting, but this is just what users are feeling not what is really happening inside the Database. Are users telling me truth? I asked myself every time while analyzing Database performance problems, knowing that users feel the overall…