.. -*- coding: utf-8; -*-
.. include:: HEADER.rst

==================
 Oracle database.
==================
.. contents::

Oracle database development environment.
========================================

  http://en.wikipedia.org/wiki/Oracle_SQL_Developer
                Integrated development environment (IDE) for working with
                SQL/PLSql in Oracle databases.
  http://en.wikipedia.org/wiki/SQL*Plus
                An Oracle database client that can run SQL and PL/SQL commands
                and display their results.
  http://en.wikipedia.org/wiki/Oracle_Forms
                Is a software product for creating screens that interact with an
                Oracle database. It has an IDE including an object navigator,
                property sheet and code editor that uses PL/SQL.
  http://en.wikipedia.org/wiki/Oracle_JDeveloper
                JDeveloper is a freeware IDE supplied by Oracle Corporation. It
                offers features for development in Java, XML, SQL and PL/SQL,
                HTML, JavaScript, BPEL and PHP.
  http://en.wikipedia.org/wiki/Oracle_Reports
                Oracle Reports is a tool for developing reports against data
                stored in an Oracle database.

Информация о таблицах в БД Oracle.
==================================

Список таблиц::

  select * from user_tables;

Занимаемый размер таблиц и индексов::

  select segment_name, segment_type, sum(bytes) from user_extents
    group by segment_name, segment_type order by sum(bytes);

  select sum(bytes) from user_extents;

Список индексов по таблицам::

  select * from user_indexes order by table_name;

Список размеров индексов по таблицам::

  select index_name, table_name, sum(user_extents.bytes) as bytes from user_indexes
    left outer join user_extents on user_extents.segment_name = table_name
    group by index_name, table_name
    order by table_name;

Список ограничений::

  select * from user_constraints;

Используемое пространство таблиц::

  select distinct tablespace_name from user_tables;