ergem.net logo
RESUME PROJECTS THESIS, PUB & SEMINARS APPLICATIONS WEB DESIGNS PHOTOS HOME
     
 contact info
ergemp@gmail.com
 
site note
 
 Further Development
http://ergempeker.blogspot.com
http://ergemp.blogspot.com
http://ergem.blogspot.com
 
 Documents
My Oracle Documents
My UNIX Documents
Scripts and Notes


 Oracle Database Server
  - Docs
    - Oracle_DBA (pdf) (12.03.2009)
    - Oracle_Plsql (pdf)
    - Oracle_Perftune (pdf) (12.03.2009)
    - Oracle_RMAN (pdf)(10.12.2008)
     
  - Pl/Sql
    - Example Sql Loader
    - Example Sql Loader (control file)
    - Example UTL File
    - Find DB Size
    - Find DB Version
    - Find and Compile invalid objects
    - Find OS User (sql)
    - Find Trace filename (sql)
    - Find who is running the sql (sql)
    - Find Table Size (Function)
    - Find how many rows processed by an import (sql)
    - Create Controlfile (sql)
    - Gather table stats (Procedure)
    - Hot backup script (Procedure)
    - TAF Example (Text)
    - Change job next date (sql)
    - Schema Trigger Before DDL (trg)
    - Logminer reference (sql)
    - Statspack in a nutshell
   

- job controller (Procedure)

    - dblink controller (Procedure)
    - close a dblink connection (Procedure)
    - table monitoring (Procedure)
    - drop a user locking a source package (sql)
     
  - Links
    http://www.psoug.org/
    http://www.unix.org.ua/orelly/oracle/index.htm

 Unix Shell Scripts
  - Docs
    - AIX System Commands (Word)
    - AIX Tar Command (Word)
    - AIX User limit performance parameters (Word)
    - AIX Volume Manager (Word)
    - AIX - LINUX Network Time Protocol (Word)
    - Tivoli Guide 1 (.JPG)
    - Tivoli Guide 2 (.JPG)
    - Tivoli Guide Ref. (Word) (Turkish)
    - Tivoli Troubleshooting (Word)
   
  - Shell Scripts
    - Delete last line of a text file (sh)
    - Text File Formatting (sh)
    - Change backup time of cron job (sh)
    - Restore backup time of cron job (sh)
    - Kill oracle users from shell (sh)
    - Delete oracle archive logs (sh)
    - Find and Delete something in UNIX (txt)
    - Find and Compress something in UNIX (txt)
    - UNIX system checking scripts (zip)
    - LINUX change the hostname (txt)
    - LINUX pagefile howto (txt)
    - LINUX software RAID by mdadm (txt)
    - LINUX software firewall by iptables
     
  - Links
    - http://www.grymoire.com/Unix/
     

 Others
  - Docs
    - Apache Web Server (Word)
    - iptables Linux (Word)
    - xml - xsl - xpath basics (Word)
     
   
  - Links
    http://uralural.blogspot.com
     
    http://www.dmoz.org
    http://www.tldp.org
     
    http://httpd.apache.org/docs-2.0/
    http://www.openssl.org/docs/
    http://www.iptables.org
    http://www.ahinc.com/online.htm
     
    http://www.xml.com/ldd/chapter/book/index.html
    http://www.unix.org.ua/orelly/oracle/index.htm
     
    http://www.elektronikhobi.com/
    https://www.britishpathe.com
     
     

 Update Log
03-05-2010
I moved Documents and Scripts on Google Docs.
22-10-2007
Document viewer application is now online. You can track new documents, codes and examples with this application.
10-08-2007
My new application photo album viewer is now online. You can view my photos with this new asp.net application.
03-04-2007
New plsql and linux scripts added.
14-10-2006
decided to change the main page for more functionality. New sources and links added. You can also find new resume.
04-04-2005
some sources added and projects link is now working
13-03-2005
oracle performance tuning document is added and resume is updated. contact info is also updated
26-03-2004
 a new publication is added and links page is updated.
18-11-2003
New links and panda photos are added. All links are working by now
17-09-2003
The site is updated but still has missing links especially on downloads
11-02-2002
The site is online by an under construction warning