- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Commands/Script to Compare Oracle Performance
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-16-2005 08:39 AM
тАО03-16-2005 08:39 AM
Commands/Script to Compare Oracle Performance
I have 1 TB instance that's on 2 environments -- one is stored as RAW and the other Filesystems.
Nothing fancy.. probably simple querys to do some decent comparison.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-16-2005 09:20 AM
тАО03-16-2005 09:20 AM
Re: Commands/Script to Compare Oracle Performance
http://www.oracle.com/technology/pub/notes/technote_dms.html
A possibly helpful white paper.
http://oracle.ittoolbox.com/nav/t.asp?t=379&p=379&h1=379
Your dba should be able to write some scripts that test performance of the database alone.
There are some third party products that you have to purchase for the same purpose.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-16-2005 09:49 AM
тАО03-16-2005 09:49 AM
Re: Commands/Script to Compare Oracle Performance
Are the loads the same on both servers such that a statspack compare would be useful? If loads are not the same - then you've got a different problem.
Since you're looking at concurrency for raw i/o vs filesystem - then I think you're mainly going to be faced with testing with something that generates a fair amount of writes, and concurrency.
I know you've asked for something simple, but once statspack is setup, is actually quite simple to run reports from. You asked for simple queries, and I'm not sure that's going to get you any where...
But, lets say you do a
create table junk as select a.a,a.b,a.c, b.a,b.b,b.c from employees a, users b
where a.empid = b.empid;
I'm supposing that you can get two large tables you can join for this... in my example I'm just
Now, run them concurrently as a parallel query...
create table junk as select /*+PARALLEL(inventory_parts 12) */ a.a,a.b,a.c, b.a,b.b,b.c from inventory_parts a, inventory_kits b
where a.invid = b.kitid;
Run again at level 32 or something insane...
Now, run them all on the other server.
Check your timings, see what you've got.
You may not need to join two tables to create your new one, you could also check it out just pulling from a single table...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-16-2005 09:51 AM
тАО03-16-2005 09:51 AM
Re: Commands/Script to Compare Oracle Performance
at the same time.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-16-2005 10:12 AM
тАО03-16-2005 10:12 AM
Re: Commands/Script to Compare Oracle Performance
When you're done - I'd be interested in hearing how much different the two systems are. It'd be great if you could post a summary of whatever you used to determine the differences and how it panned out. Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-16-2005 03:56 PM
тАО03-16-2005 03:56 PM
Re: Commands/Script to Compare Oracle Performance
as john mentioned above, a 15mins (not more) snap at different time intervals will definitely help in doing this.
Another method would require you to intervene at the database level and write down plsql code and analyze using SQL_TRACE.
Operations that you may want to compare would be:
1. Bulk insert
2. Single-row inserts
3. Bulk update
4. Single-row updates
5. Bulk delete
6. Single-row deletes
This benchmark will conclusively show how well each system is doing. No guessing involved!
hope this helps!
regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-18-2005 12:48 AM
тАО03-18-2005 12:48 AM