How To Monitor Alert Log File (using Any Tool Or Manual)

May 10, 2013

1)How to monitor alert log file (using any tool or manual)?

2) What are the implications of a database with multiple data block sizes?

View 4 Replies


ADVERTISEMENT

Windows :: Tool To Monitor Oracle Host And Services?

Jun 29, 2010

What tool can be used to monitor Oracle host on Windows environment if the database goes down? I know about "Nagios" but like to know is there any other tool available?

View 6 Replies View Related

Call Interface :: Monitor Stream Activity With Strmmon Tool

Dec 20, 2012

I want to monitor the stream activity with strmmon tool. How to compile the strmmon.mk? I was seeing with visual studio command prompt but it does not work properly.

Oracle Version: 10.2.0.4
Server: Win 2008 R2

View 0 Replies View Related

Forms :: Display Alert When Click On Insert Record In Tool Bar?

Jun 26, 2013

I want to display an alert when we click on Insert Record in tool bar. I put allow update->yes and insert->no.

but when i click on the insert record in tool bar it showing message only.

Instead of message I need an alert using triggers. I added the image also.

View 1 Replies View Related

Server Utilities :: Tool To Create CTL File?

Oct 25, 2011

Are there any GUI based tools that can auto generate a CTL file based off a CSV input? I'd love something like this since I have quite a few SQL*LDR projects coming up!

View 2 Replies View Related

Application Express :: File Browse Field In Manual Tabular Form?

Oct 26, 2012

I am using Oracle APEX 4.0. I want to create a tabular form with one column as File Browse field.I've created form using APEX_ITEM and file browse item using pure HTML tags as we do not have any such item in APEX_ITEM. So these fields are appearing now but how do I save uploaded files in APEX_APPLICATION_FILES and then in my table?

View 3 Replies View Related

Finding Alert Log File

Dec 23, 2011

How can i come to know that which current alert log file is being used for database? Is their a command at database level to find out the current alert log file to which database is using ?

View 2 Replies View Related

Alert Log And Listener Log File Purging In 11g?

Mar 6, 2013

how to purge the alert log and listner log file in 11g.

OS:IBM/AIX RISC System/6000
DB version: 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

View 8 Replies View Related

Networking And Gateways :: ORA-3136 Frequently In Oracle Db Alert Log File

Jan 2, 2011

I am facing below error so frequently in alert log file Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.1.0.6.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.1.0.6.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.1.0.6.0 - Production
Time: 03-JAN-2011 02:00:00

[code]....

View 18 Replies View Related

Can Monitor 10.2.0.2 Databases Using OEM 11g

Feb 7, 2011

In my company we have few 10.2.0.2 databases and few 10.2.0.4 databases.Currently we are monitoring using OEM 10g (10.1.0.5.0) installed on a seperate server.

Planning to install OEM on a new server as part of server room renovation. let me know the process of installing OEM on a different server without loosing the historical data?Also wondering if the OEM 11g will support the current databases?

View 2 Replies View Related

Flag Or Monitor CPU Utilization?

Dec 22, 2010

I have to run a resource extensive SQL. It utilizes CPU to a great extent. I've created a new user just to run this particular report. I need to ensure that this particular user doesn't uses more CPU.

Hence, I need to generate an alarm (email) only if a threshold is exceeded for a certain period of time (above x% for y minutes),(example more than 80% for 10 min.), so that I can either kill the process or continue running it depending on CPU usage.

Can I do it using scripts or OEM. I couldn't find any specific metrics to do it in latter. (I'd prefer scripts though. )

My system details are as follows:

1. Database: Oracle 10g R2
2. Unix: Sun OS 5.10

View 2 Replies View Related

How To Monitor Oracle Application R12

Jul 16, 2011

How can I monitor Oracle Apps R12 on Linux RHEL5. Application and database status.

View 2 Replies View Related

SQL & PL/SQL :: Monitor Jobs From Procedure?

Dec 31, 2010

We have a job table, and whenever jobs are added to this table the job processing procedure should be started.

In unix we have crontab facility where we can schedule to run for 24/7.

similarly do we have any option in oracle daatbase, to keep on running a prcedure in loop.

View 2 Replies View Related

Windows :: Monitor The Cpu Utilization On Xp?

Jul 16, 2010

how can we monitor the cpu utilization on windows xp.

View 2 Replies View Related

How To Monitor Drop User

Jan 31, 2013

How to monitor the DROP USER command?

OS: AIX, Oracle: 11.2.0.2

View 8 Replies View Related

How To Monitor Space Of Database In RAC And NON-RAC

Nov 17, 2012

I need to monitor the Database daily, so i need to check whether the size of the DB is increasing @ a slow rate or rather than that. I need to do it in RAC & NON-RAC.

View 3 Replies View Related

Monitor The Creation Of New Datafiles / Tempfiles?

Oct 15, 2012

I am looking for a way to monitor the creation of new datafiles / tempfiles.Let's say I am creating a new datafile of 8GB in size, and it takes a few minutes to create.

I have looked at v$session_longops, and several other system views, but cannot find any that indicate how the file creation is progressing.

I want to be able to display something simple, such as "72% complete".

