Killing the Oracle DBMS_JOBS

Hi Readers,
I have got something which many DBA's are looking for. What an excellent article by "James F Koopmann" on killing DBMS JOBS. Read on and spread knowledge.

Happy Reading!

Blog Entry shared from the An Expert's Guide to Database Solutions Blog.
Original author: James F. Koopmann (Database Expert)


Regards
Raheel

Installing Oracle 9i in RHEL4

Here is a quick guide to install Oracle 9i on Redhat linux. You can download the document from the link.

Download Installing Oracle 9i in RHEL4.doc


Thanks and regards
Raheel

To be a Oracle Apps DBA is it mandatory ...

This is the most common question everyone asks, "to be a oracle application DBA is it mandatory one should know core DBA concepts?" well if you ask me then the answer is "yes". There are few training institutes which says "one can do Oracle Application DBA and later learn few mandatory concepts of core DBA, but i suggest one should get trained on core DBA concepts first and move on to Apps DBA.

See what experts says:
To be a Oracle Apps DBA is it mandatory ...

Oracle E-Business Suite 11i Applications Technology

Oracle Applications DBA Certified Professionals demonstrate the complete set of skills required for working independently as experts in this role. An Oracle Applications DBA assumes the role of a database administrator on Oracle9i Database or Oracle Database 10g, with a focus on E-Business 11i Applications. Certified Applications DBAs are able to effectively manage the overlying database applications, including file system management, installation, maintenance using AD utilities, patching and cloning. They are also proficient with the underlying database architecture and configuration, including managing the database instance, managing objects and storage structures, performing backup and recovery, monitoring, performance tuning and troubleshooting

Computer Software / ITES - Job Listing

Dear Readers,
Looking for a change in your career, salary starts from 18000.00 for any graduate. Please call Waseem@9848574738 to discuss more about job profile and interview.

Best of luck!
Syed

Know about Los Angeles!

Los Angeles

Mann's Chinese Theatre is the one-time home of movie premieres. [Address: 6925 Hollywood Blvd, Hollywood, CA, Tel: 323-464-8111]

The Hollywood Walk of Fame is where Hollywood stars are immortalized with bronze star-plaques embedded in pink and charcoal squares in the boulevard. [Address: Hollywood Boulevard at Vine Street, Hollywood, CA, Tel: 323-469-8311]

Mulholland Drive is one of the most famous thoroughfares in the city, and location site for many movies, cutting through the parkland of the Santa Monica Mountains. Drive the length of the hilltop road to take in the fantastic views you've seen in all those classic films.

The Hollywood Bowl is a huge outdoor amphitheatre, opened in 1920, where everyone who's anyone has played sell-out gigs for decades. [Address: 2301 Highland Ave, Los Angeles, CA, Tel: 323-850-2000, hollywoodbowl.com]

Another highlight is getting a limo tour of the stars' houses and where the stars hang out in L.A.'s hills and on the streets of Beverly Hills.

Built in the 1920s on Sunset Boulevard, Chateau Marmont Hotel has been a magnet to the stars and is still the best place to spot them. [Address: 8221 W Sunset Blvd, West Hollywood, CA, Tel: 323-656-1010, chateaumarmont.com]

To feel like a star but save the odd hundred dollars, visit the 1960s style hair salon, Beauty Bar, and experience the height of kitsch. You don't need to book but the best time for your pamper is between 6 and 8pm. [Address: 1638 North Cahuenga Boulevard, Los Angeles, CA, Tel: 323-464-7676, beautybar.com]

Lively and popular, Venice Beach is the ultimate LA hangout and the best place to feel part of the in-crowd. Muscle Beach in Santa Monica, a symbol of body-conscious California, has also just got to be seen. [Venice Beach: 1531 Ocean Front Walk, Los Angeles, CA, and Tel: 310-399-2775]

