Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps
                          

 

BC Oracle Tips

Also see Oracle Application Server Tips

This Oracle Tips newsletter will subscribe you to receive the latest Oracle tips, alerts and Oracle news, directly from Don Burleson and the experts at Burleson Consulting.


Please enter your e-mail address and preferred deliver method to quickly enroll in the new Oracle Tips list   -->    
Join Burleson's Oracle Tips Newsletter!
Enter your email to join Oracle Tips today!
 
HTML Text AOL

 

 

Burleson Oracle tips provides Oracle DBA tips, Oracle PL/SQL tips, Oracle tips for developers, Oracle data warehouse tips and Oracle community news and Oracle alerts.

Also, visit the Oracle Tips Archive:


 

 

EDB book excerpts:

Ingres tips

History of Postgres releases & features

EnterpriseDB history

Bizgres tips

Slony-I tips

Open-Xchange tips

Best Postgres Features tips

PL/SQL features by release

 

 

 

web stalkers:

Web Predators book

Internet Predators book - Internet predators

Internet identity theft protection

Identity theft protection book - internet identity theft

Internet Phishing scams book

Internet scams protection book - online web scams

Online fraud protection - web online internet fraud

Online libel and interference invasion of privacy

 

Consulting links:

Oracle Caribbean Consulting & Caribbean Training

Oracle database poster Oracle DBA poster  Oracle Diagram Oracle chart Oracle Reference

Oracle9i migration, Oracle9i replicationOracle Security, Oracle privacy, Oracle consulting

Migrating to Oracle, Oracle Migration, Migrating to Oracle from SQL Server, DB2 Oracle Migration,
Migrating to Oracle from DB2, Oracle Migration from SQL Server, SQL Server Oracle Migration,
Oracle Migration from DB2

Oracle Apex Developer, Oracle Apex Consultant, Oracle Apex Programmer, Oracle Apex System DeveloperOracle Apex Programming, Oracle Apex Consulting, Oracle Apex System Development, Oracle Apex Development

We have oracle emergency assistance and emergency oracle support. oracle reco emergency 1 emergency 2 emergency 3 emergency 4 emergency 5 emergency 6 emergency 7 emergency 8 emergency 9

 

fin1 fin2 fin3 fin4
fin5 fin6 fin7 fin8
fin9 fin10 fin11 fin12
fin13 fin14 fin15 fin16
fin17 fin18 fin19 fin20
fin21      
  fin22    
       
dev1      
dev2      
dev3      
dev4      

scripts1 scripts2 scripts3 scripts4 scripts5 scripts6 scripts7 scripts8 scripts9 scripts10 scripts11 scripts12
scripts13 script14 scripts15 scripts16 script17 scripts 18

oas1 text

oas1 oas2 oas3 oas4 oas5 oas6 oas7 oas8 oas9 oas10 oas11 oas12 oas13 oas14 oas15 oas16 oas17 oas18 oas19 oas20

  perf1 perf2 perf3 perf4 perf5

sec1_text

Ion Oracle proactive performance analyzer

sql1 sql2 sql3 sql4 sql5

racbook1 racbook2 racbook3 racbook4 racbook5 racbook6 racbook7 racbook8 racbook9 racbook10

rac_test

rac1 rac2 rac3 rac4 rac5 rac6 rac7 rac8 rac9 rac10 rac11 rac12 rac13 rac14

Oracle growth monitoring

Other links:

Eagle Alliance

environmental assets

Oracle Links

Remote Links

plsql tuning

oracle publishing

pl_sql tuning plsql tuning pl_sql_performance plsql_perf

plsql_support plsql_support pl_sql_cons plsql_cons

oracle links remote

10g1 10g2 10g3 10g4 10g15/a> 10g6 10g7 10g8 10g9 10g10 10g11 10g12 10g13 10g14 10g15 10g16 10g17 10g18 10g19 10g20  

oracle health check

corporate oracle training corp ora train

cbo1 cbo2 cbo3 cbo4 cbo5 cbo6 cbo7 cbo8 cbo9 cbo10 cbo11 cbo12

10g1

grid1 grid2 grid3 grid4 grid5 grid6 grid7 grid8 grid9 grid10 grid11 grid12 grid13 grid14  grid 15 grid16 grid17 grid18 grid19 grid20

JavaJob1 JavaJob2 JavaJob3 JavaJob4 JavaJob5 JavaJob6 JavaJob7 JavaJob8 JavaJob9 JavaJob10 JavaJob11 JavaJob12 JavaJob13 JavaJob14

j2ee1 j2ee2 j2ee3 j2ee4 j2ee5 j2ee6 j2ee7 j2ee8 j2ee9 j2ee10 j2ee11 j2ee12 j2ee13 j2ee14 j2ee15 j2ee16 j2ee17 j2ee18

10gNew1 10gNew2 10gNew3 10gNew4 10gNew5 10gNew6 10gNew7 10gNew8 10gNew9 10gNew10

WebDesign1 WebDesign2 WebDesign3 WebDesign4 WebDesign5 WebDesign6 WebDesign7 WebDesign8 WebDesign9 WebDesign10 WebDesign11 WebDesign12 WebDesign13 WebDesign14
WebDesign15 WebDesign16 WebDesign17 WebDesign18 WebDesign19 WebDesign20
WebDesign21 WebDesign22 WebDesign23 WebDesign24 WebDesign25

TopJob1 TopJob2 TopJob3 TopJob4 TopJob5 TopJob6 TopJob7 TopJob8 TopJob9 TopJob10
TopJob11 TopJob12 TopJob13 TopJob14 TopJob15 TopJob16

unix1 unix2 unix3 unix4 unix5 unix6 unix7 unix8 unix9 unix10

networking1 networking2 networking3 networking4 newtworking5 networking6 networking7 networking8 networking9 networking10 networking11 networking12 networking13 networking14 networking15 networking16 networking17 networking18 networking19 networking20

webmaster1 webmaster2 webmaster3 webmaster4 webmaster5 webmaster6 webmaster7 webmaster8 webmaster9 webmaster10 webmaster11 webmaster12 webmaster13 webmaster14 webmaster15
webmaster16 webmaster17 webmaster18 webmaster19 webmaster20 webmaster21 webmaster22
webmaster23

orajob1 orajob2 orajob3 orajob4 orajob5 orajob6 orajob7 orajob8 orajob9 orajob10 orajob11

oraclescripts  oraclescript  oracletuningscripts  oracletuningscript  oracleperformscripts oracleshellscripts
oraclecronscripts  oracledictscripts  oraclerecovscripts oracleunixscipts oraclebackupscript  oraclebackupscripts oraclecrontabscripts  oraclesqlscripts  oraclesqltuningscript oraclesqltuningscripts
unixoraclescript  unixoraclescripts oraclescripts2 oraclev$scripts

programming1  programming2  programming3  programming4 programming5  programming6
programming7  programming8  programming9  programming10  programming11  programming12
programming13  programming14  programming15

oracle shell scripting


Oracle 11g Grid & RAC

t_rac_grid_computing.htm t_rac_grids_clusters.htm t_rac_parallel_execution.htm
t_rac_performance_availability.htm t_rac_cluster_registry_CRSCTL_command.htm t_rac_clusterware_high_level_tools.htm
t_rac_command_line_management.htm t_rac_creating_backups.htm t_rac_database_deployment_considerations.htm
t_rac_database_enterprise_edition_new_features.htm t_rac_maximum_availability_architecture.htm t_rac_system_database_instance.htm
t_rac_wait_events.htm t_rac_statspack_awr_report_tips.htm t_rac_statspack_awr_performance.htm
t_rac_sga_sizing.htm t_rac_services_settings.htm t_rac_partitioning.htm
t_rac_one_node.htm t_rac_oem_monitoring.htm t_rac_monitoring.htm
t_rac_load_balancing.htm t_rac_linux_px.htm t_rac_jdbc.htm
t_rac_instance_affinity.htm t_rac_installation.htm t_rac_grid_documentation.htm
t_rac_ges_monitoring.htm t_rac_gcs_monitoring.htm t_rac_file_io_monitoring.htm
t_rac_extended_distance_clusters.htm t_rac_configuration_documentation.htm t_rac_components_clusterware.htm
t_rac_clusters_data_warehouse.htm t_rac_cluster_fencing.htm t_rac_cloning_hot_backup.htm
t_rac_blocking_sessions.htm t_rac_automatic_memory_management_amm.htm  

 

Oracle 10g Grid Computing with RAC
 

Cluster Architecture Grid Architecture Large Pool Streams Pool
Logical Physical Components Fixed SGA System Global Area
RAC Components High Availability Automatic Shared Memory Management
   
Automatic Storage Management Database SGA Memory Manager
Database Instance Multi-Instances Program Global Area PGA
System Global Area SGA Global Cache Service GCS Global Enqueue Service
   
SGA Database Block Buffers Global Resource Directory
Database Block Buffers Keep Default Background Processes System
Setting Block Cache Sizes Background Processes Archive Redo Logs Checkpoint
   
Multiple Block Size Job Process Advance Queuing Dispatcher Process
Blocksize Redo Log Buffers MMOM Metrics History Capture
Java Pool Shared Pool Data Dictionary RBAL Rebalance Automatic Storage Management


Oracle 10g Grid Computing with RAC

Background Process RAC Specific Processes Oracle Binaries UNDO Tablespaces
Global Cache Service Processes Raw Partitions Oracle Parallel Server OPS
Diagnosability Daemon RAC Instance Redo Threads Shared Storage
   
Global Cache Service Global Enqueue Service Redo Threads Database Logical Objects
Database Related Files Data Blocks Extents Segments
Data Files Raw Partition Nodes Tablespaces Big File Small File
   
Control Files Redo Log Files Big File Tablespace Locally managed
Archive Log Files Redo Log Tablespace Database Size
Parameter File SPFile Cluster Ready Services CRS
   
Password File Alert Log File Trace Files Cluster Ready Services Event Manager
Oracle Cluster Registry OCR CRS Cluster Manager Voting Disk
OCR Voting Disk File GCS GRS CRS IP Virtual Interface ASM



Oracle 10g Grid Computing with RAC

Cluster Private Interconnect listener.ora File Load Balancing
Cluster Private Interconnect listener.ora
RAC Database Nodes tnsnames.ora Transparent Application Failover
   
Database Nodes Server Redundancy tnsnames.ora
Server Redundancy Transparent Application Failover
Server Redundancy Shared Server Configuration
   
Dynamic Reorganization DR Server Shared Server Architecture
Predictive Failure Analyis ECC Memory Shared Server Configuration
Redundant Networking Component Shared Server Configuration
   
Hot Swap Power Hot Swap Fans Replacement Parameters
Partitions Server Network Services v$dispatcher
listener.ora File Memory Structures Background Processes


Oracle 10g Grid Computing with RAC

Preparing Shared Stoage Structures Cluster File System Automatic Storage Management
Storage Units System Layers ASM Shared Storage Structures
Physical File Structure Network File System Cluster File System
   
Shared Storage Data Files Control Files Storage Design Redundancy
Alert Log Files Redo Log Files Shared Storage Multiple Instances
Shared Stored Inputs Direct Attached Storage Network Attached Storage
   
Raw Devices Partitions Storage Disk System Just a Bunch of Disks
Raw Device Raw Partitions JBOD Direct Attached Storage
Raw Devices Data Files Network Attached Storage Storage Area Networks
   
