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:
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Via a live example, show how to take different types of Oracle backups using RMAN.
Suggested Courses
Course of the Month9 days, 9 hours left to enroll

762 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