Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win



Posted on 2010-08-27
Medium Priority
Last Modified: 2013-12-28
Can you let me know from the attched file how is this system sized and configured (i.e CPU, RAM, DISK size, etc).
Are all those drives logical or physical?
Which drive/directory do you usually install oracle?
Question by:sam15
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 77

Accepted Solution

slightwv (䄆 Netminder) earned 1000 total points
ID: 33543651
Memory size: 16379 Megabytes

Can't tell disk size but filesystem size is under the kbytes column.


>>Are all those drives logical or physical?
No way of knowing here.  Do you really care?  This is typically up to the sys admin.  I'm not familiar with Solaris but you would need to check out their Logical Volume Manager to verify this.

>>Which drive/directory do you usually install oracle?

I typically use /opt.  Back when I was on UNIX this was a common place the 'optional' software.

I'm sure Oracle covers this under their OFA:


Author Comment

ID: 33543885
If i am reading thsi correctly the /opt disk is 8 GB of which 3 GB are taken and 5 Gb available.
Is not this tight for oracle.

I am also confused on RAM aviable using sar. Total RAM is 16 GB which is good but say is showing 261 MB available. Something is not right.
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 33543953
>>Is not this tight for oracle.

You only install the Oracle software under /opt.  5 Gig should be plenty.

You should create your Oracle database on different disks.  You should also separate the files on different disks.  For example, redo logs should not be on the same disks as datafiles.

All this should be covered in the OFA guides.

>>showing 261 MB available. Something is not right.

My UNIX is pretty old but it does look like there is only 261M free.  What makes you think that isn't right?

Check out prstat:
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.


Author Comment

ID: 33546094
because machine has 16 GB RAM and nothing is running yet on it.
Oracle need min of 1 GB RAM so that is not enough.

Also, would you use OFA and same structure on DEV/TEST like PROD.
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 33546137
>>because machine has 16 GB RAM and nothing is running yet on it.

What does prstat say?  Maybe a: ps -ef and look for memory usage.

>>would you use OFA and same structure on DEV/TEST like PROD.

Yes.   Keeping everything the same allows you to create templates.  

It also allows you to create script that might use file/path names.  Once they are tested, there is nothing to change when you go to run them in production.

Author Comment

ID: 33546233

it seems you have to multiply the freemem *8 which is still 1.6 GB.

I ran vmstat -s and it show about 4 GB. kind of strange where the other 12 GB.

Author Comment

ID: 33546249
ps -ef does not show where memory is used

Author Comment

ID: 33547191
I see a list of processes with ps -ef. Nothing about memory. where do you see it.

Assisted Solution

Amol earned 500 total points
ID: 33554166
Memory is almost  16GB.
For CPU, give the o/p of "prtdiag -v" or "psrinfo"
For total disk size, give the o/p of "format" command
Some are metadevices according to your o/p of filesystem.
For Oracle, you have to find a suitable filesystem with min 1.5 GB of free space
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 33557586
>>ps -ef does ...

I was going from memory since I don't have access to UNIX any more.  I was thinking there was a way to get process memory usage from the ps command.  Sorry about that.

It looks like prstat (Link provided above), does this for Solaris.

LVL 13

Assisted Solution

Rowley earned 500 total points
ID: 33565714
echo '::memstat' | mdb -k  

Will give you information about where memory is allocated in the system. It is not uncommon to see a busy solaris system use all available memory, especially on hosts that deal with many file access requests.

When reading the output, cachelist and freelist go together to make up free memory. Page cache is generated for any file system access. The page scanner kicks in when free memory drops below 1/64th of physical memory to free up mem from the page cache. No point in having unused memory is there?
Seeing as you're running oracle, you should also check how many shared memory segments are being used too using the 'ipcs -mb' command. To check what disk subsystem you're running, you could start by issuing the "echo "" | format" command or "iostat -En"

"pmap -x [pid]" will give you details on memory usage per process.

Most dba's that i've worked with like to install oracle binaries somewhere under /u01.

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Attention: This article will no longer be maintained. If you have any questions, please feel free to mail me. jgh@FreeBSD.org Please see http://www.freebsd.org/doc/en_US.ISO8859-1/articles/freebsd-update-server/ for the updated article. It is avail…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question