:

RSSArticles

Essential Expert Oracle Books You Must Read

Essential Expert Oracle Books You Must Read

Would you consider yourself an Oracle expert? Good, because that means you are serious about your career and that will always reap rewards. My personal belief is that experience trumps certifications. It’s often the case that you learn the most when you absolutely have to. In that sink of swim moment, when your production database is […]

Continue Reading

Oracle 11g

Oracle 11g

In this article I would like to give a high level overview about what the Oracle Relational Database Management System (RDBMS) is; its history, what the Oracle database does, when the Oracle 11g database was released and the kinds of administrative tasks that a database administrator can expect to perform when using an the database. […]

Continue Reading

Create Tablespace Oracle

Create Tablespace Oracle

The Oracle create tablespace statement can be quite complex if you look at it in the Oracle documentation. In this article I would like to try and break down the create tablespace command in to simpler terminology. There are three main types of Oracle tablespace: Normal – CREATE TABLESPACE TEMPORARY – CREATE TEMPORARY TABLESPACE UNDO – […]

Continue Reading

Oracle RMAN – Backup & Recovery

Oracle RMAN – Backup & Recovery

In this article I would like to first go through a quick Q&A and then cover some of the RMAN fundamentals in a little more detail. If you are not already backing up your database, read on and start doing it. Note: I will be making this information as easy to digest as possible. If […]

Continue Reading

Oracle Schema – What is an Oracle Schema? Is it a User?

Oracle Schema – What is an Oracle Schema? Is it a User?

What is an Oracle Schema? In simple terms a schema in an Oracle database is another name for a user. So a schema and a user are the same thing. SCHEMA = USER The purpose of a schema in Oracle is to house database objects. The objects could be physical segments, like tables and indexes, […]

Continue Reading

Kill Oracle Session

There are many reasons why you might want to kill an Oracle database session. Perhaps there are a large number of sessions connected from an application server which is malfunctioning and you want to remove them all. Maybe you want to put the database in to a restricted session state and kill off a load of the […]

Continue Reading

What Should I look for in an Oracle DBA?

How to Spot a good DBA Throughout my time as an Oracle DBA I have seen many DBAs, through working alongside them to interviewing them. I’m not going to list the qualities of a good Oracle DBA in this article, as I have already done so in a previous one called “What qualities make a good […]

Continue Reading

Autoextend

We upgraded our databases from 10g to 11g quite recently. After doing so, and after resolving a few resource manager issues, we thought we had everything covered. Soon thereafter, we started to notice that the tablespaces would automatically extend all datafiles by a substantial amount in one go when a single datafile reached the point at which it […]

Continue Reading

What is REDO?

In this article I hope the summarise in simple terms what the REDO logs are for in your database, how to manage them and why they are so important. There are a lot of topics to cover when discussing REDO logs, but the aim of this article is not to comprehensively detail every nuance of […]

Continue Reading

Create, Alter and Cache Oracle Sequence

What are Sequences in Oracle? A database object which generates numbers Usually used to generate a value for a primary key column You can select the current and next values from them Are not table specific so can be used to generate a primary key value across multiple tables No locking required if simultaneous generation […]

Continue Reading