Just an aside, I have been pretty unhappy with 8.1.7.1.2, lots
of crashes/core dumps with 7445 errors. I would not suggest
going there, I hope 8.1.7.4 is a better place to be.
On Thu, Jul 18, 2002 at 09:43:26AM -0800, Fowler, Kenneth R wrote:
> List,
>
> One of the DBA's here needs to migra
Hi all,
I'm trying to explain to some customers of ours in The Netherlands
what I mean by some database terms - but my Dutch is limited to things
about food ( broodjes, poffertjes, etc.), and their English is very
good - but just not about databases.
Any ideas what terms I'd use to describe refe
Title: connecting session to sqlarea to find the sql_text
Is there any means to connect session information (v$session) and v$sqlarea (or any other dynamic table) to find out which sessions have fired what sql_text?
Any other workaround?
rgds
amar
http://amzone.netfirms.com
Hi List,
My friend has foll.(Big)problem.
He'was testing the following trigger n now stuck.
Do not execute this trigger on ur side.
CREATE OR REPLACE TRIGGER tpp
before alter or create or drop on database
declare
uname varchar2(20);
begin
select osuser into uname from v$se
What the f* does this euphemistic cr*pola mean:
...
| "Our strategy has never changed with what we are
| trying to do with consulting, but it sure looked
| that way in the early part of the year because we
| managed to get a disalignment between our
| incentives and our resources and
Welcome mate ,
Same question I posted a month back
First get the
select osuser,sid from v$session;
then use sid in foll. query
SELECT sql_text FROM v$sqlarea WHERE (address,
hash_value) IN
(SELECT sql_address, sql_hash_value FROM v$session
WHERE sid = &sid_number)
--- sam d <[EMA
Try to disable the trigger first then drop it.
The error is expected because the SQL in trigger will return more than one
row.
HTH
Sanjay
-Original Message-
Sent: 22 July, 2002 2:38 PM
To: Multiple recipients of list ORACLE-L
Hi List,
My friend has foll.(Big)problem.
He'was testing t
Just realized that alter table disable trigger will not work too..
Even if there is only one session on server it will return more than one row
because of BG processes.
Sanjay
-Original Message-
Sent: 22 July, 2002 2:38 PM
To: Multiple recipients of list ORACLE-L
Hi List,
My friend
Title: download or upload.
Some terminology confusion.
When you load a text file into the database, you call it download or upload?
When you create a text file from your database you call it download or upload?
rgds
amar
http://amzone.netfirms.com