Home
Author Forum
Author Resources
Author FAQ
Author Tips
Publishers
Oracle Tips
Oracle News
Oracle Forum

Oracle Tips
 

This page includes Oracle tips and techniques.

Oracle 10g

10g_216 10g_217 10g_218 10g_219 10g_220
10g_221 10g_222 10g_223 10g_224 10g_225
10g_226 10g_227 10g_228 10g_229 10g_230
10g_231 10g_232 10g_233 10g_234 10g_235
10g_236 10g_237 10g_238 10g_239 10g_240

 

10g_366 10g_367 10g_368 10g_369 10g_370
10g_371 10g_372 10g_373 10g_374 10g_375
10g_376 10g_377 10g_378 10g_379 10g_380
10g_381 10g_382 10g_383 10g_384 10g_385
10g_386 10g_387 10g_388 10g_389 10g_390

 

10g_516 10g_517 10g_518 10g_519 10g_520
10g_521 10g_522 10g_523 10g_524 10g_525
10g_526 10g_527 10g_528 10g_529 10g_530
10g_531 10g_532 10g_533 10g_534 10g_535
10g_536 10g_537 10g_538 10g_539 10g_540

Oracle Replication

rep_126 rep_127 rep_128 rep_129 rep_130
rep_131 rep_132 rep_133 rep_134 rep_135
rep_136 rep_137 rep_138 rep_139 rep_140
rep_141 rep_142 rep_143 rep_144 rep_145
rep_146 rep_147 rep_148 rep_149 rep_150

Oracle Physical Design

phys_126 phys_127 phys_128 phys_129 phys_130
phys_131 phys_132 phys_133 phys_134 phys_135
phys_136 phys_137 phys_138 phys_139 phys_140
phys_141 phys_142 phys_143 phys_144 phys_145
phys_146 phys_147

Oracle Privacy Security Auditing

aud_126 aud_127 aud_128 aud_129 aud_130
aud_131 aud_132 aud_133 aud_134 aud_135
aud_136 aud_137 aud_138 aud_139 aud_140
aud_141 aud_142 aud_143 aud_144 aud_145
aud_146 aud_147 aud_148 aud_149 aud_150

 

aud_276 aud_277 aud_278 aud_279 aud_280
aud_281 aud_282 aud_283 aud_284 aud_285
aud_286 aud_287 aud_288 aud_289 aud_290
aud_291 aud_292 aud_293 aud_294 aud_295
aud_296 aud_297 aud_298 aud_299 aud_300

 

aud_426 aud_427 aud_428 aud_429 aud_430
aud_431 aud_432 aud_433 aud_434 aud_435
aud_436 aud_437 aud_438 aud_439 aud_440
aud_441 aud_442 aud_443 aud_444 aud_445
aud_446 aud_447 aud_448 aud_449 aud_450

 

aud_576 aud_577 aud_578 aud_579 aud_580
aud_581 aud_582 aud_583 aud_584 aud_585
aud_586 aud_587 aud_588 aud_589 aud_590
aud_591 aud_592 aud_593 aud_594 aud_595
aud_596 aud_597 aud_598 aud_599 aud_600

 

aud_726 aud_727 aud_728 aud_729 aud_730
aud_731 aud_732 aud_733 aud_734 aud_735
aud_736 aud_737 aud_738 aud_739 aud_740
aud_741 aud_742 aud_743 aud_744 aud_745
aud_746 aud_747 aud_748 aud_749 aud_750

Oracle Internals Monitoring

int_126 int_127 int_128 int_129 int_130
int_131 int_132 int_133 int_134 int_135
int_136 int_137 int_138 int_139 int_140
int_141 int_142 int_143 int_144 int_145
int_146 int_147 int_148 int_149 int_150

 

int_276 int_277 int_278 int_279 int_280
int_281 int_282 int_283 int_284 int_285
int_286 int_287 int_288 int_289 int_290
int_291 int_292 int_293 int_294 int_295
int_296 int_297 int_298 int_299 int_300

 

