Folks,
I am trying to get some stats from a oracle DB (cant use DBI, dont ask why)
I need to escape out v$session, but cant seem to find the right magic :(
I have tried
v\$session and get the ugly so such table or view
Ron
: Yacketta, Ronald [mailto:[EMAIL PROTECTED]]
:Sent: Monday, June 25, 2001 10:45 AM
:To: Beginners (E-mail)
:Subject: escaping v$session
:
:
:Folks,
:
:I am trying to get some stats from a oracle DB (cant use DBI,
:dont ask why)
:I need to escape out v$session, but cant seem to find the
:right magic
-Original Message-
From: Stephen Neu [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 25, 2001 12:04 PM
To: Perl Beginners (E-mail)
Subject: RE: escaping v$session
Try 'v$session' instead of v$session
The single quote doesn't interpolate variables like the double-quote
:@active = qx(
:sqlplus -S $RTDUSER/$RTDPASS\@$RTD_ORACLE_SID -!
:select count(distinct(process)) ACTIVE from --- v$session ---
:where last_call_et 60 and
:process in (select ltrim(rtrim(to_char(process_id) )) from
:session_list);
:quit
:!
:);
Ok, so you're using qx(foo), which is the same
On 25 Jun 2001 12:15:15 -0400, Yacketta, Ronald wrote:
snip /
this is what I am trying todo
@active = qx(
sqlplus -S $RTDUSER/$RTDPASS\@$RTD_ORACLE_SID -!
select count(distinct(process)) ACTIVE from --- v$session ---
where last_call_et 60 and
process in (select
:@active = qx(
:sqlplus -S $RTDUSER/$RTDPASS\@$RTD_ORACLE_SID -!
:select count(distinct(process)) ACTIVE from --- v$session ---
:where last_call_et 60 and
:process in (select ltrim(rtrim(to_char(process_id) )) from
:session_list);
:quit
:!
:);
Oh... Didn't see the other variables you were
On 25 Jun 2001 12:57:39 -0400, Yacketta, Ronald wrote:
This one was really close :)
I had to change
select count(distinct(process)) ACTIVE from . 'v$session' .
to
select count(distinct(process)) ACTIVE from . 'v\$session' .
and it worked!
Thanxs everyone!
Ron
What version
On 25 Jun 2001 09:47:08 -0800, Michael Fowler wrote:
On Mon, Jun 25, 2001 at 01:09:51PM -0400, Chas Owens wrote:
On 25 Jun 2001 12:57:39 -0400, Yacketta, Ronald wrote:
select count(distinct(process)) ACTIVE from . 'v$session' .
select count(distinct(process)) ACTIVE from .
On Mon, Jun 25, 2001 at 02:09:59PM -0400, Chas Owens wrote:
@active = qx(
sqlplus -S $RTDUSER/$RTDPASS\@$RTD_ORACLE_SID -!
select count(distinct(process)) ACTIVE from v\\\$session
where last_call_et 60 and
process in (select ltrim(rtrim(to_char(process_id) )) from
session_list);
quit
!
On Mon, Jun 25, 2001 at 02:24:21PM -0400, Chas Owens wrote:
Let me see if I have this straight:
Perl was ignoring $session because of the \ and then passing the output
to the shell (stripping the \).
Yes.
The shell saw $session so it tried to replace it with the enviromental
variable
10 matches
Mail list logo