Raw Devices Partitions Archive Logs Logical Unit Number LUN IO Path
Cluster File System IO Path Host Bus Adapter
Cluster File System Oracle Managed Files Hot Spares Hot Plug


Oracle 10g Grid Computing with RAC

Hot Swapping Multiple RAID Controllers Secure Path Dynamic MultiPathing DMP
Storage Processors Power Management Volume Management Logical Volume Manager
High Availability SAN Volume Management LVM
   
RAID Administration IO Path Host IO Cluster File System
RAID 0 RAID 1 Cluster File System Direct IO
RAID 1 RAID 4 CFS External Table Oracle Home
   
RAID 4 RAID 5 RAID 10 Context Dependent Symbolic Link
Mirrored Striped Striped Mirror Veritas CFS CDSL
RAID Levels IO Global Lock Manager GLM
   
Software RAID Hardware RAID Portability HP Tru64 CFS Direct IO
Software RAID Hardware RAID Context Dependent Symbolic Link
Multiple Access Paths Host Oracle Cluster File System OCFS


Oracle 10g Grid Computing with RAC

t_oracle10g_striping_ t_oracle10g_cluster_
t_oracle10g_storage_management_ t_oracle10g_automated_
t_oracle10g_poly_serve_ t_oracle10g_asynchronous_
   
t_oracle10g_oracle_disk_ t_oracle10g_asm_latency_
t_oracle10g_mirroring_ t_oracle10g_asm_instances_
t_oracle10g_load_balancing_ t_oracle10g_asm_instance_background_
   
t_oracle10g_io_ t_oracle10g_asm_instance_
t_oracle10g_failure_groups_ t_oracle10g_asm_disks_
t_oracle10g_disk_manager_ t_oracle10g_asm_configuration_
   
t_oracle10g_disk_groups_ t_oracle10g_asm_files
t_oracle10g_direct_io_ t_oracle10g_asm_concepts_
t_oracle10g_cluster_file_ t_oracle10g_asm_

Oracle 10g Grid Computing with RAC

t_oracle10g_volumes_ t_oracle10g_initasm_
t_oracle10g_soft_links_ t_oracle10g_file_types_
t_oracle10g_raw_devices_linux_ t_oracle10g_disk_partitions_
   
t_oracle10g_raw_devices_ t_oracle10g_disk_asm_
t_oracle10g_raw_device_bindings_ t_oracle10g_dbca_utility_
t_oracle10g_oracle_universal_ t_oracle10g_database_instance_
   
t_oracle10g_ocfstool_ t_oracle10g_control_file_
t_oracle10g_ocfs_modules_ t_oracle10g_asm_views_
t_oracle10g_ocfs_ t_oracle10g_asm_library_
   
t_oracle10g_logical_unit_ t_oracle10g_asm_lib_
t_oracle10g_logical_partitions_ t_oracle10g_asm_configuration_
t_oracle10g_libraries_  

Oracle 10g Grid Computing with RAC

t_oracle10g_313_ocfs_linux t_oracle10g_325_db_file_system_
t_oracle10g_314_PolyServe_ t_oracle10g_326_cluster_volume
t_oracle10g_315_cluster_file_ t_oracle10g_327_cluster_file_
   
t_oracle10g_316_storage_volume_ t_oracle10g_328_volume_manager_
t_oracle10g_317_storage_control_ t_oracle10g_329_cluster_volume_management_
t_oracle10g_318_san_disks_ t_oracle10g_330_nfs_file_
   
t_oracle10g_319_storage_psfs_ t_oracle10g_331_file_system
t_oracle10g_320_psfs_odm_ t_oracle10g_332_oracle_rac_
t_oracle10g_321_context_dependent_ t_oracle10g_333_shared_storage_
   
t_oracle10g_322_psfs_file_ t_oracle10g_334_clusterware_
t_oracle10g_323_polyserve_mount_ t_oracle10g_335_rac_installation_
t_oracle10g_324_db_optimized_ t_oracle10g_336_nodes_servers

Oracle 10g Grid Computing with RAC

t_oracle10g_337_private_interconnect_ t_oracle10g_349_cluster_software_
t_oracle10g_338_shared_storage_ t_oracle10g_350_clusterware_
t_oracle10g_339_oracle_database_ t_oracle10g_351_cluster_ready_
   
t_oracle10g_340_servers_ t_oracle10g_352_crs_ocr_
t_oracle10g_341_operating_systems_ t_oracle10g_353_SKGXP_Libraries_
t_oracle10g_342_rac_implementation_ t_oracle10g_354_cluster_configuration_
   
t_oracle10g_343_supported_platforms_ t_oracle10g_355_rac_database
t_oracle10g_344_cluster_interconnect_ t_oracle10g_356_kernel_parameters_
t_oracle10g_345_interconnect_ t_oracle10g_357_cluster_ready_
   
t_oracle10g_346_interconnect_types_ t_oracle10g_358_crs_database_software_
t_oracle10g_347_interconnect_nodes_ t_oracle10g_359_os_platform_
t_oracle10g_348_message_size_ t_oracle10g_360_storage_options_


Oracle 10g Grid Computing with RAC

t_oracle10g_361_cluster_ready__ t_oracle10g_373_advanced_cluster_
t_oracle10g_362_crs_installation_ t_oracle10g_374_communication_stack_
t_oracle10g_363_crs_location_page_ t_oracle10g_375_cluster_volume_
   
t_oracle10g_364_oracle_cluster_ t_oracle10g_376_vcs_framework_
t_oracle10g_365_crs_summary_page_ t_oracle10g_377_vcs_service_groups_
t_oracle10g_366_oracle_cluster_registry_ t_oracle10g_378_Hacmp_vsd_
   
t_oracle10g_367_crs_installer_ t_oracle10g_379_virtual_shared_disk_
t_oracle10g_368_crs_cluster_ready_ t_oracle10g_380_general_parallel_file_
  t_oracle10g_381_aix_cluster_environment_
   
t_oracle10g_370_crs_environment_ t_oracle10g_382_oracle_rac_software_
t_oracle10g_371_sun_cluster_ t_oracle10g_383_rac_software_
t_oracle10g_372_veritas_dbe_ t_oracle10g_384_installation_type_

Oracle 10g Grid Computing with RAC

t_oracle10g_385_database_management_ t_oracle10g_397_creation_scripts_
t_oracle10g_386_virtual_ip_ t_oracle10g_398_cluster_ready_parameters_
t_oracle10g_387_oracle_database_ t_oracle10g_399_creation_manually_
   
t_oracle10g_388_dbca_ t_oracle10g_400_database_creation_
t_oracle10g_389_rac_database_ t_oracle10g_401_scripts_
t_oracle10g_390_dbca_welcome_page_ t_oracle10g_402_instances_
   
t_oracle10g_391_dbca_database_template_ t_oracle10g_403_SYSAUX_tablespace_
t_oracle10g_392_dbca_database_storage_ t_oracle10g_404_rac_databases_
t_oracle10g_393_dbca_database_services_ t_oracle10g_405_cache_fusion_
   
t_oracle10g_394_server_parameter_ t_oracle10g_406_cache_fusion_evolution_
t_oracle10g_395_initialization_parameters_ t_oracle10g_407_cache_coherency_
  t_oracle10g_408_global_cache_

Oracle 10g Grid Computing with RAC

t_oracle10g_409_cache_fusion_ t_oracle10g_421_rac_components_
t_oracle10g_410_concurrency_  
t_oracle10g_411_cache_coherency_ t_oracle10g_423_enqueues_locks
   
t_oracle10g_412_global_cache_ t_oracle10g_424_table_locks
t_oracle10g_413_system_global_ t_oracle10g_425_row-level_locks_
t_oracle10g_414_shared_pool_ t_oracle10g_426_global_resource_
   
t_oracle10g_415_large_pool_ t_oracle10g_427_rac_processes_
t_oracle10g_416_database_buffer_ t_oracle10g_428_lock_manager_
t_oracle10g_417_buffer_cache_ t_oracle10g_429_resource_coordination_
   
t_oracle10g_418_dirty_block_ t_oracle10g_430_synchronization_
t_oracle10g_419_process_architecture_ t_oracle10g_431_gcs_resources_
t_oracle10g_420_locking_mechanism_ t_oracle10g_432_past_image_

Oracle 10g Grid Computing with RAC

t_oracle10g_433_lock_modes_ t_oracle10g_445_recovery_
t_oracle10g_434_block_access_ t_oracle10g_446_recovery_methodology_
t_oracle10g_435_buffer_states_ t_oracle10g_447_online_instance_
   
t_oracle10g_436_cache_fusion_ t_oracle10g_448_lock_remastering
t_oracle10g_437_cache_fusion_scenarios_ t_oracle10g_449_remastering_
t_oracle10g_438_gcs_processing_ t_oracle10g_450_recovery_process_
   
t_oracle10g_439_cache_fusion_  
t_oracle10g_440_block_transfers_ t_oracle10g_452_resource_coordination_
t_oracle10g_441_block_transfers_ t_oracle10g_453_data_concurrency_
   
t_oracle10g_442_lock_conversions_ t_oracle10g_454_rac_administration_
t_oracle10g_443_block_access_ t_oracle10g_455_parameter_management_
t_oracle10g_444_grants_interrupts_ t_oracle10g_456_initialization_parameters_

Oracle 10g Grid Computing with RAC

t_oracle10g_457_initialization_parameters_ t_oracle10g_469_server_parameter_
t_oracle10g_458_identical_parameters_ t_oracle10g_470_parameter_file_values_
t_oracle10g_459_parameters_instances_  
   
t_oracle10g_460_instances_ t_oracle10g_472_exporting_server_parameter_
t_oracle10g_461_unique_parameters_ t_oracle10g_473_undo_management_
  t_oracle10g_474_rollback_segments_
   
t_oracle10g_463_parameters_instances_ t_oracle10g_475_automatic_undo_
t_oracle10g_464_parameters_instances_ t_oracle10g_476_undo_tablespace_
t_oracle10g_465_asm_related_parameters_ t_oracle10g_477_undo_management_
   
t_oracle10g_466_initialization_parameters_ t_oracle10g_478_initialization_parameters_
t_oracle10g_467_asm_instances_ t_oracle10g_479_undo_parameters_
t_oracle10g_468_client_side_ t_oracle10g_480_undo_tablespace_

Oracle 10g Grid Computing with RAC

t_oracle10g_481_undo_tablespace_ t_oracle10g_493_dba_tablespaces_
t_oracle10g_482_dynamic_performance_ t_oracle10g_494_dbms_spaces_
t_oracle10g_483_system_rollback_ t_oracle10g_495_segment_space_
   
t_oracle10g_484_public_rollback_ t_oracle10g_496_segment_space_
t_oracle10g_485_redo_log_threads_ t_oracle10g_497_manual_segment_
t_oracle10g_486_redo_groups_ t_oracle10g_498_free_lists_
   
t_oracle10g_487_redo_log_ t_oracle10g_499_storage_parameters_
t_oracle10g_488_log_thread_ t_oracle10g_500_instances_free_list_
t_oracle10g_489_alter_database_ t_oracle10g_501_oracle_managed_files_
   
t_oracle10g_490_performance_views_ t_oracle10g_502_managed_files_
  t_oracle10g_503_db_create_
t_oracle10g_492_automatic_segment_ t_oracle10g_504_oracle_disk_manager_

Oracle 10g Grid Computing with RAC

