develop metrics for grid control?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: develop metrics for grid control?

  1. #1
    Join Date
    Jun 2006
    Posts
    101

    develop metrics for grid control?

    Hi,

    Grid control doesnt collect statistics on number of rows in table plus other
    information which might be usefull...
    we have our own housekeeping procedure which works similar to grid control, just wondered
    if its possible to have our own developed metrics(developed using shell script/pl-sql) add to grid control?

    Thanks

  2. #2
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245
    yes you can have user defined metrics at various levels like host,db
    Rgds
    Parag

  3. #3
    Join Date
    Jun 2006
    Posts
    101
    thanks for your reply

    what about having historical information like number of rows in table gatherd/stored in grid, can we edit grid to keep such information too?

    Thanks

  4. #4
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245
    you cant change whatever metrics are present by default but can change the thresholds etc for those metrics.

    as i said you can have user defined metrics as per your wish.
    in your case you want "number of rows in table" this could be a db metric develop a script in perl or shell on your own and call it in User defined metric.
    Rgds
    Parag

  5. #5
    Join Date
    Jun 2006
    Posts
    101
    currently as part of our housekeeping we keep historical information about,table,database,tablespace sizes for couple of month so we can go back and have a look at it and do comparision if required to do so.... I undrestand that grid by default stores historical information about database performance etc ....
    can we extend this so it includes historical information on tablespace,size,tables row? (something that is not collected and stored in grid by default),

    Thanks

  6. #6
    Join Date
    Jun 2006
    Posts
    101
    hello , any ideas?

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