What are the various reports taken by oracle dba
jeevan mathewdbaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DavidSenior Oracle Database AdministratorCommented:
Jeevan, say more.  There are thousands of views one can query.  Also the popular GUI tools such as TOAD for Oracle and SQL*Developer contain many pre-defined reports for monitoring a database.
slightwv (䄆 Netminder) Commented:
To add:
Every DBA is different in what the monitor.

What you need to monitor is what is important to you and your specific database.
jeevan mathewdbaAuthor Commented:
I just want to know about the report name in oracle.
Can I assume that TOAD is a reporting tool,
if so if we want to get the out put of a query how we will take?
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

slightwv (䄆 Netminder) Commented:
>>I just want to know about the report name in oracle.

There is no 'report name'.  There are also not out of the box 'reports'.

What specifically are you thinking there is?

>>Can I assume that TOAD is a reporting tool,

No.  Toad is a developer/DBA GUI tool.

>>if so if we want to get the out put of a query how we will take?

Output from a query depends on the tool.  In Toad, I believe there is a results window/panel.

Saving the output to a flat file is different.

In sqlplus you are looking for the spool command.  SQL Developer and Toad will also accept the spool command when you 'Run as script'.
DavidSenior Oracle Database AdministratorCommented:
You're asking a question as if you are not acquainted with the tool -- good for you to connect with experts, even if we confuse you.

At the simplest level, we use the command line interface.  The getting started guides will refer you to an executable, sqlplus.exe, also known as SQL*Plus.  When the database administrator has created or installed the database, s/he will have created certain user accounts with certain privileges.

If I want to display the result set from a simple query, the data will display to the SQL*Plus window.
should return something like
> 30-DEC-2014 13:41

In order to capture and save that output, SQL provides the SPOOL command.

where you can type, edit, cat, or whatever command your O/S uses to view the content of MYFIRST.txt.

There are a number of format and output settings, but this is the concept of how Oracle creates a report.
Gerwin Jansen, EE MVETopic Advisor Commented:
If I were a DBA (which I'm not), I'd be interested in things like:

- Table space usage (data/index), free disc space
- #Transactions per time (hr/day)
- Resource usage of database host (cpu, network, IO etc.)
- Standby DB status
- Backup statistics
- Avg #users connected

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
slightwv (䄆 Netminder) Commented:
>> I'd be interested in things like:

I didn't even attempt this aspect of the question because of two reasons:
1:  The list is infinite
2: This iffers for each DBA and even each individual database and type of database (OLTP, DSS or hybrid).
Gerwin Jansen, EE MVETopic Advisor Commented:
@slightwv - Yes I know, but you and dvz were not making any concrete suggestions so I just named a few, we need more info from asker here.

@jeevan mathew - What is it you really want to know by asking such a broad question? It might be an idea to read a bit about how to ask good questions ;)
DavidSenior Oracle Database AdministratorCommented:
Actually, I thought my observation and example on using SPOOL was pretty specific :)  Until the requester gets back and says more about getting a "report", we're all just waiting.
jeevan mathewdbaAuthor Commented:
Good report
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.