Oracle Tips

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_