WWhat is the use of ANALYZE command ?

WWhat is the use of ANALYZE command ?
by

1 Answer

Answer :

To perform one of these function on an index,table, or cluster:
- To collect statistics about object used by the optimizer and store
them in the data dictionary.
- To delete statistics about the object used by object from the data
dictionary.
- To validate the structure of the object.
- To identify migrated and chained rows of the table or cluster.
by

Related questions

wwhat is eating my potted million bells

Description : wwhat is eating my potted million bells

Last Answer : after the sun almost goes down mix up 1 teasp non-alcohol w 1 qt water and spray....................after it rains spray again..............if you think that it is ants....put cornmeal down....they love it but can't digest it.

What is WWhat is "leakage flux?"

Description : What is "leakage flux?"

Last Answer : Lines of flux generated by one winding which do not link the other winding.

What is the use of TABLES option in EXP command ?

Description : What is the use of TABLES option in EXP command ?

Last Answer : List of tables should be exported.ze)

What is the use of PARFILE option in EXP command ?

Description : What is the use of PARFILE option in EXP command ?

Last Answer : Name of the parameter file to be passed for export.

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 command would you use to encrypt a PL/SQL application?

Description : What command would you use to encrypt a PL/SQL application?

Last Answer : WRAP

What command would you use to create a backup control file?

Description : What command would you use to create a backup control file?

Last Answer : Alter database backup control file to trace.

What is the use of CONSISTENT (Ver 7) option in EXP command ?

Description : What is the use of CONSISTENT (Ver 7) option in EXP command ?

Last Answer : A flag to indicate whether a read consistent version of all the exported objects should be maintained.

What is the use of CONSTRAINTS option in EXP command ?

Description : What is the use of CONSTRAINTS option in EXP command ?

Last Answer : A flag to indicate whether constraints on table need to be exported.

What is the use of SHOW option in IMP command ?

Description : What is the use of SHOW option in IMP command ?

Last Answer : A flag to indicate whether file content should be displayed or not.

What is the use of FULL option in EXP command ?

Description : What is the use of FULL option in EXP command ?

Last Answer : A flag to indicate whether full databse export should be performed.

What is the use of GRANT option in IMP command ?

Description : What is the use of GRANT option in IMP command ?

Last Answer : A flag to indicate whether grants on database objects will be imported

What is the use of GRANT option in EXP command?

Description : What is the use of GRANT option in EXP command?

Last Answer : A flag to indicate whether grants on databse objects will be exported or not. Value is 'Y' or 'N'.

What is the use of INDEXES option in IMP command ?

Description : What is the use of INDEXES option in IMP command ?

Last Answer : A flag to indicate whether import should import index on tables or not.

What is the use of INDEXES option in EXP command ?

Description : What is the use of INDEXES option in EXP command ?

Last Answer : A flag to indicate whether indexes on tables will be exported.

What is the use of ROWS option in IMP command ?

Description : What is the use of ROWS option in IMP command ?

Last Answer : A flag to indicate whether rows should be imported. If this is set to 'N' then only DDL for database objects will be executed.

What is the use of ANALYSE ( Ver 7) option in EXP command ?

Description : What is the use of ANALYSE ( Ver 7) option in EXP command ?

Last Answer : A flag to indicate whether statistical information about the exported objects should be written to export dump file.

What is the use of IGNORE option in IMP command ?

Description : What is the use of IGNORE option in IMP command ?

Last Answer : A flag to indicate whether the import should ignore errors encounter when issuing CREATE commands.

What is the use of COMPRESS option in EXP command ?

Description : What is the use of COMPRESS option in EXP command ?

Last Answer : Flag to indicate whether export should compress fragmented segments into single extents.

What is the use of ROWS option in EXP command ?

Description : What is the use of ROWS option in EXP command ?

Last Answer : Flag to indicate whether export should compress fragmented segments into single extents.

What is the use of RECORD option in EXP command?

Description : What is the use of RECORD option in EXP command?

