Posted on 2014-12-30
Last Modified: 2015-01-03
What are the various reports taken by oracle dba
Question by:jeevan mathew
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 2
  • +1
LVL 23

Expert Comment

ID: 40524310
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.
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40524435
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.

Author Comment

by:jeevan mathew
ID: 40524629
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?
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40524671
>>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'.
LVL 23

Expert Comment

ID: 40524723
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.
LVL 38

Accepted Solution

Gerwin Jansen, EE MVE earned 500 total points
ID: 40524738
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
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40524752
>> 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).
LVL 38

Expert Comment

by:Gerwin Jansen, EE MVE
ID: 40525790
@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 ;)
LVL 23

Expert Comment

ID: 40526365
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.

Author Closing Comment

by:jeevan mathew
ID: 40529341
Good report

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question