Using JVM Diagnostics (JVMD) to help tune production JVMs
By Shiraz Kanga-Oracle
Yesterday was the first meeting of the newly restarted Arizona Oracle User Group, AZORA. It was a good first meeting to kick off what I hope will turn into an active club.
We met in the Tempe Public Library in a large downstairs room with a projector screen and plenty of seating with tables so it was easy to take notes. We also had snacks. I got a Paradise Bakery chocolate chip (more...)
Use Resource Manager for a CDB and a PDB Managing Resources between PDBs The Resource Manager uses Shares ans Utilization limit to manage resources allocated to PDBs. The more “Shares” you allocate to a PDB, the more resource it will have. Shares are allocated through DBMS_RESOURCE_MANAGER.CREATE_CDB_PLAN_DIRECTIVE. One directive can only concern one PDB and you can’t [...]
The post OCP 12C – Resource Manager and Performance Enhancements appeared first on Oracle DBA Scripts and (more...)
I just wanted to write something as a follow up to my recent and provocatively titled Oracle ACE = Oracle’s Bitch? post. Obviously, that subject has been preying on my mind a little… I said before, it is hard to be objective about yourself, so maybe some aspects of the “being an Oracle ACE changes you” debate may be true. It would be wrong of me to deny that outright, but I think there are some (more...)
Follow the link to find out whether I thought it was the most amazing product in the history of storage, or simply a rehashed Pillar Axiom hybrid array with some SSDs and a ton of marketing.
I can easily extend or shrink my logical volumes because I am using LVM in my virtual machines. (more...)
I’ve spent the last couple of evenings playing with the new SQL pattern matching feature in Oracle 12c.
I’m doing some sessions on analytic functions in some upcoming conferences and I thought I should look at this stuff. I’m not really going to include much, if anything, about it as my sessions are focussed on beginners and I don’t really want to scare people off. (more...)
Extended Character Data Type Columns In this release Oracle changed the maximum sixe of three data types In Oracle 12c if you set a VARCHAR2 to 4000 bytes or less it is stored inline, if you set it to more than 4000 bytes then it is transformed in extended character data type and stored out [...]
The aim of this post is not to explain how the APPROX_COUNT_DISTINCT function works (you find basic information in the documentation and in this post written by Luca Canali), but to show you the results of a test case I run to assess how well it works.
Here’s what I did…
I created a table with several numerical columns (the name of the column shows how many distinct values it contains), loaded 100 million (more...)
- Enterprise Manager Base Platform - Grid Control (OMS) 10.2.0.5.10 PSU.
- Enterprise Manager Base Platform - Grid Control (OMS) 126.96.36.199.11 PSU.
- Enterprise Manager Base Platform - Cloud Control (OMS) 188.8.131.52.1 PSU.
In addition to improving read I/Os, Oracle Exadata Write back flash cache also provides the ability to cache write I/Os directly to PCI flash. Exadata storage software version 184.108.40.206.1 is the minimum version required to use write back flash cache. Grid infrastructure and database homes must run 220.127.116.11.9 or later to use with Write-back Smart […]
However we ran into one problem the other week. I noticed that the test3 database was still in physical standby (more...)
I got a comment today on my recent Oracle fanboy post, which I thought was very interesting and worthy of a blog post in reply. The commenter started by criticising the Oracle license and support costs (we’ve all had that complaint) as well as the quality of support (yes, I’ve been there too), but that wasn’t the thing that stood out. The final paragraph was as follows…
“One addition. I know you, your past work (more...)
Fellow Phoenicians (citizens of the Phoenix, Arizona area):
This is a reminder that tomorrow is the first meeting of the newly reborn (risen from the ashes) Arizona Oracle User Group. Here are the meeting details: url
I hope to meet some of my fellow Phoenix area DBAs tomorrow afternoon.
Oracle DataPump Enhancements Full Transportable Export and Import of Data In Oracle 12c you now have the possibility to create full transportable exports and imports. A full transportable export contains all objects and data needed to create a copy of the database. To create a fully transportable export of your database you need to specify [...]
The post OCP 12C – DataPump, SQL*Loader, External Tables Enhancements appeared first on Oracle DBA Scripts and Articles (more...)