Home -> Usenet -> c.d.o.server -> Re: What value Oracle uses for db_cache_size when making decision on direct path reads if db_cache_size isn't set?

Re: What value Oracle uses for db_cache_size when making decision on direct path reads if db_cache_size isn't set?

From: vsevolod afanassiev <vsevolod.afanassiev_at_gmail.com>
Date: Mon, 18 Aug 2014 01:11:49 -0700 (PDT)
Message-ID: <6d6a12ae-6d2f-4d94-9e08-cac3f159214c_at_googlegroups.com> 






strace allows to see system calls, for example, if I trace DBWR process when opening database I see something like that:


open("/db01/oracle/oractrl/control_01.ctl", O_RDWR|O_SYNC|O_DIRECT|O_LARGEFILE) = 15
open("/db02/oracle/oractrl/control_02.ctl", O_RDWR|O_SYNC|O_DIRECT|O_LARGEFILE) = 16
open("/db01/oracle/oradata/system_01.dbf", O_RDONLY|O_DIRECT|O_LARGEFILE) = 17
open("/db01/oracle/oradata/system_01.dbf", O_RDWR|O_SYNC|O_DIRECT|O_LARGEFILE) = 17
open("/db01/oracle/oradata/undo_01_01.dbf", O_RDONLY|O_DIRECT|O_LARGEFILE) = 18
open("/db01/oracle/oradata/undo_01_01.dbf", O_RDWR|O_SYNC|O_DIRECT|O_LARGEFILE) = 18
open("/db02/oracle/oradata/sysaux_01.dbf", O_RDONLY|O_DIRECT|O_LARGEFILE) = 19
open("/db02/oracle/oradata/sysaux_01.dbf", O_RDWR|O_SYNC|O_DIRECT|O_LARGEFILE) = 19
open("/db02/oracle/oradata/tools_01.dbf", O_RDONLY|O_DIRECT|O_LARGEFILE) = 20
open("/db02/oracle/oradata/tools_01.dbf", O_RDWR|O_SYNC|O_DIRECT|O_LARGEFILE) = 20






How do you use output of strace to see internal calculations done by Oracle?
Received on Mon Aug 18 2014 - 10:11:49 CEST












Original text of this message