RE: How do I check to see who is logged into the database

RE: How do I check to see who is logged into the database

 

  


How can one find out, when a table was last updated or when was the last
time an insert was done on that table.

Thanks


Robert A. Akonji
Sr. Oracle DBA
Brightpoint Inc.
Plainfield, Indiana
46168 USA
Tel: 317 707 2318
Fax: 317 707 2397
Cell: 317 509 0497


-----Original Message-----
From: Manash Baruah
[mailto:oracledba-ezmlmshield-x31566651.[Email address protected]
Sent: Thursday, February 28, 2008 11:55 AM
To: LazyDBA Discussion
Subject: RE: How do I check to see who is logged into the database



Abhijeet,

There are three ways as far as I recall:

1. Use the DELETE method of the recordset object you have created for
the table
2. Use the ConnectionObject.Execute "DELETE FROM TABLE_NAME"
3. Use the Delete method of the DATA control Active-X control (if) you
are using.

Thanks & Regards,

Manash Partim Baruah
MS-LCS| DBA| Tech Mahindra Ltd.
Sharda Center, 6th Floor Annex Building, Pune-4, India
www.techmahindra.com


-----Original Message-----
From: Abhijeet Bhurke [mailto:abhijeet-[Email address protected]
Sent: Thursday, February 28, 2008 12:39 PM
To: Manash Baruah
Subject: RE: How do I check to see who is logged into the database

**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email, **and removed
any attachments, and kept your email address secret **from this person,
and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal **Anything below this line is the original email text


Dear All,

Please help me.

I want to delete data from some table in Oracle 10G. I am using VB 6.0
front end & oracle as backend.

What script should I write.

Please mail.



Thanks & regards,
Abhijeet Bhurke
MIS

Ph: 07292-255021 Ext. 129
Mob: (0)9826781621
-----Original Message-----
From: Manash Baruah
[Email address protected]
Sent: Monday, February 25, 2008 9:46 PM
To: LazyDBA Discussion
Subject: RE: How do I check to see who is logged into the database


This will help:

SELECT
SID,SERIAL#,USERNAME,STATUS,OSUSER,MACHINE,PROGRAM
FROM v$session WHERE TYPE='USER' ;


Thanks & Regards,

Manash Partim Baruah
MS-LCS| DBA| Tech Mahindra Ltd.
Sharda Center, 6th Floor Annex Building, Pune-4, India
www.techmahindra.com


-----Original Message-----
From: Sikyala Raquel [USA]
[mailto:oracledba-ezmlmshield-x84228228.[Email address protected]
Sent: Monday, February 25, 2008 9:38 PM
To: LazyDBA Discussion
Subject: How do I check to see who is logged into the database

What is the syntax I would use to check to see if there is anyone logged
into the database?



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



========================================================================
====
================================================


Disclaimer:

This message and the information contained herein is proprietary and
confidential and subject to the Tech Mahindra policy statement, you may
review the policy at <a
href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahind
ra.c
om/Disclaimer.html</a> externally and <a
href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahind
ra.c
om/Disclaimer.html</a> internally within Tech Mahindra.

========================================================================
====
================================================


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html







========================================================================
====================================================


Disclaimer:

This message and the information contained herein is proprietary and
confidential and subject to the Tech Mahindra policy statement, you may
review the policy at <a
href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahind
ra.com/Disclaimer.html</a> externally and <a
href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahind
ra.com/Disclaimer.html</a> internally within Tech Mahindra.

========================================================================
====================================================


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page