Results 1 to 3 of 3

Thread: Unused Synonyms

  1. #1
    Join Date
    Mar 2004
    Location
    India
    Posts
    87

    Unhappy Unanswered: Unused Synonyms

    Hi,
    Is there any way to find out which all synonyms have not been used even once in the database. I am aware of MONITORING option for tables and indexes. Is there anything that can help me for synonyms
    Thanks!

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    As far as I know: no.

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    I can think of only one way to get close to accomplishing what the OP wants.
    OP could enable AUDIT on synonym creation.
    After that was done then SYS.AUD$ would contain a record of every SYNONYM created from that point in time forward.
    Of course this assumes that no AUD$ records ever get deleted.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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