Send 'help' to [EMAIL PROTECTED]
It will contain some info about receiving your own posts. ( I think )
Jared
Benny Pei [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
08/19/2003 03:24 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
I think that www.2train4.com have a testing
tool.
also www.mercury.com have such a tool.
Yechiel AdarMehish
- Original Message -
From:
Baswannappa,
Shiva
To: Multiple recipients of list ORACLE-L
Sent: Friday, June 06, 2003 5:30 PM
Subject: Testing tools for custom
Sorry for the delay in replying; something more urgent popped up.
Nope, the x$uganco doesn't show the db_links opened by other sessions. The
inst_id field looks like it would be useful only in Parallel Server
environments. Any other ideas?
I can't believe Oracle doesn't keep track of open
Sorry, no more ideas.
Allan
-Original Message-
Sent: Wednesday, February 26, 2003 6:19 AM
To: Multiple recipients of list ORACLE-L
Sorry for the delay in replying; something more urgent popped up.
Nope, the x$uganco doesn't show the db_links opened by other sessions.
The inst_id field
I think I spoke too soon.
The v$dblink view shows the db_links opened by the current session only.
I want to be able to find out the db_links opened by all current sessions
and the sids for the sessions. This way I can monitor all the application
instances that opened the db_link and those that
There is an underlying x$table named x$uganco that contains a column
named inst_id which is being filtered in the view_definition for
V$DBLINK as found in V$FIXED_VIEW_DEFINITION. Selecting from the
x$uganco should do the trick. Mind you there are no rows in there when
the links are not active
Charu,
The view V$DBLINK can show you if the link is in use.
select open_cursors, in_transaction
from v$dblonk
where db_link = 'mylink'
HTH.
Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, February 21, 2003 8:03 AM
Dear
V$dblink
-Original Message-
Sent: Friday, February 21, 2003 7:04 AM
To: Multiple recipients of list ORACLE-L
Dear Listers,
Oracle 8i HP-UX11.
We have a database link with a remote database which is accessed from
the application code. In the application code, a call is made to the
Darn!!
I had taken a hasty look at 'Oracle 8i reference', before posting the query.
Not my day today.
Thanks Allan.
Regards,
Charu
-Original Message-
Allan
Sent: Friday, February 21, 2003 5:04 PM
To: Multiple recipients of list ORACLE-L
V$dblink
-Original Message-
Sent:
Title: RE: Testing
We regret to inform you that your test has failed, please try again.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN
(20 days later -- occurrences aren't that common)
Jared,
Ok, I've re-RTFM'd the Concepts manual and have dog eared Steve's book
unbelievably. I've used the event 10046 traces while the blocking
lock event was going on. The curious thing is that I'm not seeing any
buffer busy waits. The
See my comments in the text:
Robert Eskridge wrote:
(20 days later -- occurrences aren't that common)
Jared,
Ok, I've re-RTFM'd the Concepts manual and have dog eared Steve's book
unbelievably. I've used the event 10046 traces while the blocking
lock event was going on. The curious
Robert,
Simulating the problem and proving the correction is an excellent idea.
One thing to consider when putting together your testing scenario is
that writes to the database block by a transaction are done in memory,
that is they are made to the cached database blocks.
An internal locking
I think that many of the more vocal members are busy
playing, uh I mean *working* at OOW.
Jared
Sherman,
No, I backup databases on 3 machines using rman. Our recovery catalog
database is on our production machine and I backup my production databases
on that machine.
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 3:20 AM
15 matches
Mail list logo
