OraFAQ Forum: Performance Tuning » while taking performance measeure ?

Home » RDBMS Server » Performance Tuning » while taking performance measeure ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

while taking performance measeure ? [message #273836]

Thu, 11 October 2007 19:08

skumar.dba
Messages: 82
Registered: October 2007

Member

Hi Experts,

I am kumar, working as oracle dba. i read the all the document which i found in the links. it is very useful to me

i have one simple question. while measuring performance of the database, how would i login to database.

as sysdba or system/manager

Report message to a moderator

Re: while taking performance measeure ? [message #273850 is a reply to message #273836]

Thu, 11 October 2007 23:58

Michel Cadot
Messages: 68658
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

None of them.
Connect as a user you create for this.

Regards
Michel

Report message to a moderator

Re: while taking performance measeure ? [message #274334 is a reply to message #273850]

Mon, 15 October 2007 11:03

skumar.dba
Messages: 82
Registered: October 2007

Member

Michel,

how are you. Thanks for your reply.my question is do i need to create one uesr for measure performance.

if yes what are the role and priviliges i have to assign to that user.

one more problem is with AWR

i was connected as sysdba and i ran this script.

@C:\oracle\product\10.2.0\RDBMS\ADMIN\awrrpt.sql

then it is asking like this and i pass the parameters like this

Enter value for report_type: text
Enter value for num_days: 1
Enter value for begin_snap: 1001
Enter value for end_snap: 1003

after passing this values i am getting this error

declare
*
ERROR at line 1:
ORA-20200: Begin Snapshot Id 6394 does not exist for this database/instance
ORA-06512: at line 22

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

i am not able to understand what was the problem. could you please provide some information of this problem.

Quote:

Report message to a moderator

Re: while taking performance measeure ? [message #274335 is a reply to message #274334]

Mon, 15 October 2007 11:25

Michel Cadot
Messages: 68658
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Never use SYS but for maintenance purpose.

Create a new user.
I don't know what are the least needed privileges.
Give him DBA if you don't want to bother, study what you user has to do if you want to be strict (which is preferable but requires work).

Regards
Michel

Report message to a moderator

Re: while taking performance measeure ? [message #274336 is a reply to message #273836]

Mon, 15 October 2007 11:32

skumar.dba
Messages: 82
Registered: October 2007

Member

Michel,

Thanks for your reply.

one more thing is i want to know how many transactions are taking per minute in my database. how can i find this information.

Report message to a moderator

Re: while taking performance measeure ? [message #274337 is a reply to message #273836]

Mon, 15 October 2007 11:39

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>i want to know how many transactions are taking per minute in my database
One would be to use LOGMINER to count COMMITs.

While number of transactions sounds like an interesting number,
I am not clear how useful it is as a tuning metric.

Are all "transactions" created equal?

Are SELECT for reporting purposes counted as any transaction?

Report message to a moderator

Re: while taking performance measeure ? [message #274338 is a reply to message #274337]

Mon, 15 October 2007 11:51

skumar.dba
Messages: 82
Registered: October 2007

Member

Michel,

for a point in time (10:30 to 11:30) my database is very slow. taht time i checked that around 700 users are connected my database. some of them are running reprots and inserting data.

i thought it might be aproblem with shared pool and db buffer chahe.

i just want to know the no of tx, and parsing information, how many buffers are efficting.

Report message to a moderator

Re: while taking performance measeure ? [message #274343 is a reply to message #274338]

Mon, 15 October 2007 12:12

Michel Cadot
Messages: 68658
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Use AWR or Statspack to get this information.
Have a look at DBA_HIST% views.

Regards
Michel

Report message to a moderator

Previous Topic:	degradation after restart
Next Topic:	Keep buffer &recycle cache size

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 31 23:59:42 CDT 2024