Welcome to Datavail’s Blog, where you can read the latest insights, tips and opinions of our experts on all things data and technology.
In our Remote DBA practice, we frequently perform comprehensive system reviews for our customers on their database services.
On Tuesday, Amazon announced availability of an Oracle version of their Relational Database Service (RDS). RDS is one of Amazon’s cloud services.
Here’s a revised version of an old popular article I wrote over ten years ago. I wrote this when I was at Amazon.com, long before I came to work at remote DBA provider Blue Gecko. Enjoy! Oracle’s pre-RMAN hot backup mode is the subject of one of the most pervasive and persistent misconceptions about Oracle.
Before launching into this, I must give due deference to Mogens Nørgaard’s landmark article, You Probably Don’t Need RAC (YPDNR), available here, but originally published Q3 2003 in IOUG Select Journal.
As information technology professionals, we constantly complain about mismanaged projects in which we have the misfortune to be involved.
Oracle serializes transactions and manages concurrency and recovery using an ever-increasing number called a system change number, or SCN.
Ora-00054 fix! Learn how to resolve Oracle errors, including this truncate error: ORA-00054: Resource Busy and Acquire With NOWAIT Specified.
Most people will encounter this error when their application tries to connect to an Oracle database service, but it can also be raised by one database instance trying to connect to another database service via a database link.