Server Administration :: Monitoring Alerts And Logs?

Dec 19, 2012

I have version 11.2.0.3 installed in a server AIX and i'd like to know where are alerts and logs like "max extents reached in table....". I don't see them in alert.log.

Where is the best way to monitoring this class of alerts and logs?

How can i see how many actuals extents go consumed in tables and indexes?

View 10 Replies


ADVERTISEMENT

Server Administration :: Monitoring Open_cursors

Sep 13, 2011

When I monitoring db, I see open cursor increase from a machine running Java application. On the develop machine, everything is ok, but on the production server, open cursors can not close.Although the parameters are the same on 2 servers.

View 15 Replies View Related

Server Administration :: Monitoring Script Required For Oracle 9.2.0.7.0 On Windows 2000 Server

Apr 8, 2010

My manager is asking to create a SQL scrip, which will provide following information.

Our database is 9.2.0.7.0 on Windows 2000 Server

-How many records Insert / Update or Delete daily in my Oracle database?

- Check Archive log / Redo Log switching information?

-Check database growth ?

View 10 Replies View Related

Server Administration :: Monitoring Unusable Objects

May 6, 2012

How monitor the unusable objects in oracle 10g (10.2.0.1.0) os rhel 5? is it same as invalid objects and can be monitor as same?

View 4 Replies View Related

Server Administration :: Monitoring User Session And Killing It?

Jun 8, 2010

I am using TOAD to monitor user sessions. I have a user who uses nearly 80% of Overall resources in the mornings. He calls me daily and say that his work is done. But even then the TOAD shows that he is using same resources for some time.

My question is can i kill the session once he confirms his work is done OR do i need to wait till the redologs are cleared.

View 9 Replies View Related

Server Administration :: Monitoring Auto Allocate Tablespaces

Nov 7, 2011

Currently all my tablesapces are "UNIFORM" and I am looking into going to "AUTOALLOCATE" so space will not be some much of an issue.

I am using the following code and here is the output

sqlplus -s / <<-EOT
set pages 50
set line 100
set verify off
set feed off
set trimspool on
[code]........

Have a script that can emulate my above output and also deal with tablespaces that can autotallocate?

View 4 Replies View Related

Server Administration :: Access Logs Via SQL

Jul 14, 2011

I'm currently working on a project in which I do not have permissions to access the Server where the database is installed and configure.Because of company policies, I do not have Admin Rights over Oracle, but I do have an account that can make Selects to DBA_USER_PRIVS for instance.

I would like to know if there is any way to access the database logs to know if there was any kind of problem within the database, because one of my Schemas misteriously went clean (all tables, sequences, triggers, ... vanished)

View 4 Replies View Related

Server Administration :: Comprehension Of Different Logs

May 11, 2010

I always find difficult to understand the alert logs and other log of cluster as well so i am wondering what to read for . do i need operating system knowledge or oracle architecture knowledge or some concepts or ?. as i saw many experts and even normal dba always talk about read logs and they are quite technical so how can i achieve to understand these logs completely

View 1 Replies View Related

Monitoring Script From Client Side (no Access To Server)

Sep 12, 2012

We are on oracle 11.2.0.2 on Solaris 10. I dont have acces to the db server but connect to the db from the client side using sqlplus. though I have dba privilege (at oracle level) but no access to db server at os level. I also dont have access to enterprise manager console where such information is available.

I want to set up monitoring so that I can get a mail when the space falls below some threshold like say tablespace is 90% full. Is it possible to get mail from pl/sql script for example?

View 1 Replies View Related

Exadata :: Monitoring Cell Server With OS Watcher / Other Command Line Tools

Aug 7, 2012

we can't use the Exadata Plugin for Cloud Control but we need some monitoring of the Cell Servers.Does OS Watcher is the right tool or do we need ADRCI for incidents and so on.

What do have to install and what information do we get.

View 5 Replies View Related

Server Utilities :: Remove Current Archive Logs

Sep 12, 2011

Developer is importing some large volumes of data. As the filesystem was filling up fast, I removed the all the archive log files. Will this affect the functioning of database? It is a development environment.

View 6 Replies View Related

Forms :: How To Get Alerts

May 27, 2010

I have written code on WHEN-BUTTON-PRESSED trigger