int_426 int_427 int_428 int_429 int_430
int_431 int_432 int_433 int_434 int_435
int_436 int_437 int_438 int_439 int_440
int_441 int_442 int_443 int_444 int_445
int_446 int_447 int_448 int_449 int_450

Java Job Interview

java_126 java_127 java_128 java_129 java_130
java_131 java_132 java_133 java_134 java_135
java_136 java_137 java_138 java_139 java_140
java_141 java_142 java_143 java_144 java_145
java_146 java_147 java_148 java_149 java_150

 

java_276 java_277 java_278 java_279 java_280
java_281 java_282 java_283 java_284 java_285
java_286 java_287 java_288 java_289 java_290
java_291 java_292 java_293 java_294 java_295
java_296 java_297 java_298 java_299 java_300

Oracle Disk I/O Tuning

RAID Redundant Arrays Concurrency IO Path
EMC Storage IO Path Fragmentation
Array Schematic Write Caching
   
StorEdge EMC Storage Shared Storage
EMC Storage Logical Units LUNS AMS
Memory Caches Shared Storage RAC Cluster
   
IO Profiles RAC Database Control Parameter
RAID Arrays Shared Storage Voting Disk OCR
IO Profiles Inputs Cluster File System
   
Concurrency Raw Devices Raw Partition RAC
IO Profiles Concurrency Shared Storage Raw Partitions
Load Transfer Tablespace Cluster File System

 

Oracle SQL & CBO Internal

Transportable Tablespaces Database Event Triggers
Transportable Tablespaces v$dbfile Database Event Triggers
Transportable Tablespaces dbms_standard dbms_trigger
   
dbms_tts dbms_output dba_triggers
db_block_size Locally Managed Tablespaces dba_triggers
dba_free_space Database Event Triggers
   
LogMiner dbms_logmnr dbms_standard
dbms_logmnr Log Files Database Event Triggers
dbms_logmnr v$logmnr Defragging Non-partitioned Tables
   
LogMiner v$logmnr Defragging Non-partitioned Tables
LogMiner v$logmnr Defragging Non-partitioned Tables
LogMiner dbms_logmnr Explain Plan

 

Oracle SQL & CBO Internal

Identify Resource-Intensive Code Row Counts Chained Row Counts
Cartesian Join v$sqlplan Space Extents High Water Marks
Resource-Intensive Code v$sql_plan_statistics Selectivity Unique Keys
   
Tune SQL Code Database High-Quality Database Code
Large Table Scans Data Volume Changes Indexes
dba_segments dba_indexes High-Quality Database Code
   
v$segment_statistics SQL Perfection Checklist
SQL Code Database Performance STATSPACK v$sqlarea
Creating High-Quality Database Code dbms_stats Materialized View
   
High-Quality Database Code Oracle Optimizer Parameters
High-Quality Database Code Oracle Optimizer Parameters
dbms_utility db_file Multi Block Read Count


UNIX Job Interview

Policies Process Procedures Coordination People Tasks
Challenging Policy Attention Detail High-Risk Environment
Quality Deadlines High Standards Monitor Systems
   
Quality Coordination Accuracy Consistency Document Data
Product Service Detail Routine Work
Commitment Task Responsibility Attention Detail
   
Quality Dependability Initiative
Commitment Task Long Hours Supervision
Task Urgency Initiative Volunteer
   
Planning Prioritizing Goal Setting Production Business Outcome
Customer Size Deadlines  


J2EE Job Interview

Design Patterns Objects Application Costs Bean Home Extend Interface
Application Complex Object Algorithm Interface EJB
Iterator Class Method Bean Types Session Beans
   
Enterprise Java Beans EJB Stateful Stateless Session Beans
Types J2EE Specification EJB Data Secondary Storage Devices
Java Beans EJB Listener Java Messaging Passivation EJB
   
EJB Software Component Transaction Passivation Types Beans
EJB Container Unique Object Identifier
EJB Class Interfaces Container-managed Bean-managed
   
Remote Interface Bean Class Session Entity Bean Pooling
Entity Bean Methods Workflow System Lightest Weight
Entity Bean Extend Interface Single Message-driven Bean


Programmer Job Interview

