ANSWER OF PREVIOUS POST

About urself
1.education
2.intrest
3.hobby
4.exp
5.current role in company
6.achivement
7.strength.


query for checking which instance is up at os level
1.echo ORACLE_SID
2.ps -ef|grep smon

How u know that db is up from sp file or pfile
check the value of parameter spfile, if it returns blank then database was started by pfile.
belows show database was started by spfile
SQL> show parameter spfile;

NAME TYPE VALUE
—— —— ————————————————
spfile string /u01/apps/oracle/10g/dbs/spfileorcltest.ora

how query process in db...also in middle they used to ask which bkground process how they work.
1.Working
2.wt bgprocess do
3.etc.

What kind of info. stored in large pool and java pool
1.UGA for the shared server and the Oracle XA interface (used where transactions interact with multiple databases)
2.Message buffers used in the parallel execution of statements
3.Buffers for Recovery Manager (RMAN) I/O slaves
Java Pool
The Java pool is an area of memory that stores all session-specific Java code and data within the
Java Virtual Machine (JVM).

Is session take memory?
yes(my answer)...

dbwr write or copy or both?
Only write
If db down then?
1.Restarting
2.If it doesn't start
 You have to try to figure out why it isn't starting
3.If it doesn't stop
 Kill off all sessions connected to shutdown immediate or (gulp) do a shutdown abort.
4.Kill some of the process that is unwanted.