Игорь Олемской — практические заметки по системному администрированию Linux CentOS

This article is a step by step guide for tuning and optimizing Red Hat Enterprise Linux on x86 and x86-64 platforms running Oracle 9i (32bit/64bit) and Oracle 10g (32bit/64bit) standalone and RAC databases. This guide covers Red Hat Enterprise Linux Advanced Server 3 and 4 and the older version 2.1. For instructions on installing Oracle 9i and 10g databases, see Oracle on Linux. Other Linux articles can be found at www.puschitz.com...

Original news source

A short guide to build RPM of Oracle Instant Client.

Installing the Oracle Instant Client
is probably the simplest solution to get a Oracle server access from a Unix/Linux/Windows/MacOS client. Oracle provides some RPM (usable with Fedora) for some versions and for some architectures. For others versions, only ZIP archives are available on their site.
Personally, official RPM don't suits my need... Lire RPM Oracle Instant Client 11.2

RPM of new version of TOra — Toolkit For Oracle are available in remi repository for Fedora 10 to 14.

The official site also provides RPM for Fedora 12.
To work, you need RPM Oracle Instant Client.
Pour l'installer, comme toujours :
yum --enablerepo=remi install toraThis tool can be used to manage your Oracle, PostgreSQL and MySQL databases. Despite this software is GPLv2, it can't be included in the official repository because of its link with... Lire tora-2.1.3

The output of SQL Plus can be a annoying a little bit. Here are some techniques that show how to enhance the readability of SQL Plus output...

Original news source

RPM of new version of TOra — Toolkit For Oracle are available in remi repository for Fedora ≥ 9.

The official site also provides RPM for Fedora 12.
To work, you need RPM Oracle Instant Client.
Pour l'installer, comme toujours :
yum --enablerepo=remi install toraThis tool can be used to manage your Oracle, PostgreSQL and MySQL databases. Despite this software is GPLv2, it can't be included in the official repository because of its link with... Lire tora-2.1.2

Случайно наткнулся на серию статей, ознакомиться с которыми будет полезно, как сисадминам, так и программистам.

1. Кортежи. Разбор запроса, построение AST, оптимизация AST. Построение плана выполнения
2. Выполнение плана запроса
3. Кэширование планов выполнения запроса
4. Управление оперативной памятью

1. Типы индексов: B-Tree, R-Tree, GiST, Bitmap, Hash, GIN