Java Servlets attributeAdded Method JSP Declare Initialize String Object
Listener Servlet Container JSP Comments
XML Element Name Syntax Servlet JSP Response Object
   
Thread Safe Servlet Container JSP Import Java Class Files
Error Message Servlet Container Client Session Translation Http Session
ServletContext Interface String Method Default Value Session JSP Attribute
   
Sessions Session ID Cookie Browser Contents Source Code
Parameter Session ID Servlet JavaBean Syntax
Java Server Pages JSP Web Application JavaBean Scope Attribute
   
Directory Java Servlets JavaBean ID Attribute
Lifecycle Java Server Page JSP Tab Libraries Custom Tag Library URI
JSP Response First Client Request Custom Tag Library Directive


Oracle 10g Grid Computing

RAC Performance Monitoring Tuning GES Processes
Tuning StatsPack OEM Oracle Enterprise Manager
StatsPack Waits Oracle Intelligent Agent
   
StatsPack Enqueues Cluster Cache Coherency Page
StatsPack Latches File IO Rates Timing
StatsPack Latches Tuning IO Statistics
   
StatsPack Enqueues Tuning IO Statistics
Tuning StatsPack TM DML Tuning IO Statistics
Enqueues GCS Monitoring Tuning IO Timing
   
GCS Monitoring StatsPack Global Enqueue Services
GCS Monitoring gv$cache_transfer Unbalanced Timing Instances
Index Data Hash Range Partitions RAC System Events Script
   
Monitoring Index Data RAC System Events Script
v$class_cache v$file_cache_transfer v$temp StatsPack Global Enqueue Services
v$class_cache v$file_cache_transfer v$temp RAC System Events Script
   
GES Processes v$cache Cluster Interconnect Network
GES Processes  
SQ TX Enqueues Parallel Slave Synchronization  

 

Web Master Job Interview

t_webmasterjob_97_correct_wiring_ t_webmasterjob_109_fdm_tdm_
t_webmasterjob_98_switching_protocol_ t_webmasterjob_110_security_availability_
t_webmasterjob_99_ip_network_MAC_ t_webmasterjob_111_packet_sniffer_
   
t_webmasterjob_100_member_IP_network_ t_webmasterjob_112_cisco_router_lan_
t_webmasterjob_101_switches_hubs_ t_webmasterjob_113_stateless_stateful_
t_webmasterjob_102_dlci_ t_webmasterjob_114_source-address_verification_
   
t_webmasterjob_103_authentication_methods_ t_webmasterjob_115_security_dmz_
t_webmasterjob_104_csu_dsu_ t_webmasterjob_116_security_vpn_
t_webmasterjob_105_circuit-switched_packet_ t_webmasterjob_117_security_vpn_
   
t_webmasterjob_106_wep_ t_webmasterjob_118_private_ipv4_
t_webmasterjob_107_wireless_lan_ t_webmasterjob_119_nat_benefits_
t_webmasterjob_108_layer2_switch_ t_webmasterjob_120_ssl_trusted_third_party_y_

 

Web Master Job Interview

t_webmasterjob_217_transaction_ t_webmasterjob_229_object_retrieve_
t_webmasterjob_218_acid_transactions_ t_webmasterjob_230_command_class_
t_webmasterjob_219_jar_files_ t_webmasterjob_231_ResultSet_Command_
   
t_webmasterjob_220_corba_object_ t_webmasterjob_232_ResultSet_
t_webmasterjob_221_remote_method_rmi_ t_webmasterjob_233_ResultSet_
t_webmasterjob_222_asynchronous_messaging_ t_webmasterjob_234_connection_pooling_
   
t_webmasterjob_223_applications_transactions_ t_webmasterjob_235_service_method_
t_webmasterjob_224_API_ t_webmasterjob_236_deployment_descriptor_
t_webmasterjob_225_api_packages_ t_webmasterjob_237_httpservlet_
   
t_webmasterjob_226_connections_database_ t_webmasterjob_238_class_files_root_
t_webmasterjob_227_no_suitable_error_ t_webmasterjob_239_servlet_method_
t_webmasterjob_228_connection_object_ t_webmasterjob_240_initialization_parameter_

 

