I am looking for pointers on any tools that might be available to
analyze a set of Oracle databases.  For example, I have recently
inherited a number of databases that appear to have basic and
multimaster replication as well as hot standbys with log shipping

Happy New Year Everybody.
I have a question about local and global indexes in Oracle 8i (8.1.7).
Is there any straightforward way to identify whether or not an Index is
Global or Local via the data dictionary?

As I must run an audit on a DB with 30Tx/sec
(mainly update, insert) I need to know
if the fact to set TIMED_STATISTICS to TRUE
involve an overhead on the database ?

I am getting "unable to extend temp segment" for
INSERT INTO TABLE_A SELECT * FROM TABLE_B.
Both tables are in the same TS MY_DATA with indexes in the same TS
MY_IDX.

I have a strange behaviour in our production database (9.2.0.7). In a
method inside a package a cursor is used to iterate through the dataset.
When the cursor arrives at a certain row, an ORA-01722 invalid number is
thrown.

I am new in this field and would appreciate it if someone points me to
the right direction.
I have a website with lots of users and each have lots of data in
multiple tables. I want to create a search box where a user can search

I frequently want to display query results in SQL*Plus,
but they come out poorly formatted because
the default length of the columns causes excessive wrapping on lines.
I can fix the problem to some extent by:

Is it possible to store persistant data in anything other than a
database or flat files?
birarai

If you're interested in the topic of Oracle database security there's a
couple of posts on Pete Finnigan's site that might interest you.
http://www.petefinnigan.com/weblog/entries/
Happy New Year.