Big bdb files in a RAC

This post applies only for the 11.2.0.4 database version in RAC mode (Real Application Cluster), I don’t have any reference about this problem in other versions; if you have another version, you must test the solution before in an non-production environment and/or research in My Oracle Support.

The problem is that there are some files with bdb extension with a big size based on a bug of the database version, between these files, there is a special one called crfclust.bdb with a really big size.

Here you’ll find how to solve this little problem. Read more of this post

Advertisements

More than one foreign key between two tables?

This simple post was created based in a question from a friend who doesn’t know very well this Oracle’s characteristic. Can exist more than one foreign key between two tables?, here I show the answer with an example: Read more of this post

Installing and running SQL Developer on Ubuntu

In this post, I’ll show you how to install the SQL Developer on Ubuntu and how to run it; because there is a problem when you try to start the program, here I’ll show you how to avoid this error  too. Read more of this post

Changing the AUD$ table to another tablespace

Naturally, after an Oracle database installation, the AUD$ table stores the auditing activities and its the base for the DBA_AUDIT_TRAIL view, it’s placed in the SYSTEM tablespace.

According the audited quantity of actions and the quantity of users in the database, the AUD$ table can require too much tablespace space. And since the SYSTEM tablespace is very important for the Oracle database, that AUD$ growing can generate serious problems.

Here, I show you how to change the AUD$ table to a different tablespace. Read more of this post

Records concatenation

In this post I’ll show you how to concatenate records like columns, without any program, just a simple query. Read more of this post

Installing examples and HR schema

When you install the RDBMS, if you choose to create the database, you can choose the installation of the Oracle examples.

Here I’ll show you how to install the Oracle examples if you choose to install just the RDBMS without any database.

In these examples, there is a set of scripts to configure the HR schema with some objects to be used in any SQL or PL/SQL tests.

This is valid for the 11g version, the most mature right now. However, you must consider that there is the 12c version and will be more versions later. Read more of this post

Test values for RAW and BLOB columns

In this post, you will find an easy and quick way to insert test data in a RAW or BLOB column, without using the Oracle’s DBMS_LOB package for real file loading. Read more of this post

%d bloggers like this: