Hi,
I m doing one project, which is related to oracle workload detection. I have to find which workload is runing now.
I want to know about how we can take the data from oracle viwes(instances) as the performance of oracle workload by using TPC-c and TPC-H banchmark, by dynamic table that are easly as by select query also I want to know that how to retrive data from oracle diagnostic tool(performance of workload).If any one knows plz help me....

Thank you
Vini.....