sample data to test Oracle database performance [message #65055] |
Thu, 08 April 2004 18:48 |
lakshmi
Messages: 22 Registered: July 2000
|
Junior Member |
|
|
Hi,
I'm working on a project on Oracle database performance tuning. Before implementing the changes/tuned parameters on the live database,i need to test it on a small Oracle8 database with sample data. The sample data should be such that it would test each of the performance determinant of my database.
Can anyone suggest where i can get such data samples to test the performance of an Oracle database?
Thanks
Lakshmi
|
|
|
Re: sample data to test Oracle database performance [message #65056 is a reply to message #65055] |
Thu, 08 April 2004 22:09 |
Daljit Singh
Messages: 290 Registered: October 2003 Location: Texas
|
Senior Member |
|
|
Hi,
Wht do u mean by "small database"? if u mean that first u want to apply the settings on a DB having less amount of data than ur prod db than u r doing a very big mistake. BCZ the cost based optimizer highly depends on the size, weight, selectivity, cardinality of the data, which in ur case will not match with the real picture. And the results on ur SMALL DATABASE would be totally different than ur prod DB.
According to me if u really want to check the setting than u should create an exact mirror copy of ur prod DB using MViews and go for the testing which would give u almost exact feel as ur prod db.
By the way can u share with us wht types of tuning parameters u r goung to test which will increase the performance.
Daljit Singh.
|
|
|
|
|