Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
SCN and alertlog file
This is a discussion on SCN and alertlog file within the Database General forums, part of the Databases category; hi I have following ques: 1.when i start up database, in alert log file following information is displayed: PMON started with pid=2 DBW0 started with pid=3 LGWR started with pid=4 ...
|
|||||||
07-27-2008
|
|||
|
|||
|
SCN and alertlog file
hi I have following ques:
1.when i start up database, in alert log file following information is displayed: PMON started with pid=2 DBW0 started with pid=3 LGWR started with pid=4 CKPT started with pid=5 SMON started with pid=6 RECO started with pid=7 CJQ0 started with pid=8 QMN0 started with pid=9 What does it mean? 2.I fired command alter system set log_checkpoints_to_alert=true. I get this information: Beginning log switch checkpoint up to RBA [0x27.2.10], SCN: 0x0000.001a7a8b can anyone explain? 3.when the database is mounted,it says database is mounted in exclusive stage.What is exclusive stage means? 
|
| Sponsored Links |
|
07-30-2008
|
|||
|
|||
|
Re: SCN and alertlog file
1.whenever you start instance it starts background processes automactically. PMON ,DBW0, LGWR ,CKPT etc are background processes.
3.In Exclusive mode only the current instance can access database. If it is in parallel mode it allows multiple instances to access database.
|
 |
|
«
the difference between dbms and rdbms in detail
|
microsoft access- Round((Table2.OUT-Table2.[IN])*24,4) AS HOURS
»
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Convert dbf file to ASCII (text) file | mohit1211 | Oracle | 2 | 02-17-2008 11:54 PM |
| Use of export xml file and import xml file options | naags | QTP | 1 | 07-19-2007 02:37 PM |
| Steps for deploying a war file/ear file on websphere | Sujatars | Java | 0 | 07-19-2007 12:49 AM |
| How do I 'unpack' and view a .FILE vsam file | Geek_Guest | MainFrame | 0 | 06-26-2007 09:22 PM |
| Frigate3 File Manager: highly configurable and convenient file management environment | JobHelper | Geeks Lounge | 0 | 03-30-2007 03:30 PM |
All times are GMT -4. The time now is 12:36 AM.