Easy Oracle Automation

t_easyoracle_73_advisory_framework_ t_easyoracle_85_addm_
t_easyoracle_74_btime_limit_ t_easyoracle_86_addm_
t_easyoracle_75_addm_performance_ t_easyoracle_87_addm_
   
t_easyoracle_76_addm_mmon_ t_easyoracle_88_dba_hist_
t_easyoracle_77_enterprise_manager_ t_easyoracle_89_dbms_workload_
t_easyoracle_78_addm_alerts_ t_easyoracle_90_dynamic_performance_
   
t_easyoracle_79_addm_metrics_ t_easyoracle_91_wrh$_tables_
t_easyoracle_80_addm_ t_easyoracle_92_wrh$_tables_
t_easyoracle_81_addm_ t_easyoracle_93_wrh$_wri$_
   
t_easyoracle_82_addm_ t_easyoracle_94_wri$_
t_easyoracle_83_addm_ t_easyoracle_95_statspack_
t_easyoracle_84_addm_ t_easyoracle_96_statspack_

 

Oracle Streams

t_oraclestreams_122_add_table_rules_ t_oraclestreams_134_propagation_
t_oraclestreams_123_capture_process_ t_oraclestreams_135_dbms_flashback_
t_oraclestreams_124_dba_queues_ t_oraclestreams_136_dbms_capture_
   
t_oraclestreams_125_add_table_ t_oraclestreams_137_show_capture_
t_oraclestreams_126_capture_process_ t_oraclestreams_138_v$database_
t_oraclestreams_127_add_table_rules_ t_oraclestreams_139_dba_propagation_
   
t_oraclestreams_128_dba_rules_ t_oraclestreams_140_show_capture_process_
t_oraclestreams_129_dbms_lob_ t_oraclestreams_141_v$streams_
t_oraclestreams_130_queue_apply_ t_oraclestreams_142_v$streams_
   
t_oraclestreams_131_dbms_streams_ t_oraclestreams_143_streams_process_
t_oraclestreams_132_capture_apply_ t_oraclestreams_144_dbms_streams_
t_oraclestreams_133_propagate_  


Web Designer Job Interview

t_webdesigner_217_j2ee_web_application_ t_webdesigner_230_java_remote_method_
t_webdesigner_218_xml_root_element_ t_webdesigner_231_deployment_descriptor_
t_webdesigner_219_web-based_technologies_ t_webdesigner_232_enterprise_applications_
   
t_webdesigner_220_class_method_entity_ t_webdesigner_233_enterprise_archive_
t_webdesigner_221_entity_bean_ t_webdesigner_234_web_archive_files_
t_webdesigner_222_java_objects_ t_webdesigner_235_transport_protocols_
   
t_webdesigner_223_session_bean_ t_webdesigner_236_EIS_tier_
t_webdesigner_224_HTTP_Servlet_ t_webdesigner_237_enterprise_information_
t_webdesigner_225_HTTP_PUT_method_ t_webdesigner_238_j2ee_containers_
   
t_webdesigner_226_java_server_page_ t_webdesigner_239_modeling_tool_
t_webdesigner_227_j2ee_application_ t_webdesigner_240_modeling_tool_
t_webdesigner_229_RMI_protocol_  


Web Stalkers

t_webstalker_97_stalking_ t_webstalker_109_love_obsession_
t_webstalker_98_web_stalking_ t_webstalker_110_love_obsession_stalking_
t_webstalker_99_technology_stalking_ t_webstalker_111_erotomaniacs_
   
t_webstalker_100_credible_threat_ t_webstalker_112_erotomaniacs_
t_webstalker_101_credible_threat_ t_webstalker_113_terrorism_stalking_
t_webstalker_102_web_harassment_ t_webstalker_114_predatory_web_stalking_
   
t_webstalker_103_web_harassment_ t_webstalker_115_predatory_web_stalking_
t_webstalker_104_web_stalker_ t_webstalker_116_legal_issues_stalking_
t_webstalker_105_web_stalker_ t_webstalker_117_recognizing_stalkers_
   
