http://bikle.com
http://bikle.net

Mailing Address:
PO BOX 29502
RCM#33332
LAS VEGAS, NV
89126-9502

Phone: 1-702-927-2995
Fax:   1-702-944-7872

Internet email:  bikle@bikle.com
Owner: Daniel B. Bikle BSEE Caltech 1988 Dan's Resume

www.bikle.com is a site which provides technical information (Oracle related mostly)

Performance Tuning
Backup/Recovery planning 
Data Replication
Oracle Installation
Environment Configuration
Space Management
Capacity Planning
Security
Database Design
Data Migration

www.bikle.com is run by Dan Bikle.

Dan Bikle wants to establish/maintain relationships with people who
work in the software/hardware arena.

For all you Oracle DBAs, we have bikle.com tech tips.

www.bikle.com DBA Technical Tips

DISCLAIMER.txt

Search the Dan Tech Tips:
http://www.google.com/advanced_search?q=site:www.bikle.com+searchStringHere&hl=en

Tips:
A Demonstration of Oracle 8i Managed Recovery Mode
Creation of an Oracle 8i Package for pkgadd
grep and awk Demo to Drop Foreign Keys
Transforming a Large Table Into a Partitioned Table
Tips for Using The Oracle SYSDBA Role
Dan's Oracle Install Demo
Monitoring Oracle with Expect Scripts
Using Expect to Manage Oracle Recovery
Dan's First Oracle Partitioning Demonstration
A Simple Demonstration of RMAN Setup
Some Simple Locking Scenarios
The Magic of CURSOR_SHARING=FORCE
Performance Tuning an AdManager Database
Dan's Performance Tuning Tips
Dan's 9i Performance Tuning Tips
Monitoring for Bad Events
A Simple TKPROF Demo
Dan Meets JDeveloper
Some Simple Java on DOS Tips
Short Java Demo #1
Short Java Demo #2
Short Java Demo #3
Short Java Demo #4
Short Java Demo #5
Short Java Demo #6
Servlet Demo #1
Creation of a Java Based SQL Function
A Demo of Mixing Java With SQL Loader
Some JDBC Demos
Java AWT, XML, UML, Ant, Javadoc
Dan's OCP Notes
Lost Windows Password
Dan's XML Notes
Dan's XML Tutorial
Some UNIX tips
A Simple 9i Install on Solaris
oradebugTrace.txt
Some Veritas Notes
Oracle 9.2 RAC Install on Solaris
Demo of 8i to 9i Upgrade
Oracle 9.2 RAC Load Balancing and Failover Demo
Data Guard for Oracle 9i RAC
Use /tmp to boost load I/O (with risk)
How to clone to a 9i RAC database
Sun Fire 6800 Domain Setup Notes
Sun Fire 4810 Domain Setup Notes
T3 Storage Array Setup Notes
More T3 Storage Array Setup Notes
Simple RMAN Scripts For 9i RAC database
Statspack Demo
ssh Port Forwarding on UNIX
Gathering CBO Statistics
Oracle Dynamic SGA, DISM, SunFire 6800 Dynamic Reconfiguration
Quick Comparison of Gigabit Ethernet to 100 Base-T
Some Linux Notes
Linux: rpm notes
Script to Create ISO file to hold a file system
Linux: Mount a .iso file as a file system
Solaris: Mount a .iso file as a file system
ciscoVPN on Linux
genclntsh problem on Linux
Brief Study of XQuery Implementations
Some notes about XPath
FOOFMAPI: Dan's Python Tutorial
Install Oracle 9i RAC on Solaris 9
UML Demo 10
UML Demo 11 with some Java and JUnit
UML Demo 12, Enhancement to Demo11 UML model
Using Oracle 10g On Linux To Study Options Pricing Data
Oracle 10g RAC On Solaris 9 Installation Notes
UNIX strings, grep, sed against expdat.dmp
Simple 10g RMAN demo
10g "BIN$/" Segments
cboStatsPost.txt

