Sitemap

Amicuk Programming Answers

Initial Parameter DB_WRITER_PROCESSES Doesn't work

-0001-11-30   Views:0

Advertisement

I set the initial parameter DB_WRITER_PROCESSES as 5 in init.ora file. But when I restarted the database, I found the parameter show as 1 and only DBW0 existed. I don't know the reason, would you please help me? Thanks and Best Regards, Su QianDid yo

I set the initial parameter DB_WRITER_PROCESSES as 5 in init.ora file. But when I restarted the database, I found the parameter show as 1 and only DBW0 existed.
I don't know the reason, would you please help me?
Thanks and Best Regards,
Su Qian

The replay answer
Advertisement
Did you get a message in the alert log about starting dbwr processes failed?No, I havn't gotten the message.
Also, having multiple writers on a single cpu system could bring performance down. I think one rule of thumb is to have 4 cpus per writer.Thanks for your message. I will not re-set the parameter.
First, I'd like to let you know that the environment of my production database are as follows:
OS: HP-UX
Database Version: Oracle8 Enterprise Edition Release 8.0.4.2.1 - Production
The setting of DB Block: 2K
The main problem I come across is when running application the response speed of DB is very slow.
The first step I adopted was checking free space. After checking I thought it was sufficient. But when I adopted the second step checking v$system_event, I found the wait time of following events is high.
EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT
db file parallel write 471 1 128370 272.547771
log file parallel write 30307 0 51440 1.69729765 (For reference)
pmon timer 37189 36806 11111071 298.773051
rdbms ipc message 142737 112253 66295957 464.462312
rdbms ipc reply 296 0 7167 24.2128378
smon timer 372 369 11082933 29792.8306
write complete waits 75 37 5149 68.6533333
According to the above message, I decided to tune I/O first. Is my thought right?
If dbwr is rather slow, these events should give som hints: free buffer waits, rdbms ipc reply, log file switch (checkpoint incomplete).Yes, when I had a look at the alert.log I found the error message: checkpoint incomplete. So I created a new log group.Perhaps the problem was too few log groups and not dbwr. If you do not have high free buffer waits dbwr should be ok :)I agree with you. I havn't high free buffer waits, so the main problem could be too few log groups. But I don't understand two points as follows.
1. Last Friday I had 4 log groups and the size of every group is 2M. when getting the message "Thread 1 cannot allocate new log, sequence 87816 Checkpoint not complete", I created a new log group of 2M. Normally, this operation should improve performance, but when I observed the statistics I found the average wait time of "db file parallel write" became more longer. (Please refer to the following list)
EVENT TOTAL_WAITS TIME_WAITED AVERAGE_WAIT DATE LOG_GROUPS
db file parallel write 471 128370 272.547771 2002-08-05 5
db file parallel write 798 88568 110.987469 2002-08-03 4
2. I think the shortage of log groups is caused by the archive of log group don't complete before overwirting. From the alert.log file I found the time of log switch is about 20 minutes. From my viewpoint 20 minutes is enough for log archive. Why is the log groups still short?
In addition, according to the setting of checkpoint parameters I think the checkpoint should occur only at the time of log switch.
NAME TYPE VALUE
db_block_checkpoint_batch integer 8
log_checkpoint_interval integer 1000000
log_checkpoint_timeout integer 0
db_block_max_dirty_target integer 4294967294
db_block_buffers integer 153600 (For reference)
Do you know the meaning db_block_checkpoint_batch? (I can't find it in the document of 8i, because it is obsoleted.)
From the alert.log file, I got the following errors.
1. Fri Aug 2 17:10:36 2002
Errors in file /lims/oradata/lab1/udump/ora_10976.trc:
ORA-00600: internal error code, arguments: [1237], [], [], [], [], []
(I got the error message occasionally.)
2. Fri Aug 2 16:57:37 2002
ORA-1652: unable to extend temp segment by 256 in tablespace TEMP
(I don't understand it clearly, because the size of temporary tablespace is 400M. I think it is large enough.)     
3. Fri Jul 26 12:00:17 2002
Thread 1 cannot allocate new log, sequence 87816
Checkpoint not complete
Current log# 1 seq# 87815 mem# 0: /u02/oradata/lab1/db/redolab101.log
Looking forward your reply.
Thanks and Best Regards,
Su Qian

Go to See the other 11 answers

Initial Parameter DB_WRITER_PROCESSES Doesn't work

Category:DefaultRelease time:-0001-11-30Views:130

I set the initial parameter DB_WRITER_PROCESSES as 5 in init.ora file. But when I restarted the database, I found the parameter show as 1 and only DBW0 existed. I don't know the reason, would you please help me? Thanks and Best Regards, Su QianDid yo[More]

Initial Parameter DB_WRITER_PROCESSES Does not Work

Category:DefaultRelease time:-0001-11-30Views:130

Sorry, I can't find my tips after replying. My DB server version is Oracle 8.1.6. The paramter dbwr_io_slaves is inactive. In test stage I use test server, most of which parameters are set as default value. So db_block_lru_latches = 1. MY OS is Win20[More]

Oracle i9 - setup initial parameter values fo process number

Category:DefaultRelease time:-0001-11-30Views:130

Hello all experts, Please help. We have an oracle server i9 version. Sometimes Oracle failed and reset to 30 process due to too many connections to the database. Some people told me that there is a way to increase the process number by editing the or[More]

Can't change parameters that are not shown on initial parameter panel

Category:DefaultRelease time:-0001-11-30Views:130

I have a Crystal Report that is based on an Oracle Stored Procedure. This was created using Crystal Reports 2008, and it is published on a Business Objects 3.1 environment. There are actually 7 parameters in the stored procedure, of which only 2 requ[More]

Modify INITIAL in partitioned table

Category:DefaultRelease time:2015-10-11Views:130

Dear all, Facts: oracle 10.1 aix 5.3 i have a table with the INITIAL value 1M: partition PARTITION_83 values less than (201103) tablespace D_DML pctfree 0 pctused 40 initrans 1 maxtrans 255 storage initial 1M minextents 1 maxextents unlimited and i w[More]

Oracle db_writer_processes

Category:DefaultRelease time:-0001-11-30Views:130

Hi, When one of process ran in 11.5.10.2, DBWR0 process get loaded since that process execute INSERT internally. I'm thinking to increase db_writer_processes process to 3. The current parameter value is 1. Does this help ? or in what situation we nee[More]

Increasinf : db_writer_processes

Category:DefaultRelease time:-0001-11-30Views:130

How can increase db_writer_processes  in ORACLE DATABASE  & How can i find out the existing parameter value for it Rgds PRas orasid sqlplus> show parameter db_writer_processes sqlplus>alter system set db_writer_processes=xx scope=spfile; If you[More]

Resizing initial extent

Category:DefaultRelease time:-0001-11-30Views:130

HI Guys Is there a way to resize the initial extent of a table without dropping and recreating by changing the INITIAL parameter? Is there a kind of package or something available? We have lot of tables with initial size is quite big as they were def[More]

New user just for entering JE and General Ledger

Category:DefaultRelease time:2015-10-11Views:130

hello experts, I created a user, just to enter few of the Journal Enteries and General Ledgers. I gave the rights for JE and also Financial reports but when I open the "G/L account and Business Partner" Report in Financial Report > Accounting[More]

New Events Are Created Automatically in Outlook

Category:DefaultRelease time:2015-10-11Views:130

New events are appearing on my Outlook calendar that I didn't create. They are blank execpt for the name "New Event" and the Start and End time are filled in. I did not create these events and don't know why they appear randomly on my calendar.[More]

Issue encountered when Login as sysdba role using Thin Oracle JDBC Driver

Category:DefaultRelease time:2015-10-11Views:130

Hello all, we are now considering to use Thin oracle JDBC driver to create database in our project, but we met one issue when we tried to connect to oracle as sysdba role using Thin driver, and it throws java.sql.SQLException: Io Exception: SO Except[More]

Hot
Hi.. Did any body try to change Oracle 10g SSO login page with custom login Page as we used to do in 902 and 1022 versions by changing wwsso_ls_configuration_info_t table entries? It seems that there is now other file policy.properties that has entry [More]
I run Logic Pro 9.1.8 on a Mac Pro 1,1 (Snow Leopard 10.6.8) and GarageBand 2.0.1/ iOS (7) on the iPad2. The songs are built on the iPad, then opened in Logic on the Mac. This worked like a charm until recently when the iPad was updated w/ the new GB [More]
I'm in desperate need of help! I have recently noticed that i have been getting various pop-ad's and other window pop-up's whilst running safari and google chrome. I have managed to stop the majority of adds popping up by using a free download of the [More]
I am trying to track individual sales with each of my vendors. I have a column of drop down menu's that list each of my vendors. I am trying to associate a dollar amount for a single transaction in a row that is associated with a vendor and get a sum [More]
Greetings!  We are getting the following error on one of our Web Roles: DiagnosticsPlugin.exe Information: 0 : [3/18/2015 7:39:07 PM] Decrypting private configuration DiagnosticsPlugin.exe Warning: 0 : [3/18/2015 7:39:07 PM] No certficate with given [More]
Hi there! I've been digging and digging and digging trying to find a work-around for this issue I'm having. I bought Windows 8 without first checking to see if my Macbook would be compatible with running both OSX and Windows 8... Stupid move #1 becau [More]
Hi, I'm old school still using the OS 10.5.8 on my 20" monitor iMac, I've purchased the snow leopard upgrade but the drive won't accept it and spits the disc out so how can I get the drive to read it? I put the disc in and about 30 seconds later it s [More]
Dear, i have 2 node apps EBS R12 12.0.5 node1 = app tier node2 = db tier show parameter for utl_file_dir i could see 2 locations /usr/tmp and ....... the job OAM Applications Dashboard Collection.most of the time is fine, sometime it shown completed [More]
早上业务部分和我说数据库连不上,首先ssh连接至数据库 sqlplus / as sysdba习惯性登入,卡住,无反应 再去查看alert.log Mon Nov 19 08:33:08 2012 ksvcreate: Process(m000) creation failed Mon Nov 19 08:35:16 2012 ksvcreate: Process(m000) creation failed Mon Nov 19 08:51:37 2012 kkjcre1p: unable to [More]
Hi guys, I need to develop consignment sales process for multiple customers. Am confused regarding the four process like consignment fill up, consignment issue, consignment returns, consignment pick up, do we need to take reference of consignment fil [More]