Last Answer : For Incremental exports, the flag indirects whether a record will be stores data dictionary tables recording the export.

What is the use of PARFILE option in EXP command ?

Description : What is the use of PARFILE option in EXP command ?

Last Answer : Name of the parameter file to be passed for export.

What is the use of RECORD LENGTH option in EXP command ?

Description : What is the use of RECORD LENGTH option in EXP command ?

Last Answer : Record length in bytes.

What is the use of FILE option in IMP command ?

Description : What is the use of FILE option in IMP command ?

Last Answer : The name of the file from which import should be performed.

What is the use of INCTYPE option in EXP command ?

Description : What is the use of INCTYPE option in EXP command ?

Last Answer : Type export should be performed COMPLETE,CUMULATIVE,INCREMENTAL. List the sequence of events when a large transaction that exceeds beyond its optimal value when an entry wraps and causes the rollback segment toexpand into anotion Completes. e. will be written.

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 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 command would you use to check the availability of the RAC system?

Description : What command would you use to check the availability of the RAC system?

Last Answer : crs_stat -t -v (-t -v are optional)

What command will you use to navigate through ASM files?

Description : What command will you use to navigate through ASM files?

Last Answer : asmcmd

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.

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 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.

Some Basics command of ORACLE 10g on Windows Operating System:

Description : Some Basics command of ORACLE 10g on Windows Operating System:

Last Answer : SQL> show parameter db_name SQL> show parameter instance_name SQL> show parameterdb_block_size (it will show the default block size which is 8KB)

What command will you start to run the installation of Oracle software on Linux?

Description : What command will you start to run the installation of Oracle software on Linux?

Last Answer : runInstaller

If you use a social media analytics tool like True Social Metrics, what can you use it for to get a better understanding of what content is effective - and what isn't? A. Measure the real active engagement of users with your social media pages B. Compare your results against that of your competitors and learn their best practices. C. Analyze which topics and types of content are the most effective at engaging your influencers. D. All of the above

Description : If you use a social media analytics tool like True Social Metrics, what can you use it for to get a better understanding of what content is effective - and what isn't? A. Measure the real ... topics and types of content are the most effective at engaging your influencers. D. All of the above

Last Answer : D. All of the above

The Hawthorne studies: (a) Found that to increase worker efficiency, management must analyze and minimize the motions required to complete a task. (b) Found that when workers know they are being watched, their productivity increases. (c) Found that a worker is inherently lazy and will use any excuse not to perform their duties. (d) Found that workers accept a managerial directive only if it is acceptable in terms of their personal interests.

Description : The Hawthorne studies: (a) Found that to increase worker efficiency, management must analyze and minimize the motions required to complete a task. (b) Found that when workers know they are ... that workers accept a managerial directive only if it is acceptable in terms of their personal interests.

Last Answer : (b) Found that when workers know they are being watched, their productivity increases. 

Can someone analyze the poem "A Professional Middle Class Couple" for me? I can't understand it.

Description : Can someone analyze the poem "A Professional Middle Class Couple" for me? I can't understand it.

Last Answer : We don’t do homework here but I would suggest you can analyze it yourself by looking at what is being contrasted between the couple’s apparel and where it came from. That should give you a place to start.

Could someone help me analyze this chat conversation[Details inside]?

Description : Could someone help me analyze this chat conversation[Details inside]?

Last Answer : answer:She's finding you to be a liar twice in one conversation. Not going too well for you right now. First off, you told her that if I like a girl, I'll tell her but you like her ... then you're probably not mature enough to be out of the house alone and talking to girls in the first place.

When you make a mistake do you analyze it and learn from it, or do you quickly reverse the mistake and vow to never do it again?

Description : When you make a mistake do you analyze it and learn from it, or do you quickly reverse the mistake and vow to never do it again?

Last Answer : That seems like a false dichotomy. You can reverse the mistake, vow never to do it again and analyze it and learn from it. It sounds more like you’re asking about happy accidents.

