I am running Oracle 9i on Solaris 9 Sparc platform. Our server (Sun Fire E20K) has 64 Gigs of ram. We have 6 different instances of Oracle running. The sga_max_size for each database is set to 5 gigs. Our shmmax kernel setting is set to around 6 gigs. Should the shmmax be larger? In particular someone said that the shmmax kernel parameter should be set to the sum of the sga_max_size of the instances we have running. Is this true? I have thus been unable to find any documentation on this.
This post first appeared at Oracleinaction (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself).
I will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines