default screenshot for jonathansblog

Oracle process overview

Oracle process overview. There are 3 types of oracle processes: USER processes SERVER processes BACKGROUND processes User connected to a user application (eg sql*plus) controls the application associated with an oracle server process Server processes there are 2 types of oracle server process, depending on configuration Dedicated ( 1 server Read more…

default screenshot for jonathansblog

Oracle forms overview

Oracle forms overview. Oracle internet platform consists of 3 components: oracle application server (forms service + OC4J) oracle developer suite (forms developer + object navigator + form module) oracle database Oracle application server includes forms service – new generation of tools that allow devs to deploy new and existing forms Read more…

default screenshot for jonathansblog

Oracle control file

Oracle control file: binary file start of instance, file is checked database has 1 control file each modifiable only by oracle editing prohibited, even by DBA Keeps track of: datafile names and locations redo log names and locations table-space information name of database time-stamp of database creation Usage: on start Read more…

default screenshot for jonathansblog

Updating to php 5.4 and mysql 5.5 in centos 6

To update to php 5.4 and mysql 5.5 in centos 6: 1) install the epel, remi and rpm-forge repos rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm rpm -Uvh http://pkgs.repoforge.org/rpmforge-release/rpmforge-release-0.5.3-1.el6.rf.x86_64.rpm 2) edit the /etc/yum.repos.d files to enable the repos vi /etc/yum.repos.d/epel.repo change the enabled=0 to enabled=1 vi /etc/yum.repos.d/remi.repo change the enabled=0 to Read more…

default screenshot for jonathansblog

Evaluation of FPA

Evaluation of FPA (Function Point Analysis) Language independant Derived from Specification Re-Usable code / Object Oriented Business software is best suited Training required Innovative code with fewer LOC is not Penalized Backfiring: FPA can be converted to LOC using backfiring tables.

default screenshot for jonathansblog

XP extreme programming

Here are my bullet points for XP extreme programming: [DeLeRIuM Pair] Design Later Reuse / Refactor / OO Integrate continually Minimal system first, expand later Pair Programming [5 ‘Donts’] Don’t Write documentation Don’t Design / analyse before writing code Don’t Specialise in any one area Don’t Leave testing till later Read more…

default screenshot for jonathansblog

Waterfall method

I’m studying a Masters Degree in ‘Advanced Computer Systems Design’. I have an upcoming exam in project management. One of the areas I’m studying is SDLC [software development life-cycles]. This is a short post on the waterfall method. These are my study notes: Waterfall: The waterfall SDLC method is the Read more…

default screenshot for jonathansblog

Subnetting class C networks

Subnetting class C networks Benefits of Subnetting: Reduced Network Traffic Optimised Network Performance – as a result of reduced traffic Simplified management Facilitated spanning of large geographical distances   How to create subnets: Determine the number of required network ID’s one for each subnet one for each WAN connection Determine Read more…