Results 1 to 2 of 2

Thread: i need advice

  1. #1
    Join Date
    Sep 2003
    Location
    kerala
    Posts
    24

    Unanswered: i need advice

    hi
    i need advice in two area

    1) i have two tables. pra_cust_rec and cust_rec.i wanna to update category_code of pra_cust_rec with category code of cust_rec
    i gave the update statement like this
    update pra_cust_rec a
    set a.category_code=(select category_code from cust_rec
    where unique_code=a.unique_code)
    unfortunatyly it took a lot of time
    can u suggest a better query
    2) my server is with two processers. i wanna to implemnt paralle query.
    i made this cahnge in init.ora
    1)parallel_min_servers=12
    parallel_max_server=60

    and i tried with this two cammands
    1) select sum(calls),sum(rent) from bill group by exg_code.My bill table is with 37 lakh records
    it responed iwth 1 minute
    next i tried
    1) select /*+ PARALLEL (bill,6) */ sum(calls),sum(rent) from bill
    group by exg_code
    it responded with 3 mints
    can u tell me..where i went wrong
    regards
    Praveen

  2. #2
    Join Date
    May 2003
    Location
    France
    Posts
    112

    Re: i need advice

    Hi,
    For the first question, check indexes on pra_cust_reg(unique_code) and cust_reg(unique_code).

    About 2nd question, parrellism is not always the best solution for improvment.

    Originally posted by praveenagri
    hi
    i need advice in two area

    1) i have two tables. pra_cust_rec and cust_rec.i wanna to update category_code of pra_cust_rec with category code of cust_rec
    i gave the update statement like this
    update pra_cust_rec a
    set a.category_code=(select category_code from cust_rec
    where unique_code=a.unique_code)
    unfortunatyly it took a lot of time
    can u suggest a better query
    2) my server is with two processers. i wanna to implemnt paralle query.
    i made this cahnge in init.ora
    1)parallel_min_servers=12
    parallel_max_server=60

    and i tried with this two cammands
    1) select sum(calls),sum(rent) from bill group by exg_code.My bill table is with 37 lakh records
    it responed iwth 1 minute
    next i tried
    1) select /*+ PARALLEL (bill,6) */ sum(calls),sum(rent) from bill
    group by exg_code
    it responded with 3 mints
    can u tell me..where i went wrong
    regards
    Praveen

Posting Permissions

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