Trashy Lingerie is the first stop for countless Hollywood stars before award nights and parties. [Address: 402 N. La Cienega Blvd, West Hollywood, CA, tel: 310/652-4543]

Best time to go

Los Angeles: August and September are the hottest months, January and February the coolest and wettest. Offshore breezes keep the beach communities cooler in summer and warmer in winter than those further inland. Las

FAQ's on SAP - ABAP/4

1. What is the typical structure of an ABAP/4 program?
Ans: - HEADER, BODY, FOOTER.

2. What should be the approach for writing a BDC program?
Ans: -
step 1: converting the legacy system data to a flat file to internal table called "conversion".
Step 2: transferring the flat file into sap system called "sap data transfer".
Step 3: depending upon the bdc type i) call transaction (write the program explicitly)
ii) create sessions (sessions are created and processed. if success data will transfer).

3. What is a batch input session?
Ans: -
BATCH INPUT SESSION is an intermediate step between internal table and database table.
Data along with the action is stored in session i.e. data for screen fields, to which screen it is passed, program name behind it, and how next screen is processed.

4. What is the alternative to batch input session?
Ans: -
Call transaction.

5. A situation: An ABAP program creates a batch input session.
We need to submit the program and the batch session in back ground. How to do it?
Ans: -
go to SM36 and create background job by giving
job name, job class and job steps (JOB SCHEDULING)

6. What are the problems in processing batch input sessions?
How is batch input process different from processing online?
Ans: -
PROBLEMS: -
i) If the user forgets to opt for keep session then the session will be automatically removed from the session queue (log remains). However if session is processed we may delete it manually.
ii) If session processing fails data will not be transferred to SAP database table.

7. What are the different types of data dictionary objects?
Ans: -
tables, structures, views, domains, data elements, lock objects, Matchcode objects.

8. How many types of tables exist and what are they in data dictionary?
Ans: -
4 types of tables
i) transparent tables - Exists with the same structure both in dictionary as well as in database exactly with the same data and fields. Both Opensql and Nativesql can be used.

ii) Pool tables & iii) Cluster tables -
These are logical tables that are arranged as records of transparent tables. One cannot use native sql on these tables
(only opensql).They are not manageable directly using database system tools.

iv)Internal tables.

9. What is the step by step process to create a table in data dictionary?
Ans:-
step 1: creating domains(data type, field length, range).
step 2: creating data elements(properties and type for a table field).
step 3: creating tables(SE11).

10. Can a transparent table exist in data dictionary but not in the data base physically?
Ans: - no.
Transparent table does exist with the same structure both in the dictionary as well as in the database, exactly with the same data and fields.

11. What are the domains and data elements?
Ans: -
Domains: formal definition of the data types. They set attributes such as data type, length, and range.
Data element: a field in r/3 system is a data element.

12. Can you create a table with fields not referring to data elements?
Ans:- YES. eg:- ITAB LIKE SPFLI.here we are refereeing to a data object(SPFLI) not data element.

13. What is the advantage of structures? How do you use them in the ABAP programs?
Ans:-
Adv - GLOBAL EXISTANCE(these could be used by any other program without creating it again).

14. What does an extract statement do in the ABAP program?
Ans:-
Once you have declared the possible record types as field groups and defined their structure, you can fill the extract dataset using the following statements:
EXTRACT .

When the first EXTRACT statement occurs in a program, the system creates the extract dataset and adds the first extract record to it. In each subsequent EXTRACT statement, the new extract record is added to the dataset

EXTRACT HEADER.

When you extract the data, the record is filled with the current values of the corresponding fields.

As soon as the system has processed the first EXTRACT statement for a field group , the structure of the corresponding extract record in the extract dataset is fixed. You can no longer insert new fields into the field groups and HEADER. If you try to modify one of the field groups afterwards and use it in another EXTRACT statement, a runtime error occurs.

