• RELEVANCY SCORE 4.01

    DB:4.01:Explain Plan Is Disabled - Why? s8




    Hi

    I was using SqlDeveloper 1.0 and had no problems using the Explain Plan feature. Now I upgraded to 1.1 (did not migrate settings) and now the explain plan button is always greyed out. Am I missing something to enable the explain plan feature?

    Thanks

    DB:4.01:Explain Plan Is Disabled - Why? s8

    Are all the buttons grayed out on the worksheet or just the explain plan button? If you look at your worksheet, is the drop list on the right hand side populated? i.e does it display your user connection? If not, select your connection in the drop kist and the icons will change from gray to available.

    You say in your message that you upgraded to 1.1. I assume you did a fresh install in a new directory.

    Regards
    Sue

  • RELEVANCY SCORE 3.50

    DB:3.50:Explain Plan Option Disabled zj




    Hi,

    When I take an Explain Plan using TKPROF it gives the following error:

    Error in CREATE TABLE of EXPLAIN PLAN table: APPS.prof$plan_table
    ORA-00955: name is already used by an existing object

    parse error offset: 18
    EXPLAIN PLAN option disabled.
    ********************************************************************************

    And the Explain Plan is snot displayed in the o/p file for all the queries.

    Can any one help me on this.

    Thanks,
    Kiran

    DB:3.50:Explain Plan Option Disabled zj

    Hi kiran

    When I take an Explain Plan using TKPROF it gives the following error:

    Error in CREATE TABLE of EXPLAIN PLAN table: APPS.prof$plan_table
    ORA-00955: name is already used by an existing object

    parse error offset: 18
    EXPLAIN PLAN option disabled.
    ********************************************************************************What is your Db verssion and EBS? What is your kprof syntax. By the way please check those doc adn see its helpful:

    Run Adadmin To Recreate Grants And Synonyms ORA-20000 ORA-00955 In Synonyms Loop:create_synonym(GL,PLAN_TABLE,APPS,PLAN_TABLE) [ID 437714.1]
    TKPROF With Explain Fails With ORA-00903 invalid table name [ID 257294.1]
    OERR: ORA 955 is already used by an existing object [ID 18549.1]

    Also check:
    Re: TKPROF and Explain Plan

    Regard
    Helios

  • RELEVANCY SCORE 3.39

    DB:3.39:Why Copy And Cut Icons Disabled? 98




    Hello everyone,

    pls can u explain why COPY and CUT in any form disabled while it is enabled in EDIT tool bar?
    and how can i make these icons enabled?

    DB:3.39:Why Copy And Cut Icons Disabled? 98

    Hello everyone,

    pls can u explain why COPY and CUT in any form disabled while it is enabled in EDIT tool bar?
    and how can i make these icons enabled?

  • RELEVANCY SCORE 3.29

    DB:3.29:Explain Plan pj


    in explain plan report what is the difference between nested loop and merge join

    DB:3.29:Explain Plan pj

    To add to the information Paulie made available. There are three methods or operations that the Oracle Cost Based Optimizer, CBO, can use to perform a join: sort/merge, nested loops, and hash joins. All three are described in the Oracle Performance and Tuning manual for your version of Oracle.

    HTH -- Mark D Powell --

  • RELEVANCY SCORE 3.29

    DB:3.29:Print Command And Icon Disabled In Pdf Preview Mode a9


    Hi, can somebody please explain why the FilePrint command and the toolbar icon for Print in LiveCycle Designer is permanently disabled when I go into PDF Preview mode? How can I re-enable them? (The Form Properties-Defaults-Preview Type setting has no effect on this). The command and icon are not disabled in standalone Reader or Acrobat.

    Harry

    DB:3.29:Print Command And Icon Disabled In Pdf Preview Mode a9

    Thanks Shari, yes the right-click Print command is there. Strange.

    thanks,
    Harry

  • RELEVANCY SCORE 3.24

    DB:3.24:Debug Button Disabled zk


    Hi AndreyAnother problem that i faced is that after i place the code in the code block, I find that Debug button is disabled. Could you please explain to me why this happens?Thanx

    DB:3.24:Debug Button Disabled zk

     Sarveshvs wrote:

    Hi AndreyAnother problem that i faced is that after i place the code in the code block, I find that Debug button is disabled. Could you please explain to me why this happens?Thanx

  • RELEVANCY SCORE 3.19

    DB:3.19:Script For Explain Plan jx


    Hi all
    What is the name of the script for creating the plan table in order to execute the explain plan command ?

    DB:3.19:Script For Explain Plan jx

    your_oracle_home\rdbms\admin\utlxplan.sql

  • RELEVANCY SCORE 3.19

    DB:3.19:Re: Explain Plan j7


    HIS CLIENT IS 8. WILL THIS PLAN TABLE WILL BE POPULATED

    DB:3.19:Re: Explain Plan j7

    Thank You Sven.

    Now it is working.

    Regards
    Krishna

  • RELEVANCY SCORE 3.19

    DB:3.19:Why Does Flash Still Load When Disabled? ca



    I have Shockwave Flash disabled in Firefox but on certain websites (e.g. Facebook) the browser sometimes freezes up for what seems like 10 seconds and when I check the task manager I find that Flash has just loaded in the background. Can anybody explain why it is still loading even though it is disabled? I am using Firefox 24.0 on Windows Vista.

    DB:3.19:Why Does Flash Still Load When Disabled? ca



    Seeing the Flashplayerplugin_*.exe entries in the Task Manager generally indicates that the Flash Player's protected mode is active. Otherwise, all Flash content played by Firefox would stay inside plugin-container.exe. I don't know whether disabling protected mode would help with the sluggishness, but since it can resolve some other issues, you may want to try it.

    See this support article from Adobe under the heading "Last Resort": Adobe Forums: How do I troubleshoot Flash Player's protected mode for Firefox?

  • RELEVANCY SCORE 3.19

    DB:3.19:Why Is My Apple Id Disabled fs


    Why is my apple ID disabled?

  • RELEVANCY SCORE 3.12

    DB:3.12:Re: Short Circuit Evaluation In Sql Where Clause za


    why do you think that exists predicate is not necessary?
    can you give any example where only necessary conditions are evaluated?
    did you check the order of execution in the explain plan , if not post the explain plan.

    DB:3.12:Re: Short Circuit Evaluation In Sql Where Clause za

    Etbin wrote:
    I meant: true or null = true but true and null = null Look in same chart:

    1. false and true = false
    2. false and false = false
    3. false and null = false

    Another word, based on short circuit evaluation if we have

    condition1 AND condition2and condition1 evaluates to FALSE there is no need to evaluate condition2 since we already know result will be FALSE. I hope it is clear now.

    SY.

  • RELEVANCY SCORE 3.12

    DB:3.12:Estimated Explain Plan Does Not Return s8


    Hello,
    I have a query which takes a very long time to complete appx 1 hour. If I run an estimated execution plan on the query, this can run for over an hour and doesn't return the plan. Anyideas why the plan should take so long. Is the only way around this
    to clear the cache?
    Thanks,
    Andy.

    DB:3.12:Estimated Explain Plan Does Not Return s8

    Thanks for everyones reply.

    Looking at the query, its using a view, which is based on another view! Its awful. I am going to rewrite the whole think, which I am now sure will cure the problem.

  • RELEVANCY SCORE 3.10

    DB:3.10:Re: Explain Plan For Same Query d9


    Please have a look.

    the second explain plan is accessing materialzied view and is hence is faster it seems.

    Can you please advise why the first one is not accessing the mview.

    DB:3.10:Re: Explain Plan For Same Query d9

    One database is being refreshed from another.
    Think some of parameters may be different.
    Can you advise which all of the parameters i need to compare.

    where is utlxplan.sql in 10g located.

    Edited by: user610910 on Feb 13, 2009 8:22 AM

  • RELEVANCY SCORE 3.10

    DB:3.10:Difference In Explain Plans fm


    Hi,

    I see a difference in explain plans of production and acceptance servers. In production , explain plan doesn't
    take any indexes into consideration but performance is good even if it does full scan.
    whereas in acceptance explain plan it is using indexes even then the performance is very very poor sometimes the process
    doesn't end.

    I rebuild all indexes in acceptance even then the problem exist,

    Table scripts , indexes are same in both servers , no difference at all . But i am wondering why production explain plan
    doesn't take indexes into consideration.

    all indexes in production are in valid status.

    kindly help me .

    DB:3.10:Difference In Explain Plans fm

    See the template thread:
    [url http://forums.oracle.com/forums/thread.jspa?threadID=863295]How to post a SQL tuning request

    In there, it requests the values for various parameter settings and it shows how to get execution plans - estimates and actuals.

    At the end of the day, there will be at least one significant difference in parameter settings or in statistics (system or object) that should account for this.

    Get the information, spot the difference.

  • RELEVANCY SCORE 3.09

    DB:3.09:Why Is My Apple Id Disabled 3k


    Why is my Apple ID disabled on all my stuff

    DB:3.09:Why Is My Apple Id Disabled 3k

    No one here would have any idea why your Apple ID is disabled. We are all users like yourself. Contact Apple support.http://support.apple.com/kb/HE57

  • RELEVANCY SCORE 3.07

    DB:3.07:Explain Plan Query 8p


    hi,
    is it posible to get cpu cost and other things when i run explain plan in oracle.

    regards,
    kishore

    DB:3.07:Explain Plan Query 8p

    Yes I can but the OP didn't ask for autotrace but Explain Plan only!

    Aman....

  • RELEVANCY SCORE 3.06

    DB:3.06:Why The Execution Plan Is Different For The Same Sql Script 33


    hi *,

    i explain plan for a sql script. but when i check the execution plan, i noticed that sometimes it uses nested loops ,and sometimes it uses hash join. why ? how can i do to make it always uses nested loops or hash join .

    thanks advance.

    DB:3.06:Why The Execution Plan Is Different For The Same Sql Script 33

    1. When done by the COST-based optimizer, the implementation of the join operation depends of the actual contents of the joined tables (number of rows, value distribution, etc), and on the access paths available (like indexes). If the table contents change in time, and the statistics are updated, the implementation of the same join can change.

    2. There are explicit hints for join operation,
    each hint suggesting a join operation for a table:

    USE_NL
    USE_MERGE
    USE_HASH
    DRIVING_SITE
    LEADING
    HASH_AJ, MERGE_AJ, and NL_AJ
    HASH_SJ, MERGE_SJ, and NL_SJ

    Please see http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/hintsref.htm#5637.

  • RELEVANCY SCORE 2.98

    DB:2.98:Explain Plan In Oem f3


    Is there a way to print or save of the explain plan within OEM?

    DB:2.98:Explain Plan In Oem f3

    For saving the explain plan I don't see any options.
    Printing you can do that only using File, Print. Or use a screen capture utility like ScreenHunter, Screen grabber, etc and past it in a document for later reference.

    Eric

  • RELEVANCY SCORE 2.98

    DB:2.98:Sqlplus, Toad-≫ Can Create Explain Plan In 1 Schema But Not In The Other mk


    SQL explain plan for
    2 select t.xml_msg_text
    3 from xml_tbl t
    4 where xmlexists (
    5 'declare namespace ns1 = "Abc:SET"; fn:collection("oradb:/DEV/TABLE1")/ROW[ID1=$d/main/ns1:id]'
    6 passing t.xml_msg_text as "d" );

    Here Table xml_tbl is in Schema1 and I have created a synonym for it in Schema2.

    I can do Explain Plan for this query in Schema1.

    But when I do Explain plan for this query in Schema2, I get :
    ERROR at line 6:
    ORA-00942: table or view does not exist
    WHEREAS IF I DO (i.e. miss out the text from the WHERE claue)

    explain plan for
    2 select t.xml_msg_text
    3 from xml_tbl t - IT WORKS..

    WHY this behaviour??
    And how can I make it work..
    Any suggestions please..

    Thanks..

  • RELEVANCY SCORE 2.97

    DB:2.97:Oracle Enterprise Manager Shows "Execution Plan Is Not Available." a8


    Hi,

    I'm not able to view the execution plan of some statements through Oracle Enterprise Manager (OEM). I'm looking at the Top SQL page under the Performance tab. In place of the plan the following message is displayed: "Execution Plan is not available.".

    Can someone explain (!) the reasons why the plan information is not visible? I wouldn't believe that the statement would age out so soon from the SGA.

    Regards,
    Rahul

    DB:2.97:Oracle Enterprise Manager Shows "Execution Plan Is Not Available." a8

    Well no idea what you are saying? Which EM, of 9i, 8i , 10g, 11g? Which sqlplan you want to see? Did you try to check that for the same query, teh plan is shown in teh V$SQL_PLAN view or the statement itself is shown in the V$sql or v$sql_text ?

    HTH
    Aman....

  • RELEVANCY SCORE 2.97

    DB:2.97:Graphic Memory Aero Status Disabled 1j



    How do you enable this part of the graphics memory? Is there such a thing? It would explain why so many items on the internet do not come up at all. Please let me know if this is normal or not.

    DB:2.97:Graphic Memory Aero Status Disabled 1j


    Hello jot1959,

    Take a look at this article and let me know if it helps resolve your issue. If not, when you reply, please let me know your product number and operating system.

    Thanks!

  • RELEVANCY SCORE 2.96

    DB:2.96:Why Is String Collection Editor Add Button In Application Setting Disabled? kd


    Hi All,
    Can someone explain why the button in String Collection Editor is disabled (Please see the graph)?
    My final target is to enter a name-value dictionary in App.Config file, is there any alternative method to do that?
    Thank you very much

    DB:2.96:Why Is String Collection Editor Add Button In Application Setting Disabled? kd

    Actually I wanna the define the NameValueCollection through the project setting file.
    I though I can define the values using the setting configuration in the Visual studio during the development stage.
    Looks like it is not available as PCGalen explained.
    I tried Dig-Boy's suggestion (In visual studio 2008), and found the situation is different to my one. The solution is for program want to allow users to modify the value when the program is running.
    Thanks for all

  • RELEVANCY SCORE 2.96

    DB:2.96:Execution Plans dd


    Hi,

    Most of the time I see that the actual execution plan(run time plan) differs from the plan we get through explain plan (estimated plan). i.e. Many times the execution plan derived using 'explain plan' differs from the plan we get from 'awrsqrpt.sql' or 'sprepsql.sql'.

    Why does this happen?

    Thanks and regards.

    DB:2.96:Execution Plans dd

    @Satish

    I don't know why but the link of Tom Kyte is not working.It works for me without any issues.

    May be proxy/firewall rules causing problems at your end?

  • RELEVANCY SCORE 2.95

    DB:2.95:Why Is My Itunes Disabled dj


    Why is my itunes account disabled? I corrected my payment information.

    DB:2.95:Why Is My Itunes Disabled dj

    Why is my itunes account disabled? I corrected my payment information.

  • RELEVANCY SCORE 2.94

    DB:2.94:Organisational Plan m3



    hai

    can any body explain why organsiational plan used for

    and wht for it is used with example

    thanks

    C.Theja

    DB:2.94:Organisational Plan m3


    Hi

    Plan versions are also used when an existing company is going to merge with another or some takeovers is going on this is the best example where and why we use all the different plan versions like active, planned, submitted, approved, rejected.

    Thanks

    Rafi

  • RELEVANCY SCORE 2.94

    DB:2.94:Pwa 2010:Basic Project Plan Menu Option Disabled mf


    Hi
    Can anyone please tell me, when i try to create new basic project plan why this option is disabled?

    DB:2.94:Pwa 2010:Basic Project Plan Menu Option Disabled mf

    The fact that the 2 EPTs do not have workflow and PDP association, suggests that you have a discrepancy between the WSSContent DB and the ProjectDBs. Have you taken your project dbs to a different server(4db attach migration from another 2010 server)? If
    not, do you remember if anything was done to the site(delete and recreate with the same dbs)after you used it successfully?

  • RELEVANCY SCORE 2.93

    DB:2.93:Training Videos On Oracle c3


    First training video on what is explain plan,why do wee need explain plan and to how to understand it.It also gives an idea how to use auto trace in sql *plus on this
    http://www.expertsharing.com/forum/

    DB:2.93:Training Videos On Oracle c3

    There are lots of doc available.
    Its better to visit oracle home site

  • RELEVANCY SCORE 2.93

    DB:2.93:My Account Has Been Disabled? s1


    Why is my account disabled?

    DB:2.93:My Account Has Been Disabled? s1

    I have to reset or make a new password every 2 DAYS! It has gotten to the point where I can't even reset a password. Now I have to keep making up new ones.

  • RELEVANCY SCORE 2.92

    DB:2.92:Crowdsupport js



    Please explain why i cant claim on stay coneected for a phone on a plan

    DB:2.92:Crowdsupport js

    Hey there,

    Welcome to Crowd Support

    I am sorry to hear that you have experienced issues with having a claim accepted via the StayConnected service

    What has been the issue with having this lodged as if the service is active and the handset can either be returned or IMEI blocked (if stolen) then we will be able to have the claim lodged with an access being applied. Detail on lodging a claim can be located at:

    http://goo.gl/3jaiyg

    I have sent you a PM in relation to the username for this forum, so please reply if you do have any further questions.




    DingoModerator24x7 Digital Customer Care TeamPlease send Kudo's to replies you think are worthy ____________________Need help? Why not check our KnowledgeBase here || Find what you were looking for? Tag answers as Accepted Solution All moderation actions are supported by the CrowdSupport Community Guidelines

  • RELEVANCY SCORE 2.92

    DB:2.92:Hands On Tranining Videos On Oracle fz


    First training video on what is explain plan,why do wee need explain plan and to how to understand it.It also gives an idea how to use auto trace in sql *plus on this

    http://www.expertsharing.com/forum/

    DB:2.92:Hands On Tranining Videos On Oracle fz

    BEWARE -- This looks like a website designed for capturing tech user contact data for resale.

    I checked this one out and after "registering" by providing my name, address, etc., there was no video to watch. I only got a Real Player message saying that the video file was damaged. I notified the website owner of this 15 weeks ago and there has been no response and no correction.

  • RELEVANCY SCORE 2.92

    DB:2.92:Understanding Explain Plan jj


    Hi

    Gurus.

    New to sql tuning. trying to understand explain plan

    After generating explain plan how to interpret the plan.

    I have the following questions.

    1. How to identify the starting point from the explain plan?
    2. How to identify the driving table, driver table ? (we will specify from clause, is there any deviation showing in the plan) ?
    3. Explain plan is the plan for 1 row output ? for all the rows output ?
    4. Where we can get actual rows vs selected rows of the table in the explain plan ?
    5. How to identify where could be the problem from the explain plan ?
    6. The plan of the explain plan will be different after actual execution (TKprof output plan) ?
    7. where we can see oracle generated plans for sqlid ? (v$sql_plan?)

    Pl. share if you have any links which can address these questions.

    Edited by: gln_gln_48@hotmail.com on May 10, 2010 12:40 PM

    DB:2.92:Understanding Explain Plan jj

    Pl. share if you have any links which can address these questions.Of course Using EXPLAIN PLAN.

  • RELEVANCY SCORE 2.92

    DB:2.92:Disabled Execution Plan Still Being Picked Up 8k


    I already disabled the bad execution plan in the SQL baselines (ENABLED = NO), but still being picked up by the SQL. Why is that so?

    DB:2.92:Disabled Execution Plan Still Being Picked Up 8k

    first read read about this parameter, you should set it to false in some cases for ex you abs. Sure that oracle getting bad plan, or you are testing something and etc, because disabling this parameter might improve performance for one query but slow down performance other query....

  • RELEVANCY SCORE 2.92

    DB:2.92:Expalin Plan Format?? xc


    Is there something like formatting the explain plan or so..

    actually a couple of developers approached me for the same today... they asked me if i have something which formats the explain plan?

    DB:2.92:Expalin Plan Format?? xc

    Thanks a ton..........
    That was excellent explanation.. you cleared a long time confusion in my mind....:)

  • RELEVANCY SCORE 2.92

    DB:2.92:Explain Plan k3


    I have following sample queries which are giving same Explain Plans. Why it so?

    1.
    select case when cal_date is null then null
    else cal_date end
    from d_iso_cal where .....

    2.
    select cal_date
    from d_iso_cal where .....

    When we add case or decode or any functions like to_char, etc. Is there any impact on performqance. if yes why explain plan doesn't show diffrance?

    Above queries are sample queries.

    DB:2.92:Explain Plan k3

    if you have the same predicates in your where clause for both of your query most likely it will be the same.

    try having different predicates in your where clause you would probably get different explain plan results.

  • RELEVANCY SCORE 2.90

    DB:2.90:Unable To Pass Disabled Fields To Next Page df


    whenever i try to pass disabled fields(i have inserted values into them,although dynamically, but even if hard-coded) to my next page, i results in an error.(NullPointerException) that is the value of the passed parameter is null. Please explain why?

    DB:2.90:Unable To Pass Disabled Fields To Next Page df

    Use a javascript to un-disable the fields that you want to pass before the submit:

    html
    head
    /head
    body

    form name=myForm method=get
    input type=text name=myText value="Text Data" disabled
    input type=submit name=mySubmit value="Submit" onClick="doSubmit();"
    /form

    script
    function doSubmit() {
    alert("here");
    document.myForm.myText.disabled = false;
    document.myForm.submit(); }
    /script

    /body
    /html

  • RELEVANCY SCORE 2.90

    DB:2.90:Maintenance Plan Simulation In Ip19? dd



    Dears,

    Can anyone explain me that what is maintenance plan simulation in ip19?

    i am getting only one plan while selecting the maintenance plan simulation in ip19?

    Why it is showing like that?

    when i select maintenance item overview it shows all the plans?

    please explain what is maintenance plan simulation?

    Regards,

    Varma.

    DB:2.90:Maintenance Plan Simulation In Ip19? dd


    hi

    have assigned the maintenance item to maintenance plan, also you need to assign the start of cycle to get displayed in IP19

    Regards

    thyagarajan

  • RELEVANCY SCORE 2.89

    DB:2.89:Re: Why Two Different Explain Plan For Same Objects? 1p


    This is just same copy ... everything is same...

    DB:2.89:Re: Why Two Different Explain Plan For Same Objects? 1p

    user550024 wrote:
    I am really surprise that the stat for good sql are little old. I just computed the states of bad sql so they are uptodate..

    There is something terribly wrong..Not necessarily. Just using the default stats collection I've seen a few cases of things suddenly going wrong. As the data increases, it gets closer to an edge case where the inadequacy of the statistics convinces the optimizer to do a wrong plan. To fix, I could just go into dbconsole, set the stats back to a time when they worked, and locked them. In most cases it's definitely better to figure out what is really going on, though, to give the optimizer better information to work with. Aside from the value of learning how to do it, for some cases it's not so simple. Also, many think the default settings of the database statistic collection may be wrong in general (in 10.2.x, at least). So much depends on your application and data that you can't make too many generalizations. You have to look at the evidence and figure it out. There is still a steep learning curve for the tools to look at the evidence. People are here to help with that.

    Most of the time it works better than a dumb rule based optimizer, but at the cost of a few situations where people are smarter than computers. It's taken a lot of years to get to this point.

  • RELEVANCY SCORE 2.89

    DB:2.89:Possible To Display Parallel Explain Plan? fj


    Is it possible to display a parallel explain plan, in particular the other_tag column information, from the built-in Explain on version 1.0.0.15.57?

    Thx...

    DB:2.89:Possible To Display Parallel Explain Plan? fj

    Is it possible to display a parallel explain plan, in particular the other_tag column information, from the built-in Explain on version 1.0.0.15.57?

    Thx...

  • RELEVANCY SCORE 2.89

    DB:2.89:Performance x1


    i have several question is given below

    our application is running slow how we can find the problem why application is running slow.

    other question if we use stackspack utility. in stackspack report how we can find where is there problem in database.

    if some querry take more time how we can find why this querry take long time.

    when we can use explain plan how we can understand the explain plan

    thanks in advance

    DB:2.89:Performance x1

    I would rather take you to word of oracle performance tuning, This is best place to start
    See How/b br brhare krishna brAlokbr

  • RELEVANCY SCORE 2.89

    DB:2.89:Explain Plan Of A Query. 77


    I want to know the concept of this 'Explain Plan' of a query why it is used. Could u also give the syntax of how a explain plan for a query can be done. Please help in solving the doubt as it is urgent.

    DB:2.89:Explain Plan Of A Query. 77

    What are the parameters through which we can optimize the sql query. I mean how with the help of explain plan..

  • RELEVANCY SCORE 2.89

    DB:2.89:My Wireless Is Ot Working ... It Said Wifi Disabled. I Just Got It Last Night zp



    can someone please explain why my brand new laptop 's wirelessinternet is not working... its pavillion g6

    DB:2.89:My Wireless Is Ot Working ... It Said Wifi Disabled. I Just Got It Last Night zp


    can someone please explain why my brand new laptop 's wirelessinternet is not working... its pavillion g6

  • RELEVANCY SCORE 2.89

    DB:2.89:Why Oracle Not Using The Correct Indexes After Running Table Stats f7


    I created an index on the table and ran the a sql statement. I found that via the explain plan that index is being used and is cheaper which I wanted.

    Latter I ran all tables stats and found out again via explain plan that the same sql is now using different index and more costly plan. I don't know what is going on. Why this is happening. Any suggestions.

    Thx

    DB:2.89:Why Oracle Not Using The Correct Indexes After Running Table Stats f7

    What about execution (response) time. Do you notice any difference?
    Which statistics (metrics) are you using to determine it is a more costly execution plan? Could you generate usage statistics? You can gather this running metrics from a sql prompt wiht the set autotrace traceonly command.

    ~ Madrid.

  • RELEVANCY SCORE 2.89

    DB:2.89:Can Someone Explain Why A Data Plan Is Needed To Use The Podcast App? 1m



    I can use the browser, the facebook app, and the twitter app on wifi without any complaints, why does the podcast app require that I have a data plan?

    And more importantly, is there a way I can get around this limitation?

    DB:2.89:Can Someone Explain Why A Data Plan Is Needed To Use The Podcast App? 1m


    Hello FatBerryand welcome to the BlackBerry® Support Community Forums.

    Thanks for your question regarding theBlackBerry® Podcasts application.

    In the UserGuidefor Podcasts it says:

    Requirements:

    BlackBerry device with a trackball, touch screen, or trackpad
    BlackBerry device Software 4.6 or later
    wireless service plan that includes Internet access
    media card (recommended)

    (VIew full User Guide by clicking here)

    As per the requirements, if you don't have the service plan with Internet access, it will not work. There is no way around this requirement.

    Hope this answers your question.




    -HMthePirate

    ComefollowyourBlackBerryTechnicalTeamontwitter!@BlackBerryHelp
    BesuretoclickKudos!for thosewhohavehelpedyou.ClickSolution?forpoststhathavesolvedyourissue(s)!

  • RELEVANCY SCORE 2.88

    DB:2.88:"Execute Explain Plan" Button Disabled pm


    I'm using the 1.1.3 version of SQL Developer included in the Oracle 11g distribution for Windows.

    After connecting to a database and executing a query, I am unable to view its execution plan because the explain plan button is greyed-out. The connected user has the PLAN_TABLE table in its schema.

    DB:2.88:"Execute Explain Plan" Button Disabled pm

    I'm using the 1.1.3 version of SQL Developer included in the Oracle 11g distribution for Windows.

    After connecting to a database and executing a query, I am unable to view its execution plan because the explain plan button is greyed-out. The connected user has the PLAN_TABLE table in its schema.

  • RELEVANCY SCORE 2.88

    DB:2.88:How To Read Explain Plan 1d


    can someone advise me about explain plan how to read, what is the key points to look it in the explain plan report. I already have explain plan report.
    Thanks for help

  • RELEVANCY SCORE 2.88

    DB:2.88:I Am Using Illustrator Cs4 And For Some Reason When Firefox Is On Some Keyboard Short Cuts Get Disabled, Could You Please Explain Why As Am Having To Use Alternative Browsers At The Mo p7



    The hand tool and shift tool to scale get disabled in illustrator when firefox is running - there may also be more?

  • RELEVANCY SCORE 2.88

    DB:2.88:Acs Disabled Accounts Cleaning 81



    Hello,

    Could someone explain how to clean disabled accounts from ACS v3.3 database, if there is more than 1000 disabled accounts?

    Juris

    DB:2.88:Acs Disabled Accounts Cleaning 81


    There is no problem to disable accounts. There are more than 1000 already disabled accounts under Reports And Activity/Disabled Accounts. The problem is how to clean these accounts from ACS. One idea is dump all users in one file and make a script to find out how to delete disabled users. But I think this is unreal. Is any other idea?

  • RELEVANCY SCORE 2.88

    DB:2.88:Explain Plan Generating It Self Taking Very Long Time !!! What To Do ? js


    Hi,

    I am trying to generate explain plan for a query which is running more than 2 hours. I am trying to generate explain plan for query by "explin plan for select ..." but it self is taking very long time.

    Kindly suggest me how to reduce time for explain plan ? Secondly why explain plan itself taking very long time ?

    thanks regards
    PKP

    DB:2.88:Explain Plan Generating It Self Taking Very Long Time !!! What To Do ? js

    If there is no more information than this, I would trace the explain plan to find out what's wrong...

  • RELEVANCY SCORE 2.88

    DB:2.88:Re: Explan Plan 8f


    An explain plan is just a "guestimate", it's not the actual execution plan.
    it guesses based on table definitions, statistics etc..

    To see the actual execution plan use TKProf.

    DB:2.88:Re: Explan Plan 8f

    It's possible that the second query is faster because the blocks needed are already in the cache.

    Try running them in reverse order.

  • RELEVANCY SCORE 2.86

    DB:2.86:Explain Exists az


    can anyone explain EXISTS AND WHY IS IT USED???

    DB:2.86:Explain Exists az

    Try using an IN clause against a table with a million rows then try using an exists on the same table.

    Exists determines wether a condition is satisfied. If it is , it stops.
    In has to check each row to see if the value exists.

    in general, IN is more efficient for small tables
    in general, Exists is more efficient for large tables.

    refer to the Oracle SQL referrence for examples

  • RELEVANCY SCORE 2.86

    DB:2.86:Difference Between Execution Plan &Amp; Explain Plan? p7


    what is the difference between execution plan explain plan?

    DB:2.86:Difference Between Execution Plan &Amp; Explain Plan? p7

    Explain Plan is the one that gives you the Excution Plan.

  • RELEVANCY SCORE 2.86

    DB:2.86:Invoce Plan zf



    Dear friends,

    I created rent invoice plan documents through MRIS transaction by using periodic invoice plan,my question is how to make payments automatically using invoice plan

    plz can u explain detail

    Regards

    Govind

  • RELEVANCY SCORE 2.86

    DB:2.86:"Explain Plan" In Oracle Sql Developer Is Greyed Out zx


    My question is very simple (I presume):
    1. I installed Oracle SQL Developer 3.0.04.
    2. I added a new DB connection to a DB hosted in one of my servers in the LAN.
    3. However, when I am writing some SQL queries, I intend to use the "Explain Plan" feature, but it is being greyed out (disabled).
    4. How can I enable it back?

  • RELEVANCY SCORE 2.86

    DB:2.86:Explain Plan mp


    Dear all,

    Please explain what is cpu-cost and cost in explain plan,what is the difference between those two ,i went through many documents , exact meaning i did not get . Please explain me in simplified words what does cpu-cost and cost in explain plan..

    Regards,
    Vamsi......

    DB:2.86:Explain Plan mp

    Yes, you can see but it is only a estimative of the optimizer.

    Regards

  • RELEVANCY SCORE 2.85

    DB:2.85:Crowdsupport mk



    Hello

    Can someone please explain why my 500Gb plan is being shaped at 200GB !!!!!!!

    Regards

    Chris

    DB:2.85:Crowdsupport mk


    Hi ChrisD1969

    Your service would be set up incorrectly within our Usage Meter.If you speak with us over the phone, or via Live Chat (link in my signature) we'll be able to immediately unshape you, and have our IT team resolve the issue long term




    StephSenior Moderator24x7 Digital Customer Care Team____________________PM Steph - I’m a member of the Overnight Team, so I’ll reply to messages between 10:30pm – 7:00am on the days I’m working.Live Chat with TelstraNeed help? Check out our KnowledgeBase here || Find what you were looking for? Tag answers as Accepted Solution All moderation actions are supported by the CrowdSupport Community Guidelines

  • RELEVANCY SCORE 2.85

    DB:2.85:Surcharges xp


    I'm a new user to the wireless phone. My first bill shows "Verizon Wireless surcharges" exceeding my phone plan. Why is that? The "Explanation of Charges" doesn't really explain anything!

    DB:2.85:Surcharges xp


    This topic has been thoroughly discussed and will now be closed.

  • RELEVANCY SCORE 2.85

    DB:2.85:Explain Plan a1


    Hi i have 2 databases, both will give an explain plan thorugh toad, but only one will show statistics. Any idea's why this may be?

    regards
    Mark

    DB:2.85:Explain Plan a1

    A filename is not a valid value for the database parameter value of optimizer_mode. It would be RULE, CHOOSE, ALL_ROWS, or FIRST_ROWS.

    But yes you probably just need to generate statistics though I think 8.1.7 still supported running the whole database in RULE mode. It is getting hard to remember when options dropped off the list.

    Always remember when posting online to include full versions of Oracle, OS, and tools being used since most bugs are version specific and features are also version specific.

    HTH -- Mark D Powell --

  • RELEVANCY SCORE 2.84

    DB:2.84:Cost In Explain Plan c7


    Hi all,

    Is the "COST" column in explain plan CPU or MEMORY usage cost? or both

    Thanks

    DB:2.84:Cost In Explain Plan c7

    Hi;

    Please also see:
    Understanding Explain Plan
    http://www.orafaq.com/node/1420

    Interpreting Explain Plan
    http://www.akadia.com/services/ora_interpreting_explain_plan.html

    Using explain plan
    http://download.oracle.com/docs/cd/B10500_01/server.920/a96533/ex_plan.htm

    Regard
    Helios

  • RELEVANCY SCORE 2.83

    DB:2.83:Use Of Explain Plan And Tk Prof Utility fj


    Can any one help me understanding explain plan and tk prof utilities...is there any good site or material to explain about this...

    Plzz correct me if i am wrong.. According to my understanding

    Explain plan is used to know cost of oracle before executing sql statement is it true?

    DB:2.83:Use Of Explain Plan And Tk Prof Utility fj

    look into this

    http://download.oracle.com/docs/cd/B10501_01/server.920/a96533/ex_plan.htm
    http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/sqltrace.htm#PFGRF01020

    I believe explain plan is mainly used to see the execution plan.

    Regards,

    G.

  • RELEVANCY SCORE 2.83

    DB:2.83:Fastswap Deployment In Weblogic. k9


    Hi everyone,

    I am new to weblogic.Please anyone let me know why fastswap deployment is disabled in produciton mode.

    If possible please explain in detail about fastswap deployment.

    Regards,
    Vardhan.

  • RELEVANCY SCORE 2.83

    DB:2.83:Index Scan zc


    I'm using Oracle Server 8.1.7. I've a table TEST with 40 milion records. There is a column DATE_SAVED (type DATE) in this table. I've created single column index on DATE_SAVED. Every day I insert some new records (about 2 milion) and delete some old records (also about 2 milion). Now I've got records with DATE_SAVED values between 2002/11/14 and 2002/11/26.
    I don't understand this:

    select * from TEST where DATE_SAVED '2002/1/1' ... no rows returned (immedate answer, explain plan: index range scan)
    select * from TEST where DATE_SAVED '2002/6/1' ... no rows returned (immedate answer, explain plan: index range scan)
    select * from TEST where DATE_SAVED '2002/11/1' ... no rows returned (immedate answer, explain plan: index range scan)
    select * from TEST where DATE_SAVED '2002/11/2' ... no rows returned (answer after 5 minutes, explain plan: index range scan)
    select * from TEST where DATE_SAVED '2002/11/10' ... no rows returned (answer after 15 minutes, explain plan: index range scan)
    select * from TEST where DATE_SAVED = to_date('20021119162031', 'yyyymmddhh24miss') ... 250 rows returned (immediate answer, explain plan: index range scan)
    select min(DATE_SAVED) from TEST ... 1 row returned (answer after 10 minutes, explain plan: index full scan)

    The times are very strange to me. Could you anybody explain it to me?
    Why returning empty cursor is immediate for 11/1 and 5 minutes for 11/2 ?
    Why min(DATE_SAVED) is not returned immediatelly?

    Thanks for help

    DB:2.83:Index Scan zc

    So index data are not organized (and saved in a tablespace) sorted?

  • RELEVANCY SCORE 2.83

    DB:2.83:Why Trace Is Disabled In Codewarrior 10.1.2 For Pa? cs



    hi,

    i am using Codewarrior 10.1.2 for PA, P2041RDB-PB board.

    Trace option in Debug Configurations is disabled. I have attached a screen shot of it.

    why it is disabled, how to enable it how to trace a packet?

    please explain in detail.

    Regards,

    Shashank

    DB:2.83:Why Trace Is Disabled In Codewarrior 10.1.2 For Pa? cs


    According to Tracing and Analysis Users_Guide.pdf available in the CodeWarrior-Install-Dir\PA\Help\PDF folder, it says "This manual describes how the CodeWarrior for Power Architecture V10.0.x Tracing

    and Performance Analysis tools can be used for the P4080, P4040, and P5020 devices" .

  • RELEVANCY SCORE 2.83

    DB:2.83:Problem With Execution Plan 8a


    Hi All,

    Using Oracle 10.2.0.4.0

    When I use;

    SELECT /*+ parallel (UBI.ACC_TRAN,4) */ * FROM UBI.ACC_TRAN
    WHERE ACC_CODE 0;

    The explain plan shows its using parallel processing and the query returns immediately.

    But When I use;

    SELECT /*+ parallel (UBI.ACC_TRAN,4) */ * FROM UBI.ACC_TRAN
    WHERE ACC_CODE 0;

    The explain plan shows that No parallel processing is used, and the query response is slower.

    Why is it so ?

    DB:2.83:Problem With Execution Plan 8a

    user13355115 wrote:
    Hi All,

    Using Oracle 10.2.0.4.0

    When I use;

    SELECT /*+ parallel (UBI.ACC_TRAN,4) */ * FROM UBI.ACC_TRAN
    WHERE ACC_CODE 0;

    The explain plan shows its using parallel processing and the query returns immediately.

    But When I use;

    SELECT /*+ parallel (UBI.ACC_TRAN,4) */ * FROM UBI.ACC_TRAN
    WHERE ACC_CODE 0;

    The explain plan shows that No parallel processing is used, and the query response is slower.

    Why is it so ?I have searched metalink but couldn't find a know bug about it, but I think the double quotes cause this problem.

    According to QREF: SQL Statement HINTS (MOS [ID 29236.1]), hints should not reference the schema name.

    SELECT /*+ index(scott.emp emp_ndx) */ ... should not be used. Alias the tablename instead and use the alias in the hint. for example:

    SELECT /*+ index(e emp_ndx) */ ...

    I would suggest you to use alias for tables, and try to avoid using quotes for DB objects. for example:

    SELECT /*+ parallel (at, 4) */ * FROM UBI.ACC_TRAN at
    WHERE ACC_CODE = 0;Best Regards,

    Gokhan

    -------------------------------------------------------
    If this question is answered, please mark appropriate posts as correct/helpful and the thread as closed. Thanks

  • RELEVANCY SCORE 2.83

    DB:2.83:Crowdsupport jm



    I sign a 2 year contract of $49 plan last month, and was told the phone galaxy nexus is free with the plan.

    But today when I got my first bill, it includes a $720 charge outside the plan for the phone. Which makes the bill $798 in total!

    The contract I have clearly states the phone is with the plan and is 'subsidised', and I'm 100% sure it's free on 49 plan.

    Could someone explain what is going on?

    DB:2.83:Crowdsupport jm


    Thanks,

    I phoned customer service yesterday, basically someone made a mistake on the bill and mistakenly added the price of the phone to the bill. They said they've processed a credit for me to balance out the $720 charge but it hasn't appear in my account for now.

  • RELEVANCY SCORE 2.83

    DB:2.83:Training Videos On Oracle d3


    First training video on what is explain plan,why do wee need explain plan and to how to understand it.It also gives an idea how to use auto trace in sql *plus on this
    http://www.expertsharing.com/forum/

    DB:2.83:Training Videos On Oracle d3

    Hi marvinm,

    Had the same problem but after using latest version Media Player 11, was able to view
    video demo.

    Regards
    Zack

  • RELEVANCY SCORE 2.83

    DB:2.83:Explain Plan Toad Version 9.1 Problem kp


    I have Toad Version 9.1 problem. My explain plan is not working.

  • RELEVANCY SCORE 2.82

    DB:2.82:Sharepoint Designer 1x


    Hello all,
    Can anybody explain why preview in browser is disabled in sharepoint designer ? who can preview the changes applied to a page in browser?
    Thanks
    Ameek

    DB:2.82:Sharepoint Designer 1x

    Do you have your selection on the folder or file? In case folder is selected the Preview in browser is disabled. Anyone having SPD access can view the 'page in browser'. Unless the page is Checked Out to some user. When that user checks in the page, only
    then everybody can view the changes.
    check out this link -
    http://www.sharepointnerd.com/blog/Lists/Posts/Post.aspx?ID=32

  • RELEVANCY SCORE 2.82

    DB:2.82:Processing Bd87 a1



    Hi All,

    When I am trying to reprocess a IDOC using BD87, the 'Foreground Processing' option was disabled, but wherein the same option was enabled for some IDOCs with different message types..Can anyone explain why it is disabled...

    Thanks Regards.

    Srini.

    DB:2.82:Processing Bd87 a1


    You may want to check BD51 where you can enable dialogue processing on the function module. This setting enabled foreground processing for me in one case.

  • RELEVANCY SCORE 2.82

    DB:2.82:Execution Plan j8


    hi,
    can someone explain to me why such different queries return the same execution plan?
    Thanks!

    DB:2.82:Execution Plan j8

    It dependson differences in the queries. Can you outline the differences?are you expecting a different plan?
    You can experiment with updating the statistics after checking the first query, see if that gives you a different execution plan.

    Jack Vamvas sqlserver-dba.com

  • RELEVANCY SCORE 2.82

    DB:2.82:Explain Plan With And Without Data zz


    hi..

    is there any difference while explaining the plan for a query on a table with and without data?

    for me ,on an empty table if i explain for query,it shows a full table access and index by row id if its on the same table but having some data.

    could you help me in understanding why so?

    thanks
    Dev.

  • RELEVANCY SCORE 2.82

    DB:2.82:How Can I Paste The Explain Plan From Toad.. da


    Hello all
    I tried taking a snap of the explain plan from toad but in this forum the paste option is disabled...please help

    DB:2.82:How Can I Paste The Explain Plan From Toad.. da

    964145 wrote:

    I tried taking a snap of the explain plan from toad but in this forum the paste option is disabled...please helpI don't know, but it is a waste of time since explain plans from Toad are not useful.

    Please read the forum FAQ on providing information for a tuning request, it describes how to generate an explain plan that can be shared.

    {message:id=9360003}

    This is an example.

    SQL explain plan for
    2 select * from dual;

    Explained.

    SQL select * from table(dbms_xplan.display);

    PLAN_TABLE_OUTPUT
    ----------------------------------------------------------------------------
    Plan hash value: 3543395131

    --------------------------------------------------------------------------
    | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
    --------------------------------------------------------------------------
    | 0 | SELECT STATEMENT | | 1 | 2 | 2 (0)| 00:00:01 |
    | 1 | TABLE ACCESS FULL| DUAL | 1 | 2 | 2 (0)| 00:00:01 |
    --------------------------------------------------------------------------

  • RELEVANCY SCORE 2.82

    DB:2.82:Index 11


    Oracle 10gR2 on Solaris 10.

    Index on TRAN_ID.

    SELECT * FROM HB_TRAN1 WHERE TRAN_ID 0 ; -- Output is 20% of the Table size (10 Million)

    The Explain plan shows a FULL TABLE SCAN.

    But when SELECT COUNT(*) FROM HB_TRAN1 WHERE TRAN_ID 0 ;

    The Explain Plan shows a index scan.

    Why is the index not getting used in first query ?

    DB:2.82:Index 11

    what can be done to reduce the response time.You could try parallel query.
    http://download.oracle.com/docs/cd/B19306_01/server.102/b14223/usingpe.htm#sthref2058

    Regarding the multiblock read count:
    http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:54220416567827#tom64018102081959

    Edited by: hoek on Apr 10, 2011 5:23 PM

  • RELEVANCY SCORE 2.82

    DB:2.82:Price Plan Query. x7



    I had my contract transferred in to my name on the 3rd Jan and I have received a text saying my Bill is ready to be paid for the period 3rd Jan to 3rd Feb. My price plan is £33.00 so can someone explain why I have been charged £34.06 please.

    thank you







    Solved!
    See best answer

  • RELEVANCY SCORE 2.81

    DB:2.81:Available Builds In Testing Center Is Disabled, Why? 19


    Hi All,
    I created a test plan using MTM
    I am trying to assign a build to the test plan, but the Available builds field is disabled.
    There is a filter for builds, there I can see the solution of the application under test.
    Can someone let me know how to make the build available?
    Thanks

    SDET

  • RELEVANCY SCORE 2.81

    DB:2.81:Diff In Explain Plan Of 9i And 10g 8d


    I am beginner and just started my dba career. Please can you help me by giving me the differences between a explain plan executed in oracle 9i and 10g. Why is there variations in the cost,cardinality and bytes. Is it that 9is explain plan is executed in a different way when compared to 10g's. Please help me out regarding the same.

    DB:2.81:Diff In Explain Plan Of 9i And 10g 8d

    Or even number of users, pfile parameters.

    hare krishna
    Alok

  • RELEVANCY SCORE 2.81

    DB:2.81:Explain Plan 3j


    when i try to use explain plan from toad it is not responding...
    even i have made plan_table in current schema .

    eg
    explain plan for (select * from emp ,dept where emp.deptno=dept.deptno);
    pressin the button of explain plan no response come...

    DB:2.81:Explain Plan 3j

    TOAD is not an Oracle product. I would suggest that if you have having problems with that product you contact the company you purchased it from.

    But my personal impression of Toad's explain plan is that it isn't worth the electrons that will write it to your monitor.

    Instead, as Karthick recommends use DBMS_XPLAN.
    http://www.morganslibrary.org/reference/explain_plan.html
    http://www.morganslibrary.org/reference/dbms_xplan.html

    How Quest managed to produce a plan output with so many mistakes and so much missing information I have not yet figured out.

  • RELEVANCY SCORE 2.81

    DB:2.81:Re: Full Table Scan With Connect By On Oracle 9.2.0.7.0 j1


    Please always use dbms_xplan.display and the tag to make sure indentation of explain plan is preserved.
    IMO your interpretation of explain plan is incorrect, but I can not check it as you choose to wreck the indentation.

    BTW why are you still using the Rule Based Optimizer in 9i? CBO is usually much better!

    ----------
    Sybrand Bakker
    Senior Oracle DBA

    DB:2.81:Re: Full Table Scan With Connect By On Oracle 9.2.0.7.0 j1

    Sybrand, thanks for your reply.

    This problem occurs in a customer where the database optimizer mode is RULE.
    So, I disconsider the option update statistics of tables and indexes.

    Regards,

    Fabrcio Pinto

  • RELEVANCY SCORE 2.81

    DB:2.81:Why Is 'Extract Assets' Disabled? 9f



    I open a Photoshop file and 'Extract Assets' is disabled. Why?

    DB:2.81:Why Is 'Extract Assets' Disabled? 9f


    Any Photoshop file that is in 'CMYK' Image mode will not have 'Extract Assets' enabled. Change the mode through Image Mode RGB Color.

  • RELEVANCY SCORE 2.81

    DB:2.81:Index Isn't Used When Specifying Is Null jf


    Hello,
    I'm using Oracle 10.2.0.4. When I run this statement, the explain plan shows that a composite index is used which is expected.

    select * from isis.cour_off where orga_# = 4

    However, when I run the following statement, the explain plan shows FULL TABLE SCAN:

    select * from isis.cour_off where orga_# IS NULL

    Is this to be expected? If so, then why?

    DB:2.81:Index Isn't Used When Specifying Is Null jf

    Maybe the index would be used if you added an extra NOT NULL column to it, maybe the primary key (assuming all columns currently in the index allow NULLS)?

  • RELEVANCY SCORE 2.81

    DB:2.81:Remove Data Form The External Data Range Disabled s1


    Hi,

    I am importing data from SQL Server 2012 to Excel 2013 and the option 'Remove data form the external data range before saving the workbook' is disabled in the connection properties window.

    Can someone explain why this is?

    DB:2.81:Remove Data Form The External Data Range Disabled s1

    I use Oracle connection - and I can put data do workbook and delete connections with no problem.
    So my way can not workproperly - but never know.
    Try this code:
    Sub Usniecie_polaczen_ODBC()
    Dim x
    For x = ActiveWorkbook.Connections.Count To 1 Step -1
    ActiveWorkbook.Connections(x).Delete
    Next x
    End Sub

    Oskar Shon, Office System
    MVP
    Press if Helpful; Answer when a problem solved

  • RELEVANCY SCORE 2.80

    DB:2.80:Understanding Cbo Decisions, Explain Plan Instability jm


    Hi,

    I have a situation where the explain plan for a SELECT statement changes
    and performance takes a turn for the worse. The statement in question
    executes well and has the desired explain plan but after an insertion
    having a new eventtype ID the explain plan changes (doing lots of IO)
    and remains bad until the SGA is flushed.

    I would really like to know how to figure out how the CBO makes its
    decisions and why it changes its mind over a 2min period. Any pointers
    to get me started would be greatly appreciated.

    Table has columns C_ID, R_ID, EVENTTYPE, ...
    Regular indexes on (R_ID,C_ID) and EVENTTYPE.

    The SELECT runs well as long as the compound index is used first
    and runs poorly once a new EVENTTYPE is introduced (there are
    approx 10 event types and a new one is being introduced) and its
    index consulted first.

    Thansk,
    Darren

    DB:2.80:Understanding Cbo Decisions, Explain Plan Instability jm

    Hi,
    Is it the same SELECT used before and after? If your second SELECT is having EVENTTYPE in the WHERE clause, the it might not be using the INDEX [that is defined on C_ID and R_ID]. Can you redefine or build a new INDEX which is defined on columns C_ID, R_ID, EVENTTYPE. And then try to get the explain plan. I am sure this round it will use the NEW index and runs at improved times.

    Let me know if you made it.

    Thanks,

    Anil

  • RELEVANCY SCORE 2.80

    DB:2.80:Srm 7.1 Ehp2 Supplier Self Services Transfer Button Is Disabled k1



    Hi experts,

    on supplier pre-selection screen the transfer button is deactivated. Can explain me why?

    thank you in anticipation.

    regards.

    DB:2.80:Srm 7.1 Ehp2 Supplier Self Services Transfer Button Is Disabled k1


    Hi experts,

    on supplier pre-selection screen the transfer button is deactivated. Can explain me why?

    thank you in anticipation.

    regards.

  • RELEVANCY SCORE 2.80

    DB:2.80:Why Session State Is Disabled By Default In Sharepoint 2010 dc



    Hi All,
    Can any one explain me why session state is disabled by default in SharePoint. Is this not required sessions state? If so why?
    If I have enabled session state with InProc mode in my web application will it give any issues with Load balancing server. If so how to handle the situation.
    Thanks,
    Senthil

    Senthil.NKN

    DB:2.80:Why Session State Is Disabled By Default In Sharepoint 2010 dc

    Sharepoint kinda does it's ownsessionmanagement.
    Part of the reason it's disabled (I think ) is to keep developers from screweing around withsessionsin
    sharepoint without knowing what they are doing and causing headches for admins. SharePoint does not automatically remove oldsessionstate
    records from thesessionstatedatabasetables.
    Performance will degrade if you are usingsessionswithout
    proactive action to regularly purge expiredsessions.
    Source:http://www.faultserver.com/q/answers-why-is-session-state-disabled-in-sharepoint-by-default-108332.html
    Check this one:

    patterns practices SharePoint GuidancePlease remember to mark your question as answered helpful,if this solves/helps your problem. ****************************************************************************************** Thanks -WS MCITP(SharePoint 2010, 2013) Blog: http://wscheema.com/blog

  • RELEVANCY SCORE 2.80

    DB:2.80:Ht4895 Why Is My Apple Id Disabled d3


    Why is my Apple ID disabled

    DB:2.80:Ht4895 Why Is My Apple Id Disabled d3

    Apple ID security issues -Call Apple Care and ask for the Account Security Team. They can assist you with your issue.http://support.apple.com/kb/HT5699

  • RELEVANCY SCORE 2.80

    DB:2.80:Re: Why Plan Table Showing 1 Rec dk


    Rob,

    Even after analyze, there is 1 in place of Rows
    columns into the explain plan, even if there was no
    rows in the table...Yes, that's what I meant exactly by saying

    and if it was analyzed, it maps a zero to a one.

    Regards,
    Rob.

    DB:2.80:Re: Why Plan Table Showing 1 Rec dk

    Thanx rob ,let you know laters what i inferred.

    Khurram

  • RELEVANCY SCORE 2.79

    DB:2.79:Why Can't I Change My Rate Plan Online? jf



    I was trying to change my rate plan online but a message says i can't do it through the website. It didn't explain why though, is this a common thing on att?

    DB:2.79:Why Can't I Change My Rate Plan Online? jf


    I'm trying to go from a voice to a voice+data plan, so that's probably why. I guess i'll just give them a call, thanks!

  • RELEVANCY SCORE 2.79

    DB:2.79:Query Execution Time 3j


    Hi,

    I would like to measure a query execution time?

    i've installed toad but explain plan button is disabled so currently i'm not able to do so.

    i'd used gettime function to measure the time elapsed during the query execution but that is not efficient.

    Is there any other way of measuring the time?

    Thanks.

  • RELEVANCY SCORE 2.78

    DB:2.78:Db Console - Explain Plan cs


    Does anyone know if there is an explain plan functionality included in the DB Console GUI? Just curious. Thanks.

    DB:2.78:Db Console - Explain Plan cs

    May be, you can execute the SQL and you can see the explain plan later.

    if you want to see just the explain without even executing, Use Set AutoTrace option or TOAD to see the plan.

  • RELEVANCY SCORE 2.78

    DB:2.78:Help : How To Use Cast fx


    can smone tell me how to use cast on a table and why is nesting required for "EXPLAIN PLAN"

    SQL explain plan for select * from emp;

    Explained.

    SQL select * from table(dbms_xplan.display());
    select * from table(dbms_xplan.display())
    *
    ERROR at line 1:
    ORA-22905: cannot access rows from a non-nested table item

  • RELEVANCY SCORE 2.78

    DB:2.78:Explain Plan In Awr Report? md


    Is there any way to generate the explain plan in AWR report?Is it possible to generate the explain plan in AWR?

    Pandu

    DB:2.78:Explain Plan In Awr Report? md

    awr report generate report like this :
    http://nextre.it/oracledocs/misc/awr_reports/iosched01/awrrpt_cfq.html

    http://www.oracle.com/technology/deploy/performance/pdf/tips_perf_awr_sql_report.pdf

  • RELEVANCY SCORE 2.78

    DB:2.78:Stored Procedure To Count Rows And Columns- Newb 17


    I have the following table and I want to get a count of 'Enabled' in each column and output to a new table with the same column names with counts. Is this possible?
    AzureRMS Office_PP Lync Office_Onli Sharepoint Exchange Visio Project ExchangeArc
    -------- --------- ---- ----------- ---------- -------- ----- ------- -----------
    Disabled Enabled Disabled Enabled Enabled Disabled Disabled Disabled Disabled
    Disabled Enabled Disabled Enabled Enabled Disabled Disabled Disabled Disabled
    Disabled Enabled Disabled Disabled Disabled Disabled Disabled Disabled Disabled
    Disabled Enabled Disabled Disabled Disabled Disabled Disabled Disabled Disabled
    Disabled Enabled Disabled Enabled Enabled Disabled Disabled Disabled Disabled
    Disabled Enabled Disabled Disabled Disabled Disabled Disabled Disabled Disabled
    Disabled Enabled Disabled Enabled Enabled Disabled Disabled Disabled Disabled
    Disabled Enabled Disabled Disabled Disabled Disabled Disabled Disabled Disabled
    Disabled Enabled Disabled Disabled Disabled Disabled Disabled Disabled Disabled
    Disabled Enabled Disabled Disabled Disabled Disabled Disabled Disabled Disabled
    Disabled Enabled Disabled Disabled Disabled Disabled Disabled Disabled Disabled
    Disabled Enabled Disabled Disabled Disabled Disabled Disabled Disabled Disabled
    Disabled Enabled Disabled Disabled Disabled Disabled Disabled Disabled Disabled
    Disabled Enabled Disabled Disabled Disabled Disabled Disabled Disabled Disabled
    Disabled Enabled Disabled Disabled Disabled Disabled Disabled Disabled Disabled
    Disabled Enabled Disabled Enabled Enabled Disabled Disabled Disabled Disabled
    Disabled Enabled Disabled Disabled Disabled Disabled Disabled Disabled Disabled
    Disabled Enabled Disabled Disabled Disabled Disabled Disabled Disabled Disabled

    Dan

    DB:2.78:Stored Procedure To Count Rows And Columns- Newb 17

    In a relational database, a table is supposed to model a unique entity with a unique set of attributes. From this perspective, have a stored procedure with tablename as parameter is not meaningful. Each table is unique, and the code to access it is unique.

    It is true that some tables may seem to be similar in nature, because they only consists of an id and a name. But they still describe unique entities, and future improvements to the system may add new attribute.
    Thus, it is usually best to write one stored procedure per table.
    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

  • RELEVANCY SCORE 2.78

    DB:2.78:Mobile Broadband Disabled By Battery Removal sk



    Hello,

    I would like to know how to force mobile broadband device to operate without battery?

    Currently, if there is no battery in place, I receive an error through HP connection manager: "Disabled by battery removal".

    On the other hand, if it is immposible to start this device without battery, then it would be very nice if someone could explain why?

    DB:2.78:Mobile Broadband Disabled By Battery Removal sk


    Remove the main battery and look at the service tag. Post the complete p/n that is there.If your notebook's power adapter is connected to house current you can connect the power adapter to the notebook, press power and it should boot up to the Windows logon screen.

  • RELEVANCY SCORE 2.78

    DB:2.78:Explain Plan jz


    Hello

    I go through an artical which have idea about explain plan for a query.

    can any body tell me how it is useful to explain plan for a query and

    for what type of queries we used to explain plan.

    thanks

    DB:2.78:Explain Plan jz

    Vow! Magic!

    You seem to be increasing the performance just by running the EXPLAIN plan.

    You should be first bothered to read the documentation that I posted there. Don't get carried away with whatever you see in the time elapsed. The real culprit in your design/code comes out when you have proper test data.

    Cheers
    Sarma.

  • RELEVANCY SCORE 2.78

    DB:2.78:Re: Indexing 93


    If you don't want to use the explain plan feature you are pretty much stuck

    Also your database doesn't have a version, and the answer is version-dependent. In 9i and higher you can get the explain plan info from the cache, but you would still need to use the dbms_xplan package.

    Any comments on why you don't want to use explain plan?

    --
    Sybrand Bakker
    Senior Oracle DBA

    DB:2.78:Re: Indexing 93

    set autotrace in SQL*Plus on will also explain
    ******************************************************
    example: = output will appear on the screen
    1) sign into sqlplus
    2) type: set autotrace on explain
    3) run SQL statement
    4) type: set autotrace off explain

  • RELEVANCY SCORE 2.78

    DB:2.78:Query Of Explain Plan 7s


    1)explain plan
    set statement_id='anu_a_1'
    for select i.name from a i,b j
    where i.id=j.id1
    order by i.id

    when i am trying to select rows from plan table

    what is the purpose of id,parent_id column

    what is the meaning of these output which is associated with 1st query.

    OPERATIONOPTIONS
    -------------------------------------------------------------------

    SORTORDER BY

    when i am trying to run 2nd query

    2)explain plan
    set statement_id='anu_a_1'
    for select * from a
    where id=10
    order by id

    OPERATIONOPTIONS
    -------------------------------------------------------------------

    SORTORDER BY

    these are not come

    why i am using here same order by clause.

    DB:2.78:Query Of Explain Plan 7s

    Study the documentation.

    http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96533/opt_ops.htm#1005137

    "
    SORT ORDER BY

    SORT ORDER BY is required when the statement specifies an ORDER BY that cannot be satisfied by one of the indexes
    "

    Rgds.

  • RELEVANCY SCORE 2.77

    DB:2.77:Even Disabled, Icloud Service Uses Data On My Iphone 4s x8


    Does someone know why the icloud service use above 1mb of data per day even if the icloud service is disabled?I called the Apple support, the answer was not convincing. It is normal, increase your data plan if you reach the limit.Kind regards,Yves

    DB:2.77:Even Disabled, Icloud Service Uses Data On My Iphone 4s x8

    Clearly Aple do not care about these issues. It's sad because Apple products are generally great. But if you cannot get good support what is the point ???

  • RELEVANCY SCORE 2.77

    DB:2.77:Re: Dbms_Xplan 91


    Why do you want to that? Isn't the explain plan button good enough?

    DB:2.77:Re: Dbms_Xplan 91

    I understand your choice now. I was assuming SQLDeveloper was invoking the autotrace from SQL*Plus.

    3. Am I correct that you won't see projection column even if you set DBMS_XPLAN level to ALL?I don't believe there is any option with autotrace to do anything other than 'TYPICAL'. If this is a wrong assumption, then hopefully some one from this forum will correct me.

    Thanks.

  • RELEVANCY SCORE 2.77

    DB:2.77:Explain Plan Of A Query. 9f


    I want to know the concept of this 'Explain Plan' of a query why it is used. Could u also give the syntax of how a explain plan for a query can be done. Please help in solving the doubt as it is urgent.

    DB:2.77:Explain Plan Of A Query. 9f

    EXPLAIN PLAN gives you the overview of how the query is executing. How much time it is taking, what indexes are using. Is the query is doing full table scan or index scan etc.

    There is one more utility called SQLT. Check it in metalink. It gives more information than Explain Plan.

    Nagendra R Kondeti

  • RELEVANCY SCORE 2.77

    DB:2.77:Explain Plan 3d


    Hi,

    I have an explan plan for all rows with the statistics:
    Cost :84
    IO Cost : 64

    They are small numbers, but why is it that my query took forever to run?

    How can I generate an explain plan that will give me an estimated time that the query will run? Or at least some statistics that will be indicative of how long it will take to run the query and get all results

    DB:2.77:Explain Plan 3d

    SQL create or replace function f return number is begin sys.dbms_lock.sleep(12345); return 0; end;
    2 /

    Function created.

    SQL set autot trace exp
    SQL select f from dual;

    Execution Plan
    ----------------------------------------------------------
    Plan hash value: 1546270724

    -----------------------------------------------------------------
    | Id | Operation | Name | Rows | Cost (%CPU)| Time |
    -----------------------------------------------------------------
    | 0 | SELECT STATEMENT | | 1 | 2 (0)| 00:00:01 |
    | 1 | FAST DUAL | | 1 | 2 (0)| 00:00:01 |
    -----------------------------------------------------------------

    SQL set autot off timi on
    SQL select f from dual;
    F
    ----------
    0

    Elapsed: 03:25:45.05Message was edited by:
    Laurent Schneider
    a low cost does not imply a low response time. Use tkprof

  • RELEVANCY SCORE 2.77

    DB:2.77:Used Explain Plan k7


    Hi,on 11.2.0.3 , I use the following to verify the Explain Plan used for an executed query.SELECT * FROMTABLE(DBMS_XPLAN.DISPLAY_AWR('sql_id','plan_hash'));For exampleSELECT * FROM TABLE(DBMS_XPLAN.DISPLAY_AWR('cx8m90z5n57g1','3867296312')); The problem is that it does not bring always back a result to display . Every now and then it does not find any Explain Plan. Why ? Any other way that let to find Used Explain Plan for sure ?Thanks and regards.

  • RELEVANCY SCORE 2.77

    DB:2.77:Why Is My Apple Account Disabled? 81


    why is my apple account disabled?

    DB:2.77:Why Is My Apple Account Disabled? 81

    Where are the instructions for reinstating it?