Krishna Kishore

Node Trust Level is a profile option, to restrict access to set of responsibilities based on Web Server from which user logs in. This profile option can take one of three values – —Administrative —Normal (Default Value) —External Lets suppose E-Business Suite (11i/R12) is deployed with four middle tier where two nodes (node1 & node2) are internal(for intranet users) and two nodes (node3 & node4) are external (for internet users – iSupplier, iProcurement, iRecruitment..).

SQL and PLSQL are the basic foundations of the Oracle technology. Next step is based on the experience level, area of intrest. For example, if the person is willing to go only as a developer, Oracle developer suite is one option. If the person is having some domain experience in any business, manufacturing, banking etc., then he/she can take ERP course (Oracle APPS). There is more scope and future for this. Oracle Apps Technical consultant resume weighs much more than any Oracle core developer.

Just before proceeding to details, Optimization is at the database level and not a concept in APPS. Performance tuning is a key aspect of any deliverable. Optimising your query to produce results in less possible time is much desirable in any deliverable. Optimization is done in 2 ways. 1) Rule Based optimization and 2) Cost Based Optimization. Rule Based Optimization is where there are pre-defined set of rules based on which your query will use them to fetch the results. For example. Any index on a table used in the query though not used in the query has to be applied because of the rule defined. This will increase the execution time of the query. This is an old method followed by oracle earlier. They have now moved it to cost based optimization. Hope this clear your question. Let me know if you need any additional details. Thanks Krishna Kishore