Abbreviations:

1 Answer

Answer :

SGA: System Global Area
PGA: Program Global Area
pfile: Parameter File
spfile: Server Parameter File
CKPT: Check Point
DBW: Database Writer
LGWR: Log Writer
ARC0: Archiver
PMON: Process Monitor
SMON: System Monitor

Related questions

Description : What unrelated (or not) abbreviations/acronyms are like ICBM, for whatever reason?

Last Answer : IBM. CoopCo. SAM CEO Tons out there. There is nothing “interesting” about it. It’s just easier and faster than saying, “Intercontinental Ballistic Missile.” Takes up less characters, too.

Description : Do you know all the two letter postal abbreviations for the states?

Last Answer : answer:No, I don’t. “Does the whole world have two letter postal abbreviations?” No, not at all! There are very different ways to do this.

Description : With surgical/suture needles, what do these codes/abbreviations mean?

Last Answer : It has to do with the needle type (cutting, taper) and shape (curved, straight). I don’t remember what’s what – I’ll find out.

Description : What do the abbreviations S.O., B.A., and B.O. stand for in Nancy Mitford's novel?

Last Answer : I guessed it meant “British accent”, “Scottish accent” and “British origin”

Description : Why do we shorten some phrases into abbreviations or acronyms, only to later lengthen them again - into whole new words?

Last Answer : I have never seen MC written as emcee or DJ written as deejay until now.

Description : In medical abbreviations, is it mEq or mg that is not to be used?

Last Answer : In my experience, mcg is microgram, mg is very common. Any of us who read prescriptions are very aware that the difference between the two could mean the difference between treatment and death ... very surprised if it were ever used on a prescription) it could easily be confused with mcg.

Description : Why do countries have two letter abbreviations?

Last Answer : In which system were countries assigned 3-letter abbreviations and which system is now using 2? Is this a Postal code you're referring to, or something else? I am mostly familiar ... Denmark; F for France; FIN for Finland; etc.) http://en.wikipedia.org/wiki/List_of_international_license_plate_codes

Description : Whats with the oval stickers with abbreviations I often see on bumpers?

Last Answer : answer:This was originally European, but I'm not sure what year it started. The 40's, I believe? It was a way to differentiate cars from different countries when they drove abroad. I suspect ... exploded sometime in the 90's, when places in the US started using them strictly for souvenir purposes.

Description : what do the abbreviations after a word in the dictionary tell you about the word? -General Knowledge

Last Answer : The abbreviations after a word in the dictionary tell you the word's: part of speech.

Description : What is the meaning of the different symbols and abbreviations found on the documents that they use (such as surface finish to be achieved linear and geometric tolerances electronic components weld s?

Last Answer : Need answer

Description : What do the abbreviations MLA APA and CMS refer t What do the abbreviations MLA APA and CMS refer too?

Last Answer : Need answer

Description : What is the difference between abbreviations and acronyms?

Last Answer : Answer: There is a difference between acronyms and abbreviations. An acronym Is usually formed by taking the first initials of a phrase or compounded- Word and using those initials to form a word that stands ... pronouncing it as three Separate letters, "U * R * L," thus making it an abbreviation.

Description : what do the following scientific abbreviations stand for?

Last Answer : (1) CRO-CRO - Cathode rays oscillator (2) SARS - Severe Acute respiratory syndrome (3) BOT - Built operate transfer (4) AMU - Atomic mass unit (5) EMF - Electromotive force (6) ADH - Anti ... Electron Volt (9) NTP - Normal Temperature Pressure OR Network Time Protocol (10) CRT - Cathode ray tube

Description : What do the following scientific abbreviations stand for:

Last Answer : (a) I-1DL (b) McV - Means Cell Volume (c)UHF - Ultrahigh Frequency (d) LED - Light-Emitting Diode (e) LCD - Liquid Crystal Display (f) BASIC - Beginner's All-Purpose Symbolic ... - High-Speed Train or Hubble space telescope (j) DBS - Direct Broadcast Satellite or Direct Broadcasting by Satellite.

Description : what do the following scientific abbreviations stand for ?

Last Answer : a. STP standard temperature and pressure/ Shielded Twisted Pair b. ATP Adenosine Tri-Phosphate c. PNP proton - neutron - proton [Positive-Negative-Positive (transistor) ] d. LANlocal area network e. KWh ... ] h. ROM Read only memory i. MAF million acre feet j. SONAR Sound Navigation and Ranging

Description : What do the following scientific abbreviations stand for :