if any one closing form i asking YOU WANT TO CLOSE THE SEARCH BOX if yes then close the form else written to search box....

alert is generating but if i click on yes it not get closed....

DECLARE
al_id Alert;
al_button NUMBER;
BEGIN

[Code]...

whats problem in this code?

View 4 Replies View Related

Managing Tablespace Alerts Without EM?

Dec 5, 2012

How to Managing Tablespace usage Alerts with out EM(Enterprise manager), in oracle 11g & 10g

I want to set threshold on tablespace usage, it is possible to set threshold on tablespace usage reached 80% full then send email notification with out EM use.

If it not possible,then any other option available to get automatic alert.

View 1 Replies View Related

Configuring OEM Alerts For Mobiles To Send SMS

Aug 15, 2010

How to configure SMS alerts for mobiles from OEM. We have a very big setup managed by 10g grid and i want to configure Mobile SMS alerts from OEM Grid.

View 5 Replies View Related

OEM Alerts That Tablespace Running Out Of Space?

Aug 9, 2013

I know this has been done to death, but I wanted to just go over what I do when OEM alerts me to a tablespace running out of space.First, I check the free space of the tablespace using this query:

SET LINESIZE 100COLUMN TABLESPACE FORMAT A15select t.tablespace,  t.totalspace as " Totalspace(MB)",round((t.totalspace-fs.freespace),2) as "Used Space(MB)",fs.freespace as "Freespace(MB)",round(((t.totalspace-fs.freespace)/t.totalspace)*100,2) as "% Used",round((fs.freespace/t.totalspace)*100,2) as "% Free"from(select round(sum(d.bytes)/(1024*1024)) as totalspace,

[code]....

View 2 Replies View Related

To Permanently Deactivate Alerts From 12C Grid Control

Oct 15, 2013

I want to  permanently de activate alerts from 12C  grid control so i do not get email anymore.

View 4 Replies View Related

Sending Email Notifications / Alerts Via Enterprise Manager 11g

Feb 24, 2013

I have Oracle 11g on Linux...and i have set up SMTP of my Enterprise Manager Database control. I click on Test and an email was sent successfully. What i don't know is how to add more emails as the recipient of the alerts.

I have setup metrics like number of sessions, cpu usage, buffer cache hits, swapping, tablespace usage, etc...Upon saving and waiting for transactions to come in, alerts were shown the the EM homepage..but i did not receive any emails.

View 2 Replies View Related

Enterprise Manager :: Configuring Grid Alerts For Two Different Groups Based On Database Environment

Aug 12, 2010

i have implemeted grid control for monitoring database. we have different database environment like PROD , STAGE, TEST, BETA.

Now my requirement is, i need to configure PROD & STAGE alert for one group (group1@oracle.com) means, what ever alerts generated by grid should sent notification to group1@oracle.com and TEST AND BETA database alerts should to group2@oracle.com.

Now i am following the oracle manual to configure notifications. unfortunately i could not find to complete my requirement.

[URL]

did any one implemented alerts to send different groups.

View 2 Replies View Related

Forms :: Dual Monitor Forms With Alerts / Messages

Apr 18, 2013

We have forms 11gr2 on win xp 32bit , weblogic linux server 64bit. We are converting 6i to 11g. Our system has many forms that span on 2 monitors. 1280x768 monitors, so some forms are 2560x768.

When alerts/messages pop up on the screen , they are positioned in the middle of both screens (guessing Oracle by default calculates width =2560/2, height =768/2).

Possible options:

1- is there a way to tell oracle to open alerts/messages a X Y coordinates? Maybe a config file on the server? Already file a Sr with Oracle tech support.
2- tried creating a form to do our messages. but this is flawed since when you call the new form to display the message, then the focus on current form is lost. when the message form is closed (then trigger when_window_activate fires)...this would be hell to try and control all our messages (we may have 20-30 on each big form. We have a total of 118 forms. Lots of messages with Y/N/Cancel options.
3- Maybe create a place holder for messages on all forms (bottom of screen)...thats the best idea we have so far.
4- Is there a way to do something with a java beans? We already have some knowledge with beans since we use image beans and pdf beans.

View 1 Replies View Related

Alert Log Monitoring?

Jul 23, 2012

I'm using this logic to avoid specific error.Does not seem to be working fine. Any other method to exclude perticular error from monitoring.

if [ -n "$line_no1" -o -n "$line_no3" ] ; then
cat $script_loc/alrt_chk.log | grep -i "ORA-" > $script_loc/ora_alert_only.log
#----
echo "Entering in while Loop"

[code]...

View 2 Replies View Related

Monitoring Runtime Of Procedures

May 23, 2013

runtime monitoring procedures....need a sample script

View 1 Replies View Related

How To Know Database Shutdown Without Monitoring

Nov 23, 2010

The Database is Shutdown, no user is complaining about it and also you are not monitoring it through alert log file, then how will you, as a DBA, come to know about it?

View 2 Replies View Related

SQL & PL/SQL :: Tablespace Monitoring Script

May 20, 2013

To create a script i want to monitor my tablespaces . I want monitor my tablespace by my sqlplus in this script i want tablespace name,total size(MB),user Space (MB),Used Space (%),Free space(MB).

View 9 Replies View Related

Monitoring Oracle Database

Aug 20, 2010

Whats is the best Tool for monitoring ORACLE DBs ?

I've heard about Toad, Spotlight, and of course The EM from Oracle..but i know there some other tools that i maybe don't know.

View 1 Replies View Related

SQL & PL/SQL :: Monitoring Status Of Procedure?

Feb 24, 2010

I've got a pl/sql procedure that i would like to monitor its progress. Its been running for quite a few hours now and i dont really know if it is stuck in a loop or if it is just taking too long read/execute queries. Is there a way to find out what is the status of the procedure? or what it is currently doing?

I looked at views like v$sessions or v$session_longops but they dont actually tell me what it is currently doing. All of them just point to the call to the pl/sql procedure. Also, is it possible to look at the physical files on the filesystem to know if there is actually any processing going on and files are being written to? Is this possible or a files written to only after a commit?

View 17 Replies View Related

Database Monitoring And Report

Aug 31, 2012

I'd like to start monitoring the customer's database. I need a tool to monitor database's performances and I also need to run day by day a series of queries that produce control reports.

I'd like the tool alerts me by email if something goes wrong.

View 4 Replies View Related

How To Take Full Advantages Of Monitoring Tools

Aug 6, 2013

11.2.0.1Aix 6.1 5L (quadcore, 16GRam) I am still confused how to take full advantage of these monitoring tools. Actually the our database performance is currently satisfactory, except for occasional few minutes spikes of CPU highs > 80 .I just want to catch the culprit process/program responsible for this spikes. Is it wise to run ASH, AWR, ADDM with an input from time 1AM to 1AM next day? What I mean is I will analyze a 1-day period, so that I can catch the program/process that has the higest cpu/memory usage for the day. 

View 24 Replies View Related

Why Is OEM SQL Monitoring Showing Parallel On Almost Every Statement

Jan 28, 2013

I'm running Oracle EE 11.2.0.2 and when I look in OEM SQL Monitoring, it shows nearly every sql statement running with a degree of parallelism of *2*.

I've checked dba_tables and the 'degree' for all tables is only 1. I look at the actual sql statement, and there are no hints to tell it to use parallelism. So why and how is the database using parallelism?

I do see that parallel_threads_per_cpu is set to 2, but this is default for our Solaris 10 operating system.

REF: (for 11.2)
===========
PARALLEL_THREADS_PER_CPU specifies the default degree of parallelism for the instance and determines the parallel adaptive and load balancing algorithms. The parameter describes the number of parallel execution processes or threads that a CPU can handle during parallel execution.

The default is platform-dependent and is adequate in most cases. You should decrease the value of this parameter if the machine appears to be overloaded when a representative parallel query is executed. You should increase the value if the system is I/O bound.

how to tell if my database is actually IO bound or not?

View 6 Replies View Related

Performance Tuning :: Index Monitoring

Aug 26, 2010

get all the unused index in the system , if i put this query in batch job and execute it every night upto one months and store its data in a table and after one months i can get all the used indexes and left would be our unused indexes.

select
distinct p.object_name c1
from
dba_hist_sql_plan p,
dba_hist_sqlstat s

[Code]....

View 23 Replies View Related

Script For Monitoring Database Buffer Cache

Mar 26, 2012

give a script to find how much my db buffe cache and redo log buffer cache is used and how much is free.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved