Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Location
    India
    Posts
    30

    Question Unanswered: How DBMS determines shared/private sort

    Hi All,

    Can anybody explains How the database manger /Optimizer determines sort will be of kind shared or private, because in each case memory sources are different .

    Appreciates your quick response

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: How DBMS determines shared/private sort

    A shared sort happens when the co-ordinator agent 'spawns' subagents to perform a bit of SQL ... Memory is allocated from the database shared memory, so that all the sub-agents can use the memory for sorting ... This happens when INTRA_PARALLEL is set to YES ..

    A private sort happens when the co-ordinator agent executes the SQL ... Memory is allocated from the agent's private memory ...

    Even if INTRA_PARALLEL is enabled, depending on the query, the optimizer may decide to use private sorts ...

    HTH

    Sathyaram

    Originally posted by pushp
    Hi All,

    Can anybody explains How the database manger /Optimizer determines sort will be of kind shared or private, because in each case memory sources are different .

    Appreciates your quick response
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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