Home » RDBMS Server » Performance Tuning » Urgent: finding parameters from V$ Tables
Urgent: finding parameters from V$ Tables [message #65587] Wed, 03 November 2004 06:53 Go to next message
Bandaru
Messages: 1
Registered: November 2004
Junior Member
Hi all,
I am doing thesis in "SAP Sizing".For my sizing model I have taken the following parameters.

• Network Arrival Rate (A)
• Average Query Size (F)
• Initialization Time (I)
• Static Server Time (Y)
• Dynamic Server Rate (R)

Network arrival rate (A) is the average number of queries (i.e., "hits") received by the Database server each second. It is important to understand that A denotes an average and not an instantaneous value. Conceptually, it is often easier to mentally translate any reference to A into a corresponding "hits per day" value; just multiply A by 60*60*24 = 86,400.

Average Query size (F) is the average size (in bytes) of the queries served.

Initialization time (I), Static server time (Y), and Dynamic server rate (R) collectively describe the speed at which the Database server handles requests. I represent the average time required to perform parsing and execution for each statement. Y represents the time spent processing a buffer that is independent of the size of that buffer. Finally, R represents the rate (bytes/second) at which the server processes the buffer.

I am modelling the Database Server for mySAP.com.For analysing the model I need this test data.Can somebody tell me how can I find the test data from SAP R/3 Sytsem.Can we find them from V$ tables,if so from which tables.

Please let me know if you need any further information.

Your comments and suggestions are appreciated.
Thanks,
Phani K Bandaru

 
Re: Urgent: finding parameters from V$ Tables [message #65590 is a reply to message #65587] Wed, 03 November 2004 20:29 Go to previous message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Take a look at statspack

hth
Previous Topic: SQL Tuning
Next Topic: Memory grows steadily - Oracle 9i
Goto Forum:
  


Current Time: Fri Mar 29 10:22:58 CDT 2024