#
# Oracle Performance Tuning Chapter 11 p. 235
# Setting Rollback Segment Size
#
    CREATE ROLLBACK SEGMENT ROLB_ONIGHT
        TABLESPACE ROLB_TSPACE
        STORAGE (INITIAL        5M
                NEXT            5M
                MINEXTENTS      4
                MAXEXTENTS      121
                PCTINCREASE     0)
#
# Oracle Performance Tuning Chapter 11 p. 236
# Setting Rollback Segment Size
#
    CREATE ROLLBACK SEGMENT ROLB_ONIGHT
        TABLESPACE ROLB_TSPACE
        STORAGE (INITIAL        5M
                NEXT            5M
                MINEXTENTS      4
                MAXEXTENTS      121
                OPTIMAL         40M)
#
# Oracle Performance Tuning Chapter 11 p. 238
# Calculating the Size of the Table
#
    SELECT AVG ((NVL(VSIZE(APPLIC_ID),0)+1)
        +  (NVL(VSIZE(CATEGORY),0)+1
        +  (NVL(VSIZE(CHANGED_DATE),0)+1)
        +  (NVL(VSIZE(DESCR_LINE),0)+1)) +5
        FROM APPLICATION;
#
# Oracle Performance Tuning Chapter 11 p. 245
# Calculating the Size of an Index
#
    SELECT NAME  "INDEX NAME",
        BLOCKS * 4096 "BYTES ALLOCATED",
        BTREE_SPACE "BYTES UTILIZED",
        (BTREE_SPACE / (BLOCKS * 4096)) * 100 "PERCENT USED"
        FROM INDEX_STATS;
#
# Oracle Performance Tuning Chapter 11 p. 246
# Creating Views
#
    SELECT  *
        FROM VIEW_NAME
        WHERE ROWNUM < 5;
#
    CREATE VIEW RUNNING_TOTALS
    SELECT    D.NAME, SUM(T.FIGURE)
        FROM  DOMAIN D, TRANSACTION T
        WHERE D.ACC_NO = T.ACC_NO
        GROUP BY D.NAME;
#
    SELECT    D.NAME
        FROM  DOMAIN D, TRANSACTION T
        WHERE D.ACC_NO - T.ACC_NO
        AND   ROWNUM < 5;
#
# Oracle Performance Tuning Chapter 11 p. 247
# Creating Users
#
# In Version 6, issue commands like the following:
    ALTER USER GURRY DEFAULT TABLESPACE USER_TSPACE
#        TEMPORARY TABLESPACE OLTP_TEMP_TSPACE;
    GRANT RESOURCE (5M) ON USER_TSPACE TO GURRY;
#
# In Version 7, issue:
    ALTER USER GURRY DEFAULT TABLESPACE USER_TSPACE
#        TEMPORARY TABLESPACE OLTP_TEMP_TSPACE;
    ALTER USER GURRY QUOTA 5M ON USER_TSPACE;
#
# Oracle Performance Tuning Chapter 11 p. 247-248
# Creating Users
#
    CREATE PROFILE AD_HOC 
    LIMIT
    SESSIONS_PER_USER          2    
    CPU_PER_SESSION            20000
    CPU_PER_CALL               20000
    CONNECT_TIME               120
    IDLE_TIME                  30
    LOGICAL_READS_PER_SESSION  UNLIMITED
    LOGICAL_READS_PER_CALL     UNLIMITED;

    ALTER USER GURRY PROFILE AD_HOC;
#