#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2014
    Posts
    21
    Rep Power
    0

    Archive log counts query


    Hi All,
    I would like to know whether is it possible to get archivelog generation count by schemawise for the previous dates. If possible can please share the query.

    Thanks
  2. #2
  3. Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Sep 2006
    Posts
    867
    Rep Power
    392

    Cool


    Originally Posted by Mitu08
    Hi All,
    I would like to know whether is it possible to get archivelog generation count by schemawise for the previous dates. If possible can please share the query.

    Thanks
    You cannot distinguish "schemawise" unless you use logminer.
    Otherwise you can query the V$ARCHIVED_LOG view.

IMN logo majestic logo threadwatch logo seochat tools logo