If you're looking for Oracle TM Interview Questions for Experienced or Freshers, you are at right place. There are lot of opportunities from many reputed companies in the world. According to research Oracle TM has a market share of about 26.2%. So, You still have opportunity to move ahead in your career in Oracle TM Supply Chain Analyst. Mindmajix offers Advanced Oracle TM Interview Questions 2018 that helps you in cracking your interview & acquire dream career as Oracle TM Developer.
1. What do you know about the user-defined metrics in Oracle?
When it comes to enterprise manager monitoring, the reach and strength of the same can easily be extended up to a great extent. You might have no idea but the fact is this enables organizations to derive certain benefits. Almost all the conditions which are specific or which seem to be specific for a task can simply be meet.
2. Does SQL based metrics support external scripts?
No, they don’t support the same. Users need to enter the SQL in the enterprise manager directly and this is done at the time of creation of metric. It can even be done at a later stage. However, there are problems with the time and storage allocation which even make simple tasks very complex and users have to adopt other paths to keep up the pace in this matter.
3. Is it possible to define new metrics with the help of custom operating system in Oracle TM?
Yes, this is possible. Generally, the operating system based approach is considered for this purpose and users can always make sure of authenticity in this task.
4. For what purpose you can use an OS based metrics?
These are generally considered when it comes to monitoring a specific condition. A custom script can easily be written with the help of which this task can easily be accomplished. The script will be specified each time when the enterprise manager is evaluated. However, it depends largely on the script for returning its value.
5. What are the types of user-defined metrics that can be used for extending the monitoring capabilities?
Operating system based user Defined metrics
SQL based user defined metrics
6. What is the role of custom scripts of SQL queries in Metrics?
SQL queries, custom calls as well as custom scripts are deployed for the same purpose and i.e. for the purpose of monitoring metrics and triggering the alerts. This makes sure of the smooth flow of the operations in the shortest possible manner and without calling any extra functions for the same.
7. What you need to do to make the features available in a metrics after creating the same?
Well, in Oracle TM, users need not to worry about the same. This is because once the metrics get created, all the required features become available automatically. This is one of the best things about creating metrics that can be deployed for any purpose under the defined conditions.
8. From where you can access the SQL based metrics?
Basically, it is accessed through the target home pages of the databases. When it comes to custom database management, they are generally called for the deployment purposes. In case the time saving approach is to be considered, the functions can also be called in a very easy manner to fulfillment of the similar or the parallel tasks without deriving the extra time.
9. Can you name a few important features that are available in a metrics?
10. How administrators can add custom features in a metrics?
Well, this approach is simple. For this, administrators can simply add their custom monitoring scripts library by integrating the same with the enterprise manager. A user-defined metric can be considered for the effective integration and the good thing is users can simply make sure of quality results. The SQL based metric is common considered for this purpose.
11. Name the two steps which are common in creating the operating System based user defined metrics?
12. Are users free to consider the scripting language of their choice for creating a script?
When it comes to creating a script that is having the information or commands for the purpose of checking the condition under monitoring, users are always free to use the scripting language of their choice. This is one of the best things about metrics that are available with the Oracle TM.
13. Is there any condition on the location of scripts which generally run with user-defined metrics?
Yes, there is a basic condition and i.e. they all should be placed in a directory which the agent must have complete access. Any script outside the directory is generally ignored and users will not be able to use the same unless it is specified in the directory. In case the directory is full, users have the provision to create a new directory and assign the name as per their wish.
14. What is the significance of configuring the script runtime environment?
This actually makes sure that all the scripts can simply be adopted by the management agent for the considered purpose. In case it is not confirmed, scripts always have a limit on their functionality. There are also chances that a few of them doesn’t work in the way they have to be. In addition to this, configuring the script runtime always make sure that multiple metrics can be created at the same time without the use of maximum features or tools.
15. Name one interpreter that scripts generally require? Where should it be installed?
Perl is the interpreter that scripts generally need. It must be installed on the host system.
16. On a particular file system, is it possible that the exact amount of free space can be calculated?
Yes, this is possible and is generally done with the help of defined logic that is responsible for running the code. Users are free to access the same anytime they want and the good thing is it can be customized for extending its capabilities. If the scripts contain a lot of sections or the files, there are chances that the displayed information regarding the memory could be wrong and thus appropriate actions are required for the same.
17. Which value is to be returned by the script after monitoring the object? What does this indicate?
The script should return the value which is associated with the monitoring object. This indicates that there is nothing wrong with the object and the same can executed further. Returning of this value also states that the all the warnings which are related with the object have also been considered. Sometimes it takes extra time for returning this value and under such conditions, users can manually fetch the same with the metric allocation tools.
18. Do you think there is anything which is common in all the monitoring scripts used in the metrics?
Yes, they all must contain the code for performing some basic functions. The two very important ones are Code for the purpose of checking the status of objects monitored. The second is the code to return the script outcomes to the enterprise manager. Users are free to keep the similar information in them if they are meant to perform the similar tasks.
19. What are the values associated with the em_results and em_messages indicates?
This generally contains the information related to the formatted information that the script returns to the enterprise manager. This states that the same has been allocated to the metrics and further operations can now be accomplished. In case of any error, there is a warning sign which appears on the screen. These values can also be provided custom tags or the information for the purpose of using them for other purposes than the ones they are actually meant for.
20. Can you register your script in the console? When it is generally done?
Yes, it’s possible for the users to perform this task. However, under normal conditions it is not done. When there are some critical warnings or a specific threshold is reached, registration in the console is then done. The fact is there are restrictions for registrations at the other locations and console can be used as the last option for this task.
21. What is the first step for the execution of a script after it is created?
It is necessary that the scripts must have the starting point as em_results for a new line wherever it is mentioned. If this condition is not fulfilled, there is always a runtime error on the screen and users have to pay attention to a number of facts for the clearance of the same. Thus it must be considered on priority.
22. Can user submit multiple em_message tags to the metrics?
Yes, users can do so. However, the next message always remains under queue until the first one is completely executed. Also, it is not possible in all the cases. In a few cases, users are not allowed to do so. This is common with the scripts that have multiple tags already with them by default.
23. When situation represents a metric error in the metrics and how this can be eliminated?
When the non-zero value is displayed on the screen or when the STDOUT and STDERR message are not available on the exact location, this indicates the error. Users either need to execute the task again or there is a need for them to reconcile the activities which are considered to eliminate the same.
24. What do you know about the script location in Oracle TM?
Well, it is recommended that the OS scripts which are user-defined must remain at a location which should be outside the agent home. Actually it makes sure that no harm is caused to the script when the agent is updated. This always makes sure that the script remains operational under all the conditions. When you have to register it in the control console, the full path must be specified to the script. In some cases, users are not allowed to use the default properties.
25. Tell something about the script runtime environment?
Upon the evaluation of user-defined metrics, the script also gets executed and is generally specified under at the same time when the script is registered in the EM console. Users need to make sure that the information provided for the authentication purpose must belong to a valid or an active account.
26. Tell one common mistake that users can make while registering the scripts as user-defined metrics?
Well, the fact is its necessary that the agent is present on the machine where the monitoring script resides. A higher residue function is required for performing the function smoothly. A few users forget to keep it on the same machine and this creates runtime error.
27. What should you define in the script along with itself?
Rather than the summary or other useful information, it is necessary that you define the various parameters which are related to the environment and operation of the script. This makes sure it can be used easily with different range metrics without the violation of anything.
28. What do you mean by scheduling a script?
It is nothing but specifying the start time, as well as the frequency at which the script has been created to run. It is necessary to use the agent time zone on the script.
29. What information about the metric you need to provide when you create a new user-defined metric on the metric page?
The information to be provided are Metric name, type, number, command line where it is used, Operating system type, comparison operator, threshold settings, authentication related information, Notifications and alert information and so on.
30. What do you mean by RAC?
It stands for Real Application Cluster and is basically a single instance database.
Free Demo for Corporate & Online Trainings.