scroll to top
Stuck on your essay?
Get ideas from this essay and see how your work stacks up
Word Count: 489
In many business environments there are a subset of transaction that are time critical The amount of time that it takes to perform the transaction radically impacts other business processes downstream An example of this may be a marketing report that allows the marketing division of an organization to judge the effectiveness of an advertising campaign in various cities across the country The ability to judge the effectiveness of the campaign in a timely manner can be critical in making decisions concerning the purchase of ad space in newspapers or magazines The inability to make that decision because a report is performing poorly can potentially lead to inaccurate and If the DBA is concerned about making certain that business critical queries are insulated from factors that may change their performance characteristics then stored outlines can provide some measure of performance stabilityEach query that is delivered to the Oracle server goes through a number of processes before it is executed Some of these basic steps areParse - this step does an analysis of the query to determine a number of basic attributes associated with the query such as if the table the query is referencing exists in the database Another function of this step is to hash the query The result of the hash is a value that can be used to search the library buffer cache to determine if the query has been executed before If the query has been executed before then an execution plan has already been created for the query If the query has never been executed since the instance has started then an execution plan needs to be created for the queryExecute - this step actually executes the query once it has been parsedFetch - this step returns rows to the process executing the query assuming thatDuring the parse phase of query processing an execution plan is created for a query The execution plan defines how the data is to be
@Kibin is a lifesaver for my essay right now!!
- Sandra Slivka, student @ UC Berkeley
Wow, this is the best essay help I've ever received!
- Camvu Pham, student @ U of M
If I'd known about @Kibin in college, I would have gotten much more sleep
- Jen Soust, alumni @ UCLA