OraFAQ Forum: Server Administration » Whole Database Report !

Home » RDBMS Server » Server Administration » Whole Database Report !

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Whole Database Report ! [message #471970]

Wed, 18 August 2010 01:51

aalmoosa
Messages: 15
Registered: August 2010
Location: bahrain

Junior Member

Hi all,

Is there any script to run or a way in oracle database to get the whole database structure such as (Tablespaces, schemas, datafiles, redo-log files, tables(structure), views....etc) plus the number of daily transactions and operations happens such as (insert, delete, update,...etc)

Generally, a fully detailed report of my database structure, changes in structure and daily DML operations.

Please if anyone can help me with it.

Regards
Al-Moosa

Report message to a moderator

Re: Whole Database Report ! [message #471973 is a reply to message #471970]

Wed, 18 August 2010 01:53

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Statspack/AWR + simple queries on dictionary for physical information + Log Miner for all operations.

Regards
Michel

Report message to a moderator

Re: Whole Database Report ! [message #472037 is a reply to message #471970]

Wed, 18 August 2010 08:45

LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL

Senior Member

Or...
You could install RDA (Remote Diagnostic Agent [Doc id: 314422.1]) and run the report, It gives you a comprehensive snapshot of your database. Then you can complement the info with whatever other data you require.

[Updated on: Wed, 18 August 2010 09:37] by Moderator

Report message to a moderator