By processing EXTRACT statements several times using different field groups, you fill the extract dataset with records of different length and structure. Since you can modify field groups dynamically up to their first usage in an EXTRACT statement, extract datasets provide the advantage that you need not determine the structure at the beginning of the program.

15. What is a collect statement? How is it different from append?
Ans:-
If an entry with the same key already exists, the COLLECT statement does not append a new line, but adds the contents of the numeric fields in the work area to the contents of the numeric fields in the existing entry.

16. What is open sql vs. native sql?
Ans:-
Open SQL , native SQL are the interfaces to create the database applications.
Open SQL is consistent across different types of existing Databases.
Native SQL is the database language specific to database. Its API is specific to the database.
Open SQL API is consistent across all vendors

17. What are the events in ABAP/4 language?
Ans:-
Initialization, At selection-screen,Start-of-selection,end-of-selection,top-of-page,end-of-page, At line-selection, At user-command, At PF,Get,At New, At LAST,AT END, AT FIRST.

18. What is an interactive report?
What is the obvious diff of such report compared with classical type reports?
Ans:-
An Interactive report is a dynamic drill down report that produces the list on user’s choice.
diff:-
a) THE LIST PRODUCED BY CLASSICAL REPORT DOESN'T allow user to interact with the system
the list produced by interactive report allows the user to interact with the system.
b) ONCE A CLASSICAL REPORT EXECUTED USER LOOSES CONTROL.IR USER HAS CONTROL.
c) IN CLASSICAL REPORT DRILLING IS NOT POSSIBLE.IN INTERACTIVE DRILLING IS POSSIBLE.

19. What is a drill down report?
Ans:-
It’s an Interactive report where in the user can get more relevant data by selecting explicitly.

20. How do you write a function module in SAP? describe.
Ans:-
creating function module:-
called program - se37-creating funcgrp,funcmodule by assigning attributes,importing,exporting,tables,and exceptions.
calling program - SE38-in pgm click pattern and write function name- provide export,import,tables,exception values.

System Analyst

Systems analysts are responsible for designing computer information systems, modifying systems to improve production or work flow, or expanding systems to serve new purposes. The information they deal with relates to all aspects of an employer's operations planning, monitoring, testing, accounting, forecasting, coordination, scheduling, etc.They may be responsible for a firm's entire system or part of it, or work from project to project. They also may analyze systems for their employer or for client firms.

The first task of the Systems Analyst is the evaluation of business procedures and problems. Analysts begin an assignment by talking with managers or specialists to determine the precise nature of the problem and to break it down into its component parts. This may involve interviews with staff to specifically identify what information is being processed, where it comes from, and where it goes. In addition to the interview method of data collection, analysts also conduct written surveys and observe workers performing tasks.
After sufficient information has been collected, the analyst prepares charts and diagrams that constitute a representation of the new system in terms which managers or non-data-processing personnel can understand. Analysts consult with management throughout this phase in order to confirm that the analyst and the management agree on the principles of the system. Analysts also prepare analysis which present cost versus benefit as a result of implementing the proposed new system.

Once the system is accepted, Systems Analysts prepare specifications for programmers to follow. The specifications include detailed descriptions of the records, files, and documents used in processing, and data flow charts describing the interrelationship of the data elements to be considered by the programmers. The analysts also coordinate the development of test problems to debug the system and participate in trial runs of the systems. They also may determine what computer hardware and software will be needed to set up the system. Some analysts also prepare programs and may be known as Programmer Analysts.

A bachelor’s degree is a prerequisite for many Systems Analyst jobs. Some positions
may require only a 2-year degree. Relevant work experience also is very important.
For more advanced positions, majors in Information Technology, Information
Systems or graduate degrees are preferred.

There are numerous technical institutions offering specialized training for Systems
Analysts. Many of these schools partner with software vendors and offer graduates
industry standard certifications such as MCSD - Microsoft Certified Solution
Developer, and MCAD - Microsoft Certified Application Developer.

NOTE: Re-framed and published from different sources.