|
What tools would you recommend for monitoring the general health and performance of an oracle database. How do you ensure database issues are picked up and resolved quickly.
Started by Matthew Watson on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
You could have a look at Oracle....
Statspack and AWR are part of oracle (statspack is pre-oracle10 and AWR.
If you get the edition with the DBA module, there are heaps of monitoring & optimization features.
Have you looked at TOAD.
|
|
Hi all,
I'm using (have to) a badly designed Oracle(10) DB, for which I don't have admin rights (although I can create tables, triggers, etc in my scheme).
Now I had run into a problem: this DB connected with several users/programs. I must find out who...
Started by Zsolt Botykai on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
It would be easier to do.
Type and the oracle user...as well as a bunch of other data if you need it.
|
|
What does scheduler mean in Oracle? Is it connection scheduling or query scheduling or the query plan execution scheduling or something else?
Started by Monis Iqbal on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
To be called/accessed via DBMS_JOB if that rings any bells?)
I would guess that the Performance Monitor, the term "scheduler" usually refers to the processes that are running under the new Oracle job.
|
Ask your Facebook Friends
|
Is there a option to see if existing table/record from a Oracle database is updated?
Started by R van Rijn on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Streams can be used to track changes by monitoring the redo the transaction we can monitor....
From a monitoring perspective the record changes (insert, update, delete).
Of to see when any particular row in a table has been updated .
|
|
Moving from Oracle to PostgreSQL, what (preferably free/OSS) software/tools are available that replace Oracle Enterprise Manager? I'm aware of pgAdmin, as well as some tools bundled into EnterpriseDB's Postgres Plus AS, but am looking for more context...
Started by Jacob on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
I doubt you will find an open source tool that really competes head-to-head with Oracle.
That said point.
For monitoring I use nagios to script psql to query vitals.
Upgrade, replication.
|
|
We have grown from a small time of 2-3 developers to about 30 developers very quickly. We supposedly never needed Source Control, or Db Monitoring or Schema diagrams.
Now we see more and more terrible code being moved to the Production. Is there an off...
Started by Reuben on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Have you considered SVN for your source control and management of scripts, DDLs and etc? Our ORACLE.
|
|
Hi,
I am looking for a tool to monitor results of a periodically run sql query and raise a notification based on the fact that the query returns any results. (any other filters are welcome)
I need to watch a transaction table for errors, and it would ...
Started by Kamil Zadora on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
How about.
Have your monitoring / notification code there.
Put the query in a stored procedure.
|
|
I'm trying to convert the permanent tables used in a stored procedure to
global temp tables. I've looked at the stats on these permanent tables
and some have tens of millions of rows of data and are on the order if
gigabytes in size (up to 10 GB).
So,...
Started by Dragos Toader on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
I looked at large sized Global Temporary Tables for a migration the sessions as separate oracle....
Oracle has no such limitations.
It is very rare in Oracle to even need temporary tables-- it is far more common in other on it.
Solutions.
|
|
Hey everyone,
I was wondering if anyone could point me in the direction of some good resources (web sites, technical articles/journals, books, etc.) related to database monitoring/performance?
I am looking to write a paper that explores what kinds of ...
Started by behrk2 on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
You may use....
Example : Oracle.
In most cases the database providers release a good set of tools for monitoring analysis purposes.
I don't think this is a question question.
Try here - the first link is a PDF to activity monitoring.
|
|
I want to put together some scripts to run an automated health check of Oracle 9i and 10g databases. Before I start from scratch, I was wondering if anyone know of any available open source scripts that I could use as a base for this project.
Started by Roy on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at serverfault):
I would bet there's a lot://www.evdbt.com/tools.htm has a whole bunch of healthcheck/monitoring/performance related scripts of monitoring and health checking....
Tim Hall has a great site for Oracle resources: oracle-base.com .
|
