AoA,
If someone has Oracle Alerts info then please share with us. thanks
Oracle Alerts
-
sridhar_6735
- Posts: 47
- Joined: Thu Apr 20, 2006 9:59 am
- Location: India
Oracle Alert
Oracle Alert is complete exception control solution. Oracle Alert facilitates the flow of information within organization by letting one to create entities called alerts to monitor business information and to notify the information you want. You can define one of two types of alerts: an event alert or a periodic alert.
? An event alert immediately notifies you of activity in your database as it occurs.
? A periodic alert, on the other hand, checks the database for information according to a schedule you define.
#61656; Keep you informed of critical activity in your database
#61656; Deliver key information from your applications, in the format you Choose
#61656; Provide you with regular reports on your database information
#61656; Automate system maintenance, and routine online tasks
Oracle Alert is complete exception control solution. Oracle Alert facilitates the flow of information within organization by letting one to create entities called alerts to monitor business information and to notify the information you want. You can define one of two types of alerts: an event alert or a periodic alert.
? An event alert immediately notifies you of activity in your database as it occurs.
? A periodic alert, on the other hand, checks the database for information according to a schedule you define.
#61656; Keep you informed of critical activity in your database
#61656; Deliver key information from your applications, in the format you Choose
#61656; Provide you with regular reports on your database information
#61656; Automate system maintenance, and routine online tasks
-
sridhar_6735
- Posts: 47
- Joined: Thu Apr 20, 2006 9:59 am
- Location: India
AOL ? Alerts
1. What are the different business uses of Alerts
Keep you informed of critical activity in your database
Deliver key information from your applications, in the format you choose Provide you with regular reports on your database information
Automate system maintenance and routine online tasks Information about exception conditions.
2. What are the different types of alerts, Define it?
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:
a) an insert and/or an update to a specific database table.
4. What actions can you perform in an alert?
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?
A SQL Select statement that retrieves specific database information,
The frequency that you want the periodic alert to run the SQL statement,
Actions that you want Oracle Alert to perform once it runs the SQL statement.
5. Can you define Alert on Oracle Applications Tables?
Yes
6. How alert is different from database triggers?
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.
7. Can you define detailed or summary actions in alert?
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.
8. Can you perform actions when NO exceptions are found?
No Exception Actions
Oracle Alert can perform actions if it finds no exceptions in your database, same as alert actions.
9. Can you specify History Maintenance?
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.
10. What is Escalation capabilities in Oracle Alert
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.
11. Can alert check for user response
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.
12. Can it send mail message?
Yes it can send. Oracle Alert allows you to send electronic mail messages directly to your mail system.
13. Can you distribute a report, log etc with Alert?
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.
14. How can you use PL/SQL functions in Oracle Alert.
Defining the PL/SQL as file format, and we does not contain an Into clauses.
15. What are the four steps to create Periodic Alert
Define your periodic alert and specify its frequency
Specify the details for your alert
Define actions for your alert
Create action sets containing the actions you want your alert to perform
16. How do you refer the variables whose value is selected in SQL statement of Alert?
You Use Into statement with &variable name
17. Any limitation on SQL statement?
Yes, it accepts only 64K
18. Can you use SQL statement from a file, is it necessary to have into clause in it?
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.
19. Is it necessary that the application that owns an alert and on which executes have to be same:
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.
20. Can you use view as an event alert table:
You cannot use a view as the event table for your alert.
21. What are the four types of actions in alert can be specified.
There are four types of actions you can create:
Message actions
Concurrent program actions
Operating script actions
SQL statement script actions
22. Are there any limitations in Response processing when getting inputs back from user.
Yes, User must respond answer in a specific format and content.
23. How does Alert works
Oracle Alert checks your database for the exceptions you want to know about using several concurrent programs:
? Periodic Alert Scheduler
? Check Periodic Alert
? Check Event Alert
? Response Processor
The Periodic Alert Scheduler (ALEPPE) is a concurrent program that automatically checks your scheduled periodic alerts.
24. How Check Event Alert Works
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.
25. What is the purpose of: DATE_LAST_CHECKED
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.
26. Action History A record of the actual actions
Performed for each action set check that includes the value substituted for each output.
27. Can you perform actions if a recipient doesn?t respond?
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.
1. What are the different business uses of Alerts
Keep you informed of critical activity in your database
Deliver key information from your applications, in the format you choose Provide you with regular reports on your database information
Automate system maintenance and routine online tasks Information about exception conditions.
2. What are the different types of alerts, Define it?
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:
a) an insert and/or an update to a specific database table.
4. What actions can you perform in an alert?
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?
A SQL Select statement that retrieves specific database information,
The frequency that you want the periodic alert to run the SQL statement,
Actions that you want Oracle Alert to perform once it runs the SQL statement.
5. Can you define Alert on Oracle Applications Tables?
Yes
6. How alert is different from database triggers?
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.
7. Can you define detailed or summary actions in alert?
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.
8. Can you perform actions when NO exceptions are found?
No Exception Actions
Oracle Alert can perform actions if it finds no exceptions in your database, same as alert actions.
9. Can you specify History Maintenance?
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.
10. What is Escalation capabilities in Oracle Alert
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.
11. Can alert check for user response
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.
12. Can it send mail message?
Yes it can send. Oracle Alert allows you to send electronic mail messages directly to your mail system.
13. Can you distribute a report, log etc with Alert?
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.
14. How can you use PL/SQL functions in Oracle Alert.
Defining the PL/SQL as file format, and we does not contain an Into clauses.
15. What are the four steps to create Periodic Alert
Define your periodic alert and specify its frequency
Specify the details for your alert
Define actions for your alert
Create action sets containing the actions you want your alert to perform
16. How do you refer the variables whose value is selected in SQL statement of Alert?
You Use Into statement with &variable name
17. Any limitation on SQL statement?
Yes, it accepts only 64K
18. Can you use SQL statement from a file, is it necessary to have into clause in it?
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.
19. Is it necessary that the application that owns an alert and on which executes have to be same:
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.
20. Can you use view as an event alert table:
You cannot use a view as the event table for your alert.
21. What are the four types of actions in alert can be specified.
There are four types of actions you can create:
Message actions
Concurrent program actions
Operating script actions
SQL statement script actions
22. Are there any limitations in Response processing when getting inputs back from user.
Yes, User must respond answer in a specific format and content.
23. How does Alert works
Oracle Alert checks your database for the exceptions you want to know about using several concurrent programs:
? Periodic Alert Scheduler
? Check Periodic Alert
? Check Event Alert
? Response Processor
The Periodic Alert Scheduler (ALEPPE) is a concurrent program that automatically checks your scheduled periodic alerts.
24. How Check Event Alert Works
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.
25. What is the purpose of: DATE_LAST_CHECKED
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.
26. Action History A record of the actual actions
Performed for each action set check that includes the value substituted for each output.
27. Can you perform actions if a recipient doesn?t respond?
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.
-
Chaetanya58
- Posts: 1
- Joined: Tue Nov 14, 2006 4:40 am
- Location: India
Hi,
Am probably very late in asking this but can anyone please tell me something about the FNDLOAD for alerts.
I have the following command with me but I there are some missing parameters to it.
FNDLOAD apps/apps@devenv 0 Y DOWNLOAD $ALR_TOP/patch/115/import/alr.lct alerts.ldt ALR_ALERTS APPLICATION_SHORT_NAME=SQLGL
Would really appreciate a response on this.
Am probably very late in asking this but can anyone please tell me something about the FNDLOAD for alerts.
I have the following command with me but I there are some missing parameters to it.
FNDLOAD apps/apps@devenv 0 Y DOWNLOAD $ALR_TOP/patch/115/import/alr.lct alerts.ldt ALR_ALERTS APPLICATION_SHORT_NAME=SQLGL
Would really appreciate a response on this.
Who is online
Users browsing this forum: No registered users and 1 guest