Skill sets needed by Developers and DBAs

DBAs	Developers
Operations	Algorithms
Resource management	Languages
Troubleshooting	Frameworks
Physical data design	Design
System interfaces	User interfaces
Data modeling	Data modeling
SQL optimizer	Debugging, profiling, tracing
Oracle product features	Business-domain processes

Basic Data Mining Tutorial

Memo to Myself

Test (Sample) Data Generators

25+ Alternative & Open Source Database Engines

Hacking and Hardening Oracle XE (link)

How to Install Oracle 11g Release 2 on OEL 5.4 on VirtualBox: Installing Grid Infrastructure

How can I format xxxxxxxxx like xxx-xx-xxxx in Oracle?

Creating Custom Authentication in APEX

Installing Oracle 11g inside an Xubuntu Linux VMWare Image

Apex Database Objects

1. Workspace files: apex_workspace_files
Includes columns for:
file_name - name of file uploaded
file_id - unique identifier
application_id - application number
workspace_name - should always be your workspace
mime_type - e.g. text/plain, image/gif, application/excel
file_size - file size in bytes
created_by - e.g. APEX_PUBLIC_USER
created_on - sysdate
document - blob that contains contents of uploaded file

2. Apex access log: apex_workspace_access_log
Creates log record every time you log into application via Apex standard login page (I think). Must be workspace and Apex-owner schema-specific?
Columns include:
ip_address
seconds_ago - how log ago the access happened - dynamic?
access_date
authentication_result - e.g. AUTH_SUCCESS
custom_status_text - ?

3. Apex summary log: apex_workspace_log_summary
Includes columns:
application_id
page_views
distinct_pages
total_elapsed_time
first_view - date/time
last_view - date/time
period_in_days

4. Application activity log: apex_workspace_activity_log
Logs internal (Apex) as well as pages accessed in your application.
Columns include:
application_id
application_name
application_schema_owner - e.g. STEW_STRYKER
page_id
page_name - e.g. Load Import File - new
ip_address
error_message - e.g. ORA-00904: “ADDRESS_LINE_2_BILLING”: invalid identifier
error_on_component_type - report
error_on_component_name - Review Participants

5. Apex view definitions: apex_dictionary
Lists all views and their columns. The view columns are documented in this table in the Comments column.
To get a list of Apex Views
SELECT DISTINCT apex_view_name FROM apex_dictionary;
6. Installation-specific?
V3 Apex schema: flows_030000

Creating Oracle Extended RAC on Oracle VM

Click here for details on Oracle Extended RAC on Oracle VM.