View 1 Replies View Related

Client Tools :: SQL Monitor Alternative?

Jan 5, 2011

Many moons ago, at a previous employer, I had access to the SQL Monitor tool that came with TOAD. I could really use an alternative to this now, as we don't have TOAD here, and it would need to be free. I'm getting a problem with a forms update failing, and I really need to see what's actually being submitted to the database by the form. We're still stuck on Forms 6 by the way

View 2 Replies View Related

Replication :: How To Monitor Complete Refresh

Oct 29, 2008

I am using basic replication in oracle 10.2.0.3. My materialized view object contains around 3 million records. Usually we are using FAST refresh but in my materialized view having some problem that’s the reason I am going to Complete refresh.

If I start complete refresh it will take 8-12 hours to complete refresh.

My Question is: During Complete refresh how to monitor complete refresh running or not except using

v$mvrefresh.

Is there any way to monitor complete refresh because suppose target database not available/network problem/ dead lock occur in my database. I can’t able to track refresh.

Even there is no notification in alert log.

View 1 Replies View Related

Server Administration :: Monitor PGA Utilization?

Dec 28, 2011

I have a requirement to monitor the PGA utilization with time to time. Provide a good script which will effectively show the pga utilization.

View 2 Replies View Related

How To Monitor ALTER TABLESPACE Ddl Change

Jan 8, 2013

I can use trigger to monitor ALTER TABLESPACE ddl statement against a particular tablespace in a schema.

CREATE OR REPLACE TRIGGER HOT_MAIL_DDL_CHANGE
AFTER ALTER TABLESPACE <tbs_name>
ON SHANNURA.SCHEMA
BEGIN
INSERT INTO HOT_MAIL_DDL_AUDIT_LOG VALUES
(SYSDATE,
SYS_CONTEXT('USERENV', 'SESSION_USER'),
ORA_SYSEVENT,
ORA_DICT_OBJ_TYPE,
ORA_DICT_OBJ_NAME
          );
END;
/

I think, line no.2 isn't a valid statement. Or can I use AUDIT instead - in fact, I want to monitor/audit only ALTER TABLESPACE ddl statement and that too for a particular tablespace only.

View 3 Replies View Related

Security :: SQLs To Monitor User Access?

Jul 2, 2011

There is a user account called 'BALA'.How to create SQLs to monitor 'BALA' user access ?

View 9 Replies View Related

Server Utilities :: How To Monitor Export And Import Job

Apr 28, 2012

how can i monitor the export and import job and how increase the export and import job performance.

can i monitor the export and import job by checking the log and dump file created by export and import and can its performance increase by configure parallism. m i right or not?

View 2 Replies View Related

How To Bypass Manual Query Execution

Apr 13, 2013

when i run a form no information shows up until i click execute query... i need the info to be their automatically to browse with the previous and next button

View 3 Replies View Related

Oracle SGA Components Manual Allocation

May 13, 2013

Phyical memory : 420G My database version : 11.2.0.3 running on linux machine.

Memory_target = 200G . I would like to allocate this value to following SGA components. I don't want to automatic memory management enabled. how to split 200G for following components. Is there any percentage for each components ?

db_cache_size
db_recycle_cache_size
db_keep_cache_size
large_pool_size
java_pool_size
shared_pool_size
pga_aggregate_target
streams_pool_size
log_buffer

View 10 Replies View Related

Client Tools :: SQL Tool To Use With InForm

Nov 7, 2012

I'm a Data Manager recently hired at a small company that uses InForm as our data management tool. We are currently not set up with any type of SQL tool to query the database. Consequently, I feel like I'm trying to clean data with one hand tied behind my back. I have two questions:

1) Is there any sort of built in feature in InForm for using SQL statement to query the data? (I'm not really a fan of the built in Cognos feature.)
2) Any tool that is easy to install/configure?

I'm facing some resistance here, so I'm looking for a really easy/cheap solution. I've used SQL Developer before, and I know that's free, but is it easy to set-up?

View 1 Replies View Related

Forms :: How To Hide MENU And TOOL Bar

Jun 22, 2012

i want hide the content shown in the picture

View 6 Replies View Related

SQL & PL/SQL :: Capture Queries Run By 3rd Party Tool?

Dec 7, 2011

I have this 3rd party tool, which are running SQL queries. I need to see what queries the tool is running and capture them. I enabled tracing but that's not working, as the tool doesn't establish connection, it connects when it has to run the query and then gets disconnected.

View 2 Replies View Related

Forms :: Use Text Tool In Programming?

Feb 3, 2010

Can i use Text tool in programming...

i just want to change color at run time of text tool....

i attached a picture must see...

View 9 Replies View Related

Networking And Gateways :: Logs Or Queries To Monitor Clients IP

Oct 13, 2012

Is there any logs or query where I can monitor client's IP previously connected to the database? I have created 2 listener with 10.1.2.x and 10.1.100.x network. I would like to separate the oracle traffic to the 10.1.100.x alone. As of now both can connect to the database. I like to monitor if everybody is already transferred to the 10.1.100.x network before I will disable the 10.1.2.x.

View 2 Replies View Related







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