Last Answer : a). SONAR : SOund NAvigation and Ranging b). SARS :severe acute respiratory syndrome c). NTP : network time protocol d). RQ : respiratory quotient e). PVC : polyvinyl chloride f). NPN : negative ... h). ECG: electro cardio gram i). CPU: central processing unit j). BCG : bacillus calmette Guerin

Description : What do the following scientific abbreviations stand for ?

Last Answer : a. LASER b. RADAR c. LPG d. PVC e. CFC f. AIDS g. ROM h. LAN i. WWW j. DNA

Description : What do the following scientific abbreviations stand for?

Last Answer : a) LPG Liquefied Petroleum Gas b) TNT Tri niotro toline c ) RNA Ribonucleic Acid d) CNG Compressed Natural Gas e) ATP Adenosine tri Phosphate f) RBC Red Blood Cells g) ECG Electro Cardio Gram h) PVC Poly Vinyl Chloride i) RAM Random Access Memory j) CFC Chlorofluorocarbons

Description : WHAT IS THE GOLDEN RULE FOR WRITING HEADLINES a) Keep it short and bright b) Be as clever as possible c) Never let the facts get in the way of news story d) Use Abbreviations

Last Answer : a) Keep it short and bright

Description : Which amongst the following Abbreviations stands for organization related to Indian space programme? (1) NASA (2) ISO (3) ISRO (4) NSAT

Last Answer : (3) ISRO

Description : Which amongst the following Abbreviations stands for organization related to Indian Defence forces? (1) DOD (2) RDSO (3) DRDO (4) DRES

Last Answer : (3) DRDO

Description : The Abbreviations PSLV stands for (1) Polar Survey Landing Vehicle (2) Polarised Source Laser Viewing (3) Precise Source Locating Vision (4) Polar Satellite Launch Vehicle

Last Answer : (4) Polar Satellite Launch Vehicle

Description : Power Maintenance ABBREVIATIONS

Last Answer : 1 W - Watts 2 KW - Kilowatts 3 KWH - Kilowatt Hour 4 KVA - Kilo Volt Amps 5 KVAR - Kilo Volt Ampers Reactive 6 H.P. - Horse Power 7 A.H. - Ampere Hours 8 P.F. - Power Factor 9 R.P.M. - ... L.T.U.G - Low Tension Under Ground 36 P.V.C. - Poly Vinly Chloride 37 H.R.C. - High Rapturing Capacity

Description : Important Abbreviations

Last Answer : Important Abbreviations Abbreviations are extremely important to learn. You need to use abbreviations in your daily communication models. However, it is also important to update yourself with respect to ... Atomic Research Centre 44. BBC - British Broadcasting Corporation 45. BC - Before Christ

Description : ABBREVIATIONS

Last Answer : Q, R QMG: Quarter Master General QR: Quantitative Restriction RAF: Rapid Action Force RAM: Random Access Memory RBI: Reserve Bank of India RCC: Reinforced Concrete Cement RDF: ... in 1988 by the World Meteorological Organisation (WMO) and the United Nations Environment Programme (Unep)

Description : What does "jumps off the screen" mean?

Last Answer : answer:AMD is a relatively small manufacturer but well established in the industry. In this context, AMD jumps off the screen at the guy doing the research into acquiring companies for ... chip manufacturing division, but AMD is the one that really stands out from an acquisition perspective.

Description : How to add conditions in select statement in oracle?

Last Answer : Just add the decode

Description : How can I dump an oracle schema to a LOCAL file over a network connection from sqlplus?

Last Answer : By connecting and spooling are you excluding the exp/imp commands (or expdb/impdb in 10g)?

Description : What are the two ways to incorporate images into a oracle forms application?

Last Answer : Boilerplate Images Image_items

