command to find os user for inactive sid

Posted on 2011-10-31
Last Modified: 2013-01-21
Hi Guys,
There is any way to find out the OS user from the trace file information, if SID is not active.
Question by:nirvairghuman
    LVL 73

    Expert Comment

    no,  sorry

    if the trace file doesn't have it and the sid is gone, then you can't track it
    LVL 73

    Accepted Solution

    if you have auditing turned on, you might be able to derive it by looking in dba_audit_trail and checking timestamps of activities.

    it's not 100% reliable, but it's better than nothing

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Suggested Solutions

    Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
    Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
    This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
    This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now