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

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

1 Answer

Answer :

COST and RULE.
by

Related questions

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 ?

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.

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

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.

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

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.

What is the function of Optimizer ?

Description : What is the function of Optimizer ?

Last Answer : The goal of the optimizer is to choose the most efficient way to execute a SQL statement.

What are the different approaches used by Optimizer in choosing an execution plan ?

Description : What are the different approaches used by Optimizer in choosing an execution plan ?

Last Answer : Rule-based and Cost-based.

When the form is running in DEBUG mode, If you want to examine the values of global variables and other form variables, What package procedure command you would use in your trigger text ?

Description : When the form is running in DEBUG mode, If you want to examine the values of global variables and other form variables, What package procedure command you would use in your trigger text ?

Last Answer : Break. SYSTEM VARIABLES

What is the OPTIMAL parameter?

Description : What is the OPTIMAL parameter?

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

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

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.

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

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

Last Answer : Yes

Can u run the report with out a parameter form

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

Table Space,Data Files,Parameter File, Control Files

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.

What is difference between a formal and an actual parameter?

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

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

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

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

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.

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?

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.

How do you reference a Parameter?

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

What use of command line parameter cmd file?

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.

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

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

Last Answer : Read only

What are the different Parameter types?

Description : What are the different Parameter types?

Last Answer : Text ParametersData Parameters

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

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.

How do you reference a parameter indirectly?

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')

When do you use data parameter type?

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

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?

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.

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

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

Last Answer : Yes.

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

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.

What is PGA_AGGREGATE_TARGET parameter?

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.

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

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

Last Answer : ALLOW_RESETLOGS_CORRUPTION

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

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

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

What is the maximum buffer size that can be specified using the DBMS_OUTPUT.ENABLE function?

Description : What is the maximum buffer size that can be specified using the DBMS_OUTPUT.ENABLE function?

Last Answer : 1,000,00

How many types of database triggers can be specified on a table ? What are they ?

Description : How many types of database triggers can be specified on a table ? What are they ?

Last Answer : Insert Update Delete Before Row o.k. o.k. o.k. After Row o.k. o.k. o.k. Before Statement o.k. o.k. o.k. After Statement o.k. o.k. o.k. If FOR EACH ROW clause is ... for each Row affected by the statement. If WHEN clause is specified, the trigger fires according to the returned Boolean value.

Which of the following is specified parameter of SLA? a) Response times b) Responsibilities of each party c) Warranties d) All of the mentioned

Description : Which of the following is specified parameter of SLA? a) Response times b) Responsibilities of each party c) Warranties d) All of the mentioned

Last Answer : All of the mentioned

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

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.

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

Description : Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

Last Answer : ARCHIVELOG mode is a mode that you can put the database in for creating a backup of all transactions that have occurred in the database so that you can recover to any point in time. ... having to write transactions to an archive log and thus increases the performance of the database slightly.

What is Restricted Mode of Instance Startup ?

Description : What is Restricted Mode of Instance Startup ?

Last Answer : An instance can be started in (or later altered to be in) restricted mode so that when the database is open connections are limited only to those whose user accounts have been granted the RESTRICTED SESSION system privilege.

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode ?

Description : What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode ?

Last Answer : Complete database recovery from disk failure is possible only in ARCHIVELOG mode. Online database backup is possible only in ARCHIVELOG mode.

What are savepoint mode and cursor mode properties ? level?

Description : What are savepoint mode and cursor mode properties ? level?

Last Answer : Specifies whether Oracle Forms should issue savepoints during a session. This property is included primarily for applications that will run against non-ORACLE data sources. For applications that will run ... use the default setting. Cursor mode - define cursur state across transaction Open/close.

what are key-mode and locking mode properties? level ?

Description : what are key-mode and locking mode properties? level ?

Last Answer : Key Mode : Specifies how oracle forms uniquely identifies rows in the database.This is property includes for application that will run against NON-ORACLE datasources . Key setting unique (default.) ... locks on rows that correspond to queried records in the form. a) immediate b) delayed

My database was terminated while in BACKUP MODE, do I need to recover? (for DBA

Description : My database was terminated while in BACKUP MODE, do I need to recover? (for DBA

Last Answer : If a database was terminated while one of its tablespaces was in BACKUP MODE (ALTER TABLESPACE xyz BEGIN BACKUP;), it will tell you that media recovery is required when you try to restart the ... : ALTER DATABASE END BACKUP; The above commands need to be issued when the database is mounted.

Does Oracle write to data files in begin/hot backup mode? (for DBA

Description : Does Oracle write to data files in begin/hot backup mode? (for DBA

Last Answer : Oracle will stop updating file headers, but will continue to write data to the database files even if a tablespace is in backup mode.In backup mode, Oracle will write out complete changed blocks ... ). Because of this, one should notice increased log activity and archiving during on-line backups.

What is the diff. when confine mode is on and when it is off?

Description : What is the diff. when confine mode is on and when it is off?

Last Answer : When confine mode is on, an object cannot be moved outside its parent in the layout.

What is the diff. when Flex mode is mode on and when it is off?

Description : What is the diff. when Flex mode is mode on and when it is off?

Last Answer : When flex mode is on, reports automatically resizes the parent when the child is resized.

Which command will we use to manage (stop, start…) RAC services in command-line mode?

Description : Which command will we use to manage (stop, start…) RAC services in command-line mode?

Last Answer : srvctl

What are the return values of functions SQLCODE and SQLERRM ? What is Pragma EXECPTION_INIT ? Explain the usage ?

Description : What are the return values of functions SQLCODE and SQLERRM ? What is Pragma EXECPTION_INIT ? Explain the usage ?

Last Answer : SQLCODE returns the latest code of the error that has occurred. SQLERRM returns the relevant error message of the SQLCODE.

Can you pass values to-and-fro from foreign function ? how ?

Description : Can you pass values to-and-fro from foreign function ? how ?

Last Answer : Yes . You obtain a return value from a foreign function by assigning the return value to an Oracle Forms variable or item. Make sure that the Oracle Forms variable or item is the same data type as ... SQL data type; it must also be the appropriate parameter type as defined in the PL/SQL interface.

Can the default values be assigned to actual parameters?

Description : Can the default values be assigned to actual parameters?

Last Answer : Yes

What are the two ways by which data can be generated for a parameters list of values?

Description : What are the two ways by which data can be generated for a parameters list of values?

Last Answer : 1. Using static values. 2. Writing select statement.

How can values be passed bet. precompiler exits & Oracle call interface?

Description : How can values be passed bet. precompiler exits & Oracle call interface?

Last Answer : By using the statement EXECIAFGET & EXECIAFPUT.

What are the built-ins used for Getting cell values?

Description : What are the built-ins used for Getting cell values?

Last Answer : GET_GROUP_CHAR_CELL (function) GET_GROUPCELL(function) GET_GROUP_NUMBET_CELL(function)

What are the built-in used for getting cell values?

Description : What are the built-in used for getting cell values?

Last Answer : Get_group_char_cell(function) Get_groupcell(function) Get_group_number_cell(function)

CROSS VALIDATING VALUES

Description : CROSS VALIDATING VALUES

Last Answer : - For key flexfields with multiple segments, we can define rules to cross check value combinations entered with in the key flexfield segments. This option is referred as Cross Validation rules.