Home » RDBMS Server » Performance Tuning » while taking performance measeure ?
while taking performance measeure ? [message #273836] Thu, 11 October 2007 19:08 Go to next message
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
Re: while taking performance measeure ? [message #273850 is a reply to message #273836] Thu, 11 October 2007 23:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
None of them.
Connect as a user you create for this.

Regards
Michel
Re: while taking performance measeure ? [message #274334 is a reply to message #273850] Mon, 15 October 2007 11:03 Go to previous messageGo to next message
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:


Re: while taking performance measeure ? [message #274335 is a reply to message #274334] Mon, 15 October 2007 11:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
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
Re: while taking performance measeure ? [message #274336 is a reply to message #273836] Mon, 15 October 2007 11:32 Go to previous messageGo to next message
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.

Re: while taking performance measeure ? [message #274337 is a reply to message #273836] Mon, 15 October 2007 11:39 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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?

Re: while taking performance measeure ? [message #274338 is a reply to message #274337] Mon, 15 October 2007 11:51 Go to previous messageGo to next message
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.
Re: while taking performance measeure ? [message #274343 is a reply to message #274338] Mon, 15 October 2007 12:12 Go to previous message
Michel Cadot
Messages: 64139
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
Previous Topic: degradation after restart
Next Topic: Keep buffer &recycle cache size
Goto Forum:
  


Current Time: Thu Dec 08 08:19:28 CST 2016

Total time taken to generate the page: 0.13596 seconds