Unit 4: Troubleshooting / Scenarios
Q.1: Define the concept of troubleshooting in ORACLE?
Ans: In Oracle, troubleshooting is a state-of-the-art concept. It defines directions to perform an appropriate process of resolving Oracle performance issues. Oracle is one of the world's largest database. A steep density has turned Oracle into a difficult database hard to troubleshoot.
Q.2: What are the major objectives of Oracle troubleshooting?
Ans: The major objectives of Oracle troubleshooting include:
1. To learn latest troubleshooting methods for optimizing and monitoring the memory usage.
2. To learn an accurate methodology to be used for investigating the Oracle database.
3. To get knowledge how to locate and decide Input / Output storage points,
…show more content…
To acquire knowledge of using multiple scripts used to expose session related bottlenecks.
5. To fully understand the techniques that are used to locate and fix SQL issues.
6. To comprehend bottleneck and ratio-based troubleshooting examination.
Q.3: What is the best time to increase copy latches? Mention parameter used to control copy latches?
Ans: The best time to increase copy latches is when a DBA gets extra contention for copy latches shown by the “redo copy” latch hit ratio. An initialization parameter LOG_SIMULTANEOUS_COPIES is used to double the CPU on the system.
Q.4: What would you do in the following scenario?
“A job that normally takes one hour to execute, is taking six hours now. What steps would you take to resolve the issue as a DBA?”
Ans: In this scenario, I will take the following steps:
1. I will verify if there is any modification in the job code.
2. Then, I will check statistics of table.
3. After checking statistics, I will generate explain plan for all DML/DDL statements and the SQL queries written in that particular job.
4. To check the index involvement, I will disable all indexes temporarily so that the job execution time can be minimized.
Q.5: What would you do in the following
…show more content…
Yes, I have used partitioning because it effectively enhances the manageability, performance, and availability of a number of applications. It has helped me in reducing the total ownership cost for piling large sized data. Partitioning permits tables, indexes, and index-organized tables so that they can be subdivided into smaller segments.
Q.11: Why do we use composite partitioning?
Ans: We use partitioning if we work with large sized table. We need faster access enabling the database objects to manage and access granularity. Oracle provides a number of partitioning extensions and strategies to meet the needs of enterprises.
Q.12: How do you re-organize the Oracle database?
Ans: In Oracle 9i, we use “EXP / IMP” command move table. From Oracle 10g and onwards, we use “SHIRNK COMPACT” command.
Q.13: What is the difference between global and local index?
Ans: A global index is known as one-to-many relationship. It allows one index partition to map with many table partitions. On the other hand, a local index is a one-to-one mapping between an index partition and a table partition.
Q.13: Why do indexes become impracticable during a table
Answer: Drop_NoFast scenario has the slowest growth in sequence numbers since it has 0.5% of packet drop and even fast retransmit is turned off in the TCP settings. Therefore there are several timeouts in the connection and usually one big timeout period occurs before transmission of packet again. But due to fast retransmit turned on, only 3 round trips of time occurs before a packet is retransmitted so there is a faster recovery.
Analysing the graph, since there are loss of packets and retransmission, the congestion window size graph fluctuates by increasing and decreasing very frequently.
The main problem, in this case, is involving Vermont Teddy Bear which was John Sortino in 1981 is that the companies point of sale system was severely lagging behind. In 2011, The company struggled with major surges in customer periods, for example, Valentine's day and Christmas Eve this occurred because of VTB's intricate middleware system. The issue may have happened because instead of revamping it's system during down periods the company attempted to do patch work jobs over time. This is quite alarming because a major retailer would not have these types of issues with the system when they need it most. Which leads to the next point of the IT supervisor being faced with a dilemma on what to improve prior to the next surge period(Mother's
The “Robust” OP’s tempo seems to drive supervision to push speedy completion of certain jobs, at all costs, we understand the importance of the FMC rate, some of these planes are twenty nine years old, yet they’re flown like they just came off the assembly line, things break, parts can be difficult to get, OP’s needs to be aware of that.
The most critical problem my interviewee encountered the past year was staffing, she had a handful of employees leaving several positions in her branch that needed filling. Moreover, the process of hiring and training took some time, and getting the staff in place was time consuming. Other critical problem my interviewee encountered is calming down the customers after a misunderstanding with a bank teller.
This is one of the most effective ways of speeding up the rate of a
... realize the logistics of time management during the first year’s efforts by requiring 64 interviews during one week of inexperienced recruiters whose normal job is to manage departments.
The long hours 2. And having to have a great deal of patience Conclusion: Describe why I would this job. Mike Smith MR. Smith EXPOS.
Oracle's relational databases represent a new and exciting database technology and philosophy on campus. As the Oracle development projects continue to impact on University applications, more and more users will realize the power and capabilities of relational database technology.
That’s why they’re there when you need them. Specifically, my main goal in this paper is to help you understand what a Computer Systems Analyst is, what they do, things like those that explain everything about a Computer Systems Analyst. You could probably guess from the name of this job title that the main function of a Computer Systems Analyst is to determine how a computer system can best help something. Well, this is exactly the key role of what they do is determine how a computer system can best serve a business or organization's needs. David P. Bieg says “You need to understand how systems interact, but you don’t really need to understand the core of every technology---it’s really about how information and process flows through the system.”
Learning from failures is more important than fixing problems. It is crucial to address the system and process problems that cause the failure in the first place
However, in some cases we need to develop strategies for them to improve their efficiency, improve their machinery, install backup generation, etc. In these scenarios, a team is developed with the consultant being the project manager or point man. Therefore, these projects require the four functions to be followed so we can develop the best possible solution. The first function used is “Planning”, which allows us to outline a strategy catering to the specific needs of our client. The “Planning” function also gives us a time table on how long the project will take to complete, who needs to be involved, and how we expect to accomplish each goal.
They provide two term of flexibility “initial flexibility” and “subsequent flexibility”. “Initial flexibility” is to plan the spacing of windows in such a way that you can insert partition walls on a module of perhaps two meters. The other kind is that everything can change all the time, where all partitions are movable. That is very expensive and most of the time it is not needed, because people’s are not that movable. When for example you have a wall that can move but you have people working with tons of document on the other side. There will be a great likelihood that this wall will never move. Therefore, the question rises if that kind of flexibility is really necessary much of the time? (Proto,
Almost all commercial database systems available today are designed to provide a high level of performance to its users. Nonetheless, Database Performance Tuning for large volumes of data is an arduous task. Even minor changes can bring about a substantial impact (positive or negative) on the performance of the system (KOCH, 2014).
The scheduler should scale well with a growing number of tasks, ideally being O(1). This is observed in the Linux kernel.