1. What are the different business uses of Alerts?
Ans:
a) Keep you informed of critical activity in your database
b) Deliver key information from your applications, in the format you choose to provide you with regular reports on your database information
c) Automate system maintenance and routine online tasks Information about exception conditions.
2. What are the different types of alerts, Define it?
Ans:
You can define one of two types of alerts: an event alert or a periodic alert.
Event alert: An event alert immediately notifies you of activity in your database as it occurs.
Periodic alert: A periodic alert, on the other hand, checks the database for information according to a schedule you define.
3. What database events can cause what actions?
Ans: An insert and/or an update to a specific database table
4. What actions can you perform in an alert?
Ans: An action can entail sending someone an electronic mail message, running a concurrent program, running an operating script, or running a SQL statement script. You include all the actions you want Oracle Alert to perform, in an action set.
5. What do you specify when creating a Periodic Alert?
Ans:
a. A SQL Select statement that retrieves specific database information
b. The frequency that you want the periodic alert to run the SQL statement
c. Actions that you want Oracle Alert to perform once it runs the SQL statement.
6. Can you define Alert on Oracle Applications Tables?
Ans: Yes
7. How alert is different from database triggers?
Ans:
a) Code can be modified and viewed in a screen
b) Periodic alert is not possible through Database trigger
c) Oracle Alert will also transfer your entire alert definition across databases. You can instantly leverage the work done in one area to all your systems.
d) Customizable Alert Frequency with Oracle Alert, you can choose the frequency of each periodic alert. You may want to check some alerts every day, some only once a month, still others only when you explicitly request them.
8. Can you define detailed or summary actions in alert?
Ans: Yes, Detail or Summary Actions you can choose to have Oracle Alert perform actions based on a single exception or a combination of exceptions found in your database.
9. Can you perform actions when NO exceptions are found?
Ans: No Exception Actions : Oracle Alert can perform actions if it finds no exceptions in your database, same as alert actions.
10. Can you specify History Maintenance?
Ans: Alert History Oracle Alert can keep a record of the actions it takes and the exceptions it finds in your database, for as many days as you specify.
11. What is Escalation capabilities in Oracle Alert ?
Ans: Action Escalation You can define a sequence of actions and have Oracle Alert perform the next action in that sequence each time it finds the same exception or exceptions in your database.
12. Can alert check for user response?
Ans: Yes, it has response processing feature. Response Processing Oracle Alert can take certain predefined actions based on a user’s response to an alert message. The response can cause Oracle Alert to send another alert message, run a SQL script or an operating system script, or submit a concurrent request, or any combination of the above.
13. Can it send mail message?
Ans: Yes it can send. Oracle Alert allows you to send electronic mail messages directly to your mail system.
14. Can you distribute a report, log etc with Alert?
Ans: Yes, With Oracle Alert, you can include a file created by another application as part of an alert message. You can also define an alert that distributes an electronic copy of a report, log file, or any other ASCII file.
15. How can you use PL/SQL functions in Oracle Alert?
Ans: Defining the PL/SQL as file format, and we does not contain an Into clauses.
16. What are the four steps to create Periodic Alert?
Ans:
a) Define your periodic alert and specify its frequency
b) Specify the details for your alert
c) Define actions for your alert
d) Create action sets containing the actions you want your alert to perform
17. How do you refer the variables whose value is selected in SQL statement of Alert?
Ans: You Use Into statement with &variable name
18. Any limitation on SQL statement?
Ans: Yes, it accepts only 64K
19. Can you use SQL statement from a file, is it necessary to have into clause in it?
Ans: Yes, you can use a file. If the Select statement in the file does not contain an into clause, Oracle Alert automatically inserts an into clause into the alert Select statement as &OUTPUT1, &OUTPUT2, and &OUTPUT3.
20. Is it necessary that the application that owns an alert and on which executes have to be same?
Ans: NO, but both applications must reside in the same Oracle database and the application that owns the alert has to have Select privileges on the tables listed in the alert Select statement.
21. Can you use view as an event alert table?
Ans: You cannot use a view as the event table for your alert.
22. What are the four types of actions in alert can be specified?
Ans: There are four types of actions you can create
a) Message actions
b) Concurrent program actions
c) Operating script actions
d) SQL statement script actions
23. Are there any limitations in Response processing when getting inputs back from user?
Ans: Yes, User must respond answer in a specific format and content.
24. How does Alert work?
Ans: Oracle Alert checks your database for the exceptions you want to know about using several concurrent programs
a) Periodic Alert Scheduler
b) Check Periodic Alert
c) Check Event Alert
d) Response Processor
The Periodic Alert Scheduler (ALEPPE) is a concurrent program that automatically checks your scheduled periodic alerts.
25. How Check Event Alert Works?
Ans: Once you define an event alert to monitor a table for any insert or update to the table will trigger the event alert. When an insert or update to an event table occurs, Oracle Alert submits To the concurrent manager, a request to run a concurrent program called Check Event Alert (ALECTC). The concurrent manager runs this request according to its priority in the concurrent queue. When the request is run, Check Event Alert executes the alert Select statement. The Response Processor (ALPPIM) is the Oracle Alert concurrent program that processes responses to an alert message.
26. What is the purpose of: DATE_LAST_CHECKED ?
Ans: An Oracle Alert implicit input that contains the date and time that an alert was last checked Oracle Alert automatically provides the value for: DATE_LAST_CHECKED. You must use DATE_LAST_CHECKED to create self–referencing alerts.
27. What is meant by Action History?
Ans: A record of the actual actions performed for each action set check that includes the value substituted for each output.
28. Can you perform actions if a recipient doesn’t respond?
Ans: Yes, Using No Response field to specify the actions you want Oracle Alert to perform if the recipient does not respond within the number of Response Days specified in the Action Details window of the Alerts form known as the response processor.
29. Can one create event alerts on custom tables, triggered by custom applications?
Ans: Yes, Oracle Alerts can be integrated with your custom application and detailed information is available in the below link
https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=60879.1
30. How often should the Alert tables be purged?
Ans: There is no recommended purge frequency. It all depends on how many alerts have been enabled and their frequency.
Plz say the significance of Frequency like N Calender days, On Demand etc.
ReplyDeleteI mean each specific option in LOV given my oracle, how does it works.