Title: monitoring listener.log
Hi list,
We have a script wich monitor the alert.log for each database. This script scan the alert.log file and send an email if an ORA-xxx error occured
Now, we want to write a script monitoring the listener.log file : wich kind of message or variable
elaborate how do u scan each log
file, and convert it in email msg.
how do u do this..
saurabh sharma
dba
- Original Message -
From:
NGUYEN Philippe (Cetelem)
To: Multiple
recipients of list ORACLE-L
Sent: Wednesday, April 25, 2001 9:10
PM
Subj
Title: cursor and no data found
Hi List !
how can I can make a continue statement in my loop when a request return no data
e.g :
cursor c1 is .
for c in c1 loop
select a into v1
from table1
where a 1 and b 2 and ...
/* if my select into return no data ?
how can I tell him to
Title: Web application and Oracle session
Hi list !
environment :
userA -connexion-
userB -connexion- OAS (htp package) - 1 session -- Oracle8i (only 1 application schema)
... ...
userX -connexion-
A web application is accessed by many users throw OAS
SET ORACLE-L NOMAIL
Title: Partition and primary key
Hi List,
We are using Oracle 8.1.7 (64 bits) with Solaris 8
I have a big table with over 300 millions rows (10 Go),
We have partinionned this table by range of date.
When we try to create a constraint primary key (with dedicated tablespace), we fail each
Title: RE: Partition and primary key
thank U Johnattan, which book are you talk about ? (isbn)
-Message d'origine-
De: Jonathan Lewis [mailto:[EMAIL PROTECTED]]
Date: mercredi 5 février 2003 19:20
À: Multiple recipients of list ORACLE-L
Objet: Re: Partition and primary key
First
error message, including text?
It could be failing on the temp segment initially created in
the index tablespace, and not necessarily running out
of sort space.
Jared
NGUYEN Philippe (Cetelem) [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/05/2003 06:52 AM
Please respond to ORACLE-L
Title: RE: Partition and primary key
Here a sample of my alert.log, SCOPE_MD_IDX is my index tablespace :
ORA-1652: unable to extend temp segment by 320 in tablespace SCOPE_MD_IDX
ORA-1652: unable to extend temp segment by 320 in tablespace TEMP
1. I've then created a primary key with
Title: SQL question : How to retrieve the File_name without Directorie Path ?
Hi Gurus!
a very simple problem for You :I just want to retrieve the .dbf name from file_name column in dba_data_files.
eg :'/oracle/d0/data/user.dbf' -- user.dbf
Maybe using translate function ?
Thank in advance !
Title: Any German here ? Character set
Hi List,
could you please tell me wich Character Set you are using in your database ?
Thank in advance!
Philippe
Title: RE: Any German here ? Character set
thanks all for all thoses relevant answers ;-)
Philippe Nguyen
CETELEM - Administration, Architecture Décisionnelle
Direction Customer Relationship Management
E-Mail : [EMAIL PROTECTED]
Tel
we have the same configuration, Metalink
recommend registering you're 32 bit instance with 64 listener (startup /
shutdown many times if necessary)
De: John Shaw
[mailto:[EMAIL PROTECTED]Envoyé: Mittwoch, 30.
Juli 2003 22:49À: Multiple recipients of list
ORACLE-LObjet: 64 and 32 bit on
Title: size of a row
Hi list,
sorry because the question is certainly already posted :
How can I calculate a size of one row in my Table ?
Thanks in advance!
Philippe
Title: DIRECT=TRUE and local partitioned indexes
Hi Gurus,
We have a table partitionned on date column with local indexes.
If we load datas with DIRECT=TRUE sql*loader option, will it make all my indexes Unusable or only the concerned local index?
Thank in advance
Philippe
Title: URGENT : sql*loader performance problem on partionned table
Hi gurus,
we have two daily loads that one after the other.
The first fill up a non partitionned table and the second do the same into a partitionned table.
First times the second load ran very quickly : 1 min instead of 5 min
Title: RE: URGENT : sql*loader performance problem on partionned table
precision : Oracle 8.1.7.3 (64 bits) in Solaris 8
-Message d'origine-
De : NGUYEN Philippe (Cetelem)
Envoyé : 02 September 2003 18:14
À : '[EMAIL PROTECTED]'
Objet : URGENT : sql*loader performance problem
Title: RE: URGENT : sql*loader performance problem on partionned table
thank U Dennis,
I use local index,
the script is still running (2hours now! instead of 10-20 min) and here is the statement in question (the script who used non-partionned table is already ended)
SELECT NULL
FROM
Title: RE: URGENT : sql*loader performance problem on partionned table
thankx for all those
advbices, actually,the problem does not come from the
sql*loader but from this particular statement:
SELECT NULL FROM
hrel_fusion WHERE cod_rel =
:b1 AND dat_rel =
:b2 AND NOT EXISTS
Title: RE: RE: URGENT : sql*loader performance problem on partionned table - not sql*loader problem but cursor pb!
Here the informations :
table HREL_FUSION :
63 millions rows
3 indexes on columns : nodos_or, nodos_or, numcli --- too much indexes ??
table primedi_enr2_temp_fusion : 133
Title: RE: RE: URGENT : sql*loader performance problem on partionned tab
here the trace :
SELECT STATEMENT, GOAL = CHOOSE 2 72 1368
FOR UPDATE
FILTER
PARTITION RANGE SINGLE
TABLE ACCESS BY LOCAL INDEX ROWID FICOM HREL_FUSION 2 72 1368
INDEX RANGE SCAN FICOM
Title: Exporting a partition with transport tablespace
Hi list,
is it possible to export a partition with the transportable tablespace feature ?
My partition is over 8 Go.
Here my statements , thank you in advance !
SQLexec
-contained. everything that is being transported has to be in that tablespace. it doesnt matter if its a different datafile.
you probably have your partitions in seperate tablespaces? or am i wrong?
From: NGUYEN Philippe (Cetelem) [EMAIL PROTECTED]
Date: 2003/12/22 Mon AM 10:34:25 EST
23 matches
Mail list logo