t_webstalker_106_types_web_stalkers_ t_webstalker_118_web_harassment_
t_webstalker_107_stalker_schizophrenia_ t_webstalker_119_stalkers_impersonation_
t_webstalker_108_obsessive_personalities_ t_webstalker_120_identity_impersonation_

 

OCP Instructors

t_ocpinstructors_121_oracle9i_external_tables_ t_ocpinstructors_133_index_usage_
t_ocpinstructors_122_organization_external_ t_ocpinstructors_134_parameters_index_
t_ocpinstructors_123_type_default_directory_ t_ocpinstructors_135_index-only_access_
   
t_ocpinstructors_124_alter_table_move_ t_ocpinstructors_136_index_rebuilds_
t_ocpinstructors_125_dbms_redefinition_ t_ocpinstructors_137_index_coalesce_rebuild_
t_ocpinstructors_126_on-line_table_ t_ocpinstructors_138_index_structure_
   
t_ocpinstructors_127_table_reorganizations_ t_ocpinstructors_139_function-based_indexes_
t_ocpinstructors_128_dbms_redefinition_ t_ocpinstructors_140_bitmap_indexes_
t_ocpinstructors_129_pctfree_pctused_ t_ocpinstructors_141_optimizer_bitmap_index_
   
t_ocpinstructors_130_clustering_data_ t_ocpinstructors_142_bitmap_indexes_
t_ocpinstructors_131_merging_tables_ t_ocpinstructors_143_bitmap_b-tree_index_
t_ocpinstructors_132_query_performance_ t_ocpinstructors_144_child_table_performance_

 

OCP Instructors

t_ocpinstructors_265_granted_privileges_ t_ocpinstructors_277_aud$_table_
t_ocpinstructors_266_granted_privileges_ t_ocpinstructors_278_database_security_
t_ocpinstructors_267_accounts_database_creation_ t_ocpinstructors_279_certification_test_
   
t_ocpinstructors_268_database_creation_ t_ocpinstructors_280_certified_associate_tests_
t_ocpinstructors_269_wrapping_programs_ t_ocpinstructors_281_introduction_oracle9isql_
t_ocpinstructors_270_remote_os_authent_ t_ocpinstructors_282_oracle_database_fundamentals_
   
t_ocpinstructors_271_security_profiles_ t_ocpinstructors_283_oracle_database_
t_ocpinstructors_272_security_profiles_ t_ocpinstructors_284_database_fundamentals_
t_ocpinstructors_273_SYS_SYSTEM_passwords_ t_ocpinstructors_285_database_fundamentals_
   
t_ocpinstructors_274_grant_any_object_ t_ocpinstructors_286_database_fundamentals_
t_ocpinstructors_275_user_auditing_ t_ocpinstructors_287_oracle_database_
t_ocpinstructors_276_audit_trail_ t_ocpinstructors_288_oracle_database_


Job Scheduling

t_jobscheduling_265_error_checking_ t_jobscheduling_277_dbms_stats_
t_jobscheduling_266_error_checking_ t_jobscheduling_278_email_notification_
t_jobscheduling_267_error_logs_ t_jobscheduling_279_utl_smtp
   
t_jobscheduling_268_error_logs_ t_jobscheduling_280_utl_mail_
t_jobscheduling_269_list_error_logs t_jobscheduling_281_running_os_scripts
t_jobscheduling_270_list_error_logs t_jobscheduling_282_os_commands_
   
t_jobscheduling_271_exception_job_ t_jobscheduling_283_os_commands_
t_jobscheduling_272_list_error_logs t_jobscheduling_284_os_commands_scripts
t_jobscheduling_273_email_notifications_ t_jobscheduling_285_host_command_
   
t_jobscheduling_274_utl_smtp_ t_jobscheduling_286_dbms_java_
t_jobscheduling_275_utl_smtp_ t_jobscheduling_287_host_command_
t_jobscheduling_276_automated_email_  


BC Oracle consulting & Training Support logo

Rampant Oracle Books and downloads

Remote DBA Oracle logo 

Copyright 2006 by Burleson Consulting (BC)