SQL> create tablespace perfstat datafile ‚d:\oracle\oradata\bankprod\perfstat.dbf‘ size 500m;Tablespace created.SQL> create user perfstat identified by „p_rfstat98“;User created.SQL> @spcreate… Installing Required PackagesPackage created.Grant succeeded.View created.Package body created.Package created.Synonym created.Grant succeeded.View created.Synonym created.View created.Synonym created.Synonym created.View created.Synonym created.View created.Synonym created…. Creating PERFSTAT user …Choose the PERFSTAT user’s password.Not specifying a password will result in the installation FAILINGSpecify PERFSTAT passwordEnter value for perfstat_password: p_rfstat98p_rfstat98PL/SQL procedure successfully completed.create user perfstat identified by p_rfstat98 *ERROR at line 1:ORA-01920: user name ‚PERFSTAT‘ conflicts with another user or role nameGrant succeeded.Grant succeeded.Grant succeeded.Grant succeeded.Grant succeeded.Grant succeeded.Below are the list of online tablespaces in this database.Decide which tablespace you wish to create the STATSPACK tablesand indexes. This will also be the PERFSTAT user’s default tablespace.Specifying the SYSTEM tablespace will result in the installationFAILING, as using SYSTEM for performance data is not supported.TABLESPACE_NAME CONTENTS—————————— ———DRSYS PERMANENTEXAMPLE PERMANENTINDX PERMANENTPERFSTAT PERMANENTTEMP TEMPORARYTOOLS PERMANENTUNDOTBS1 UNDOUSERS PERMANENTXDB PERMANENT9 rows selected.Specify PERFSTAT user’s default tablespaceEnter value for default_tablespace: perfstatUsing perfstat for the default tablespacePL/SQL procedure successfully completed.User altered.User altered.Choose the PERFSTAT user’s temporary tablespace.Specifying the SYSTEM tablespace will result in the installationFAILING, as using SYSTEM for the temporary tablespace is not recommended.Specify PERFSTAT user’s temporary tablespace.Enter value for temporary_tablespace: tempSynonym created.Synonym created.NOTE:SPCTAB complete. Please check spctab.lis for any errors.SQL> — Create the statistics PackageSQL> @@spcpkgSQL> RemSQL> Rem $Header: spcpkg.sql 10-may-2004.15:32:48 cdialeri Exp $SQL> RemSQL> Rem spcpkg.sqlSQL> RemSQL> Rem Copyright (c) 1999, 2004, Oracle. All rights reserved.SQL> RemSQL> Rem NAMESQL> Rem spcpkg.sqlSQL> RemSQL> Rem DESCRIPTIONSQL> Rem SQL*PLUS command file to create statistics packageSQL> RemSQL> Rem NOTESSQL> Rem Must be run as the STATSPACK owner, PERFSTATSQL> RemSQL> Rem MODIFIED (MM/DD/YY)SQL> Rem cdialeri 05/10/04 – 3566569SQL> Rem vbarrier 03/20/02 – 2184504SQL> Rem spommere 03/19/02 – 2274095SQL> Rem vbarrier 03/05/02 – Segment StatisticsSQL> Rem spommere 02/14/02 – cleanup RAC stats that are no longer neededSQL> Rem spommere 02/08/02 – 2212357SQL> Rem cdialeri 02/07/02 – 2218573SQL> Rem cdialeri 01/30/02 – 2184717SQL> Rem cdialeri 01/09/02 – 9.2 – features 2SQL> Rem cdialeri 11/30/01 – 9.2 – features 1SQL> Rem hbergh 08/23/01 – 1940915: use substrb on sql_textSQL> Rem cdialeri 04/26/01 – 9.0SQL> Rem cdialeri 09/12/00 – sp_1404195SQL> Rem cdialeri 04/07/00 – 1261813SQL> Rem cdialeri 03/28/00 – sp_purgeSQL> Rem cdialeri 02/16/00 – 1191805SQL> Rem cdialeri 11/01/99 – Enhance, 1059172SQL> Rem cgervasi 06/16/98 – Remove references to wrqsSQL> Rem cmlim 07/30/97 – Modified system eventsSQL> Rem gwood.uk 02/30/94 – ModifiedSQL> Rem densor.uk 03/31/93 – ModifiedSQL> Rem cellis.uk 11/15/89 – CreatedSQL> RemSQL>SQL> set echo off;Creating Package STATSPACK…Package created.No errors.Creating Package Body STATSPACK…Package body created.No errors.NOTE:SPCPKG complete. Please check spcpkg.lis for any errors.



Komentáře