2 Oracle DBAs Needed..Rapid City, South Dakota..

From: OraStaff <orastaff_at_mindspring.com>
Date: Thu, 3 Aug 2000 10:57:13 -0400 (EDT)
Message-Id: <10578.113735@fatcity.com>

*Description:
Rapid City, South Dakota client needs 2 Oracle DBAs to join its' I.T. team. These positions will have typical DBA responsibilities: physical database design,
installations,performance analysis, system tuning, backup, recovery, etc. These are full time staff positions.

Requirements:
- 2-3+ yrs Oracle DBA experience.
- Unix
- U.S. Citizenship or permanent residency

This position offers:

Opportunity to become a key member of the team
Compensation D.O.E...up to in the 60s
Challenge
Relocation Assistance

NO sub contracting positions available.

*U.S. citizenship or green card holders only

PLEASE do not send your resume if you are not in the United States.

For immediate consideration, please send your resume as an attachment to:
Bill Law,
Oracle Placement Specialist
OraStaff, Inc.
Ph: 1-800-549-8502-Please do not call if you need sponsorship
Email: orastaff_at_mindspring.com
Please use job code: DBA/Rapid City/Monte/one

Note: This is only one of the many opportunities that we have available across the U.S.
for candidates with Oracle skills who are U.S. citizens or permanent residents.
So if this one is not a match for you, we invite you to send us your resume- as we quite possibly have the opportunity that you are seeking.

We pay referral fees.
So please contact me if you know of anyone who would be qualified/interested
in the posiition described above- if it is not a match for you.
Thanks,
Bill Law

From: "Vidya Kalyanaraman" <kvidya13_at_hotmail.com> Date: Thu, 03 Aug 2000 10:59:53 EDT
Subject: Re: locks?

Pls have a look at the following query... I got it from one of the lists...
set linesize 200
set pagesize 40

col object_name format a25
col object_id format 999999 heading 'OBJ|ID'
col locked_mode format 999 heading 'OBJ|LCK'

col lmode format 999 heading 'SES|LCK'
col sid format 999
col status format a8
col Descrip format a10
col type format a4
col Blk heading 'BLK?'
select b.object_name,a.object_id,a.locked_mode,c.lmode, decode(c.lmode,0,'None',1,'Null',2,'Row-S',3,'Row-X',4,'Share',5,'S/Row-X',6 ,'Exclusive') Descrip,

d.sid,d.serial#,d.status, c.ctime,decode(c.block,0,'No',1,'Yes') Received on Thu Aug 03 2000 - 09:57:13 CDT