Oracle user privileges

[Bruzé 0]

Hi, I´m curious about user privileges in oracle.I´ve been search on internet but a i can´t get the information

 

I just wanna know what kind of privileges for user to access oracle database by Wapt??For Database Performance...

Just a user with Grant to create session is enough???

 

Thanks all.

[sergei 0]

User should have privileges to do SELECT in the system table "v$sysstat".

[Bruzé 0]

Thanks for the answer!!

 

You are right, searching on wapt i found a Function SQLMonitor with this:

 

function SQLMonitor()

{

return counter.SQLGetValue("SELECT \"VALUE\" FROM v$sysstat WHERE \"STATISTIC#\"=230");

}

 

 

I just need to confirm this to pass the information.

 

Thanks again... =)

[sergei 0]

Yes, WAPT uses SQL queries to collect a performance data from Oracle server. And you can add your own counters.