t_oracle10g_505_oracle_disk_manager_ t_oracle10g_517_server_control_
t_oracle10g_506_server_control_ t_oracle10g_518_oracle_interface_
t_oracle10g_507_cluster_database_ t_oracle10g_519_network_interfaces_
   
t_oracle10g_508_server_control_ t_oracle10g_520_global_interface_
t_oracle10g_509_utility_verbs_  
t_oracle10g_510_utility_nouns_ t_oracle10g_522_syntax_getif_
   
t_oracle10g_511_utility_commands_ t_oracle10g_523_syntax_delif_
t_oracle10g_512_configured_databases_ t_oracle10g_524_oracle_cluster_
t_oracle10g_513_environment_variables_ t_oracle10g_525_backup_files_
   
t_oracle10g_514_srvctl_instances_ t_oracle10g_526_cluster_registry_
t_oracle10g_515_srvctl_start_ t_oracle10g_527_restoring_registry_
t_oracle10g_516_srvctl_stop_ t_oracle10g_528_cluster_registry_

Oracle 10g Grid Computing with RAC

t_oracle10g_529_importing_cluster_registry_ t_oracle10g_541_automated_storage_
t_oracle10g_530_ocrconfig_tool_ t_oracle10g_542_asm_instances_
t_oracle10g_531_Oracle_hardware_ t_oracle10g_543_srvctl_
   
t_oracle10g_532_hardware_assistant_ t_oracle10g_544_enterprise_manager_
t_oracle10g_533_HARD_initiative_ t_oracle10g_545_oem_tool_
t_oracle10g_534_HARD_test_kit t_oracle10g_546_oem_tool_
   
t_oracle10g_535_HARD_test_kit_ t_oracle10g_547_lsnodes_
t_oracle10g_536_HARD_validated_products_ t_oracle10g_548_local_listener_
t_oracle10g_537_ocr_configuration_ t_oracle10g_549_tnsnames.ora_
   
t_oracle10g_538_srvconfig_  
t_oracle10g_539_SQL_Plus_ t_oracle10g_551_sql_plus_
t_oracle10g_540_cluster_mode_ t_oracle10g_552_enterprise_manager_

Oracle 10g Grid Computing with RAC

t_oracle10g_553_enterprise_manager_ t_oracle10g_562_grid_cluster_
t_oracle10g_554_parameter_management_ t_oracle10g_563_cache_coherency_
t_oracle10g_555_oifcfg_ocrconfig_ t_oracle10g_564_metrics_
   
t_oracle10g_556_oracle_grid_control_ t_oracle10g_565_global_cache_
t_oracle10g_557_grid_control_ t_oracle10g_566_target_groups_
t_oracle10g_558_grid_control_server_ t_oracle10g_567_target_groups_
   
  t_oracle10g_568_rac_related_jobs_
t_oracle10g_560_preferred_credentials_ t_oracle10g_569_grid_control_
t_oracle10g_561_top_level_enterprise_  

Programmer Job Interview

t_programmer_242_command_slice_ t_programmer_254_openboot_prompt_
t_programmer_243_command_display_ t_programmer_255_single_user_mode_
t_programmer_244_mounted_file_ t_programmer_256_command_display_
   
t_programmer_245_file_settings_ t_programmer_257_list_irq_
t_programmer_246_command_options_ t_programmer_258_data_modeling_
t_programmer_247_default_file_ t_programmer_259_relational_databases_
   
t_programmer_248_access_control_list_ t_programmer_260_erd_
t_programmer_249_security_context_ t_programmer_261_recursive_relationships_
t_programmer_250_file_default_ t_programmer_262_hard_one-to-one_
   
t_programmer_251_file_system_errors_ t_programmer_263_many-to-many_
t_programmer_252_bin_directories_ t_programmer_264_derived_primary_key_
t_programmer_253_master_kernel_ t_programmer_265_denormalization_


Programmer Job Interview

t_programmer_266_compiler_directive_ t_programmer_278_function_prototype_
t_programmer_267_compiler_directive_ t_programmer_279_c_library_
t_programmer_268_compiler_directive_ t_programmer_280_c_programming_
   
t_programmer_269_if_block_code_ t_programmer_281_five_element_
t_programmer_270_markers_comments_ t_programmer_282_variable_memory_
t_programmer_271_symbol_identifier_ t_programmer_283_memory_address_
   
t_programmer_272_symbol_end_statement_ t_programmer_284_c_programming_code_
t_programmer_273_block_ t_programmer_285_malloc_function_
  t_programmer_286_Typedef_names_
   
t_programmer_275_void_main_ t_programmer_287_mmap_sizeof_function
t_programmer_276_function_name_ t_programmer_288_Language-Adaptable_Header_Files
t_programmer_277_constant_variable_ t_programmer_289_Idempotent_Header_Files


Oracle 10g Grid Computing with RAC

t_oracle10g_1_rac_migration_ t_oracle10g_13_instances_nodes_
t_oracle10g_2_rac_migration_ t_oracle10g_14_automated_conversion_
t_oracle10g_3_migration_methodology_ t_oracle10g_15_manual_conversion_
   
t_oracle10g_4_single_instance_ t_oracle10g_16_conversion_single_instance_
t_oracle10g_5_converting_single_instance_ t_oracle10g_17_single_instance_cluster_
t_oracle10g_6_database_creation_ t_oracle10g_18_HA_Cluster_RAC_Cluster_
   
t_oracle10g_7_single_instance_cluster_ t_oracle10g_19_oracle_disk_manager_
t_oracle10g_8_extending_clusterware_ t_oracle10g_20_sap_software_
t_oracle10g_9_clusterware_layer_ t_oracle10g_21_oracle_ebusiness_suite_
   
t_oracle10g_10_oracle_home_ t_oracle10g_22_virtual_ip_
  t_oracle10g_23_virtual_ip_
t_oracle10g_12_oracle_home_nodes_ t_oracle10g_24_virtual_ip_

Programmer Job Interview

t_programmer_290_comment_line_ t_programmer_302_decrement_operator_
t_programmer_291_comment_slash_star_ t_programmer_303_increment_decrement_operators_
t_programmer_292_case_sensitive_ t_programmer_304_statement_
   
t_programmer_293_whitespace_ t_programmer_305_nested_parentheses_
t_programmer_294_expression_ t_programmer_306_relational_operators_
t_programmer_295_constants_l_values_ t_programmer_307_logical_operators_
   
t_programmer_296_assignment_operator_ t_programmer_308_ternary_operator_
t_programmer_297_constants_ t_programmer_309_direct_recursion_
t_programmer_298_modulus_operator_ t_programmer_310_c++_classes_
   
t_programmer_299_semicolon_statement_ t_programmer_311_virtual_copy_constructor_
t_programmer_300_expression_ t_programmer_312_php_scripting_
t_programmer_301_increment_operator_  


Programmer Job Interview

t_programmer_313_php_scripting_html_ t_programmer_325_n12br_function_
t_programmer_314_print_statement_ t_programmer_326_integer_time_function_
t_programmer_315_post_get_method_ t_programmer_327_post_superglobal_
   
t_programmer_316_array_function_ t_programmer_328_cookie_
t_programmer_317_simple_array_ t_programmer_329_non-technical_
t_programmer_318_values_array_ t_programmer_330_non-technical_overtime_
   
t_programmer_319_php_tags_ t_programmer_331_non-technical_flaw_
t_programmer_320_standard_data_types_ t_programmer_332_non-technical_least_boss_
t_programmer_321_declare_variables_ t_programmer_333_non-technical_future_plans_
   
t_programmer_322_dot_operator_ t_programmer_334_non-technical_vegetable_
t_programmer_323_counted_loops_ t_programmer_335_non-technical_money_
t_programmer_324_type_specifiers_ t_programmer_336_non-technical_leave_job_

Programmer Job Interview

t_programmer_337_non-technical_description_ t_programmer_349_non-technical_future_career_goals_
t_programmer_338_non-technical_job_location_ t_programmer_350_non-technical_hobbies_
t_programmer_339_non-technical_company_history_ t_programmer_351_non-technical_job_motivation_
   
  t_programmer_352_non-technical_job_importance_
t_programmer_341_non-technical_new_job_ t_programmer_353_non-technical_qualities_success_
t_programmer_342_non-technical_self_background_ t_programmer_354_non-technical_work_experience_
   
t_programmer_343_non-technical_characteristics_ t_programmer_355_non-technical_success_definition_
t_programmer_344_non-technical_ideal_job_  
t_programmer_345_non-technical_tough_customer_ t_programmer_357_non-technical_failure_
   
t_programmer_346_non-technical_co-worker_ t_programmer_358_non-technical_leadership_roles_
t_programmer_347_non-technical_availability_ t_programmer_359_non-technical_travel_
t_programmer_348_non-technical_career_goals_ t_programmer_360_non-technical_improvements_


Oracle Data Guard

**********************

Data Guard Install Tips  
Data Guard Architecture Tips  
oracledataguard_9_standby_database_  
t_oracledataguard_3_failover_  
oracledataguard_5_oracle_licensing_  
oracledataguard_25_physical_standby_  
t_oracledataguard_13_logical_standby_  
oracledataguard_20_load_balancing_  
oracledataguard_22_force_logging_  
oracledataguard_18_disaster_recovery_  
oracledataguard_37_archive_gap_sequence  
oracledataguard_29_log_transport_  
oracledataguard_33_apply_modes_  
oracledataguard_35_log_miner_  
oracledataguard_39_data_guard_broker  
oracledataguard_42_server_side_broker_  
oracledataguard_43_client_side_broker  
   
   
t_oracledataguard_56_hot_cold_backup_  
t_oracledataguard_57_backup_primary_database_  
   
t_oracledataguard_58_initialization_parameter_  
t_oracledataguard_59_cache_io_  
t_oracledataguard_60_control_file_  
t_oracledataguard_61_network_registration_pools_  
t_oracledataguard_62_initialization_parameter_  
t_oracledataguard_63_log_archive_trace_  
   
t_oracledataguard_64_log_archive_trace_  
t_oracledataguard_65_fal_server_  
t_oracledataguard_66_oracle_net_  
   
t_oracledataguard_67_tnsnames.ora_  
t_oracledataguard_68_host_port_sid_  
t_oracledataguard_69_standby_database_  
   
t_oracledataguard_70_physical_standby_database_  
t_oracledataguard_71_archive_log_destination_  
t_oracledataguard_72_recover_managed_  
Data Guard Managed Recovery Tips  
v$dataguard_status script  
v$managed_standby Tips  
v$archive_log tips  
Data Guard parameters Tips  
Data Guard tnsnames and listsner.ora Tips  
Starting a standby database tips  
Create a Logical Standby Database Tips  
Oracle Dataguard  
dba_logstdby_unsupported script  
Rely constraint tips  
dba_logstdby_not_unique Tips  
LogMiner tablespace tips  
   
   
   
   
   

Oracle Dataguard

Creating a Logical Standby Database

Create LogMiner directory tips

Modifying the Initialization Parameter File

Configure Oracle Net on the Standby Site

Data Guard Redo Log Apply Services tips

Change the dbname of a Logical Standby Database

How to turn on Data Guard

dba_logstdby_log tips

dba_logstdby_progress tips

dba_logstdby_progress tips

Data Guard Symmetrical initialization files Tips

Data Guard listener.ora file tips

tnsnames.ora for Data Guard Standby Database

Open Data Guard standby in read-only mode

Manual Recovery of Data Guard Standby Database

Physical Standby Database monitoring Tips

