Top 30 Oracle Transaction Management Interview Questions
Q1. When Situation Represents A Metric Error In The Metrics And How This Can Be Eliminated?
When the non-0 price is displayed at the screen or while the STDOUT and STDERR message aren't to be had on the exact place, this suggests the error. Users either need to execute the task again or there is a want for them to reconcile the sports that are taken into consideration to get rid of the identical.
Q2. What Are The Values Associated With The Em_results And Em_messages Indicates?
This normally incorporates the data related to the formatted statistics that the script returns to the agency supervisor. This states that the equal has been allocated to the metrics and in addition operations can now be finished. In case of any blunders, there's a warning sign which seems on the screen. These values also can be provided custom tags or the statistics for the cause of using them for different functions than the ones they are clearly intended for.
Q3. What You Need To Do To Make The Features Available In A Metrics After Creating The Same?
Well, in Oracle TM, customers need now not to fear about the equal. This is due to the fact as soon as the metrics get created, all of the required functions grow to be to be had routinely. This is one of the best things approximately developing metrics that may be deployed for any purpose below the described situations.
Q4. What Do You Know About The User-defined Metrics In Oracle?
When it involves organisation supervisor monitoring, the reach and electricity of the same can easily be prolonged up to a first-rate extent. You may don't have any idea but the reality is that this allows groups to derive certain benefits. Almost all of the situations that are precise or which appear to be particular for a challenge can honestly be meet.
Q5. How Administrators Can Add Custom Features In A Metrics?
Well, this technique is simple. For this, administrators can truly upload their custom monitoring scripts library by integrating the equal with the organization supervisor. A person-described metric can be considered for the effective integration and the best aspect is customers can sincerely make sure of high-quality consequences. The SQL based totally metric is common taken into consideration for this purpose.
Q6. Does Sql Based Metrics Support External Scripts?
No, they don’t assist the same. Users need to go into the SQL inside the organisation supervisor directly and that is performed on the time of advent of metric. It can even be done at a later degree. However, there are issues with the time and garage allocation which even make easy responsibilities very complicated and users have to adopt other paths to preserve up the tempo on this rely.
Q7. What Do You Mean By Rac?
It stands for Real Application Cluster and is largely a single example database.
Q8. On A Particular File System, Is It Possible That The Exact Amount Of Free Space Can Be Calculated?
Yes, that is viable and is usually achieved with the help of described common sense this is accountable for running the code. Users are unfastened to get right of entry to the identical each time they need and the coolest issue is it could be custom designed for extending its abilities. If the scripts contain quite a few sections or the documents, there are possibilities that the displayed data concerning the reminiscence will be incorrect and consequently suitable moves are required for the equal.
Q9. Name One Interpreter That Scripts Generally Require? Where Should It Be Installed?
Perl is the interpreter that scripts commonly need. It have to be installed at the host gadget.
Q10. Is It Possible To Define New Metrics With The Help Of Custom Operating System In Oracle Tm?
Yes, this is possible. Generally, the working machine based totally approach is considered for this cause and users can always ensure of authenticity on this project.
Q11. What Is The Significance Of Configuring The Script Runtime Environment?
This in reality makes certain that every one the scripts can absolutely be adopted with the aid of the management agent for the taken into consideration reason. In case it is not showed, scripts usually have a restrict on their functionality. There are also chances that some of them doesn’t work inside the manner they ought to be. In addition to this, configuring the script runtime always make sure that a couple of metrics can be created at the same time without the use of maximum functions or gear.
Q12. Are Users Free To Consider The Scripting Language Of Their Choice For Creating A Script?
When it comes to developing a script that is having the records or commands for the purpose of checking the circumstance below monitoring, customers are constantly free to use the scripting language of their desire. This is one of the first-rate things about metrics that are to be had with the Oracle TM.
Q13. What Do You Mean By Scheduling A Script?
It is not anything however specifying the begin time, as well as the frequency at which the script has been created to run. It is important to apply the agent time region on the script.
Q14. Name The Two Steps Which Are Common In Creating The Operating System Based User Defined Metrics?
These are:
First creating the Operating machine tracking script
Registering the script as a consumer define metric
It is likewise feasible in a few instances to apply it without registration. However, its talents continue to be restrained below one of these situation.
Q15. Tell One Common Mistake That Users Can Make While Registering The Scripts As User-described Metrics?
Well, the truth is its vital that the agent is gift at the machine in which the monitoring script is living. A higher residue feature is needed for acting the feature easily. A few users forget about to hold it at the equal machine and this creates runtime blunders.
Q16. From Where You Can Access The Sql Based Metrics?
Basically, it's miles accessed thru the target home pages of the databases. When it involves custom database control, they are commonly referred to as for the deployment functions. In case the time saving method is to be taken into consideration, the features can also be called in a very clean way to fulfillment of the similar or the parallel duties with out deriving the extra time.
Q17. Can User Submit Multiple Em_message Tags To The Metrics?
Yes, users can accomplish that. However, the next message usually remains under queue until the first one is completely accomplished. Also, it isn't always feasible in all of the instances. In some cases, users aren't allowed to achieve this. This is common with the scripts which have multiple tags already with them with the aid of default.
Q18. Can You Name A Few Important Features That Are Available In A Metrics?
These are:
Notifications associated with the current duties
System signals
Corrective movements taken by way of the users
Historical collections
Metric tracking
Allocation associated functions
Q19. Tell Something About The Script Runtime Environment?
Upon the evaluation of user-defined metrics, the script also gets performed and is commonly special beneath at the same time while the script is registered in the EM console. Users need to ensure that the statistics supplied for the authentication purpose ought to belong to a valid or an energetic account.
Q20. Which Value Is To Be Returned By The Script After Monitoring The Object? What Does This Indicate?
The script have to go back the value that's associated with the tracking object. This indicates that there is nothing wrong with the object and the equal can finished in addition. Returning of this cost also states that the all the warnings which are associated with the object have also been taken into consideration. Sometimes it takes extra time for returning this price and under such conditions, customers can manually fetch the identical with the metric allocation tools.
Q21. What Is The Role Of Custom Scripts Of Sql Queries In Metrics?
SQL queries, custom calls in addition to custom scripts are deployed for the equal motive and i.E. For the purpose of tracking metrics and triggering the alerts. This makes sure of the easy float of the operations inside the shortest viable way and without calling any extra functions for the identical.
Q22. What Is The First Step For The Execution Of A Script After It Is Created?
It is vital that the scripts must have the starting point as em_results for a new line wherever it's far noted. If this circumstance isn't always fulfilled, there may be continually a runtime mistakes on the display and customers ought to be aware of a number of records for the clearance of the same. Thus it have to be considered on priority.
Q23. What Are The Types Of User-defined Metrics That Can Be Used For Extending The Monitoring Capabilities?
These are:
Operating gadget based totally user Defined metrics
SQL based consumer defined metrics
Q24. What Information About The Metric You Need To Provide When You Create A New User-described Metric On The Metric Page?
The information to be supplied are Metric call, type, quantity, command line where it's far used, Operating device kind, contrast operator, threshold settings, authentication associated statistics, Notifications and alert data and so on.
Q25. Is There Any Condition On The Location Of Scripts Which Generally Run With User-defined Metrics?
Yes, there may be a basic condition and i.E. They all must be positioned in a directory which the agent have to have entire get entry to. Any script outdoor the directory is commonly not noted and customers will no longer be able to use the same until it's far unique inside the listing. In case the listing is full, users have the provision to create a brand new directory and assign the name as per their want.
Q26. What Should You Define In The Script Along With Itself?
Rather than the summary or other beneficial statistics, it's far necessary which you define the various parameters that are associated with the surroundings and operation of the script. This makes certain it is able to be used without problems with unique range metrics with out the violation of anything.
Q27. Can You Register Your Script In The Console? When It Is Generally Done?
Yes, it’s possible for the users to perform this assignment. However, under regular conditions it isn't always achieved. When there are some critical warnings or a particular threshold is reached, registration within the console is then finished. The reality is there are regulations for registrations at the other locations and console can be used as the remaining option for this mission.
Q28. For What Purpose You Can Use An Os Based Metrics?
These are normally considered with regards to tracking a particular circumstance. A custom script can effortlessly be written with the assist of which this undertaking can effortlessly be completed. The script can be certain on every occasion when the business enterprise supervisor is evaluated. However, it depends in large part at the script for returning its value.
Q29. Do You Think There Is Anything Which Is Common In All The Monitoring Scripts Used In The Metrics?
Yes, all of them must include the code for doing some basic features. The two very essential ones are Code for the purpose of checking the reputation of objects monitored. The 2d is the code to return the script effects to the corporation manager. Users are unfastened to preserve the same records in them if they are meant to perform the similar obligations.
Q30. What Do You Know About The Script Location In Oracle Tm?
Well, it is recommended that the OS scripts which can be user-defined need to continue to be at a region which have to be out of doors the agent domestic. Actually it makes sure that no harm is caused to the script whilst the agent is up to date. This continually makes positive that the script remains operational under all the conditions. When you have to sign up it inside the control console, the entire path need to be distinct to the script. In a few cases, customers aren't allowed to apply the default homes.

