|
Oracle database management, tutorials, scripts, coding, programming and tips for database administrators
07/10/2014
The next big thing after Exadata is the new Oracle 12c Database In-memory feature, which will dramatically improve database performance for analytical queries and OLTP without application re-coding.
06/30/2014
When performance suffers it's likely the DBA who gets the blame, but it may not be the database that's at fault. Read on to see what other factors can affect performance and how to identify what is causing the slowdown.
06/12/2014
Chained and migrated rows in an Oracle database can adversely affect I/O performance, especially Exadata. Read on to discover how these rows are generated and what you may be able to do to correct the situation.
05/27/2014
How do you ensure that the DBA doesn't, or can't, drop a table accidentally? Oracle has at least two ways to ensure that a table cannot be accidentally dropped but there are some limitations to those methods. David Fitzjarrell looks at those methods to see which one works for the DBA account.
05/08/2014
Some business decisions may need to be redone, like making a non-unique primary key index unique. In Oracle 12c it's a simple task, but in Oracle 11.2. and earlier it's a bit more involved but still possible. Read on to see how this can be done.
04/28/2014
Your developer has deleted a ton of data to help you free up space in the OS. Right? Wrong. Find out how to get all that free space in a table reflected all the way out to the operating system.
04/10/2014
With a product as complex as Oracle some bugs are bound to be present. Some of these bugs are show-stoppers, and others aren't, but it does teach you to pay careful attention to the results a query delivers. Even though queries are syntactically and logically correct you can't be certain that Oracle won't do something 'behind the scenes' that can produce the wrong answer.
03/31/2014
Do you really need an RMAN catalog to successfully recover your Oracle database? There are those that think so -- but they would be wrong. Read on to find out what you need to recover your database without a catalog.
03/13/2014
In Release 11.2, Oracle has provided three improvements to earlier attempts at controlling parallel execution. These improvements make this feature more manageable, more scalable, and less likely to saturate server resources, such as memory and CPU, than earlier releases of the database. David Fitzjarrell discusses the first of those improvements, parallel statement queuing.
02/24/2014
For many of us, setting up an Oracle standby database has become fairly old hat. Just remember, keep everything on the standby server exactly the same as the primary, and everything will go fine. But what if you want your standby on the same server as the primary database? And why on earth would you want to do that anyway? Isn’t the point Disaster Recovery?
02/10/2014
New index access paths in Oracle 11g and later releases can use existing multi-column indexes even when the column you're looking for isn't the leading column. Read on to see how Oracle accomplishes this feat.
01/27/2014
Using RMAN to clone a database is old hat to a lot of folks. But for some, it can be a daunting task. Here's a refresher on cloning using RMAN.
01/09/2014
Collections can be a real timesaver for bulk processing of data; they may not be applicable in every situation but when the conditions are right they can make your job so much easier.
12/30/2013
Autoextensible files have been around for quite awhile. Why do people shy away from them? Learn how to effectively allocate space and monitor your Oracle tablespaces by taking advantage of autoextensible files.
12/09/2013
A new role has emerged relative to Oracle Exadata, that of the Database Machine Administrator, or DMA. Read on to learn what being a DMA really means.
Oracle Archives
|