Monday morning quarterbacks! Care to analyze the 2014 Superbowl?

Description : Monday morning quarterbacks! Care to analyze the 2014 Superbowl?

Last Answer : answer:Well, I think that it is a positive anti-drug message. The team whose state has not yet implemented legalized pot beat the team whose state is stoned.

Can Hijackthis! still be found and sites that analyze the results?

Description : Can Hijackthis! still be found and sites that analyze the results?

Last Answer : I think it’s just Chrome. I have a lot of trouble with the so-called unsafe page notice as well.

When studying sonnets or other poems, why do we analyze the stressed and unstressed syllables?

Description : When studying sonnets or other poems, why do we analyze the stressed and unstressed syllables?

Last Answer : The author had a rhythm in mind when he/she wrote the piece. If you don’t get that down how are you living up to what the author had in mind? Is that simple enough for a teenager?

Can we analyze the Marriott Rewards advertising brochure inserted into this week's Time Magazine?

Description : Can we analyze the Marriott Rewards advertising brochure inserted into this week's Time Magazine?

Last Answer : answer:Disclaimer: We are members of the Marriott Rewards Club. I believe that type of advertising is aimed toward the newly wealthy or what we used to call YUPPY, Young Urban Professional. It is meant as a starter or entry into the Luxury Class.

How do you analyze a sonnet?

Description : How do you analyze a sonnet?

Last Answer : Oddly enough a similar question was asked here before though the answers don’t look too helpful. You could try here but you will have to read it, use your imagination and come up with some of your own ideas.

Has anyone read the book "How to Analyze People on Sight"? Is this a gimmick or is it accurate?

Description : Has anyone read the book "How to Analyze People on Sight"? Is this a gimmick or is it accurate?

Last Answer : answer:I have no read it, but I believe it is possible. I don't know if I can do it on sight, but I know I can do it if I see someone move-preferably by dancing with them. You can tell a lot ... if there is a formula for these things. I'd have to read the book to see if I agreed with their method.

Would you analyze a trend of your choice?

Description : Would you analyze a trend of your choice?

Last Answer : There is a trend that girls are hitting puberty earlier than ever and I agree that it is linked to obesity on the rise and to the kinds of foods we, as a society, feed our children (meat and ... they shouldn't eat meat and dairy and that kids, given how horrible school food is, should eat better.

I tend to over analyze things, how can I change this.

Description : I tend to over analyze things, how can I change this.

Last Answer : I think it’s just natural to over analyze things in certain situations. Everyone does it. Don’t worry about it.

How to analyze BSOD dumps on Windows XP/Vista?

Description : How to analyze BSOD dumps on Windows XP/Vista?

Last Answer : How do you mean? Are you saying you see the BSOD, and you want to be able to read it and know what caused it? If that's what you're saying - you'll usually get an error code or ... easily found by just googling the error code you got. If that's not what you're saying sorry I misinterpreted!

I have to analyze a Star Trek movie for my 'Intro to Cultural Anthropoloy' class. In this assignment I have to apply 4 anthropological theories, and find examples from the movie. Which Star Trek movie is the best one to get for this or which one is the best Star Trek movie out there, that I can stay awake watching?

Description : I have to analyze a Star Trek movie for my 'Intro to Cultural Anthropoloy' class. In this assignment I have to apply 4 anthropological theories, and find examples from the movie. Which Star Trek movie is ... this or which one is the best Star Trek movie out there, that I can stay awake watching?

Last Answer : Any will work. Btw, folks here don’t like doing your homework for you, I’ve noticed.

"I heard him come home late." How would we analyze this sentence?

Description : "I heard him come home late." How would we analyze this sentence?

Last Answer : Elliptical infinitive is when you drop the to part from the infinitive, correct? In that case, I definitely think it's an elliptical infinitive. to come home to come home . I heard him coming ... present (-ing) I heard THAT he came/had come home late - indirect statement Language is fun!