What is the OPTIMAL parameter?

1 Answer

Answer :

How does one use ORADEBUG from Server Manager/ SQL*Plus? (for DBA

Related questions

Description : What are the minimum parameters should exist in the parameter file (init.ora) ?

Last Answer : DB NAME - Must set to a text string of no more than 8 characters and it will be stored inside the datafiles, redo log files and control files and control ... an ORACLE instance acquires at database startup. Also optionally LICENSE_MAX_SESSIONS,LICENSE_SESSION_WARNING and LICENSE_MAX_USERS.

Description : What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ? )

Last Answer : CHOOSE,ALL_ROWS,FIRST_ROWS and RULE.

Description : What are the values that can be specified for OPTIMIZER MODE Parameter ?

Last Answer : COST and RULE.

Description : s it possible to disable the parameter from while running the report?

Last Answer : Yes

Description : Can u run the report with out a parameter form

Last Answer : Yes it is possible to run the report without parameter form by setting the PARAM value to Null

Description : Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?

Last Answer : All the default storage parameters defined for the tablespace can be changed using the ALTER TABLESPACE command. When objects are created their INITIAL and MINEXTENS values cannot be changed.

Description : Table Space,Data Files,Parameter File, Control Files

Last Answer : Table Space :: The table space is useful for storing the data in the database.When a database is created two table spaces are created. a) System Table space :: This data file stores all the tables ... They contain the Db name, name and location of dbs, data files ,redo log files and time stamp.

Description : What is difference between a formal and an actual parameter?

Last Answer : The variables declared in the procedure and which are passed, as arguments are called actual, the parameters in the procedure declaration. Actual parameters contain the values that are ... procedure and receive results. Formal parameters are the placeholders for the values of actual parameters

Description : What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?

Last Answer : Add_parameter Create_Parameter_list Delete_parameter Destroy_parameter_list Get_parameter_attr Get_parameter_list set_parameter_attr

Description : Which parameter in Storage clause will reduce no. of rows per block?

Last Answer : PCTFREE parameter Row size also reduces no of rows per block.

Description : What are the default parameter that appear at run time in the parameter screen? What are the various sub events a mouse double click event involves?

Last Answer : Destype and Desname.

Description : How do you reference a Parameter?

Last Answer : In Pl/Sql, You can reference and set the values of form parameters using bind variables syntax. Ex. PARAMETER name = '' or :block.item = PARAMETER Parameter name

Description : What use of command line parameter cmd file?

Last Answer : It is a command line argument that allows you to specify a file that contain a set of arguments for r20run.

Description : Which parameter can be used to set read level consistency across multiple queries?

Last Answer : Read only

Description : What are the different Parameter types?

Last Answer : Text ParametersData Parameters

Description : What is the maximum no of chars the parameter can store?

Last Answer : The maximum no of chars the parameter can store is only valid for char parameters, which can be upto 64K. No parameters default to 23Bytes and Date parameter default to 7Bytes.

Description : How do you reference a parameter indirectly?

Last Answer : To indirectly reference a parameter use the NAME IN, COPY 'built-ins to indirectly set and reference the parameters value' Example name_in ('capital parameter my param'), Copy ('SURESH','Parameter my_param')

Description : When do you use data parameter type?

Last Answer : When the value of a data parameter being passed to a called product is always the name of the record group defined in the current form. Data parameters are used to pass data to produts invoked with the run_product built-in subprogra

Description : If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied?

Last Answer : While both reports 2.0 and 2.5 create the parameter, report 2.5 gives a message that a bind parameter has been created.

Description : Does a Before form trigger fire when the parameter form is suppressed?

Last Answer : Yes.

Description : What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?

Last Answer : The Optimizer chooses Cost_based approach and optimizes with the goal of best throughput if statistics for atleast one of the tables accessed by the SQL statement exist in the data dictionary. Otherwise the OPTIMIZER chooses RULE_based approach.

Description : What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ? What are the factors that affect OPTIMIZER in choosing an Optimization approach ?

Last Answer : Answer The OPTIMIZER_MODE initialization parameter Statistics in the Data Dictionary the OPTIMIZER_GOAL parameter of the ALTER SESSION command hints in the statement.

Description : What is PGA_AGGREGATE_TARGET parameter?

Last Answer : PGA_AGGREGATE_TARGET: specifies the target aggregate PGA memory available to all server processes attached to the instance.

Description : What parameter will you use to force the starting of your database with a corrupted resetlog?

Last Answer : ALLOW_RESETLOGS_CORRUPTION

Description : How can you difference a usual parameter and an undocumented parameter?

Last Answer : Undocumented parameters have the prefix ‘_’. For example, _allow_resetlogs_corruption

Description : Car-savvy jellies: what's the optimal $ cutoff for buying a used car?

Last Answer : I have bought a number of used cars. I would never buy any car that I knew needed work. I always buy a Toyota or Honda. They run forever.

Description : What is the maximum amount of power a AA battery can generate in optimal conditions?

Last Answer : answer:it is possible, it is all in the gearing, although it can lift a man, it would be very slow. With everything there is a trade off of power and speed, if you add to one side, you have to take away from the other side. i.e. more power, less speed, etc.

Description : I want to paint my old furniture. How do I get optimal results?

Last Answer : answer:Use a fine grain sand paper first, then make sure you have completely cleaned off all the dust and oil. It might be a good idea to use a detergent on it. (wood) Consult one of the many internet sites available for tips and ideas for refinishing/repainting furniture.

Description : How do you do an optimal binary search on a two variable function?

