Code Name: Guest Login / Register

Be rightous in your life and walk in the fun.
2 users online


Category: General >> Website

Restructure+1

Posted By: Goddard on Sunday, October 31st 2010 6:54:06 PM

I have come to the conclusion that Magi Portal needs yet one more restructuring so it can be ready for what is ahead.  I want to design Magi Portal so it is a fast CMS for web masters and not a random newbie.  I think this is something that is missing from content management systems.  Mostly I'll be doing work in my free time so I can use the system, but if anyone wants to help I do have it on git hub.  I'll put a link up for that soon once I restructure the database.




Category: General >> Launch Pad Club

LaunchPadClub.com is Live+1

Posted By: Goddard on Tuesday, August 10th 2010 11:07:50 AM

The site may be live, but it is still under construction.  All site features are missing so don't plan on talking to any of the members.  A few of us have been working hard during the summer trying push the group forward and get a jump on Fall term.  So far things are moving along.  We have the required 10 people and then some.  It is a mixture of about 6 ladies and 4 gentlemen.  We aren't ready to begin on the first project just yet, but in a few weeks Fall term will start and we can have our first official meeting.  Then we will be able to exchange contact information and make sure everyone is taken care of and on the same page.  I'm pretty excited to see what we can do and look forward to working with everyone.
Almost forgot the link www.launchpadclub.com




Category: Tutorials >> irssi

Funniest IRC EVER!+1

Posted By: Goddard on Saturday, July 24th 2010 12:15:58 PM

I was sitting in the php irc like I often do and while I was idling playing with my daughter the funniest conversation happened...I just had to share it with everyone.

12:06  bdbdbd> hey guy is there a way to load a text file in php?
12:06  Hajuu> nope
12:06  Hajuu> impossible.
12:07  Hajuu> no. way.
12:07  bdbdbd> really? someone told me it was possible
12:07  Hajuu> its a bit rude of you to ask frankly.
12:07  Hajuu> appologise.
12:07  bdbdbd> isn't this the place to ask questions about php?
12:07  Hajuu> no. this is Pony / Horse Play
12:07  bdbdbd> my bad
12:07  Hajuu> are you.. open minded?





Category: General >> Oracle

9i PGA and SGA summary+1

Posted By: Goddard on Thursday, July 8th 2010 9:27:01 AM

I wanted to spend some time talking about oracle's 9i Program global area, or PGA.  The PGA is used for non-shared memory the the server process uses.  The PGA is one of two memory areas used by the oracle system.  This area is allocated when the server process is started.  This memory is allocated for each process the user creates and destroys.  Memory is in turn allocated and deallocated.  This memory area is only accessed by one process.  Many times this area is used for shared and private SQL areas as well as bind information and runtime memory structures.  There are however major differences in dedicated and shared servers.  Everything from seession memory to run time memory is switched using a shared server from PGA to the SGA memory area.  If you don't know what SGA is I will explain it now.

The Shared Global Area (SGA) has many different memory structures such as shared pool, database buffer cache, and redo log buffer.  There are other structures such as lock and latch.  There are also two configurable structures that can be used within the SGA.  Large pool and Java pool.  A important feature to note is the ability to change parameters of the SGA while the instance is running that includes resizing the structure.  So all the structures mentioned earlier can have their sizes altered when the instance is running.  Although there is a limitation on the maximum size of the SGA.  This value is set as a parameter in the variable name SGA_MAX_SIZE.  The SGA is made up of 8 basic areas.  The shared pool which consists library cache, data dictionary cache and the database buffer cache which includes the keep cache which size is assigned in the variable DB_KEEP_CACHE_SIZE in the db buffer cache there is also default which holds blocks that aren't assigned to other pools and then recycle which has a variable DB_RECYCLE_CACHE_SIZE and this buffer holds information that is soon to be deallocated.  Now we have the last three areas the large pool which is controlled by its variable LARGE_POOL_SIZE then the Java pool which is controlled by JAVA_POOL_SIZE and lastly the redo log buffer which is controlled by LOG_BUFFER.  

This is just a short summary and I will add more to it as I learn more.




Category: General >> Oracle

Oracle 9i - Mandatory background processes+1

Posted By: Goddard on Thursday, July 1st 2010 3:56:59 PM

Just started some classes on Oracle so expect some new stuff coming from me on this database software.  I admit I am just learning so if you see any mistakes please let me know.

In the Oracle 9i database system there are five mandatory background processes.
  1. Database Writer (DBWn)
  2. Log Writer (LGWR)
  3. Process Monitor (PMON)
  4. System Monitor (SMON)
  5. Checkpoint (CkPT)
All of these processes run in the background and control specific areas of the oracle database system.  

The DBWn writes all data from the database buffer cache to the data files.  These database buffers are referred to as "dirty" buffers.  These dirty buffers are written directly to the disk.  The DBW stands for Database Writer while the n stands for a system variable representation meaning process number.  This is importatnt to know because you are not limited to having only one DBW process running.  Apparently this is useful in larger systems that require heavy database writing.  There is also something known as a cold buffer.  The cold buffer is a buffer that determines if something hasn't been used recently. The way this is calculated is with help from a special algorithm to determine if it falls into these category.  The algorithm is the LRU.  If you want to learn more about the LRU algorthim go YouTube - LRU Algorithm to watch a nice video that some one made.  I didn't make it so thanks for that video.

The LGWR is the process that controls the redo buffer.  The process writes to redo log files on disk.  In order for the LGWR to write the buffer to disk the user has to issue a COMMIT.  Some writing is deferred though until a more opportune time.  Other are usually written immediately.  The redo log is important in case you COMMIT something that shouldn't of been and you need restore.

The PMON is incredibly important to user error recovery and clean up.  The PMON will recover buffer cache and free any unallocated resources.  This is a pretty important background process.

The SMON is some what like the PMON in that is performs recovery, but it also performs cleaning procedures on instance start up.

The CkPT is responsible for storing data that helps in recovery.  It is the time table of sorts.  It creates recovery ids into the redo log file and it also ensures any information in the database buffer cache is written to the data files.  The point that is of most importance is the checkpoint position.  This means the point in the event of a failure to begin recovery.  The DBWn will write all information prior to the checkpoint.  This process does not write any data to disk though.

 Well that is the first bit of information I can post.  Like I said earlier I am learning so if you see any issues please let me know.




Things to Support

Save the Net LEAVE ME A COMMENT!! play chess View Ryein Goddard's profile on LinkedIn
My Facebook My Facebook