With Collaborate 2016 under way, there seems no better time to reflect on why PL/SQL is the natural choice for anyone who loves to code, and loves their data
Another video fresh off the press.
If videos aren’t your thing, you can always read the article the video is based on.
The star of this video is Kevin Closson. Kevin’s a really nice guy and has a brain the size of a planet, but you know somewhere in the back of his mind he’s wondering what it would be like to hunt you down, kill you (more...)
First, I am disappointed that Oracle does not go above and beyond to provide SQL scripts to create GoldenGate users for the database.
There are different set of privileges depending on the version of the database:
18.104.22.168 Oracle 22.214.171.124 or Earlier Database Privileges 126.96.36.199 Oracle 188.8.131.52 or Later Database Privileges
PDB is not (more...)
If you are using Proxy accounts to access users, for example as a DBA to do a release to a schema owner, how do you know the login was via proxy instead of directly with the password? This information is handily recorded in the audit, assuming you have audit switched on and use “audit session”.
I would recommend that everyone does this anyway, as it’s a useful tool when troubleshooting connection problems – you can (more...)
As always happens from time to time, we had the following request on AskTom today:
Could you list down 2 reasons why sql server is better than oracle?
Then 2 counter reasons as to why why oracle is better than sql server
And I thought I’d reproduce my response here
I’ll answer it slightly differently…
Q: When is SQL Server better then Oracle ?
A: When you have good, intelligent, knowledgeable SQL Server people (more...)
I mean this in the nicest way, but some of you lot are weird. I’m not aiming this at individuals (though there of plenty of “personalities” amongst you) but at whole damned countries.
One thing about social media is that when you tweet, blog, facebook or whatever – you are potentially communicating beyond your own culture. This is especially true when you are doing so to a community that is spread across the globe in (more...)
I wanted to import a datapump dumpfile to my laptop, and I wondered if I can install Oracle XE to ubuntu guest. I thought it would be easy because I installed Oracle 10g XE to ubuntu for several times, but I saw that Oracle doesn’t provide debian packages for Oracle 11g XE. So I needed to convert the RPM to debian package (and fix incompatibility problems). Therefor, I installed “alien” package and other required tools (more...)
We’ve all encountered a situation when you want to check a simple query or syntax for your SQL and don’t have a database around. Of course, most of us have at least a virtual machine for that, but it takes time to fire it up, and if you work from battery, it can leave you without power pretty quickly. Some time ago, Oracle began to offer a new service called “Oracle Live SQL” . It provides (more...)
It’s that time of year again and the massive undertaking of the Collaborate conference is upon us. This yearly conference, a collaboration between Quest, Oracle Applications User Group, (OAUG) and Independent Oracle User Group, (IOUG) is one of the largest conferences in the world for those that specialize in all areas of the Oracle database.
The conferene is held in different cities, but recently its been sticking (more...)
While at Collaborate on Monday, Oracle has been offered a spot to highlight The Oracle Management Cloud. OMC is a suite of next-generation monitoring and management cloud services designed for heterogeneous environments, all empowered by Oracle’s own cloud! The first three OMC services (Application Performance Monitoring, Log Analytics and IT Analytics) were launched at OpenWorld 2015. Both Log Analytics and IT Analytics contain must-have capabilities (more...)
It’s time to announce the 2nd episode of the Gluent New World webinar series!
The Gluent New World webinar series is about modern data management: architectural trends in enterprise IT and technical fundamentals behind them.
GNW02: SQL-on-Hadoop : A bit of History, Current State-of-the-Art, and Looking towards the Future
- This GNW episode is presented by no other than Mark Rittman, the co-founder & CTO of Rittman Mead and an all-around guru of enterprise BI!
In my earlier post I discussed what Dead Connection Detection is and why you should use it – read more here Oracle TNS-12535 and Dead Connection Detection
The pre-12c implementation of DCD used TNS packages to “ping” the client and relied on the underlying TCP stack which sometimes may take longer. Now in 12c this has changed and DCD probes are implemented by TCP Stack. The DCD probes will now use the TCP KEEPALIVE socket (more...)
Recently we’ve ran into an interesting question from one of our clients. They were seeing messages of the following form in syslog:
"Aug 11 11:56:02 ***** kernel: EXT3-fs warning (device ******): ext3_dx_add_entry: Directory index full!"
I haven’t encountered this before, and did a bit of research. My initial suspicion ended up being correct, and it was due to too many files being created, somewhere in that file system. I had a look around, and (more...)