Note: The default ORABM test user will be built in the tools table space, if you want to put the data in other table space can modify the orabm_user.sql to adjust.
3. The installation steps are as follows:
#
Operation
Command
1
Create the ORABM user (assumes TOOLS tablespace, TEMP temporary tablespace)
Sqlplus system/pwd @orabm_user
2
Create the Tables
Sqlplus system/pwd @orabm_tab
3
Load the data
$ orabmload Warehouses 1
4
Create the Indexes
Sqlplus system/pwd @orabm_ind
5
Analyze the tables and indexes
Sqlplus system/pwd @orabm_analyze
6
Create the Stress-test pl/sql procedures
Sqlplus system/pwd @orabm_serverside_stress
7
Cache the table and index data in the SGA
Sqlplus system/pwd @orabm_cache
4. Installation log and the following
$ sqlplus "/as SYSDBA" @orabm_userSQL *plus:release 9.2.0.4.0-production on Sat Sep 17:55:40 2004Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to:oracle9i Enterprise Edition release 9.2.0.4.0-64bit productionwith The partitioning, OLAP and Oracle Data M Ining optionsjserver release 9.2.0.4.0-productionuser created. Grant succeeded. User altered. User altered. Revoke succeeded. Disconnected from oracle9i Enterprise Edition release 9.2.0.4.0-64bit productionwith The partitioning, OLAP and Oracle D ATA Mining optionsjserver release 9.2.0.4.0-production$ sqlplus "/As SYSDBA" @orabm_tabSQL *plus:release 9.2.0.4.0-PR Oduction on Sat Sep 17:55:56 2004Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to:oracle9i Enterprise Edition release 9.2.0.4.0-64bit productionwith The partitioning, OLAP and Oracle Data M Ining optionsjserver release 9.2.0.4.0-productiontable created. Table created. Table created. Table created. Table creatEd. Table created. Table created. Table created. Table created. Disconnected from oracle9i Enterprise Edition release 9.2.0.4.0-64bit productionwith The partitioning, OLAP and Oracle D ATA Mining optionsjserver release 9.2.0.4.0-production$ CD. $ lsbin Install orabm.htm orabm.pdf orabm_files src$ cd bin$ lslinux orabm.linuxd2.log Orabm_tps.awk orabm_tps.sh Solaris windows$ CD solaris$ lsorabm orabmload$./orabmload Warehouse 1ld.so.1:./orabmload:fatal:/opt/oracle/product/9.2.0/ Lib/libclntsh.so.9.0:wrong ELF class:elfclass64killed$ Ld_library_path=${oracle_home}/lib32:${ld_library_path} Export Ld_library_path $./orabmload warehouses 1Connected to ORACLE as user:orabmusing TIMESTAMP=20040925181524TPCC Data Load started ... Loading Item ............ ... 100000Item done. Loading Warehouse Loading the Stock wid=1 ........ .....100000 done.loading districtloading customer for did=1, Wid=1...customer done.loading customer for did=2, wid=1...cu Stomer done.loading customer for did=3, Wid=1...customer done.loading customer for did=4, Wid=1...customer done.loading Cu Stomer for did=5, Wid=1...customer done.loading customer for did=6, Wid=1...customer done.loading customer for did=7, WID= 1...Customer done.loading customer for did=8, Wid=1...customer done.loading customer for did=9, Wid=1...customer Done.loa Ding Customer for did=10, Wid=1...customer done.loading Orders for d=1, w= 1. 1000.2000. 3000Orders done.loading Orders for d=2, w= 1. 1000.2000. 3000Orders done.loading Orders for d=3, w= 1. 1000.2000. 3000Orders done.loading Orders for d=4, w= 1. 1000.2000. 3000Orders done.loading Orders for d=5, w= 1. 1000.2000. 3000Orders done.loading Orders for d=6, w= 1. 1000.2000. 3000Orders done.loading Orders for d=7, w= 1. 1000.2000. 3000Orders done.loading Orders for D=8, w= 1. 1000.2000. 3000Orders done.loading Orders for d=9, w= 1. 1000.2000. 3000Orders done.loading Orders for d=10, w= 1. 1000.2000. 3000Orders done .... DATA LOADING COMPLETED successfully.$ CD. /.. /install$ lsorabm_analyze.sql orabm_ind.sql orabm_serverside_stress.sql orabm_tab_rm.sqlorabm_cache.sql orabm_query _cache.sql orabm_tab.sql orabm_user.sql$ sqlplus "/As SYSDBA" @orabm_indSQL *plus:release 9.2.0.4.0-production on Sat S EP 18:31:05 2004Copyright (C) 1982, 2002, Oracle Corporation. All rights reserved. Connected to:oracle9i Enterprise Edition release 9.2.0.4.0-64bit productionwith The partitioning, OLAP and Oracle Data M Ining optionsjserver release 9.2.0.4.0-productiondoc> *doc> * Same indexes as used to Oracle record breaking 32-CP udoc> * RAC tpc-c benchmark on linux-sept 2002doc> *doc> * Geoff Ingram (geoff@dbcool.com) doc> */session alt Ered. Index created. Index created. Index created. Index created. Index created. Index created. IndexCreated. Index created. Index created. Index created. Disconnected from oracle9i Enterprise Edition release 9.2.0.4.0-64bit productionwith The partitioning, OLAP and Oracle D ATA Mining optionsjserver release 9.2.0.4.0-production$ sqlplus "/As SYSDBA" @orabm_analyzeSQL *plus:release 9.2.0.4.0 -Production on Sat Sep 18:32:17 2004Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to:oracle9i Enterprise Edition release 9.2.0.4.0-64bit productionwith The partitioning, OLAP and Oracle Data M Ining optionsjserver release 9.2.0.4.0-productionsession altered. Table analyzed. Table analyzed. Table analyzed. Table analyzed. Table analyzed. Table analyzed. Table analyzed. Table analyzed. Table analyzed. Index analyzed. Index analyzed. Index analyzed. Index analyzed. Index analyzed. Index analyzed. Index analyzed. Index analyzed. Index analyzed. Index analyzed. Disconnected from oracle9i Enterprise Edition release 9.2.0.4.0-64bit productionwith The partitioning, OLAP and Oracle D AtaMining optionsjserver Release 9.2.0.4.0-production$ sqlplus "/As SYSDBA" @orabm_serverside_stressSQL *plus:release 9.2. 0.4.0-production on Sat Sep 18:35:50 2004Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to:oracle9i Enterprise Edition release 9.2.0.4.0-64bit productionwith The partitioning, OLAP and Oracle Data M Ining optionsjserver Release 9.2.0.4.0-productiondoc> *doc> * v2.0doc> *doc> * Copyright (c) 2002, Geoff Ing RAM (geoff@dbcool.com)-Proton Technology ltddoc> *doc> * orabm_serverside_stress.sql:Oracle package for CPU stres S test benchmarkdoc> *doc> * Distribute Orabm_serverside_stress.sql under the terms of either thedoc> * W Idely available GNU License or the artistic licensedoc> * with the exception, that it cannot is placed on A CD-ROM or similar mediadoc> * for commercial distribution without the prior of the approval. Doc> *doc> */procedure created. Procedure CreaTed. Procedure created. Procedure created. Disconnected from oracle9i Enterprise Edition release 9.2.0.4.0-64bit productionwith The partitioning, OLAP and Oracle D ATA Mining optionsjserver release 9.2.0.4.0-production$ sqlplus "/As SYSDBA" @orabm_cacheSQL *plus:release 9.2.0.4.0- Production on Sat Sep 18:36:07 2004Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to:oracle9i Enterprise Edition release 9.2.0.4.0-64bit productionwith The partitioning, OLAP and Oracle Data M Ining optionsjserver release 9.2.0.4.0-productiontable altered. COUNT (*)----------30000Table altered. COUNT (*)----------10Table altered. COUNT (*)----------30000Table altered. COUNT (*)----------299952Table altered. COUNT (*)----------100000 count (*)----------30000 count (*)----------30000 count (*)----------100000 count (*)-------- --299952 count (*)----------30000 count (*)----------30000 count (*)----------100000Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0-64bit Productionwith The partitioning, OLAP and Oracle Data Mining optionsjserver release 9.2.0.4.0-production
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.