Last Answer : You need to clarify your terminology a little bit. Symmetric about the diagonal? Strictly increasing with respect to which ordering of the pairs?

Description : How reliable is the claim that the optimal BMI is 27 because it correlates with maximum life expectancy?

Last Answer : Maybe he’s correct if your BMI is that high because it’s all sheer muscle mass and black hole bone density.

Description : Which three cities would be "optimal" for spreading a contagious agent throughout the world most effectively?

Last Answer : I know, but why would I tell?

Description : What is the optimal time in advance to book hotels online?

Last Answer : answer:Discount strategies vary from hotel to hotel. More often than not, the cheaper rates are found on the online sites. Here is how it typically works: the hotel staff forecasts what their occupancy will ... the reservation is for, ask them to honor the lower rate for your stay. Does this help?

Description : Has eating something from its optimal growing area ruined you for anything less? If so, what?

Last Answer : answer:I agree with you about the corn. I bought some “fresh” corn from Walmart today. It’s only late April. My husband laughed and we discussed where this corn may have came from. but I really wanted corn, and frozen wasn’t going to do good question!

Description : In your humble opinion, what should the human food plan/diet probably consist of for optimal health?

Last Answer : No processed foods, no sugary drinks. The diet consists of mostly vegetables, fruits and whole grains. No meat, no dairy. Obviously, this is our diet and many disagree with it. But that’s what I believe is the healthiest diet.

Description : What is the optimal angle at which to throw an object?

Last Answer : I’m going to have to go back to my Physics book on this one…

Description : What's the most "optimal" camera for Scuba Diving?

Last Answer : I do not have one particular one to recommend, however I do have a very comprehensive site which may be of help. Also keep in mind, there are many “housings” you can purchase for a point and shoot. This way, it won’t turn into a camera you use only on occasion. Best of luck.

Description : What's the optimal way to pump gas?

Last Answer : answer:I always fill up the tank when the marker is at the ¾ mark. That is because gas stations here are few and far between and there are odd and fairly regular power outages. No power, no gas. The marker ... try to keep ½ tank always. And when I pump, I stand upwind so I don't breathe the fumes.

Description : When you grow impulsive and make less than optimal choices, are you aware that it is happening?

Last Answer : Yes, yes, yes. The best example I can give is that I am a compulsive skin picker. Have been since the age of 5. I know it's awful, bad for me, and unsightly, but It's basically painful ... room somewhere in my mind. Then again, perhaps that is the qualification for crazy. I just wish I could stop.

Description : Is there anything you can do if you swallow a piece of hard candy before it has reached its OCSS (optimal comfort swallowing size)?

Last Answer : drink something hot to help it melt faster

Description : From the Aliens' POV, Which of Earth's places would be the optimal choice for peaceful first contact? United States, European Union, Russian Federation, Middle East, or China?

Last Answer : I don't think a first meeting amound a large coroboration of nations would be best An isolated meeting with one of the singular, more powerful nations would be best it seems. if they were to jump ... all at once if you isolate the first experience it reduces the chances of mass panic world wide.

Description : what is the optimal temperature at the base of the stove above a woodstove to avoid creosote buildup.

Last Answer : answer:The ‘optimal’ temperature, I cannot say. However this eHow describes steps you can take to avoid this problem: http://www.ehow.com/how_4855797_avoid-creosote-buildup-wood-stoves.html They do mention quickly getting the heat to over 220º in step 3. Cheers!

Description : azaleas when to fertilize and optimal fertilizer

Last Answer : I would test them first for PH...............

Description : What is optimal cost?

Last Answer : From an Information technology perspective, optimizing yourcosts is about spending wisely and judging where you cut and whereyou invest in terms of the impact on the business.

Description : If someone is trying to take everything into account and wants to have a child thoughtfully, how do you think you would decide how many people to give birth to?

Last Answer : Hi, I was born at the age of 22 this year, so we figured it out, it was optimal for us. However, it is also very situation-dependent and people-dependent. If someone's head doesn't ... 's obviously worth it afterwards. There are early watchers and late watchers. I think it's different for everyone.

Description : When is the optimal time to purchase investment real estate property?

Last Answer : The optimal time to purchase investment real estate property is when real estate prices are low - but before interest rates have fallen to zero. Real estate value is tied to two things - the ... , because it becomes more expensive for potential buyers to borrow money to buy the property from you.

Description : What is the optimal heart rate to start burning fat and calories?

Last Answer : It is recommended to work within 80-85% of your maximum heart rate for the highest rate of fat loss and calorie burning. The Karvonen formula tells you your maximum heart rate (http://exercise.about.com/cs/fitnesstools/g/karvonen.htm).

Description : What is needed to insure optimal engine performance?

Last Answer : Proper engine maintanace is the only thing that will insure optimal engine performance. Doing some simple things like using a higher octane fuel,and installing high quality air filter will also help your performance.

Description : What is a optimal exercise heart rate for a 35 yr old?

Last Answer : "Exercise heart rate is between 65 to 85% of (220-age = 185) i.e., 120 to 157 beats per minute. If you are a female, substitute 210 for 220." http://www.get-a-six-pack.info/what-is-a-optimal-exercise-heart-rate-for-a-35-yr-old/

Description : The optimal pH for the enzyme chymotrypsin is (A) 2.0 (B) 4.0 (C) 6.0 (D) 8.0

Last Answer : Answer : D

Description : The optimal pH for the enzyme trypsin is (A) 1.0–2.0 (B) 2.0–4.0 (C) 5.2–6.2 (D) 5.8–6.2

Last Answer : Answer : C