Jump to content


Photo

Oracle user privileges


  • Please log in to reply
3 replies to this topic

#1 kogue

kogue

    Newbie

  • Members
  • Pip
  • 2 posts

Posted 20 August 2013 - 01:17 PM

Hi, Im curious about user privileges in oracle.Ive been search on internet but a i cant 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.

#2 Sergei Leonov

Sergei Leonov

    Advanced Member

  • Administrators
  • PipPipPip
  • 662 posts

Posted 22 August 2013 - 09:37 AM

User should have privileges to do SELECT in the system table "v$sysstat".
Sergei Leonov
WAPT Project Manager
SoftLogica LLC

Office: +7-383-335-6692
Toll-free: 1-888-364-6797 (for US only)
Time zone GMT +6, EST +11
E-mail: support@loadtestingtool.com
http://www.loadtestingtool.com

#3 kogue

kogue

    Newbie

  • Members
  • Pip
  • 2 posts

Posted 23 August 2013 - 01:05 PM

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... =)

#4 Sergei Leonov

Sergei Leonov

    Advanced Member

  • Administrators
  • PipPipPip
  • 662 posts

Posted 26 August 2013 - 09:38 AM

Yes, WAPT uses SQL queries to collect a performance data from Oracle server. And you can add your own counters.
Sergei Leonov
WAPT Project Manager
SoftLogica LLC

Office: +7-383-335-6692
Toll-free: 1-888-364-6797 (for US only)
Time zone GMT +6, EST +11
E-mail: support@loadtestingtool.com
http://www.loadtestingtool.com




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users