Use this command on Solaris with bash, to get your files sorted from the smallest to the largest and quickly list large files.
$ ls -lhs | sort -nSk5
Note: k5 is the column number from left to right (in this example column 5). if your filesizes are displayed on the 3rd column you put ..k3. All depends on which column the command ls -l displays the filesizes.
Database Systems is a blog about Databases and Data of any size and shape
Wednesday, 16 February 2005
Tuesday, 1 February 2005
Unix/Linux kernel parameters for Oracle installation
This is Unix/Linux Kernel parameters configuration based on how many oracle instances with how many processes you wish to run on the Unix box.
SHMMAX = The maximum size(in bytes) of a single shared memory segment.
SHMMIN = The minimum size(in bytes) of a single shared memory segment.
The above settings let the max be bigger then we wil ever use and the min much smaller. They are sufficient for pretty much all systems.
SHMMNI = The number of shared memory identifiers.
SHMSEG = The maximum number of shared memory segments that can be attached by a process.
The above settings should also be sufficient.
SEMMNS = The number of semaphores in the system.
SEMMNI = The number of semaphore set identifiers in the system; determines the number of semaphore sets that can be created at any one time.
SHMMAX = The maximum size(in bytes) of a single shared memory segment.
SHMMIN = The minimum size(in bytes) of a single shared memory segment.
The above settings let the max be bigger then we wil ever use and the min much smaller. They are sufficient for pretty much all systems.
SHMMNI = The number of shared memory identifiers.
SHMSEG = The maximum number of shared memory segments that can be attached by a process.
The above settings should also be sufficient.
SEMMNS = The number of semaphores in the system.
SEMMNI = The number of semaphore set identifiers in the system; determines the number of semaphore sets that can be created at any one time.
SEMMSL = The maximum number of sempahores that can be in one semaphore set. It should be same size as maximum number of Oracle processes
(The PROCESSES parameter in the init.ora file).
SEMMSL
Set to 10 plus the largest initsid.ora PROCESSES parameter of an Oracle database on the system. The PROCESSES parameter can be found in each
initsid.ora file, loc ORACLE_HOME/dbs directory. The default value of PROCESSES
for the 8.1.5 prebuilt database is 50.
SEMMNS
Set to the sum of the PROCESSES parameter for each Oracle database the
largest one, plus 2 times the largest PROCESSES value, plus 10 number of Oracle
databases. For example, consider a system that has three Oracle instances with
the PROCESSES parameter in their initsid.ora files set to the following values:
ORACLE_SID=A, PROCESSES=100
ORACLE_SID=B, PROCESSES=100
ORACLE_SID=C, PROCESSES=200
The value of SEMMNS is calculated as follows:
SEMMNS = ((A=100) + (B=100)) + ((C=200) * 2) +
((# of instances=3) * 10) = 630
Definition: Semaphore
Semaphores are serialization devices (only one person at a time will get a
semaphore). In general, they are "heavy weight" (we have light weight latches
as well) and implemented by the OS itself. We use them to protect some shared
data structures from being updated by more then one process at a time.
From : http://asktom.oracle.com , Tom Kyte
(The PROCESSES parameter in the init.ora file).
SEMMSL
Set to 10 plus the largest initsid.ora PROCESSES parameter of an Oracle database on the system. The PROCESSES parameter can be found in each
initsid.ora file, loc ORACLE_HOME/dbs directory. The default value of PROCESSES
for the 8.1.5 prebuilt database is 50.
SEMMNS
Set to the sum of the PROCESSES parameter for each Oracle database the
largest one, plus 2 times the largest PROCESSES value, plus 10 number of Oracle
databases. For example, consider a system that has three Oracle instances with
the PROCESSES parameter in their initsid.ora files set to the following values:
ORACLE_SID=A, PROCESSES=100
ORACLE_SID=B, PROCESSES=100
ORACLE_SID=C, PROCESSES=200
The value of SEMMNS is calculated as follows:
SEMMNS = ((A=100) + (B=100)) + ((C=200) * 2) +
((# of instances=3) * 10) = 630
Definition: Semaphore
Semaphores are serialization devices (only one person at a time will get a
semaphore). In general, they are "heavy weight" (we have light weight latches
as well) and implemented by the OS itself. We use them to protect some shared
data structures from being updated by more then one process at a time.
From : http://asktom.oracle.com , Tom Kyte
Tuesday, 18 January 2005
Unix prompt with ORACLE_SID
Modify your command prompt on unix box to include the oracle SID in your prompt. Type this the .profile file of your user login.
PS1="
\${ORACLE_SID} on \h \${PWD}
$ "
#
PS1="
\${ORACLE_SID} on \h \${PWD}
$ "
#
Monday, 1 January 2001
Here is a set of tools I use, and some project work I done
Oracle Apex
Oracle Apex is a Oracle hosted rapid web application development tool using only an internet browser. I have been using this tool for a while and I find it very easy to use. Oracle Apex is all-in-the-database approach to application development, as application server and the webserver server are inside and are part of the Oracle database. I have an Oracle Apex test workspace hosted by Oracle. This is a free service and anybody can get an account with Oracle Apex for testing and evaluation purposes. To sign up for a FREE Oracle Apex development account go to Oracle Apex and sign up. My development site is here: Kubilay's Oracle Apex Development Website
Developer force and Salesforce
Developer Force is a free developer program for the Force.com Cloud computing Platform from Salesforce. You can get a force.com account anytime and is free. I have used this platform at work to create fault tracking and Google Maps based applications. Force.com is like Oracle Apex, a web application development environment where you do declarative programming and create apps by using just an internet browser. In the core of this technology you find a database (Oracle) and a Java like code called APEX Code and API’s. Check it out here: developer.force.com>
Informatica
A great integration environment in the Cloud. You can connect hetergeneous databases, spreadsheets, csv and cloud-computing platforms like Salesford and move data between them. A kind of ETL tool in the Cloud. Informatice is an enterprise-class software-as-a-service (SaaS) integration application. They even give you 1 connecter free! Find out more here: informaticaondemand
Oracle SQL Developer
Oracle SQL Developer is a free and fully supported graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks. Find out more about Oracle SQL Developer
Talend TOS
Like Informatica Talend is another company focusing in data integartion solutions. The difference is that Talend Open Studio is Open Source and is absolutely free! I have used Talend TOS to integrate data between Salesforce, Oracle and MS SQL Server. It is quite fun to use as is very graphical and very easy to understand. It can generate ETL scripts which you can host anywhere and run. It can generate the ETL scripts in Java or Perl and is based on Eclipse. Have a look here to find out more. www.talend.com
Apatar
Apatar is a company focusing in data integration. Is yet another Open Source data integration tool like Talend TOS. This tool is very graphical too. I have used Apatar like Talend TOS in data integration between Oracle and MS SQL Server. It works with Salesforce too, plus it has many other connectors. Find out more here: http://www.apatar.com
Tuesday, 8 August 2000
Contact
You can contact me about the blog posts in this blog or on related topics with the form below.
Subscribe to:
Posts (Atom)