Java/JDBC Demo: Catching SQLExceptions From DROP Trys:
http://www.bikle.com/TThier/Languages/java/catchDropDemo


Dan's Simple PL/SQL Demos:


SET SERVEROUTPUT ON, variables, LOOP
http://www.bikle.com/TThier/Languages/plsql/plsql01.txt

CURSOR, FETCH, %NOTFOUND, CLOSE
http://www.bikle.com/TThier/Languages/plsql/plsql02.txt

CURSOR FOR LOOP
http://www.bikle.com/TThier/Languages/plsql/plsql03.txt

Using a CURSOR FOR LOOP to generate and then run SQL commands against tables listed in the user_tables:
http://www.bikle.com/TThier/Languages/plsql/alterTmon-sql.txt
http://www.bikle.com/TThier/Languages/plsql/alterTdropFK-sql.txt

Using a CURSOR FOR LOOP to generate parameters for repeated procedure calls:
http://www.bikle.com/TThier/Languages/plsql/dropAllDBjobs-sql.txt

UPDATE, WHERE CURRENT OF
http://www.bikle.com/TThier/Languages/plsql/plsql04.txt

PROCEDURE, SHOW ERRORS, EXEC
http://www.bikle.com/TThier/Languages/plsql/plsql05.txt

Feed variable to procedure then to CURSOR WHERE clause
http://www.bikle.com/TThier/Languages/plsql/plsql06.txt

%TYPE, %ROWTYPE
http://www.bikle.com/TThier/Languages/plsql/plsql07.txt

associative array (TABLE ... INDEX BY), TYPE, FIRST, LAST
http://www.bikle.com/TThier/Languages/plsql/plsql08.txt

varray, EXTEND, FIRST, LAST, LOOP
http://www.bikle.com/TThier/Languages/plsql/plsql09.txt

virtual in-memory table (TABLE ... CAST)
http://www.bikle.com/TThier/Languages/plsql/plsql10.txt

nested table
http://www.bikle.com/TThier/Languages/plsql/plsql11.txt

virtual table, OBJECT, TABLE ... CAST, REF CURSOR
http://www.bikle.com/TThier/Languages/plsql/plsql12.txt

PACKAGE
http://www.bikle.com/TThier/Languages/plsql/plsql13.txt

PACKAGE, FUNCTION, RETURN cursorType
http://www.bikle.com/TThier/Languages/plsql/rsPLSQLdemo-sql.txt

Trigger
http://www.bikle.com/TThier/Languages/plsql/crTrigger-sql.txt

Using PL/SQL to copy a BLOB datatype
http://www.bikle.com/TThier/Languages/plsql/pl_sql_copy_blob.txt

Java JDBC oracle.sql.ARRAY PL/SQL Demonstration
http://www.bikle.com/TThier/Languages/java/ARRAYdemo

Java JDBC Oracle PL/SQL Collection Demonstration
http://www.bikle.com/TThier/Languages/java/spJava

Converting a PL/SQL Cursor into a Java ResultSet
http://www.bikle.com/TThier/Languages/java/rsPLSQLdemo

JUnit, JDBC, PL/SQL Procedures
http://www.bikle.com/TThier/Languages/java/JUnitDemo


Dan's SQL Queries (and some commands)

Dan's SQL Queries


Dan's Shell Commands

Dan's Shell Commands


Dan's J2EE Notes, Tips, Observations

http://bikle.net/TThier/J2EE/entryPoints


Some Mathematica notes

Some Mathematica notes


Ruby on Rails, Mac OS X 10.3.9, Oracle 10g, Ruby 1.8.2
Discussion about Curt Hibbs Tutorial
moreRailsNotes.txt


Ruby on Rails 0.13.1.2233, Linux, Oracle 9i, Ruby 1.8.2
linuxScreenDump.txt