Schema usage in Oracle
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Schema usage in Oracle

Hybrid View

  1. #1
    Join Date
    Jan 2001
    Posts
    2,828

    Schema usage in Oracle

    Hi DBAs,

    Can somebody tell me how to find whether a particular schema is being used or not in a oracle database.

    Like I have created one user and not accessed it in last one month, should be considered as "not in use".


    Thanx & Regds
    Jignesh

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Simply lock the account and wait to see if someone complains
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  3. #3
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Originally posted by SANJAY_G
    Simply lock the account and wait to see if someone complains
    Nice but.....

    It won't stop someone accessing the schemas objects from another user account.
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  4. #4
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Originally posted by jovery
    Nice but.....

    It won't stop someone accessing the schemas objects from another user account.
    Clever!
    My understanding from original post was: "If the user didn't login for a certain period then the account is considered 'not in use'"

    At object level auditing can be set using this:
    How often tables are accessed (AUDIT)
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  5. #5
    Join Date
    Jan 2001
    Posts
    2,828
    Hi Sanjay

    Thank you that script would do.

    regards
    Hrishy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width