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...)
Somehow missed the announcement that the Oracle Development team refreshed (9/26/2014) the VirtualBox Oracle Database…
Werelds grootste IT conferentie, Oracle OpenWorld/JavaOne conferentie in San Francisco is voorbij. Meerdere Ordina mensen…
A couple of weeks ago I wrote a post about my trip to Oracle OpenWorld 2014 and the surprise announcement of the Oracle FS1 Flash Array. I posted it on the Violin Memory corporate website here:
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. (more...)
When I create virtual machines on my notebook I always create too small disk for root partition or partition where I put Oracle binaries. After a while when I want to perform upgrade, or install another Oracle software, there is not enough space. This time I want to note steps about how to increase disk free space.
I can easily extend or shrink my logical volumes because I am using LVM in my virtual machines. (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 post OCP 12C – SQL Enhancements appeared first on Oracle DBA Scripts and Articles (Montreal).
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...)
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 22.214.171.124.1 is the minimum version required to use write back flash cache. Grid infrastructure and database homes must run 126.96.36.199.9 or later to use with Write-back Smart […]
The post Configure Oracle Exadata Write Back Flash Cache appeared first on VitalSoftTech.
We here at Seilerwerks Industries (not really) have been using snapshot standby databases to refresh an array of unit test databases from a common primary. During the business day, these would be converted to snapshot standby databases for testing, then overnight they are converted back to physical standby and recovered up to the master again.
However we ran into one problem the other week. I noticed that the test3 database was still in physical standby (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...)
A recent question on the OTN forum asked about narrowing down the cause of deadlocks, and this prompted me to set up a little example. Here’s a deadlock graph of a not-quite-standard type:
Resource Name process session holds waits process session holds waits
TX-00040001-000008EC-00000000-00000000 50 249 X 48 9 X
TX-000A001F-000008BC-00000000-00000000 48 9 X 50 249 S
My session (the one that dumped the trace file) is 249, and I was blocked (more...)
Oracle 12c (version 188.8.131.52) offers the option of using in-memory processing to speed things along. Called the In-memory option it’s installed when you install the 184.108.40.206 software. Using it can make a considerable difference in processing speed, provided you have sufficient resources (RAM) available. Let’s revisit an older example, on Bloom filters, and see if Oracle processes things any faster in-memory.
Looking again at the Bloom filter example using (more...)
Online Partition operations Table Partitions and subpartitions can now be moved online. [crayon-5447caf7d0323514534927/] Compression options can also be added during an online partition move. [crayon-5447caf7d034e673459253/] Reference Partitioning Enhancements Truncate or Exchange Partition with Cascade option With Oracle 12c, it is now possible to use the CASCADE option to cascade operations to a child-referenced table when [...]
The post OCP 12C – Partitioning Enhancements appeared first on Oracle DBA Scripts and Articles (Montreal).
So let's be honest at the beginning here.
I have way too many professional certifications for any reasonable semi honest human being. Along with two old Solaris admin certifications 7 and 8 I am ( besides an MBA degree ha ha ) OCP in 7.3 / 8.0 / 8i / 9i / 10g. At one point a ways back I was teaching all the OCP curriculum for a local community college (more...)
Here’s a zip of a script I modified today: zip
Here’s an example output:
QUERY_NUM SQL_ID PLAN_HASH_VALUE EXECUTIONS AVG_ELAPSED OPTIMIZER_COST AVG_FETCHES AVG_SORTS AVG_DISK_READS AVG_BUFFER_GETS AVG_ROWS AVG_CPU AVG_IOWAIT AVG_DIRECT_WRITES AVG_PHYS_READS AVG_PHYS_WRITES
---------- ------------- --------------- ---------- ----------- -------------- ----------- ---------- -------------- --------------- ---------- ---------- ---------- ----------------- -------------- ---------------
1 gxk0cj3qxug85 2051250004 39504258 31630.2852 15 4.71993394 .444248288 4.07294381 440.124393 41.3960784 3447.83137 28056.5262 0 .006406626 0
1 gxk0cj3qxug85 548353012 24360619 (more...)