+ Reply to Thread
Results 1 to 3 of 3
  1. 02-01-2001 02:34 PM #1
    fmedina
    fmedina is offline Junior Member
    Join Date
    Jan 2001
    Posts
    32

    Unhappy

    all session have the optimazer goal CHOOSE, but i want set optimizer goal RULE, how can i do it?



    Reply With Quote Reply With Quote
  2. 02-01-2001 02:38 PM #2
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    alter session set optimizer_goal=rule

    See ( [url]http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a85397/statem18.htm#2053036[/url] ) for other options.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."
    Reply With Quote Reply With Quote
  3. 02-01-2001 02:58 PM #3
    fmedina
    fmedina is offline Junior Member
    Join Date
    Jan 2001
    Posts
    32

    Unhappy and another session

    how can change the optimazer goal in other session?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

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

Forum Rules

 Click Here to Expand Forum to Full Width