diff options
author | cvs2git <cvs2git> | 2010-12-27 00:04:45 +0000 |
---|---|---|
committer | cvs2git <cvs2git> | 2010-12-27 00:04:45 +0000 |
commit | c82d349f864e6bd9f96fd1156903bc1f7193a203 (patch) | |
tree | e117a87533656110b6acd56fc0ca64289892a9f5 /rt/README.Oracle | |
parent | 74e058c8a010ef6feb539248a550d0bb169c1e94 (diff) |
This commit was manufactured by cvs2svn to create tag 'TORRUS_1_0_9'.TORRUS_1_0_9
Diffstat (limited to 'rt/README.Oracle')
-rw-r--r-- | rt/README.Oracle | 41 |
1 files changed, 0 insertions, 41 deletions
diff --git a/rt/README.Oracle b/rt/README.Oracle deleted file mode 100644 index 9835b93e6..000000000 --- a/rt/README.Oracle +++ /dev/null @@ -1,41 +0,0 @@ -Since RT 3.8.2 RT deployment on Oracle database has been simplified. - -You don't need to create anything beforehead. During installation -an user is created and all RT's objects are created in his schema. -User is created with the following parameters: - - CREATE USER <DatabaseUser> IDENTIFIED BY <DatabasePassword> - DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP - QUOTA UNLIMITED ON USERS - -And as well granted with 'CONNECT' and 'RESOURCE'. It's up to you -to do decide how to manage users, change quotas, table spaces and -other. - -RT has option DatabaseName which is used to define SID of -the Oracle database. You don't have to setup TWO_TASK environment -variable or other helpers files for connection. - -Example: - - ./configure \ - --with-db-type=Oracle \ - --with-db-database=XE \ - --with-db-host=192.168.0.1 \ - --with-db-dba=system \ - --with-db-rt-user=rtdb1 \ - --with-db-rt-pass=rtdb1secret \ - ... other configure options ... - -This's all specifics of deployment on Oracle you should be aware -of. To complete installation you must follow general instructions -in the README file. - -As with all databases it is important to analyze the schema and get -current statistics after any significant dataset change. Oracle's -cost-based optimizer can provide particularly bad performance when the -schema statistics are significantly inaccurate. To analyze the schema -of a user called rt, execute the following from within sqlplus: - - execute dbms_utility.analyze_schema( 'RT', 'estimate'); - |