If you’re using AQ, then it’s simple to setup simple enqueue and dequeue facilities on your local database to provide all sorts of asynchronous style processing in your applications. As long as you’re applications are designed and built to handle it, the “fire and forget” model to keep user applications responsive, and all of the “heavy lifting” done in the background is a very attractive one.
You can also use AQ to achieve the (more...)
So more on this cloud stuff then.....
Well in this case the work is just as applicable to a normal on premises configuration with 'standard' Active directory (other types of ldap directory can be used but i guess AD is the most widespread).
In this particular case (a follow up to my post on configuring HA for cloud control in Azure
) i now want to enable single sign on to this cloud control using (more...)
Thanks to all those who attended my session on “Policy Based Cluster Management In Oracle 12c” during Sangam16. I have uploaded my presentation here.
Your comments and feedback are always welcome.
You might be interested in this:
I was troubleshooting backup from standby databases and encountered an oddity which I wanted to verify.
Backing Up Archived Redo Logs with RMAN
Before beginning the backup, RMAN switches out of the current redo log group, and archives all online redo logs that have not yet been archived, up to and including the redo log group that was current when BACKUP command with any of the following clauses:
ARCHIVELOG FROM …
A bizarre one this week....
We upgraded one of our criticial production apps from 22.214.171.124 to 126.96.36.199 (+ latest PSU) and everything went well during the upgrade and seemingly afterwards too, that was until we had reports from the business that some data transfers from another system into this one were often being delayed.
After a bit of investigation we found the data was being pulled over by a (more...)
I’m off to UKOUG again this year. It’s an awesome conference, and I’ll be doing three talks there.
On Monday at 3:30 it’s my first keynote talk “12 Things You’ll Love About the Oracle Database 12.2”, followed up at 6pm by “AskTom – One Year On”.
On Tuesday, at 3:30 I’ll be doing a talk for anyone want to come up to speed on all of the partitioning features with “Partitioning 101”.
A question that has come up while preparing to deliver another Exadata Optimisation Class is whether you can offload queries against Global Temporary Tables (GTT) or not. There are subtle differences between heap tables and GTTs such as how statistics are handled and where they are stored that merit a little investigation.
I have used the lab environment on the X3-2 (Exadata 188.8.131.52.0, 184.108.40.206.160419 RDBMS) to test (more...)
I was at a wedding a few months ago and one of the guests was wearing a pair of bear ears (I think – they might have been raccoon ears, they were not exactly anatomically correct). What made it a little unusual was that the guest was an adult and something like 2 meters tall (6’4″ in real units). So they were rather noticeable. But that was it. No tail, no strange mannerisms, just being (more...)
Adaptive cursor sharing was introduced by Oracle in 11g release 1 as a way to generate best plan for a SQL in all situation. Prior to adaptive cursor sharing, optimizer used to generate a single plan for a SQL statement and that plan is used by all cursors of that SQL_ID. So if we have data skewness in a column and that column is being using in “where” clause of the SQL statement, single plan of that SQL will not (more...)
#DOAG2016, the largest Oracle Community gathering in Europe. Taking place in Nuremberg, at the Nuremberg Convention Center NCC, one of the more impressive places to hold such a conference, towering 4 stories high, with a big central atrium!!
It is a huge effort to get all of this together!
In this blog-post I want to highlight some of the crazy things I experienced this week… And… I did try to follow my own schedule (more...)
So in part1 and part2, we looked at creating tables with clustered data. If you’re ready to climb aboard the attribute clustering heading toward Fastville you might want to take an existing table and cluster it. In part 2 we saw how we had to be extra careful with syntax. The same rule applies with altering a table to cluster it. Lets start with our SOURCE_DATA table which was not (more...)
After about 4 months of preparation and by far the most stressing exam in my professional life, I am extremely happy about the email from Oracle University today saying:
Congratulations! on the successful completion of the Oracle DBA 11g Certified Master practicum.
If the UKOUG Tech16 (and App16 & JDE 16) conference in a short few days.
As well as giving 2 presentations myself, the first about Disaster Recovery, Far Sync and Fast Start Failover and the second about “RAC for beginners”.
I will also be arguing in the DBA v Dev round table at the end of Monday about what I would like to do with most Developers and the best way for me to achieve (more...)
Finally, I was able to configure OEL 7.3 Minimal Install.
OEL 7.3 was a challenge since NAT and Host Only Networking from VirtualBox was not working.
I broke down and ended up using Bridged Adapter.
Next, blogs out there were using Server with GUI installation which is a really bloated option.
Even tried CentOS 7.0 Gnome and did not like having to install UEK or rebuild RPM.
Did it work?
VirtualBox OEL 7.3 (more...)
Oracle Database 12c Release 2 has now been officially released (at least on the Oracle Database Cloud and Oracle Database Exadata Express Cloud Services). In the coming weeks, I’ll be blogging about quite a number of new indexing features/capabilities/improvements that have been introduced in Oracle Database 12c Release 2. These include: Advanced Index Compression Tracking […]
eDB360 provides a lot of insight about an Oracle database. It executes thousands of SQL statements querying GV$ and DBA views from the Oracle’s data dictionary. It was designed to impose very little load on the system where it executes, thus it consumes only one session and avoids parallel execution. On a system where the state of historical metrics is “normal”, eDB360 may take one or two hours to execute. In the other hand, when the (more...)
There are no circumstances where manually changing the passwords for the SYSMAN-named database accounts will end happily. Never attempt to change the passwords for SYSMAN, SYSMAN_APM, SYSMAN_BIPLATFORM, SYSMAN_MDS, SYSMAN_OPSS, or SYSMAN_RO from within the database.
OEM security is managed by the WebLogic admin server. The database passwords are only part of the puzzle. Your WLS relies on wallets and other encrypted files to keep it all straight. When you do the password change in the (more...)
In the previous post, I demonstrated attribute clustering by
- creating a table of source data which contained data in randomised order, via
SQL> create table source_data as
2 select d.*
3 from dba_objects d
4 where object_id is not null
5 order by dbms_random.random;
- and then it loading into a table with attribute clustering defined to cluster the data into the desired order.
The obvious question is then “Why not just cluster the (more...)