require code

Hi All,

 i want to gather memory details(physical memory,free memory,used memory) from a server and insert into a local database table which is then  inserts in to a remote table as repository database,

this proc will execute in every database in the server and i would also need to filter duplicate values

i need to write a proc with an optional in parameter,as im dba and have very little knowledge in plsql can someone please give any tips on this..

Thanks