any Free Dowloadable Oracle monitoring Tools Along with features Comparative to OEM ?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: VIVEK_SHARMA
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
oraora oraora wrote:
Guys,
i want to export table data into a CSV file.
i am using the script below to do the same.
--
set wrap off
set linesize 2000
set feedback off
set pagesize 0
set verify off
set termout off
Oracle 817 on W2k:
SELECT FUNCTION(X) FROM TABLE works fine.
SELECT COUNT (*) FROM
(SELECT FUNCTION(X) FROM TABLE) where the function and the table are the
same as above, takes hours and hours, without any result, and I have to stop
it. There is NO ERROR MESSAGE.
The same story (no result,
What does the session statistics say when you are running the query?
Do an explain plan of both the queries and see the difference. Check the
session statistics for both the queries.
Regards
Naveen
-Original Message-
Sent: Tuesday, December 24, 2002 2:34 PM
To: Multiple recipients of
Title: RE: 1998 Openworld CD
Jeremiah-
You won't believe this!! I have two of them:-) And one of them has not even been opened.
So let's contact each other offline from the list to figure this out.
Greg Loughmiller
[EMAIL PROTECTED]
-Original Message-
From: Jeremiah Wilton
Not opened, put it on EBAY :) , heck i see shirts people got from
openworld show up on ebay on day 1 of that conference, go figure.
joe
Loughmiller, Greg wrote:
RE: 1998 Openworld CD
Jeremiah-
You won't believe this!! I have two of them:-) And
one of them has not even been
I have a developers stored procedure making repeaded calls
(logons/request for data and logoff)
Each call takes only seconds but it seems like PMON dosnt close the
process in a timely manner, leaving what look to be ghost process. If a
few users hit the same app the processes go to = 50 then I
I'm
still wearing those t-shirts!
-Original Message-From: Joe Testa
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 24, 2002 8:34
AMTo: Multiple recipients of list ORACLE-LSubject: Re:
1998 Openworld CDNot opened, put it on EBAY :) , heck i
see shirts people got from
You can try using the wakeup parameter of oradebug.
You need to get the process ID of the pmon process,
select pid from v$process p,v$bgprocess b
where b.paddr = p.addr
and name = 'PMON'
then oradebug wakeup n.
where n is the process id
Let me know if it works for you.
-Original
http://www.tux.org/orac-dba/
Goto to www.freshmeat.net and search on Oracle.
Jared
On Monday 23 December 2002 23:48, VIVEK_SHARMA wrote:
any Free Dowloadable Oracle monitoring Tools Along with features
Comparative to OEM ?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
If I understand your question correctly:
If you are on Unix, or have the sed utility available. then you can do
something like the following. Assume X is the character to eliminate.
sed 's/X//g' CSV_file temp_file
verify temp_file is OK, then replace CSV_file with temp_file. Perl has
Why not just increase max processes?
Jared
On Tuesday 24 December 2002 05:53, Bob Metelsky wrote:
I have a developers stored procedure making repeaded calls
(logons/request for data and logoff)
Each call takes only seconds but it seems like PMON dosnt close the
process in a timely manner,
select pid from v$process p,v$bgprocess b
where b.paddr = p.addr
and name = 'PMON'
then oradebug wakeup n.
where n is the process id
Let me know if it works for you.
Yes, I can do that but it seems like a manual process.I need something
automatic.. No?
Jared:
We
me too(i've always wanted to say that on the list).
from 2000 openworld. :)
merry christmas.
joe
Mercadante, Thomas F wrote:
I'm still wearing those t-shirts!
-Original Message-
*From:* Joe Testa [mailto:[EMAIL PROTECTED]]
*Sent:* Tuesday, December 24, 2002 8:34 AM
Title: Message
Hi
lists
Happy holidays
from the warm Dominican Republic.
Thanks for all
your help throught the year.
Ramon E.
Estevez
[EMAIL PROTECTED]
809-565-3121
Add a dispatcher, configure MTS, min server processes and add an Oracle
service for this MTS.
An then let this app connect to Oracle through the MTS service.
Regards,
Waleed
-Original Message-
Sent: Tuesday, December 24, 2002 8:54 AM
To: Multiple recipients of list ORACLE-L
Title: Message
Enough
of the merriment and get back to work. Hum-Bug
Scrooge
-Original Message-From: Ramon E. Estevez
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 24,
2002 10:04 AMTo: Multiple recipients of list
ORACLE-LSubject: Feliz Navidad
Hi
lists
Happy
Title: RE: PMON seems to not close sessions in a timely manner eg Max processes(50) reached
From: Bob Metelsky [mailto:[EMAIL PROTECTED]]
I have a developers stored procedure making repeaded calls
(logons/request for data and logoff)
Each call takes only seconds but it seems like
Dave, do some DBA work like drop tablespaces afetr drinking eggnog.
joe
Farnsworth, Dave wrote:
Enough of the merriment and get back to work. Hum-Bug
Scrooge
-Original Message-
*From:* Ramon E. Estevez [mailto:[EMAIL PROTECTED]]
*Sent:* Tuesday, December 24, 2002 10:04
Well, I had placed the db is MTS mode and still hit the max
processes(50)
#MTS_DISPATCHERS=(protocol=tcp)(dispatchers=5)(pool=on)(tick=1)
(connections=1000)(sessions=4000)
#MTS_MAX_DISPATCHERS=32
#MTS_SERVERS=5
#MTS_MAX_SERVERS=64
#MTS_SERVICE=MYDB
#MTS_LISTENER_ADDRESS =
Does your app connect to the database using the listener or directly (BEQ)
without specifying a connect string?
It should connect using the listener and a connect string.
Regards,
Waleed
-Original Message-
Sent: Tuesday, December 24, 2002 1:14 PM
To: Multiple recipients of list
Mine is 8.1.7.2 on HP.
In init.ora, processes=1000 sessions=1000 mts_servers=8, mts_max_servers=20,
dispatcher=10
I have not seen maximum process reached but have seen Deadlock: MTS Max
Servers (20) reached because applications had more than usual connections
once in a while. But that's ok
Merry Christmas to all To All A Good Night!
Dick Goulet
Reply Separator
Author: Ramon E. Estevez [EMAIL PROTECTED]
Date: 12/24/2002 8:03 AM
Hi lists
Happy holidays from the warm Dominican Republic.
Thanks for all your help throught the year.
All,
Oracle support was able to resolve this issue for
me and I would like to share the learning. The problem was that I was unable to
create stored outline for sql executing within a stored procedure after turning
create_stored_outlines=true. Create outlines for sql satetements executing
At 11:08 AM 12/24/2002 -0800, [EMAIL PROTECTED] wrote:
Merry Christmas to all To
All A Good Night!
Dick Goulet
Ditto.
Jonathan,
What do you make out of following deadlock graph. This is happenning when 2
instance of same batch process are running. We are absolutely certain that
these batch processes are not working on same set of records (although
records can be in same block). object f9d5 is wcu_po_line table.
Bitmap indexes?
joe
Shaleen wrote:
Jonathan,
What do you make out of following deadlock graph. This is happenning when 2
instance of same batch process are running. We are absolutely certain that
these batch processes are not working on same set of records (although
records can be in same
27 matches
Mail list logo