Description : Can one export a subset of a table? (for DBA

Last Answer : From Oracle8i one can use the QUERY= export parameter to selectively unload a subset of the data from a table. Look at this example: exp scott/tiger tables=emp query=\"where deptno=10\"

Description : What are the types of visual attribute settings?

Last Answer : Custom Visual attributes Default visual attributes Named Visual attributes. Window

Description : How does one use the import/export utilities? (for DBA

Last Answer : Look for the "imp" and "exp" executables in your $ORACLE_HOME/bin directory. One can run them interactively, using command line parameters, or using parameter files. Look at the imp/exp parameters ... and export data with the "Schema Manager" GUI that ships with Oracle Enterprise Manager (OEM).

Description : what is a display item?

Last Answer : Display items are similar to text items but store only fetched or assigned values. Operators cannot navigate to a display item or edit the value it contains.

Description : What is import/export and why does one need it? (for DBA

Last Answer : The Oracle export (EXP) and import (IMP) utilities are used to perform logical database backup and recovery. They are also used to move Oracle data from one machine, database or schema to ... corruption. Ensure that all the data can be read. . Transporting tablespaces between databases . Etc.

Description : Are there any troubleshooting tips for OEM? (for DBA

Last Answer : . Create the OEM repository with a user (which will manage the OEM) and store it in a tablespace that does not share any data with other database users. It is a bad practice to create ... successfully. Check the log to see the results of the execution rather than relying on this status.

Description : Where can one get more information about TCL? (for DBA

Last Answer : One can write custom event checking routines for OEM using the TCL (Tool Command Language) language. Check the following sites for more information about TCL: . The Tcl Developer Xchange - ... the OraTCL package . Tom Poindexter's Tcl Page - Oratcl was originally written by Tom Poindexter

Description : How does one start the Oracle Intelligent Agent? (for DBA

Last Answer : One needs to start an OIA (Oracle Intelligent Agent) process on all machines that will to be managed via OEM. For OEM 9i and above:

Description : What is the Oracle Intelligent Agent? (for DBA

Last Answer : The Oracle Intelligent Agent (OIA) is an autonomous process that needs to run on a remote node in the network to make the node OEM manageable. The Oracle Intelligent Agent is ... events registered in Enterprise Manager; and . Executing tasks associated with jobs submitted to Enterprise Manager.

Description : What are the types of SQL Statement ?

Last Answer : Data Definition Language : CREATE,ALTER,DROP,TRUNCATE,REVOKE,NO AUDIT & COMMIT.

Description : How does one backout events and jobs during maintenance slots? (for DBA

Last Answer : Managemnet and data collection activity can be suspended by imposing a blackout. Look at these examples: agentctl start blackout # Blackout the entrire agent agentctl stop blackout # Resume normal monitoring ... management agentctl start blackout -s jobs -d 00:20 # Blackout jobs for 20 minutes

Description : What are the pre requisites ?

Last Answer : I. to modify data type of a column ? ii. to add a column with NOT NULL constraint ? To Modify the datatype of a column the column must be empty. to add a column with NOT NULL constrain, the table must be empty.

Description : What kind of jobs can one schedule with OEM? (for DBA

Last Answer : OEM comes with pre-defined jobs like Export, Import, run OS commands, run sql scripts, SQL*Plus commands etc. It also gives you the flexibility of scheduling custom jobs written with the TCL language.

Description : Difference between SUBSTR and INSTR ?

Last Answer : INSTR (String1,String2(n,(m)),INSTR returns the position of the mth occurrence of the string 2 instring1. The search begins from nth position of string1.SUBSTR (String1 n,m)SUBSTR returns a character string of size m in string1, starting from nth position of string1.

Description : Should the OEM Console be displayed at all times (when there are scheduled jobs)? (for DBA

Last Answer : When a job is submitted the agent will confirm the status of the job. When the status shows up as scheduled, you can close down the OEM console. The processing of the job is managed by the OIA ... that OEM will not be able to send e-mail and paging notifications when the Console is not started.

Description : Explain UNION,MINUS,UNION ALL, INTERSECT ?

Last Answer : INTERSECT returns all distinct rows selected by both queries.MINUS - returns all distinct rows selected by the first query but not by the second.UNION - returns all distinct rows selected by either queryUNION ALL - returns all rows selected by either query, including all duplicates.

Description : WHY USE RMAN ? (for DBA

Last Answer : No extra costs Its available free ?RMAN introduced in Oracle 8 it has become simpler with newer versions and easier than user managed backups ?Proper security ?You are 100% sure your ... what need to backed up Knows what is required for recovery Knows what backups are redundant

Description : WHAT IS RMAN ? (for DBA

Last Answer : Recovery Manager is a tool that: manages the process of creating backups and also manages the process of restoring and recovering from them.

Description : What is the basic structure of PL/SQL ?

Last Answer : PL/SQL uses block structure as its basic structure. Anonymous blocks or nested blocks can be used in PL/SQL.

Description : What are the two parts of a procedure ?

Last Answer : Procedure Specification and Procedure Body.

Description : What are the datatypes a available in PL/SQL ?

Last Answer : Some scalar data types such as NUMBER, VARCHAR2, DATE, CHAR, LONG, BOOLEAN. Some composite data types such as RECORD & TABLE.