Help - Search - Members - Calendar
Full Version: Filling Oracle 10g Tablespaces with garbage (test) Data
Oracle DBA Forums > Oracle > Oracle Forum
aydistant
In an attempt to test something completely different, I find myself needing to fill tablespaces with 4+ GB of data very, very quickly.

My question is, does anyone know of a method in which I can fill a brand new tablespace with any specified amount of data without manually inputting all of it?

I need to test a potential defect on a 3rd party product when tablespaces are 4gb+ and my work load does not allow for the kind of time for 1 user to manually input that much data.

Thank you in advance.
dave
just do a looped instert with a pre-defined dataset of which you know the size
burleson
Hi Aydistant,

>> My question is, does anyone know of a method in which I can fill a brand new tablespace with any specified amount of data without manually inputting all of it?

You have many choices. Here is how to add numeric data to a table quickly:

http://www.dba-oracle.com/t_test_data_date...eration_sql.htm


************************************************
You can also populate test data from dictionary stuff:

create table mytest as select * from dba_objects

create table bigtable as select * from dba_hist_sqlstat;

Double the size:

insert into bigtable (select * from dba_hist_sqlstat);

************************************************

And you can generate test data with dbms_random too:

http://www.dba-oracle.com/oracle_tips_ault...random_data.htm

************************************************
If you want tools, there are several tools and methods for generating test data for Oracle:

http://www.dba-oracle.com/t_test_data_generation.htm

STATSPACK - You can easily write your own SQL capture, directly from the STATSPACK stats$sqlstat table.

AWR - AWR captures historical SQL in the dba_hist_sqlstat table.

SQL Tuning Sets This 10g tool grabs SQL from the library cache or Oracle.

SQL Performance Analyzer (SPA) This new 11g tool captures representative SQL workloads.

Mercury LoadRunner - A popular tools for simulating the real-world effect of an Oracle system change.

Quest Benchmark Factory - A complete environment for showing the effects of an Oracle change.

DBGEN - The TPC-H tools, dbgen and qgen allow for the development of anywhere from a gig to a terabyte databases.

Hammerora - The Hammerora product provides a means to create a pseudo-TPC-C database and generate loads against it.
aydistant
Thank you, very much - the prompt and informative replies should help considerably!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.