Monitor recovery of a Data Guard standby database

 

Propagating Unrecoverable Operations to Standby Databases

Physical Standby Time Lag Tips

Fix Archive Gap Sequence on Physical Standby Databases

DBA Tips for Logical Standby Databases

Starting & stopping the Data Guard logical standby apply Service

Data Guard v$logstdby & v$dataguard_status Tips

Data Guard v$logstdby & v$dataguard_status Tips

Monitoring the Data Guard SQL apply

Data Guard Log apply service scripts

Data Guard Schema Object tips

DDL for Data Guard Tips

Instantiate a Data Guard table

dbms_logstdby.skip Tips

dbms_logstdby.unskip Tips

Logical Standby Databases Time Lag Tips

Logical standby archive log gap tips

Data Guard physical cascaded standby databases

logical cascaded standby databases

Data Guard Log Management Tips

Start Logical Oracle instance apply tips

Data Guard log management policy tips

Data Guard Redo Log Reuse Tips`

Data Guard Redo Log retry Tips

Data Guard Redo Log retry Tips

Data Guard standby redo log management

remote_archive_enable Tips

Data Guard Redo Log Tranport/copy Tips

v$archive_dest Tips

Data Guard instance Protection Modes

Data Guard protection mode Tips

Data Guard Rapid Protection Mode Tips

Data Guard maximum protection mode

Data Guard Maximum Availability Mode Tips

Data Guard Maximum Performance Tips

 

Data Guard Switchover and Failover Tips

Data Guard Role Transition Tips

Switchover Failover Graceful Forced Data Guard

Data Guard forced failover Tips

Data Guard switchover Tips

 

Prepare primary database for switchover

 

Data Guard Force Logging Tips

Data Guard Failover to physical standby Tips

Data Guard failover to logical standby Tips

Data Guard Role transition Tips

Data Guard Performance Tuning Tips

Monitoring Data Guard Performance Tips

Tuning Data Guard Log Transfer

Data Guard sample physical standby example

Data Guard optimal network bandwidth Tips

Monitor Data Guard I/O

Tuning Data Guard Log Apply Service

 

Data Guard Log Apply Statistics

Data Guard High SCN

Tuning SQL Apply Tips

Fast Performance Data Guard Tips

Data Guard Broker Tips

Data Guard Broker States & Properties

Data Guard Broker DMON Process

DGMGRL Command Tips

Data Guard Configuration Tips

Data Guard Configuration attributes

DGMGRL configuration resource command Tips

Data Guard alter resource database set state commands

Data Guard Broker switchover Tips

Data Guard Data Program protection mode Tips

Data Guard RMAN Tips

RMAN channel Tips

RMAN auxiliary database command Tips

Create Data Guard Physical Standby with RMAN

RMAN target database command

RMAN auxiliary database command Tips

RMAN channel paramater Tips

automatic channel allocation Tips

RMAN allocate channel Tips

RMAN backup set Tips

image copy command Tips

set newname command Tips

configure auxname Tips

RMAN dorecover command Tips

RMAN nofilenamecheck Tips

 

RMAN - duplicate target database for standby dorecover

Backup of Oracle instance Using RMAN

Oracle10g New Features Data Guard Data Guard Enhancements grid computing model

Data Guard Real Time Apply Tips

Oracle Data Guard Encryption

Data Guard sp_name Tips

Data Guard creation of logical standby Tips

add Standby logfile group tips

Data Guard Create Configuration Command Tips

Data Guard enable/edit database/configuration commands

alter database add supplemental log data

Data Guard remove/create configuration Tips

Data standby redo logs Tips

Data Guard Flashback database Tips

Data Guard supports CLOB LONG RAW IOT

log_archive_dest valid_for Tips

Secure Redo Data Transmission Tips

 

 

 


 

Oracle automatic performance diagnosis
automatic performance tuning
Oracle automatic SQL tuning
Oracle 10g ASM, ADDM , AWR, ASSM.
Oracle10g automation for Oracle 10g
Oracle10g Automatic storage management book
oracle automatic database management
 

Oracle 9i migration


Oracle tuning

Oracle disaster recovery


t_ault_1_installing_ofa_tablespaces t_ault_10_rac_relinking_sga
t_ault_11_runinstaller_relink_deinstall t_ault_16_administration_dba_scripts
t_ault_18_clause_minextents_maxextent t_ault_25_dbms_sql_alter
   
t_ault_27_lgwr_maxlogmembers_maxlogfiles t_ault_30_filespec_tempfile_archivelog
t_ault_32_pseudocolumn_dbms_rowid t_ault_37_table_columns_constraints
t_ault_41_dblink_scalar_lob t_ault_45_oid_unref_authid
   
t_ault_49_leaf_nodes_branches t_ault_53_subpartition_cascade_validate
t_ault_57_synonyms_sql_compliant t_ault_61_tablespace_pctfree_pctused
t_ault_65_dba_trigger_multitude t_ault_69_alteration_package_body
   
t_ault_73_dba_alter_user_privilege t_ault_77_create_role_appuser
t_ault_81_triggers_dml_ddl_row t_ault_85_lob_columns_cluster
t_ault_89_indextype_udt_opstatus t_ault_93_maxbytes_maxblocks_table
   
t_ault_97_script_format_heading t_ault_101_procedurized_bmc_galinux
t_ault_105_mts_sga_cache t_ault_109_lgwr_utlestat_lru
t_ault_113_dba_tab_columns t_ault_117_rac_sqlnet_net8
   
t_ault_121_tcpip_tnsping_database t_ault_125_db2_convoy_hashing
t_ault_129_shell_script_archivelog

Oracle Wait Event Tuning

t_andert_13_raw_pid_lid t_andert_14_MOSC_sql_prscnt
t_andert_15_tkprof_MOSC_sql t_andert_16_hotsos_cpu_portal
t_andert_17_mts_tkprof_trace t_andert_18_rbo_cbo_dba
   
t_andert_19_sql_net_tuning t_andert_20_pid_sar_ram
t_andert_21_null_event_MOSC t_andert_22_column_format_head
t_andert_23_userid_miguelma_sid t_andert_24_raid_phyrds_phywrts

Easy Oracle SQL

t_garmany_7_stor_dba_sum t_garmany_8_initcap_column_heading
t_garmany_9_sql_cross_join t_garmany_10_ansi_code_values
t_garmany_11_emp_table_column t_garmany_12_ansi_sql_dos
   
t_garmany_easysql_basic_sqls t_garmany_easysql_data_relationships_ERD_XE
t_garmany_easysql_entities t_garmany_easysql_entity_relation_modeling
t_garmany_easysql_normalizing_data t_garmany_easysql_btree_index
   
t_garmany_easysql_bitmapped_index t_garmany_easysql_function_based_indexes_fbi
t_garmany_easysql_creating_indexes t_garmany_easysql_indexing_foreign_keys

You're fired!

t_papaj_19_tax_personnel_files t_papaj_20_intimidating_work_environment
t_papaj_21_subpoenaed_osha_eeoc t_papaj_22_fmla_irca_erisa
t_papaj_23_adea_fy2002_judgement t_papaj_24_wrongful_termination_suit
t_papaj_25_fmla_irca_case t_papaj_26_sox_ceo_cfo
   
   
t_papaj_violence_in_the_workplace t_papaj_plan_ahead_terminating_IT_personnel
t_papaj_sensitive_firing_terminating_IT_employees t_papaj_IT_staff_trigger_points
t_papaj_confrontations_IT_professionals t_papaj_security_present_firing_IT_employee
   
t_papaj_workplace_weapons_firearms_prohibiting t_papaj_self_esteem_fired_employees
t_papaj_anger_management_computer_professionals t_papaj_computer_professional_angry_co_workers.htm
t_papaj_IT_managers_conflict_management t_papaj_dealing_with_conflicts
   
t_papaj_crisis_management t_papaj_workplace_threats_and_violence_policy
t_papaj_company_hotline_company_security  
   

Easy HTML-DB
 
 
t_easy_html_db_form_wizards t_easy_html_db_form_wizard_automatic_row_fetch
t_easy_html_db_examining_buttons t_easy_html_db_automatic_row_fetch
t_easy_html_db_automatic_row_processing_dml.htm t_easy_html_db_adding_page_item_to_form
   
t_easy_html_db_controlling_form_layout_colspan t_easy_html_db_building_tabular_forms
t_easy_html_db_tabular_form_wizard t_easy_html_db_tabular_form_column_row.htm
t_easy_html_db_creating_a_master_detail_form.htm t_easy_html_db_creating_a_form_on_table_with_report
t_easy_html_db_creating_a_form_for_email t_easy_html_db_storing_files_in_html_db
t_easy_html_db_loading_and_displaying_images t_easy_html_db_image_upload_application_page
t_easy_html_db_file_browse_item.htm t_easy_html_db_pl_sql_procedure_diplay_image
t_easy_html_db_display_image_html_expression t_easy_html_db_uploading_downloading_documents
t_easy_html_db_creating_report_to_display_documents t_easy_html_db_checkboxes
t_easy_html_db_form_checkboxes_tabular_forms t_easy_html_db_util.htm
t_easy_html_db_custom_auth t_easy_html_db_mail
t_easy_html_db_item t_easy_html_db_application
t_easy_html_db_collection t_easy_html_db_owa_cookie
t_easy_html_db_owa_util


Easy Oracle PHP
 

t_gogala_easyphp_hypertext_preprocessor t_gogala_easyphp_basics
t_gogala_easyphp_datatypes t_gogala_easyphp_strings
t_gogala_easyphp_arrays t_gogala_easyphp_statements
t_gogala_easyphp_loops t_gogala_easyphp_foreach
t_gogala_easyphp_loop_control t_gogala_easyphp_functions
t_gogala_easyphp_super_globals t_gogala_easyphp_$_request
t_gogala_easyphp_$_session t_gogala_easyphp_includes
t_gogala_easyphp_useful_functions t_gogala_easyphp_array_explode
t_gogala_easyphp_tour_code t_gogala_easyphp_csr2html
t_gogala_easyphp_pear_install t_gogala_easyphp_missing_features
t_gogala_easyphp_php5_apache_pear t_gogala_easyphp_apache_linux
t_gogala_easyphp_php5_linux t_gogala_easyphp_pear_modules
t_gogala_easyphp_apache2


Easy Oracle Automation
 

t_easyauto_grid_computing_initiatives.htm t_easyauto_changes_memory_structures.htm
t_gogala_easyphp_datatypes t_gogala_easyphp_strings
t_gogala_easyphp_arrays t_gogala_easyphp_statements
   

Oracle RAC & Grid Tuning
 
t_oraclerac_ssd t_oraclerac_data_caching t_oraclerac_tuning_tool
t_oraclerac_ram_speed t_oraclerac_data_buffering t_oraclerac_ram_data_buffering
t_oraclerac_io_slow t_oraclerac_ram_caches t_oraclerac_improving_io_speed
t_oraclerac_finding_baselines t_oraclerac_rac_ssd t_oraclerac_ssd_findings
t_oraclerac_moving_to_ssd t_oraclerac_look_into_future t_oraclerac_current_architectures
t_oraclerac_tpc-h_benchmark t_oraclerac_diskless_database

Oracle Solid Disk Tuning

t_ssd.htm t_ssd_data_caching
t_ssd_tuning_tool t_ssd_ram_access
t_ssd_ram_data_buffers t_ssd_io_speed
   
t_ssd_scenarios.htm t_ssd_scsi_ata_scenarios.htm
   

Personal Oracle RAC Clusters
 
t_pc_rac_hardware t_pc_rac_disks
t_pc_rac_fedora t_pc_rac_nodes
t_pc_rac_software t_pc_rac_hard_disks
t_pc_rac_standard t_pc_rac_permissions
t_pc_rac_vi t_pc_rac_gedit
t_pc_rac_gunzip t_pc_rac_requirements
t_pc_rac_groups t_pc_rac_variables
_pc_rac_external_drive t_pc_rac_file_system
t_pc_rac_ocfs_software t_pc_rac_ocfs_partition
t_pc_rac_prework t_pc_rac_cluster_manager
t_pc_rac_database_software t_pc_rac_oraenv
t_pc_rac_listener t_pc_rac_basic_database
t_pc_rac_ofa t_pc_rac_raw
t_pc_rac_gsd t_pc_rac_vip
t_pc_rac_ocfs t_pc_rac_asm
   
t_pc_rac_database_asm t_pc_rac_clusterware
t_pc_rac_shared_object t_pc_rac_cluster_ready
t_pc_rac_db_software t_pc_rac_asmcmd
   
t_pc_rac_image t_pc_rac_run_level
t_pc_rac_initial_setup t_pc_rac_release_instructions
t_pc_rac_database_services  
   
Monitoring and Tuning PL/SQL
t_plsql_monitoring t_plsql_dbms_profiler
t_plsql_trace_explain t_plsql_tuning_tips
t_plsql_tuning t_plsql_rowid_iud
   
t_pls_integer_vs_number t_plsql_temporary_tables
t_plsql_tables t_plsql_bulk_binds
t_plsql_nocopy t_plsql_hash_area
t_plsql_native_compilation

Oracle Tuning: The Definitive Reference (Excerpts from Oracle9i High Performance tuning with STATSPACK)
 
t_tuning_server_tuning t_tuning_instance_tuning
t_tuning_statspack_architecture t_tuning_resource_planning
t_tuning_missing_statspack t_tuning_stats$parameter_table
t_tuning_vmstat t_tuning_cpu_usage_vmstat
t_tuning_db_system_relationship t_tuning_load_balancing
t_tuning_execution_priority t_tuning_server_memory
t_tuning_server_statistics t_tuning_trend_reports
t_tuning_odbc_network t_tuning_disk_hot_spots
t_tuning_disk_architectures t_tuning_using_raid
Installation of Oracle (Excerpts from Oracle 10g Grid & Real Application Clusters)
t_grid_rac_disk_usage t_grid_rac_disk_striping
t_grid_rac_disk_tape t_grid_rac_process_global_area
t_grid_rac_archive_log_files t_grid_rac_dba_user_account
t_grid_rac_disk_layout t_grid_rac_sga_issues
t_grid_rac_responsibilites t_grid_rac_rollback_segments
t_grid_rac_installing_oracle9i t_grid_rac_rdbms_language
t_grid_rac_events_in_Oracle t_grid_rac_relational_tables
t_grid_rac_admin_object_tables t_grid_rac_object_types
t_grid_rac_conversion_7_9 t_grid_rac_index_only_table
t_grid_rac_admin_indexes t_grid_rac_procedures_functions
t_grid_rac_dimension_objects t_grid_rac_outline_objects
t_grid_rac_ddl_dml_locks t_grid_rac_operator_objects
t_grid_rac_table_columns t_grid_rac_cluster_storage_stats
t_grid_rac_monitoring_types t_grid_rac_monitoring_operators
t_grid_rac_monitoring_outlines t_grid_rac_monitoring_users_db
t_grid_rac_user_roles t_grid_rac_column_grants
t_grid_rac_v$_tablespaces t_grid_rac_directories_libraries
t_grid_rac_db_initial_parameters t_grid_rac_db_locks_latches

SQL Design Patterns
 
t_sql_patterns_design t_sql_patterns_counting
t_sql_patterns_cond_summation t_sql_patterns_indicator
t_sql_patterns_case_operator t_sql_patterns_summarizing
t_sql_patterns_interval_coalesce t_sql_patterns_integer_generators
t_sql_patterns_table_function t_sql_patterns_string_decomposition
t_sql_patterns_enumerating_integers t_sql_patterns_exotic_products
t_sql_patterns_product t_sql_patterns_pivot
t_sql_patterns_symmetric_diff t_sql_patterns_histograms
t_sql_patterns_logarithmic_buckets t_sql_patterns_relational_division
t_sql_patterns_constraints t_sql_patterns_materialized_view
t_sql_patterns_disjoint_sets t_sql_patterns_temporal
t_sql_patterns_trees t_sql_patterns_nested_sets
   
t_sql_patterns_matrix_encoding t_sql_patterns_nested_intervals
t_sql_patterns_ancestors_query t_sql_patterns_ordering
t_sql_patterns_reversed_nesting t_sql_patterns_graphs
   
t_sql_patterns_transitive_closure t_sql_patterns_recursive
t_sql_patterns_incremental_eval t_sql_patterns_hierarchical
t_sql_patterns_baskets  
Oracle on VMware
tp_vmware_virtualization tp_vmware_abstraction tp_vmware_ramifications
tp_vmware_architecture tp_vmware_bios_basics tp_vmware_customization
tp_vmware_complexities tp_vmware_guest_tuning tp_vmware_hardware
     
tp_vmware_virtualization_support tp_vmware_host_os_install tp_vmware_incremental_host
tp_vmware_optimizing_linux tp_vmware_tuning_linux tp_vmware_optimizing_windows
tp_vmware_tuning_windows tp_vmware_virtual_impacts tp_vmware_vm_creation
     
tp_vmare_app_development tp_vmare_benchmarking tp_vmare_benchmarking_bites
tp_vmare_content_delivery tp_vmare_host_setting tp_vmare_client_operating_system
tp_vmare_host_settings tp_vmare_operating_sys tp_vmare_interesting_possibilities
     
tp_vmare_oracle_10g_install tp_vmare_oracle_11g tp_vmare_perform_comparison
tp_vmare_rac_database tp_vmare_software_install tp_vmare_selecting_benchmarks
tp_vmare_software_installation tp_vmare_tools_warning_sign tp_vmare_true_rac_preparation
     
tp_vmare_true_rac_setup tp_vmare_tuning_thoughts tp_vmare_two_approaches
tp_vmare_virtual_machine tp_vmare_virtual_wrinkles  
     
Oracle 11g New Features
t_11g_new_interface_logminer t_11g_new_system_parameters t_11g_new_text_management
t_11g_new_baseline_plan t_11g_new_capture_workload t_11g_new_evaluation_workflow
t_11g_new_management_works t_11g_new_plan_baselines t_11g_new_workload_replay
     
t_11g_new_performance_analyzer t_11g_new_snapshot_database t_11g_new_workload_analysis
t_11g_new_sql_plan_management t_11g_new_automatic_sql_tuning t_11g_new_manual_plan_load
t_11g_new_flashback_interface t_11g_new_flashback t_11g_new_transaction_backup
     
t_11g_new_flashback_database t_11g_new_flashback_compensating t_11g_new_fdba
t_11g_new_enabling_fdba t_11g_new_ddl_limitations t_11g_new_in_flashback
     
t_11g_new_data_table_compression t_11g_new_enable_direct_nfs t_11g_new_enhanced_ilm
t_11g_new_virtual_column t_11g_new_index_features t_11g_new_nfs_performance
t_11g_new_reference_partitioning t_11g_new_system_partitioning t_11g_new_table_compression
     
t_11g_new_about_drcp t_11g_new_override_client_cache t_11g_new_viewing_client_cache
t_11g_new_database_resident t_11g_new_enabling_drcp t_11g_new_oci_client_cache
t_11g_new_ADRCI_IPS t_11g_new_binary_xlm_storage t_11g_new_ips
     
t_11g_new_enterprise_manager_ips t_11g_new_logical_packages t_11g_new_asm_attributes
t_11g_new_asm_disk_repair t_11g_new_asm_enhancements t_11g_new_asm_fast_mirror
t_11g_new_asm_fast_rebalance t_11g_new_resetting_cssd t_11g_new_asmcmd_new_features
     
t_11g_new_sysasm_role t_11g_new_acls_plsql t_11g_new_auditing_default
t_11g_new_data_encryption t_11g_new_log_miner t_11g_new_transparent_tablespace
     
t_11g_new_case_sensitive t_11g_new_complex_passwords t_11g_new_hacking_prevention
t_11g_new_password_symbols t_11g_new_secure_file_lobs t_11g_new_shared_io_pool
t_11g_new_data_guard t_11g_new_rolling_upgrades  
     
t_11g_new_snapshot_standby t_11g_new_streams_topology t_11g_new_view_topology_streams
t_11g_new_subprogram_inlining t_11g_new_automatic_diagnostic t_11g_new_trigger_enhancements
t_11g_new_result_cache t_object_basic_data_types t_object_abstract_data_types
     
Object Oriented Technology (An Overview of Oracle 8)
t_object_technology t_object_oriented_technology t_object_database_terminology
t_object_classes t_object_encapsulation_abstract t_object_inheritance_polymorphism
t_object_current_state t_object_oriented_approach t_object_relational_database
     
t_object_database_management t_object_indexed_sequential t_object_hierarchical_database
t_object_database_model t_object_odmg t_object_analysis_design
t_object_systems_analysis t_object_oriented_analysis t_object_oriented_analysis_models
     
t_object_creating_model t_object_dynamic_functional_model t_object_top_down_bottom_up
t_object_chen_diagram t_object_data_representation t_object_request_brokers
t_object_database_standards t_object_database_mgmnt_group t_object_hierarchy_data_types
     
t_object_abstract_data_types t_object_basic_data_types t_object_user_defined
t_object_relational_data_types t_object_relational_data_pointers t_object_pointers_whole_table
t_object_multi_dimensional_pointers t_object_implications_of_pointers t_object_inheritance_structures
     
t_object_methods_database t_object_methods_hierarchy t_object_functional_specifications
t_object_method_prototypes t_object_method_generation t_object_sql_relational_databases
t_object_sql_databases t_object_sql_encapsulation t_object_sql_pointers
     
t_object_speech_recognition t_object_technology_future t_object_interfacing_C++
t_object_problem_pointers t_object_array_pointers t_object_writing_object
Advanced Oracle SQL Programming
t_advanced_sql_overview t_advanced_sql_syntax t_advanced_sql_inline_view
t_advanced_sql_full_outer_join t_advanced_sql_set_operators t_advanced_sql_expressions
t_advanced_sql_table_expressions t_advanced_sql_rounding_truncating t_advanced_sql_modulo_functions
     
t_advanced_sql_regular_expression t_advanced_sql_conversion_functions t_advanced_sql_nls_functions
t_advanced_sql_null_functions t_advanced_sql_aggregate_functions t_advanced_sql_distinct_keyword
t_advanced_sql_nested_aggregates t_advanced_sql_pivot_unpivot t_advanced_sql_exercises
t_advanced_sql_analytic_function t_advanced_sql_windowing_clause t_advanced_sql_aggregation
t_advanced_sql_aggregation_exercise t_advanced_sql_xml_instance t_advanced_sql_XMLCONCAT
t_advanced_sql_XMLSEQUENCE t_advanced_sql_document_manipulation t_advanced_sql_xml_exercise
t_advanced_sql_hierarchical_queries t_advanced_sql_connect_by_loop t_advanced_sql_hierarchy_exercise
t_advanced_sql_modeling t_advanced_sql_update_statement t_advanced_sql_reference_model
t_advanced_sql_calling_a_script t_advanced_sql_formatting t_advanced_sql_modeling_exercise
     
t_advanced_sql_numeric_columns t_advanced_sql_starting_sqlplus t_advanced_sql_windows_unix_linux
Advanced Oracle Utilities
t_advanced_utilities_discovery t_advanced_utilities_unix_shell t_advanced_utilities_windows
t_advanced_os_utilities t_advanced_access control t_advanced_unix_dos
t_advanced_appending_data t_advanced_dbms_reputil.htm t_advanced_object_dependent_segments.htm
t_advanced_segment_drop_corrupt.htm t_advanced_utl_tcp_package.htm t_advanced_accept_sql_profile.htm
t_advanced_advisory_statistics.htm t_advanced_ARDCI_command_interpreter.htm t_advanced_ARDCI_command_line_interface.htm
t_advanced_bbed_undeleting_row.htm t_advanced_copy_table_stats.htm t_advanced_create_baseline.htm
t_advanced_create_object.htm t_advanced_create_tuning_task.htm t_advanced_cron_crontab_schedule_jobs.htm
t_advanced_data_recovery_advisor.htm t_advanced_dba_scheduler_windows.htm t_advanced_dbms_workload_replay.htm
t_advanced_delete_table_prefs.htm t_advanced_export_fixed_object_stats.htm t_advanced_gather_index_stats.htm
t_advanced_get_raw_function.htm t_advanced_job_execution_dates.htm t_advanced_job_resourse_manager.htm
t_advanced_job_scheduler_time_slide.htm t_advanced_load_sqlset.htm t_advanced_set_index_stats.htm
t_advanced_sql_repair_advisor.htm t_advanced_using_utl_mail.htm t_advanced_utl_compress.htm
t_advanced_utl_compress_package.htm t_advanced_utl_dbws_package.htm t_advanced_utl_http_package.htm
t_advanced_utl_I18N.htm t_advanced_utl_raw package.htm t_advanced_utl_ref package.htm
t_advanced_utl_smtp.reply.htm t_advanced_utl_spadv package.htm  
     
Oracle SQL Tuning & CBO Internal    
t_cbo_stored_outlines t_cbo_correlated_subqueries t_cbo_existence_queries_correlation
t_cbo_existence_queries t_cbo_joins t_cbo_extensions_performance
t_cbo_using_logminer t_cbo_database_event_triggers t_cbo_defragging_nonpartitioned_tables
t_cbo_explain_plan t_cbo_external_tables t_cbo_expression_filter
t_cbo_10g_new_language_features t_cbo_sql_net_diagnostics_perf_tuning  

Using Oracle SQL Stored Outlines & Optimizer Plan Stability

Oracle SQL Stability database creation assistant DBCA

Oracle SQL Stability install outln schema

Oracle SQL Stability outln schema outln_pkg

Oracle SQL Stability create outlines

Administration Creating Altering of OPERATOR Objects - CREATE OR REPLACE OPERATOR command

Oracle SQL Stability plan outlines

Oracle SQL Stability creation outline objects

Oracle SQL Stability alters outlines create replace

 

 

accounting system programmers

Albuquerque New Mexico accounting system programmers

Albuquerque New Mexico financial system programmers

Albuquerque New Mexico programming consultant

Albuquerque New Mexico programming consulting

Albuquerque New Mexico programming contracting

Albuquerque New Mexico programming contractor

Albuquerque New Mexico software programming

Atlanta Georgia accounting system programmers

Atlanta Georgia financial system programmers

Atlanta Georgia programming consultant

Atlanta Georgia programming consulting

Atlanta Georgia programming contracting

Atlanta Georgia programming contractor

Atlanta Georgia software programming

Austin Texas accounting system programmers

Austin Texas financial system programmers

Austin Texas programming consultant

Austin Texas programming consulting

Austin Texas programming contracting

Austin Texas programming contractor

Austin Texas software programming

Baltimore Maryland accounting system programmers

Baltimore Maryland financial system programmers

Baltimore Maryland programming consultant

Baltimore Maryland programming consulting

Baltimore Maryland programming contracting

Baltimore Maryland programming contractor

Baltimore Maryland software programming

Belfast Ireland accounting system programmers

Belfast Ireland financial system programmers

Belfast Ireland programming consultant

Belfast Ireland programming consulting

Belfast Ireland programming contracting

Belfast Ireland programming contractor

Belfast Ireland software programming

Boston Massachusetts accounting system programmers

Boston Massachusetts financial system programmers

Boston Massachusetts programming consultant

Boston Massachusetts programming consulting

Boston Massachusetts programming contracting

Boston Massachusetts programming contractor

Boston Massachusetts software programming

Buffalo New York accounting system programmers

Buffalo New York financial system programmers

Buffalo New York programming consultant

Buffalo New York programming consulting

Buffalo New York programming contracting

Buffalo New York programming contractor

Buffalo New York software programming

Charlotte North Carolina accounting system programmers

Charlotte North Carolina financial system programmers

Charlotte North Carolina programming consultant

Charlotte North Carolina programming consulting

Charlotte North Carolina programming contracting

Charlotte North Carolina programming contractor

Charlotte North Carolina software programming

Chicago Illinois accounting system programmers

Chicago Illinois financial system programmers

Chicago Illinois programming consultant

Chicago Illinois programming consulting

Chicago Illinois programming contracting

Chicago Illinois programming contractor

Chicago Illinois software programming

Cleveland Ohio accounting system programmers

Cleveland Ohio financial system programmers

Cleveland Ohio programming consultant

Cleveland Ohio programming consulting

Cleveland Ohio programming contracting

Cleveland Ohio programming contractor

Cleveland Ohio software programming

Cork Ireland accounting system programmers

Cork Ireland financial system programmers

Cork Ireland programming consultant

Cork Ireland programming consulting

Cork Ireland programming contracting

Cork Ireland programming contractor

Cork Ireland software programming

Dallas Ft Worth Texas accounting system programmers

Dallas Ft Worth Texas financial system programmers

Dallas Ft Worth Texas programming consultant

Dallas Ft Worth Texas programming consulting

Dallas Ft Worth Texas programming contracting

Dallas Ft Worth Texas programming contractor

Dallas Ft Worth Texas software programming

Denver Colorado accounting system programmers

Denver Colorado financial system programmers

Denver Colorado programming consultant

Denver Colorado programming consulting

Denver Colorado programming contracting

Denver Colorado programming contractor

Denver Colorado software programming

Detroit Michigan accounting system programmers

Detroit Michigan financial system programmers

Detroit Michigan programming consultant

Detroit Michigan programming consulting

Detroit Michigan programming contracting

Detroit Michigan programming contractor

Detroit Michigan software programming

Dublin Ireland accounting system programmers

Dublin Ireland financial system programmers

Dublin Ireland programming consultant

Dublin Ireland programming consulting

Dublin Ireland programming contracting

Dublin Ireland programming contractor

Dublin Ireland software programming

Edinburgh Scotland accounting system programmers

Edinburgh Scotland financial system programmers

Edinburgh Scotland programming consultant

Edinburgh Scotland programming consulting

Edinburgh Scotland programming contracting

Edinburgh Scotland programming contractor

Edinburgh Scotland software programming

financial system programmers

Glasgow Scotland accounting system programmers

Glasgow Scotland financial system programmers

Glasgow Scotland programming consultant

Glasgow Scotland programming consulting

Glasgow Scotland programming contracting

Glasgow Scotland programming contractor

Glasgow Scotland software programming

Hartford Connecticut accounting system programmers

Hartford Connecticut financial system programmers

Hartford Connecticut programming consultant

Hartford Connecticut programming consulting

Hartford Connecticut programming contracting

Hartford Connecticut programming contractor

Hartford Connecticut software programming

Honolulu Hawaii accounting system programmers

Honolulu Hawaii financial system programmers

Honolulu Hawaii programming consultant

Honolulu Hawaii programming consulting

Honolulu Hawaii programming contracting

Honolulu Hawaii programming contractor

Honolulu Hawaii software programming

Houston Texas accounting system programmers

Houston Texas financial system programmers

Houston Texas programming consultant

Houston Texas programming consulting

Houston Texas programming contracting

Houston Texas programming contractor

Houston Texas software programming

Kansas City Kansas accounting system programmers

Kansas City Kansas financial system programmers

Kansas City Kansas programming consultant

Kansas City Kansas programming consulting

Kansas City Kansas programming contracting

Kansas City Kansas programming contractor

Kansas City Kansas software programming

Las Vegas Nevada accounting system programmers

Las Vegas Nevada financial system programmers

Las Vegas Nevada programming consultant

Las Vegas Nevada programming consulting

Las Vegas Nevada programming contracting

Las Vegas Nevada programming contractor

Las Vegas Nevada software programming

Liverpool England accounting system programmers

Liverpool England financial system programmers

Liverpool England programming consultant

Liverpool England programming consulting

Liverpool England programming contracting

Liverpool England programming contractor

Liverpool England software programming

London England accounting system programmers

London England financial system programmers

London England programming consultant

London England programming consulting

London England programming contracting

London England programming contractor

London England software programming

Los Angeles California accounting system programmers

Los Angeles California financial system programmers

Los Angeles California programming consultant

Los Angeles California programming consulting

Los Angeles California programming contracting

Los Angeles California programming contractor

Los Angeles California software programming

Louisville Kentucky accounting system programmers

Louisville Kentucky financial system programmers

Louisville Kentucky programming consultant

Louisville Kentucky programming consulting

Louisville Kentucky programming contracting

Louisville Kentucky programming contractor

Louisville Kentucky software programming

Miami Florida accounting system programmers

Miami Florida financial system programmers

Miami Florida programming consultant

Miami Florida programming consulting

Miami Florida programming contracting

Miami Florida programming contractor

Miami Florida software programming

Milwaukee Wisconsin accounting system programmers

Milwaukee Wisconsin financial system programmers

Milwaukee Wisconsin programming consultant

Milwaukee Wisconsin programming consulting

Milwaukee Wisconsin programming contracting

Milwaukee Wisconsin programming contractor

Milwaukee Wisconsin software programming

Minneapolis St Paul Minnesota accounting system programmers

Minneapolis St Paul Minnesota financial system programmers

Minneapolis St Paul Minnesota programming consultant

Minneapolis St Paul Minnesota programming consulting

Minneapolis St Paul Minnesota programming contracting

Minneapolis St Paul Minnesota programming contractor

Minneapolis St Paul Minnesota software programming

New York City accounting system programmers

New York City financial system programmers

New York City programming consultant

New York City programming consulting

New York City programming contracting

New York City programming contractor

New York City software programming

Omaha Nebraska accounting system programmers

Omaha Nebraska financial system programmers

Omaha Nebraska programming consultant

Omaha Nebraska programming consulting

Omaha Nebraska programming contracting

Omaha Nebraska programming contractor

Omaha Nebraska software programming

Orlando Florida accounting system programmers

Orlando Florida financial system programmers

Orlando Florida programming consultant

Orlando Florida programming consulting

Orlando Florida programming contracting

Orlando Florida programming contractor

Orlando Florida software programming

Philadelphia Pennsylvania accounting system programmers

Philadelphia Pennsylvania financial system programmers

Philadelphia Pennsylvania programming consultant

Philadelphia Pennsylvania programming consulting

Philadelphia Pennsylvania programming contracting

Philadelphia Pennsylvania programming contractor

Philadelphia Pennsylvania software programming

Phoenix Arizona accounting system programmers

Phoenix Arizona financial system programmers

Phoenix Arizona programming consultant

Phoenix Arizona programming consulting

Phoenix Arizona programming contracting

Phoenix Arizona programming contractor

Phoenix Arizona software programming

Pittsburg Pennsylvania accounting system programmers

Pittsburg Pennsylvania financial system programmers

Pittsburg Pennsylvania programming consultant

Pittsburg Pennsylvania programming consulting

Pittsburg Pennsylvania programming contracting

Pittsburg Pennsylvania programming contractor

Pittsburg Pennsylvania software programming

Portland Oregon accounting system programmers

Portland Oregon financial system programmers

Portland Oregon programming consultant

Portland Oregon programming consulting

Portland Oregon programming contracting

Portland Oregon programming contractor

Portland Oregon software programming

programming consultant

programming consulting

programming contracting

programming contractor

Raleigh North Carolina accounting system programmers

Raleigh North Carolina financial system programmers

Raleigh North Carolina programming consultant

Raleigh North Carolina programming consulting

Raleigh North Carolina programming contracting

Raleigh North Carolina programming contractor

Raleigh North Carolina software programming

Richmond Virginia accounting system programmers

Richmond Virginia financial system programmers

Richmond Virginia programming consultant

Richmond Virginia programming consulting

Richmond Virginia programming contracting

Richmond Virginia programming contractor

Richmond Virginia software programming

Rochester New York accounting system programmers

Rochester New York financial system programmers

Rochester New York programming consultant

Rochester New York programming consulting

Rochester New York programming contracting

Rochester New York programming contractor

Rochester New York software programming

Sacramento California accounting system programmers

Sacramento California financial system programmers

Sacramento California programming consultant

Sacramento California programming consulting

Sacramento California programming contracting

Sacramento California programming contractor

Sacramento California software programming

Salt Lake City Utah accounting system programmers

Salt Lake City Utah financial system programmers

Salt Lake City Utah programming consultant

Salt Lake City Utah programming consulting

Salt Lake City Utah programming contracting

Salt Lake City Utah programming contractor

Salt Lake City Utah software programming

San Antonio Texas accounting system programmers

San Antonio Texas financial system programmers

San Antonio Texas programming consultant

San Antonio Texas programming consulting

San Antonio Texas programming contracting

San Antonio Texas programming contractor

San Antonio Texas software programming

San Diego California accounting system programmers

San Diego California financial system programmers

San Diego California programming consultant

San Diego California programming consulting

San Diego California programming contracting

San Diego California programming contractor

San Diego California software programming

San Francisco California accounting system programmers

San Francisco California financial system programmers

San Francisco California programming consultant

San Francisco California programming consulting

San Francisco California programming contracting

San Francisco California programming contractor

San Francisco California software programming

San Jose California accounting system programmers

San Jose California financial system programmers

San Jose California programming consultant

San Jose California programming consulting

San Jose California programming contracting

San Jose California programming contractor

San Jose California software programming

Seattle Tacoma Washington accounting system programmers

Seattle Tacoma Washington financial system programmers

Seattle Tacoma Washington programming consultant

Seattle Tacoma Washington programming consulting

Seattle Tacoma Washington programming contracting

Seattle Tacoma Washington programming contractor

Seattle Tacoma Washington software programming

St Louis Missouri accounting system programmers

St Louis Missouri financial system programmers

St Louis Missouri programming consultant

St Louis Missouri programming consulting

St Louis Missouri programming contracting

St Louis Missouri programming contractor

St Louis Missouri software programming

Syracuse New York accounting system programmers

Syracuse New York financial system programmers

Syracuse New York programming consultant

Syracuse New York programming consulting

Syracuse New York programming contracting

Syracuse New York programming contractor

Syracuse New York software programming

Tampa Florida accounting system programmers

Tampa Florida financial system programmers

Tampa Florida programming consultant

Tampa Florida programming consulting

Tampa Florida programming contracting

Tampa Florida programming contractor

Tampa Florida software programming

Washington DC accounting system programmers

Washington DC financial system programmers

Washington DC programming consultant

Washington DC programming consulting

Washington DC programming contracting

Washington DC programming contractor

Washington DC software programming

Oracle - The UNIX chmod command

Oracle - The UNIX pwd command

Oracle - Additional UNIX utility commands

Oracle - Using grep in UNIX

Oracle - UNIX and DOS commands

Oracle - UNIX user management

Oracle - The UNIX ls command

Oracle - File management in UNIX

Oracle - Introduction to UNIX

Oracle - Appending data to UNIX files

Oracle - Removing UNIX files and directories

Oracle - The UNIX touch command

Oracle - The UNIX head and tail commands

Oracle - Locating files in UNIX

Oracle - Changing UNIX shell environments

Oracle- Unix - Re-directing output to a NULL device

Oracle - Viewing and editing files in UNIX

Oracle - Introduction to UNIX

Oracle - UNIX shells

Oracle - System Administration in UNIX

Oracle - The UNIX cd command

Oracle - Using awk in UNIX

Oracle - UNIX user identification

Oracle - UNIX connectivity for Oracle

Oracle - Unix - Piping output from commands

Oracle - The UNIX wc command

Oracle - UNIX line continuation characters

Oracle - UNIX passwords on Oracle servers

Oracle - Controlling UNIX file permission with umask

Oracle - Using sed in UNIX

Oracle - Capturing server information with UNIX

Oracle - Unix - Using the tee command to re-direct output to files

Linux, The SUID special permission mode, sticky bit

Linux, The read statement, accept input from standard

Linux, Using the find command to locate files by age

Linux, Evaluating complex expressions, perform math functions

Linux, Find the full directory path for file

Linux, Redirection of Standard Input & Output

Linux, Change File Ownership, chown, chgrp, commands

Linux, What is a shell?, command interpreter environment

Linux, Using simple ls command options

Linux, Conditional Statements, testing conditions, performing specific actions

Linux, Pipes, string together multiple commands

Linux, Setting default permissions using a file mask, unmask, login script

Linux, User defined variables, scripts, global

Linux, Logging on to another group, id, uid, gid

Linux, Special permission mode settings

Linux, Inside vi - Changing command insert mode - saving file

Linux, Inside vi - Editor modes of operation - text editor

Linux, The case statement, performing different set commands

Linux, Using test command, expression evaluation

Linux, About Loops, for, while, execute commands repeatedly

Linux, Invoking Crontab with various options

Linux, Crontab command Lines, six positional fields

Linux, Cutting, Copying, and Pasting text, default buffer

Oracle, Analysis Tools, operating system level analysis

Oracle, Comparing the Different Scenarios, SSD, DSS, NAL

Oracle, Random Number Generation, cached performance

Oracle RAM data buffering History

Oracle, Test Architecture, overall disk specifications

Oracle, Query Processing, qgen program, DSS

Allocating Oracle Objects Multiple RAM Data Buffers

Oracle environment is being virtualized, monitoring

Oracle, Standard SCSI / ATA Runs

Oracle, Finding source bandwidth bottlenecks

SQL Server, Storage Monitoring Basics, sp_msforeachtable sp_foreachdb

SQL Server, Avoiding Free Space Deficit Bottlenecks

SQL Server, Server-Level Space Considerations, DBCC SHRINKDATABASE SHRINKFILE

SQL Server, Object Fragmentation, Internal External memory caches

SQL Server, Environments Benefit Fragmentation Elimination, OLTP

SQL Server, Diagnosing Object Fragmentation, DBCC SHOWCONTIG

SQL Server, Extent Proximity, prefetch, Read Ahead manager

SQL Server, Removing Fragmentation, INDEXDEFRAG DBCC DBREINDEX

SQL Server, Forwarded Rows, sys.dm_db_index_physical_stats function

SQL Server, SQL Workload Analysis, Teradata warehouse

SQL Server, Examining Plan Cache, input parameters

SQL Server, Collecting Statistics, extent logical fragmentation

SQL Server, Active vs. Passive Monitoring, sp_minibench stored procedure

SQL Server, Scheduling Statistical Collections, static system storage metrics

SQL Server, Centralizing Operations, SQL Agent installation

SQL Server, Setting up Trend Analysis, tempdb 4GL Timeframes

SQL Server, Correlating Statistics Calculating Rates, iostall

SQL Server, Tuning Makes Difference, monitoring databases performance

SQL Server, Simplified Performance Tuning Model, Optimization

SQL Server, Making Configuration Changes, standpoint parameters

SQL Server, Consider More Memory, configuration parameters

SQL Server, configuration parameters, fillfactor NETWORKIO

SQL Server, Decimal numeric, precision scale

SQL Server, UNIQUE, constraint CLUSTERED order_id

SQL Server, MS CryptoAPI based Public Key Implementations

SQL Server, Binary, Varbinary data type fixed variable

SQL Server, Provide automatic conversion parameter data types

SQL Server, Using framework, Appwizard SDK MFC ATL DLL

SQL Server, Applications XP_HTMLENCODE, varchar nvarchar

SQL Server, Parameter Management, srv_parname XP

SQL Server, Data types code use, Cursor Table statements

SQL Server, About NULL TSQL, SET option ANSI_NULLS

SQL Server, XP_PLAYSOUNDMEMORY, TSQL PlaySound XP_NOTIFY

SQL Server, Unicode Compilation, Win32 functions

SQL Server, CRC32 Checksum Algorithm, CRC dwCRC

SQL Server, Applications XP_SMTPSENDMAIL, table

SQL Server, Variant data type, reference SP PROPERTY

SQL Server, Track Memory Leaks, runtime heap allocations

SQL Server, Dependency Walker, Input Output parameters

SQL Server, Precompiled headers, pch stdafx

SQL Server, Code Highlights, parameters CDO macros CC

SQL Server, Blowfish - TEA Block Cipher, CBlowFish ECB mode

SQL Server, ASCII Character Set, American Standard Code

SQL Server, XP_NET_SEND Jobs, Administrator

SQL Server, MD4, MD5, SHA, Hash Algorithm

SQL Server, XP_CRYPTOAPI Usage, TSQL HMAC SDK

SQL Server, Implementation, framework XP_NETSEND code

SQL Server, Exporting function, standard boilerplate code

SQL Server, Execution Extended Stored Procedures, SP, UDF

SQL Server, Encapsulate verification setup parameters

SQL Server, Using Query Analyzer, debug SP, testing TSQL

SQL Server, Char stores fixed length ASCII data

SQL Server, Nchar stores fixed length Unicode data DATALENGTH

SQL Server, Security / Connection Management, XP_ODBC

SQL Server, MS CryptoAPI based Signing / Verification Implementations

SQL Server, Named parameters, ODS XP

SQL Server, XP_PLAYSOUNDFILE, XP_STOPSOUND, XP_PLAYSOUNDALIAS

SQL Server, Implementation Details, ADO EOF MSDN

SQL Server, Real , floating point numeric valid values mantissa

SQL Server, Hashing, hash value data collision - resistance

SQL Server, MS CryptoAPI Hash Algorithm Implementations CSP

SQL Server, Using CDO Windows 2000, DLL JScript

SQL Server, Helix Stream Cipher, CryptoAPI MAC

SQL Server, Asymmetric Encryption / Decryption, RSA DSA

SQL Server, Unicode Character Set, Consortium unified

SQL Server, Testing Code, Script EXEC

SQL Server, Registering XP from Enterprise Manager, GUI

SQL Server, XP_HTMLENCODE2, EscapeXML ATL Unicode framework

SQL Server, ODS API, functions SRV_PROC pointer

SQL Server, Symmetric Encryption / Decryption, Stream Ciphers CBC

SQL Server, Handling different data types, boolean

SQL Server, XP_NET_ADDNAME, NetBIOS UNICODE SDK

SQL Server, Applications XP_CRYPTOAPI, UDF functions

SQL Server, Implement encapsulation C++ classes

SQL Server, Default values, SP XP

SQL Server, Choice Mail Library, SMTP MAPI XP

Data Warehouse Chp 1
 

tp_data_warehouse_management_platforms_object-oriented
tp_data_storage_ISAM_VSAM_BDAM
tp_data_storage_hashing_ISAM_VSAM
tp_data_storage_redundancy_CORBA
tp_IMS_hierarchical_database_OLTP
tp_CODASYL_DBTG_database_recovery
tp_CODASYL_Bachman_data_models_DML
tp_CODASYL_BDAM_DML
tp_CODASYL_DBTG_database_recovery.htm
tp_CODASYL_IDMS_data_Warehouse_Redundancy
tp_Relational_Databases_Data_Independence_Pointerless
tp_Data_Access_Referential_Integrity_RI
tp_Contiguous_Record_Storage_RI
tp_SQL_Select_Project_Join_Tuples
tp_data_SQL_select_project_join

   
tp_data_warehouses_subject-oriented_read-only_queries  
tp_OMG_ADT_abstract_data_typing  
tp_abstract_datatypes_ADT_aggregate_objects  
tp_coupling_abstraction  
tp_inheritance_structures_method_superclass  
tp_inheritance_hierarchy_polymorphism  
   
tp_polymorphism_object-oriented_call_procedure  
   
tp_ODMG_object-oriented_data_warehouse  
   
tp_decision_support_systems_SIMULA  
tp_DSS_ad_hoc_queries  
tp_decision_support_DSS_MIS_management
tp_multidimensional_databases_niche_servers_RDBMS
tp_OLTP_pre-aggregated_ad_hoc_query
tp_data_warehouse_OLTP_STAR_schema
tp_relational_databases_denormalization_batch_updating
tp_data_warehouse_extraction_aggregation_OLTP
tp_data_warehouse_extraction_cleaning_metadata
tp_ROLAP_multidimensional_database_OLTP_metadata
tp_data_warehouse_multivariate_data_mining
tp_simulation_modeling_data_warehouse_object-oriented
tp_nonlinear_regression_forecasting_smoothing
tp_aggregation_composition_data_warehouse

Chapter 2

tp_Database_development_central_corporate_repository
tp_relational_database_object-oriented_enterprise_modeling
tp_data_warehouse_development_MIS_phases
tp_ongoing_maintenance_data_warehouse_end-users
tp_forecasting_modeling_simulation_end-users_mining
tp_simple_analysis_data_mining_warehouse
tp_technological_economic_feasibility_study_warehouse
tp_technological_feasibility_warehouse
tp_economic_feasibility_development_costs_warehouse
tp_economic_feasibility_tangible_intangible_warehouse
tp_economic_feasibility_return_investment_ROI
tp_ROI_intangible_costs_benefits_warehouse
tp_return_investment_costs_benefits_warehouse
tp_cost_benefit_curve_data_warehouse
tp_data_warehouses_ROI_payback_variance
tp_data_warehouse_project_management
tp_data_warehouse_project_model_delivery
tp_data_warehouse_project_phased_delivery
tp_data_warehouse_project_risk_management
tp_data_warehouse_project_scope
tp_data_warehouse_project_scope_work
tp_data_warehouse_project_software_delivery
tp_data_warehouse_scope_agreement
tp_data_warehouse_scope_system_analysis

Chapter 3

tp_data_warehouse_ad_hoc_classification
tp_data_warehouse_analysis_phase
tp_data_warehouse_customer_transactions
tp_data_warehouse_data_descriptions_sources
tp_data_warehouse_external_data_source
tp_data_warehouse_functional_dependency_transformation
tp_data_warehouse_Oracle_tables
tp_data_warehouse_process_source_loading
tp_data_warehouse_product_descriptions
tp_data_warehouse_query_analysis
tp_data_warehouse_source_analysis
tp_data_warehouse_source_document
tp_data_warehouse_source_document_input
tp_data_warehouse_SQL_queries
tp_data_warehouse_statistical_multivariate
tp_data_warehouse_transformation

Chp 4
 

tp_Oracle_physical_design_relation
tp_Oracle_physical_design_first_normal
tp_Oracle_design_second_normal_form
tp_Oracle_design_third_normal_dependencies
tp_Oracle_physical_design_entity_relation
tp_data_warehouse_static_data
tp_data_warehouse_SQL_joins
tp_data_warehouse_standalone_data
tp_data_warehouse_entity_relation
tp_data_warehouse_recursive_relationships
tp_data_warehouse_IS-A_hierarchy
tp_data_warehouse_design_STAR_schema
tp_data_warehouse_STAR_SQL
tp_data_warehouse_SQL_front_end
tp_data_warehouse_generate_SQL
tp_data_warehouse_logical_database_design

Chp 5
 

tp_data_warehouse_OLAP_Relational
tp_data_warehouse_OLAP_extraction_Excel
tp_data_warehouse_OLAP_pivot_wizard
tp_data_warehouse_OLAP_dimensions
tp_data_warehouse_OLAP_data_attributes
tp_data_warehouse_OLAP_OLTP
tp_data_warehouse_OLAP_multidimensional
tp_data_warehouse_ROLAP_MOLAP
tp_data_warehouse_relational_database_ROLAP
tp_data_warehouse_ROLAP_STAR_schema
tp_data_warehouse_OLAP_hybrids
tp_data_warehouse_OLAP_aggregation_multidimensional

Chp. 6
tp_data_warehouse_aggregation_multidimensional

Chp. 7
tp_parallel_server_SQL_lock_hit
tp_parallel_server_V$PING_contention

Chp. 8
 

tp_clustered_indexes_tables_logical_
 
tp_data_warehouse_SQL_Plus_ad-hoc
tp_data_warehouse_alter_tables
tp_Oracle_tablespace_table_chaining
tp_Oracle_tablespace_fragmentation_map
tp_Oracle_tablespace_manager
tp_Oracle_warehouse_horizontal_partitioning
tp_Oracle_tablespace_CD-ROM
tp_Oracle_tablespace_free_space

Chp.9
 

tp_distributed_database_systems_autonomy
tp_distributed_warehouses_query_processing
tp_distributed_warehouse_transaction_management_commit
tp_distributed_data_warehouses_network_independence
tp_database_geographical_horizontal_distribution
tp_distributed_data_warehouses_platform_vertical
tp_warehouses_table_partitioning_horizontal_vertical
tp_distributed_data_warehouses_location_transparency
tp_distributed_databases_transparency_global_transaction
tp_distributed_databases_real_location_transparency
tp_distributed_databases_table_data_replication
tp_distributed_warehouse_dynamic_transparency
tp_Oracle_SQL_NET_transparent_network
tp_Oracle_SQL_Net_Plus_sessions
tp_Oracle_SQL_Net_connections_task
tp_SQL_Net_server_remote_databases
tp_SQL_Net_logs_tracing_database
tp_SQL_Net_distributed_transactions_commit
tp_distributed_databases_warehouse_table_replication

Mothballing a Database Project - Ault

t_mothballing_project_system_programs_source
t_mothballed_project_data_definition_language
t_mothballed_database_exports_logical_copies
t_mothballed_project_system_backup
t_mothballed_database_project_documentation
t_mothballed_project_document_applications
t_project_mothballing_documentation_tools
t_project_mothballing_documentation_training_report
t_project_mothballing_comments_reports
t_project_mothballing_reactivated_failure

Using Object ID's in Oracle 8 -  Ault

tp_Oracle_8_dangling_REF
tp_Oracle_8_REF_request_passing
tp_Oracle_8_REF_object_values
tp_Oracle_8_REF_dangling

Ault Q&A

t_oracle_deleting_user_error_message
t_oracle_user_sequences
t_oracle_10g_application_server_installation
t_oracle_key_string_encryption
t_oracle_uniform_extent_size
t_oracle_archive_log_files
t_oracle_composite_primary_key
t_oracle_archive_logs
t_oracle_changing_database_objects
t_oracle_export_command
t_oracle_exporting_data
t_oracle_creating_indexes
t_oracle_query_optimization
t_oracle_access_violation_error_message
t_oracle_installation_error_message
t_oracle_length_of_numeric_data_type
t_oracle_dynamic_sql_statement
t_oracle_dropped_table
t_oracle_removing_carriage_returns
t_oracle_reading_WSID
t_oracle_reparsing

Ault Tips

t_ault_they_amm_to_please_sometimes

Garmany Q & A

t_oracle_connecting_to_a_db
t_oracle_creating_new_9i_database
t_oracle_listener_error_message.htm
t_oracle_access_violation
t_oracle_button_trigger_exception_error
t_oracle_migrating_from_9i_to_10g
t_oracle_testing_accessibility
t_oracle_database_access_via_Internet
t_oracle_installing_on_one_server
t_oracle_running_Oracle_apps_on_Internet
t_oracle_migrating_from_dev_6i
t_oracle_cluster_forms_reports

Putting Methods to Work in Oracle8 - Ault

tp_Oracle_8_REF_requests_passing

Diving Into the Shared Pool (Part 1) - Ault

tp_shared_pool_flush_script
tp_Oracle_shared_pool_routine_flush
tp_Oracle_shared_pool_area_sizing

Diving Into the Shared Pool (Part 2) - Ault

tp_shared_pool_fixed_size_pin
tp_shared_pool_null_startup_function
tp_Oracle_shared_pool_areas_MTS
tp_Oracle_SQL_statements_area_text

Job Scheduling

t_jobscheduling_193_conditional_job_creation_ t_jobscheduling_205_job_chain_enable_job_
t_jobscheduling_194_job_creation_ t_jobscheduling_206_job_enabling_
t_jobscheduling_195_job_creation_ t_jobscheduling_207_job_chain_enable_
   
t_jobscheduling_196_job_chain_ t_jobscheduling_208_job_chain_
t_jobscheduling_197_job_chain_create_ t_jobscheduling_209_job_queue_query_
t_jobscheduling_198_repeat_interval_ t_jobscheduling_210_job_queue_
   
t_jobscheduling_199_job_chain_query_ t_jobscheduling_211_job_chain_query_
t_jobscheduling_200_job_chain_query_ t_jobscheduling_212_job_chain_query_
t_jobscheduling_201_conditional_job_enabling_ t_jobscheduling_213_job_chain_enable_
   
t_jobscheduling_202_job_enasbling_ t_jobscheduling_214_job_enabling_
t_jobscheduling_203_job_enabling_ t_jobscheduling_215_job_enabling_
t_jobscheduling_204_job_enabling_ t_jobscheduling_216_conditional_job_enabling_

Oracle 11g courses

Oracle Application Express (Apex) Book

 

 

 

 

 

 

 

 

Tasteless Cartoons

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  and include the URL for the page.


                    









Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


 

Copyright 1996 -  2014

All rights reserved by Burleson

Oracle is the registered trademark of Oracle Corporation.