On Wed, 21 Mar 2007, Rainer Heilke wrote:
[... reformatted ]
> We're running Update 3. Note that the DB _does_ come up, just not in the
> two minutes they were expecting. If they wait a few moments after their
> two-minute start-up attempt, it comes up just fine.
So why don't you state the a
We're running Update 3. Note that the DB _does_ come up, just not in the two
minutes they were expecting. If they wait a few moments after their two-minute
start-up attempt, it comes up just fine.
I was looking at vmstat, and it seems to tell me what I need. It's just that I
need to present the
Did you say what version of Solaris 10 you were using? I had similar problems
on Sol10 U2, booting a database. This involved first initializing the data
files (a few Gb), then starting the server(s) which tried to allocate a large
chunk of shared memory. This failed miserably since ZFS had go
Thanks. Like above, knowing the ARC takes time to ramp up strongly suggests
that it won't be an issue on a normally booting system. It sounds like your
needs are much greater, and that your databases are running fine.
I can take this information to the DBA's and use it to "manage their
expecta
I currently run 6 Oracle 9i and 10g dbs using 8GB SGA apiece in containers on a
v890 and find no difficulties starting Oracle (though we don't start all the
dbs truly simultaneously). The ARC cache doesn't ramp up until a lot of IO has
passed through after a reboot (typically a steady rise over
Hello Rainer,
Friday, March 16, 2007, 11:11:16 PM, you wrote:
RH> Thanks for the links, but this is not really the kind of data I'm
RH> looking for. These focus more on I/O. I need information on the
RH> memory cahing, and so on. Specifically, I need data that shows how
RH> starting up a 10GB SGA
Thanks for the links, but this is not really the kind of data I'm looking for.
These focus more on I/O. I need information on the memory cahing, and so on.
Specifically, I need data that shows how starting up a 10GB SGA database on a
16GB machine will not be able to flush the ZFS cache as quickl
Overall ZFS/Database blogs:
http://blogs.sun.com/realneel/entry/zfs_and_databases
http://blogs.sun.com/roch/entry/zfs_and_oltp
Memory:
http://www.opensolaris.org/jive/thread.jspa?messageID=82353𔆱
(There are more postings on ram.. just search the forum)
This message posted from opensolaris.org