Results 1 to 2 of 2

Thread: DB Parameters

  1. #1
    Join Date
    Aug 2003
    Posts
    14

    Arrow Unanswered: DB Parameters

    I created a database in Oracle 9i. My application is a OLTP Application having 10 Tables only.But 4 of them having 10 lacs of Rows each(out of 10) . Now suggest me What are the Precautions i have to take for setting the


    Shared Pool size
    Large_pool_size
    db_cache_size
    DB_BLOCK_SIZE=4096
    and any other parameters to work my database effectively with out creating any Problem

    And how many rollbacksegments i have to create public and private?
    Please specify the Rollback segment size?

    There are more updations and insertions on my Tables.
    And if any Suggetions for this one ..please tell me.....

  2. #2
    Join Date
    Aug 2003
    Posts
    14

    Re: DB Parameters

    Originally posted by srikanthdba
    I created a database in Oracle 9i. My application is a OLTP Application having 10 Tables only.But 4 of them having 10 lacs of Rows each(out of 10) . Now suggest me What are the Precautions i have to take for setting the


    Shared Pool size
    Large_pool_size
    db_cache_size
    DB_BLOCK_SIZE=4096
    and any other parameters to work my database effectively with out creating any Problem

    And how many rollbacksegments i have to create public and private?
    Please specify the Rollback segment size?

    There are more updations and insertions on my Tables.
    And if any Suggetions for this one ..please tell me.....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •