ORA-00942 when query from Dynamic view table

[Linda Xu]

Hi, 

I need to get information from V$ dynamic table from Oracle. But receive an
Orac-00942 error : table or view not exists
I am using system as connect user.

Here is my code:

use DBI;

$dbuser='system/manager';
$dbh=DBI->connect('dbi:Oracle:host=X.X.X.X;sid=X;port=1521', $dbuser,'')
          or die "Cannot connect to database: $DBI::errstr";
$dbh->{RaiseError}=1;

$locksql=$dbh->prepare ("select to_char(sysdate, 'mm/dd/yy hh24:mi:ss')
                        ,s.machine, s.program, l.sid, l.addr,l.kaddr,l.type,
l.id1,l.id2,l.lmode, l.request, l.ctime, l.block 
                        from v$session s, v$lock l  where s.sid=l.sid")
                        or die "Cannot prepare: ".$dbh->errstr();
$locksql->execute() or die "Cannot execute: ".$locksql->errstr();
@lock = $locksql->fetchrow_array;
print @lock;


Does any body know how to query from V$ dynamic table?

TKS

Linda XU
Oracle DBA
General Magic
[EMAIL PROTECTED]