Database Reference
In-Depth Information
The total space needed for the default 128 users therefore is approximately 10,240 MB. Larger data volumes
require a larger value for the SCALE variable. If you are considering increasing the data set by adding more users, then
don't. Comments in the setup script indicate that the tested maximum number of users is 128, so instead of increasing
their number, you should use the SCALE variable.
The data is loaded into the database by calling the setup.sh script. It takes two parameters: the tablespace to
store the data on, and optionally the number of users:
[oracle@server1 SLOB]$ ./setup.sh
FATAL: ./setup.sh args
Usage : ./setup.sh: <tablespace name> <optional: number of users>
[oracle@server1 SLOB]$ ./setup.sh IOPS 128
NOTIFY: Load Parameters (slob.conf):
LOAD_PARALLEL_DEGREE == 12
SCALE == 10000
ADMIN_SQLNET_SERVICE == ""
CONNECT_STRING == "/ as sysdba"
NON_ADMIN_CONNECT_STRING ==
NOTIFY: Testing connectivity to the instance to validate slob.conf settings.
NOTIFY: ./setup.sh: Successful test connection: "sqlplus -L / as sysdba"
NOTIFY: Creating and loading seed table.
Table created.
PL/SQL procedure successfully completed.
NOTIFY: Seed table loading procedure has exited.
NOTIFY: Setting up user 1 2 3 4 5 6 7 8 9 10 11 12
[...]
NOTIFY: Setting up user 121 122 123 124 125 126 127 128
Table dropped.
NOTIFY: ./setup.sh: Loading procedure complete (158 seconds). Please check
./cr_tab_and_load.out for any errors
[oracle@server1 SLOB]$
Depending on the quality of your storage subsystem, this process can take a little while. You should heed the
advice and check the logfile for errors.
Search WWH ::




Custom Search