1" Vim syntax file 2" Language: Oracle config files (.ora) (Oracle 8i, ver. 8.1.5) 3" Maintainer: Sandor Kopanyi <sandor.kopanyi@mailbox.hu> 4" Url: <-> 5" Last Change: 2003 May 11 6 7" * the keywords are listed by file (sqlnet.ora, listener.ora, etc.) 8" * the parathesis-checking is made at the beginning for all keywords 9" * possible values are listed also 10" * there are some overlappings (e.g. METHOD is mentioned both for 11" sqlnet-ora and tnsnames.ora; since will not cause(?) problems 12" is easier to follow separately each file's keywords) 13 14" quit when a syntax file was already loaded 15if exists("b:current_syntax") 16 finish 17endif 18 19if !exists("main_syntax") 20 let main_syntax = 'ora' 21endif 22 23syn case ignore 24 25"comments 26syn match oraComment "\#.*" 27 28" catch errors caused by wrong parenthesis 29syn region oraParen transparent start="(" end=")" contains=@oraAll,oraParen 30syn match oraParenError ")" 31 32" strings 33syn region oraString start=+"+ end=+"+ 34 35"common .ora staff 36 37"common protocol parameters 38syn keyword oraKeywordGroup ADDRESS ADDRESS_LIST 39syn keyword oraKeywordGroup DESCRIPTION_LIST DESCRIPTION 40"all protocols 41syn keyword oraKeyword PROTOCOL 42syn keyword oraValue ipc tcp nmp 43"Bequeath 44syn keyword oraKeyword PROGRAM ARGV0 ARGS 45"IPC 46syn keyword oraKeyword KEY 47"Named Pipes 48syn keyword oraKeyword SERVER PIPE 49"LU6.2 50syn keyword oraKeyword LU_NAME LLU LOCAL_LU LLU_NAME LOCAL_LU_NAME 51syn keyword oraKeyword MODE MDN 52syn keyword oraKeyword PLU PARTNER_LU_NAME PLU_LA PARTNER_LU_LOCAL_ALIAS 53syn keyword oraKeyword TP_NAME TPN 54"SPX 55syn keyword oraKeyword SERVICE 56"TCP/IP and TCP/IP with SSL 57syn keyword oraKeyword HOST PORT 58 59"misc. keywords I've met but didn't find in manual (maybe they are deprecated?) 60syn keyword oraKeywordGroup COMMUNITY_LIST 61syn keyword oraKeyword COMMUNITY NAME DEFAULT_ZONE 62syn keyword oraValue tcpcom 63 64"common values 65syn keyword oraValue yes no on off true false null all none ok 66"word 'world' is used a lot... 67syn keyword oraModifier world 68 69"misc. common keywords 70syn keyword oraKeyword TRACE_DIRECTORY TRACE_LEVEL TRACE_FILE 71 72 73"sqlnet.ora 74syn keyword oraKeywordPref NAMES NAMESCTL 75syn keyword oraKeywordPref OSS SOURCE SQLNET TNSPING 76syn keyword oraKeyword AUTOMATIC_IPC BEQUEATH_DETACH DAEMON TRACE_MASK 77syn keyword oraKeyword DISABLE_OOB 78syn keyword oraKeyword LOG_DIRECTORY_CLIENT LOG_DIRECTORY_SERVER 79syn keyword oraKeyword LOG_FILE_CLIENT LOG_FILE_SERVER 80syn keyword oraKeyword DCE PREFIX DEFAULT_DOMAIN DIRECTORY_PATH 81syn keyword oraKeyword INITIAL_RETRY_TIMEOUT MAX_OPEN_CONNECTIONS 82syn keyword oraKeyword MESSAGE_POOL_START_SIZE NIS META_MAP 83syn keyword oraKeyword PASSWORD PREFERRED_SERVERS REQUEST_RETRIES 84syn keyword oraKeyword INTERNAL_ENCRYPT_PASSWORD INTERNAL_USE 85syn keyword oraKeyword NO_INITIAL_SERVER NOCONFIRM 86syn keyword oraKeyword SERVER_PASSWORD TRACE_UNIQUE MY_WALLET 87syn keyword oraKeyword LOCATION DIRECTORY METHOD METHOD_DATA 88syn keyword oraKeyword SQLNET_ADDRESS 89syn keyword oraKeyword AUTHENTICATION_SERVICES 90syn keyword oraKeyword AUTHENTICATION_KERBEROS5_SERVICE 91syn keyword oraKeyword AUTHENTICATION_GSSAPI_SERVICE 92syn keyword oraKeyword CLIENT_REGISTRATION 93syn keyword oraKeyword CRYPTO_CHECKSUM_CLIENT CRYPTO_CHECKSUM_SERVER 94syn keyword oraKeyword CRYPTO_CHECKSUM_TYPES_CLIENT CRYPTO_CHECKSUM_TYPES_SERVER 95syn keyword oraKeyword CRYPTO_SEED 96syn keyword oraKeyword ENCRYPTION_CLIENT ENCRYPTION_SERVER 97syn keyword oraKeyword ENCRYPTION_TYPES_CLIENT ENCRYPTION_TYPES_SERVER 98syn keyword oraKeyword EXPIRE_TIME 99syn keyword oraKeyword IDENTIX_FINGERPRINT_DATABASE IDENTIX_FINGERPRINT_DATABASE_USER 100syn keyword oraKeyword IDENTIX_FINGERPRINT_DATABASE_PASSWORD IDENTIX_FINGERPRINT_METHOD 101syn keyword oraKeyword KERBEROS5_CC_NAME KERBEROS5_CLOCKSKEW KERBEROS5_CONF 102syn keyword oraKeyword KERBEROS5_KEYTAB KERBEROS5_REALMS 103syn keyword oraKeyword RADIUS_ALTERNATE RADIUS_ALTERNATE_PORT RADIUS_ALTERNATE_RETRIES 104syn keyword oraKeyword RADIUS_AUTHENTICATION_TIMEOUT RADIUS_AUTHENTICATION 105syn keyword oraKeyword RADIUS_AUTHENTICATION_INTERFACE RADIUS_AUTHENTICATION_PORT 106syn keyword oraKeyword RADIUS_AUTHENTICATION_RETRIES RADIUS_AUTHENTICATION_TIMEOUT 107syn keyword oraKeyword RADIUS_CHALLENGE_RESPONSE RADIUS_SECRET RADIUS_SEND_ACCOUNTING 108syn keyword oraKeyword SSL_CLIENT_AUTHENTICATION SSL_CIPHER_SUITES SSL_VERSION 109syn keyword oraKeyword TRACE_DIRECTORY_CLIENT TRACE_DIRECTORY_SERVER 110syn keyword oraKeyword TRACE_FILE_CLIENT TRACE_FILE_SERVER 111syn keyword oraKeyword TRACE_LEVEL_CLIENT TRACE_LEVEL_SERVER 112syn keyword oraKeyword TRACE_UNIQUE_CLIENT 113syn keyword oraKeyword USE_CMAN USE_DEDICATED_SERVER 114syn keyword oraValue user admin support 115syn keyword oraValue accept accepted reject rejected requested required 116syn keyword oraValue md5 rc4_40 rc4_56 rc4_128 des des_40 117syn keyword oraValue tnsnames onames hostname dce nis novell 118syn keyword oraValue file oracle 119syn keyword oraValue oss 120syn keyword oraValue beq nds nts kerberos5 securid cybersafe identix dcegssapi radius 121syn keyword oraValue undetermined 122 123"tnsnames.ora 124syn keyword oraKeywordGroup CONNECT_DATA FAILOVER_MODE 125syn keyword oraKeyword FAILOVER LOAD_BALANCE SOURCE_ROUTE TYPE_OF_SERVICE 126syn keyword oraKeyword BACKUP TYPE METHOD GLOBAL_NAME HS 127syn keyword oraKeyword INSTANCE_NAME RDB_DATABASE SDU SERVER 128syn keyword oraKeyword SERVICE_NAME SERVICE_NAMES SID 129syn keyword oraKeyword HANDLER_NAME EXTPROC_CONNECTION_DATA 130syn keyword oraValue session select basic preconnect dedicated shared 131 132"listener.ora 133syn keyword oraKeywordGroup SID_LIST SID_DESC PRESPAWN_LIST PRESPAWN_DESC 134syn match oraKeywordGroup "SID_LIST_\w*" 135syn keyword oraKeyword PROTOCOL_STACK PRESENTATION SESSION 136syn keyword oraKeyword GLOBAL_DBNAME ORACLE_HOME PROGRAM SID_NAME 137syn keyword oraKeyword PRESPAWN_MAX POOL_SIZE TIMEOUT 138syn match oraKeyword "CONNECT_TIMEOUT_\w*" 139syn match oraKeyword "LOG_DIRECTORY_\w*" 140syn match oraKeyword "LOG_FILE_\w*" 141syn match oraKeyword "PASSWORDS_\w*" 142syn match oraKeyword "STARTUP_WAIT_TIME_\w*" 143syn match oraKeyword "STARTUP_WAITTIME_\w*" 144syn match oraKeyword "TRACE_DIRECTORY_\w*" 145syn match oraKeyword "TRACE_FILE_\w*" 146syn match oraKeyword "TRACE_LEVEL_\w*" 147syn match oraKeyword "USE_PLUG_AND_PLAY_\w*" 148syn keyword oraValue ttc giop ns raw 149 150"names.ora 151syn keyword oraKeywordGroup ADDRESSES ADMIN_REGION 152syn keyword oraKeywordGroup DEFAULT_FORWARDERS FORWARDER_LIST FORWARDER 153syn keyword oraKeywordGroup DOMAIN_HINTS HINT_DESC HINT_LIST 154syn keyword oraKeywordGroup DOMAINS DOMAIN_LIST DOMAIN 155syn keyword oraKeywordPref NAMES 156syn keyword oraKeyword EXPIRE REFRESH REGION RETRY USERID VERSION 157syn keyword oraKeyword AUTHORITY_REQUIRED CONNECT_TIMEOUT 158syn keyword oraKeyword AUTO_REFRESH_EXPIRE AUTO_REFRESH_RETRY 159syn keyword oraKeyword CACHE_CHECKPOINT_FILE CACHE_CHECKPOINT_INTERVAL 160syn keyword oraKeyword CONFIG_CHECKPOINT_FILE DEFAULT_FORWARDERS_ONLY 161syn keyword oraKeyword HINT FORWARDING_AVAILABLE FORWARDING_DESIRED 162syn keyword oraKeyword KEEP_DB_OPEN 163syn keyword oraKeyword LOG_DIRECTORY LOG_FILE LOG_STATS_INTERVAL LOG_UNIQUE 164syn keyword oraKeyword MAX_OPEN_CONNECTIONS MAX_REFORWARDS 165syn keyword oraKeyword MESSAGE_POOL_START_SIZE 166syn keyword oraKeyword NO_MODIFY_REQUESTS NO_REGION_DATABASE 167syn keyword oraKeyword PASSWORD REGION_CHECKPOINT_FILE 168syn keyword oraKeyword RESET_STATS_INTERVAL SAVE_CONFIG_ON_STOP 169syn keyword oraKeyword SERVER_NAME TRACE_FUNC TRACE_UNIQUE 170 171"cman.ora 172syn keyword oraKeywordGroup CMAN CMAN_ADMIN CMAN_PROFILE PARAMETER_LIST 173syn keyword oraKeywordGroup CMAN_RULES RULES_LIST RULE 174syn keyword oraKeyword ANSWER_TIMEOUT AUTHENTICATION_LEVEL LOG_LEVEL 175syn keyword oraKeyword MAX_FREELIST_BUFFERS MAXIMUM_CONNECT_DATA MAXIMUM_RELAYS 176syn keyword oraKeyword RELAY_STATISTICS SHOW_TNS_INFO TRACING 177syn keyword oraKeyword USE_ASYNC_CALL SRC DST SRV ACT 178 179"protocol.ora 180syn match oraKeyword "\w*\.EXCLUDED_NODES" 181syn match oraKeyword "\w*\.INVITED_NODES" 182syn match oraKeyword "\w*\.VALIDNODE_CHECKING" 183syn keyword oraKeyword TCP NODELAY 184 185 186 187 188"--------------------------------------- 189"init.ora 190 191"common values 192syn keyword oraValue nested_loops merge hash unlimited 193 194"init params 195syn keyword oraKeyword O7_DICTIONARY_ACCESSIBILITY ALWAYS_ANTI_JOIN ALWAYS_SEMI_JOIN 196syn keyword oraKeyword AQ_TM_PROCESSES ARCH_IO_SLAVES AUDIT_FILE_DEST AUDIT_TRAIL 197syn keyword oraKeyword BACKGROUND_CORE_DUMP BACKGROUND_DUMP_DEST 198syn keyword oraKeyword BACKUP_TAPE_IO_SLAVES BITMAP_MERGE_AREA_SIZE 199syn keyword oraKeyword BLANK_TRIMMING BUFFER_POOL_KEEP BUFFER_POOL_RECYCLE 200syn keyword oraKeyword COMMIT_POINT_STRENGTH COMPATIBLE CONTROL_FILE_RECORD_KEEP_TIME 201syn keyword oraKeyword CONTROL_FILES CORE_DUMP_DEST CPU_COUNT 202syn keyword oraKeyword CREATE_BITMAP_AREA_SIZE CURSOR_SPACE_FOR_TIME 203syn keyword oraKeyword DB_BLOCK_BUFFERS DB_BLOCK_CHECKING DB_BLOCK_CHECKSUM 204syn keyword oraKeyword DB_BLOCK_LRU_LATCHES DB_BLOCK_MAX_DIRTY_TARGET 205syn keyword oraKeyword DB_BLOCK_SIZE DB_DOMAIN 206syn keyword oraKeyword DB_FILE_DIRECT_IO_COUNT DB_FILE_MULTIBLOCK_READ_COUNT 207syn keyword oraKeyword DB_FILE_NAME_CONVERT DB_FILE_SIMULTANEOUS_WRITES 208syn keyword oraKeyword DB_FILES DB_NAME DB_WRITER_PROCESSES 209syn keyword oraKeyword DBLINK_ENCRYPT_LOGIN DBWR_IO_SLAVES 210syn keyword oraKeyword DELAYED_LOGGING_BLOCK_CLEANOUTS DISCRETE_TRANSACTIONS_ENABLED 211syn keyword oraKeyword DISK_ASYNCH_IO DISTRIBUTED_TRANSACTIONS 212syn keyword oraKeyword DML_LOCKS ENQUEUE_RESOURCES ENT_DOMAIN_NAME EVENT 213syn keyword oraKeyword FAST_START_IO_TARGET FAST_START_PARALLEL_ROLLBACK 214syn keyword oraKeyword FIXED_DATE FREEZE_DB_FOR_FAST_INSTANCE_RECOVERY 215syn keyword oraKeyword GC_DEFER_TIME GC_FILES_TO_LOCKS GC_RELEASABLE_LOCKS GC_ROLLBACK_LOCKS 216syn keyword oraKeyword GLOBAL_NAMES HASH_AREA_SIZE 217syn keyword oraKeyword HASH_JOIN_ENABLED HASH_MULTIBLOCK_IO_COUNT 218syn keyword oraKeyword HI_SHARED_MEMORY_ADDRESS HS_AUTOREGISTER 219syn keyword oraKeyword IFILE 220syn keyword oraKeyword INSTANCE_GROUPS INSTANCE_NAME INSTANCE_NUMBER 221syn keyword oraKeyword JAVA_POOL_SIZE JOB_QUEUE_INTERVAL JOB_QUEUE_PROCESSES LARGE_POOL_SIZE 222syn keyword oraKeyword LICENSE_MAX_SESSIONS LICENSE_MAX_USERS LICENSE_SESSIONS_WARNING 223syn keyword oraKeyword LM_LOCKS LM_PROCS LM_RESS 224syn keyword oraKeyword LOCAL_LISTENER LOCK_NAME_SPACE LOCK_SGA LOCK_SGA_AREAS 225syn keyword oraKeyword LOG_ARCHIVE_BUFFER_SIZE LOG_ARCHIVE_BUFFERS LOG_ARCHIVE_DEST 226syn match oraKeyword "LOG_ARCHIVE_DEST_\(1\|2\|3\|4\|5\)" 227syn match oraKeyword "LOG_ARCHIVE_DEST_STATE_\(1\|2\|3\|4\|5\)" 228syn keyword oraKeyword LOG_ARCHIVE_DUPLEX_DEST LOG_ARCHIVE_FORMAT LOG_ARCHIVE_MAX_PROCESSES 229syn keyword oraKeyword LOG_ARCHIVE_MIN_SUCCEED_DEST LOG_ARCHIVE_START 230syn keyword oraKeyword LOG_BUFFER LOG_CHECKPOINT_INTERVAL LOG_CHECKPOINT_TIMEOUT 231syn keyword oraKeyword LOG_CHECKPOINTS_TO_ALERT LOG_FILE_NAME_CONVERT 232syn keyword oraKeyword MAX_COMMIT_PROPAGATION_DELAY MAX_DUMP_FILE_SIZE 233syn keyword oraKeyword MAX_ENABLED_ROLES MAX_ROLLBACK_SEGMENTS 234syn keyword oraKeyword MTS_DISPATCHERS MTS_MAX_DISPATCHERS MTS_MAX_SERVERS MTS_SERVERS 235syn keyword oraKeyword NLS_CALENDAR NLS_COMP NLS_CURRENCY NLS_DATE_FORMAT 236syn keyword oraKeyword NLS_DATE_LANGUAGE NLS_DUAL_CURRENCY NLS_ISO_CURRENCY NLS_LANGUAGE 237syn keyword oraKeyword NLS_NUMERIC_CHARACTERS NLS_SORT NLS_TERRITORY 238syn keyword oraKeyword OBJECT_CACHE_MAX_SIZE_PERCENT OBJECT_CACHE_OPTIMAL_SIZE 239syn keyword oraKeyword OPEN_CURSORS OPEN_LINKS OPEN_LINKS_PER_INSTANCE 240syn keyword oraKeyword OPS_ADMINISTRATION_GROUP 241syn keyword oraKeyword OPTIMIZER_FEATURES_ENABLE OPTIMIZER_INDEX_CACHING 242syn keyword oraKeyword OPTIMIZER_INDEX_COST_ADJ OPTIMIZER_MAX_PERMUTATIONS 243syn keyword oraKeyword OPTIMIZER_MODE OPTIMIZER_PERCENT_PARALLEL 244syn keyword oraKeyword OPTIMIZER_SEARCH_LIMIT 245syn keyword oraKeyword ORACLE_TRACE_COLLECTION_NAME ORACLE_TRACE_COLLECTION_PATH 246syn keyword oraKeyword ORACLE_TRACE_COLLECTION_SIZE ORACLE_TRACE_ENABLE 247syn keyword oraKeyword ORACLE_TRACE_FACILITY_NAME ORACLE_TRACE_FACILITY_PATH 248syn keyword oraKeyword OS_AUTHENT_PREFIX OS_ROLES 249syn keyword oraKeyword PARALLEL_ADAPTIVE_MULTI_USER PARALLEL_AUTOMATIC_TUNING 250syn keyword oraKeyword PARALLEL_BROADCAST_ENABLED PARALLEL_EXECUTION_MESSAGE_SIZE 251syn keyword oraKeyword PARALLEL_INSTANCE_GROUP PARALLEL_MAX_SERVERS 252syn keyword oraKeyword PARALLEL_MIN_PERCENT PARALLEL_MIN_SERVERS 253syn keyword oraKeyword PARALLEL_SERVER PARALLEL_SERVER_INSTANCES PARALLEL_THREADS_PER_CPU 254syn keyword oraKeyword PARTITION_VIEW_ENABLED PLSQL_V2_COMPATIBILITY 255syn keyword oraKeyword PRE_PAGE_SGA PROCESSES 256syn keyword oraKeyword QUERY_REWRITE_ENABLED QUERY_REWRITE_INTEGRITY 257syn keyword oraKeyword RDBMS_SERVER_DN READ_ONLY_OPEN_DELAYED RECOVERY_PARALLELISM 258syn keyword oraKeyword REMOTE_DEPENDENCIES_MODE REMOTE_LOGIN_PASSWORDFILE 259syn keyword oraKeyword REMOTE_OS_AUTHENT REMOTE_OS_ROLES 260syn keyword oraKeyword REPLICATION_DEPENDENCY_TRACKING 261syn keyword oraKeyword RESOURCE_LIMIT RESOURCE_MANAGER_PLAN 262syn keyword oraKeyword ROLLBACK_SEGMENTS ROW_LOCKING SERIAL _REUSE SERVICE_NAMES 263syn keyword oraKeyword SESSION_CACHED_CURSORS SESSION_MAX_OPEN_FILES SESSIONS 264syn keyword oraKeyword SHADOW_CORE_DUMP 265syn keyword oraKeyword SHARED_MEMORY_ADDRESS SHARED_POOL_RESERVED_SIZE SHARED_POOL_SIZE 266syn keyword oraKeyword SORT_AREA_RETAINED_SIZE SORT_AREA_SIZE SORT_MULTIBLOCK_READ_COUNT 267syn keyword oraKeyword SQL92_SECURITY SQL_TRACE STANDBY_ARCHIVE_DEST 268syn keyword oraKeyword STAR_TRANSFORMATION_ENABLED TAPE_ASYNCH_IO THREAD 269syn keyword oraKeyword TIMED_OS_STATISTICS TIMED_STATISTICS 270syn keyword oraKeyword TRANSACTION_AUDITING TRANSACTIONS TRANSACTIONS_PER_ROLLBACK_SEGMENT 271syn keyword oraKeyword USE_INDIRECT_DATA_BUFFERS USER_DUMP_DEST 272syn keyword oraKeyword UTL_FILE_DIR 273syn keyword oraKeywordObs ALLOW_PARTIAL_SN_RESULTS B_TREE_BITMAP_PLANS 274syn keyword oraKeywordObs BACKUP_DISK_IO_SLAVES CACHE_SIZE_THRESHOLD 275syn keyword oraKeywordObs CCF_IO_SIZE CLEANUP_ROLLBACK_ENTRIES 276syn keyword oraKeywordObs CLOSE_CACHED_OPEN_CURSORS COMPATIBLE_NO_RECOVERY 277syn keyword oraKeywordObs COMPLEX_VIEW_MERGING 278syn keyword oraKeywordObs DB_BLOCK_CHECKPOINT_BATCH DB_BLOCK_LRU_EXTENDED_STATISTICS 279syn keyword oraKeywordObs DB_BLOCK_LRU_STATISTICS 280syn keyword oraKeywordObs DISTRIBUTED_LOCK_TIMEOUT DISTRIBUTED_RECOVERY_CONNECTION_HOLD_TIME 281syn keyword oraKeywordObs FAST_FULL_SCAN_ENABLED GC_LATCHES GC_LCK_PROCS 282syn keyword oraKeywordObs LARGE_POOL_MIN_ALLOC LGWR_IO_SLAVES 283syn keyword oraKeywordObs LOG_BLOCK_CHECKSUM LOG_FILES 284syn keyword oraKeywordObs LOG_SIMULTANEOUS_COPIES LOG_SMALL_ENTRY_MAX_SIZE 285syn keyword oraKeywordObs MAX_TRANSACTION_BRANCHES 286syn keyword oraKeywordObs MTS_LISTENER_ADDRESS MTS_MULTIPLE_LISTENERS 287syn keyword oraKeywordObs MTS_RATE_LOG_SIZE MTS_RATE_SCALE MTS_SERVICE 288syn keyword oraKeywordObs OGMS_HOME OPS_ADMIN_GROUP 289syn keyword oraKeywordObs PARALLEL_DEFAULT_MAX_INSTANCES PARALLEL_MIN_MESSAGE_POOL 290syn keyword oraKeywordObs PARALLEL_SERVER_IDLE_TIME PARALLEL_TRANSACTION_RESOURCE_TIMEOUT 291syn keyword oraKeywordObs PUSH_JOIN_PREDICATE REDUCE_ALARM ROW_CACHE_CURSORS 292syn keyword oraKeywordObs SEQUENCE_CACHE_ENTRIES SEQUENCE_CACHE_HASH_BUCKETS 293syn keyword oraKeywordObs SHARED_POOL_RESERVED_MIN_ALLOC 294syn keyword oraKeywordObs SORT_DIRECT_WRITES SORT_READ_FAC SORT_SPACEMAP_SIZE 295syn keyword oraKeywordObs SORT_WRITE_BUFFER_SIZE SORT_WRITE_BUFFERS 296syn keyword oraKeywordObs SPIN_COUNT TEMPORARY_TABLE_LOCKS USE_ISM 297syn keyword oraValue db os full partial mandatory optional reopen enable defer 298syn keyword oraValue always default intent disable dml plsql temp_disable 299syn match oravalue "Arabic Hijrah" 300syn match oravalue "English Hijrah" 301syn match oravalue "Gregorian" 302syn match oravalue "Japanese Imperial" 303syn match oravalue "Persian" 304syn match oravalue "ROC Official" 305syn match oravalue "Thai Buddha" 306syn match oravalue "8.0.0" 307syn match oravalue "8.0.3" 308syn match oravalue "8.0.4" 309syn match oravalue "8.1.3" 310syn match oraModifier "archived log" 311syn match oraModifier "backup corruption" 312syn match oraModifier "backup datafile" 313syn match oraModifier "backup piece " 314syn match oraModifier "backup redo log" 315syn match oraModifier "backup set" 316syn match oraModifier "copy corruption" 317syn match oraModifier "datafile copy" 318syn match oraModifier "deleted object" 319syn match oraModifier "loghistory" 320syn match oraModifier "offline range" 321 322"undocumented init params 323"up to 7.2 (inclusive) 324syn keyword oraKeywordUndObs _latch_spin_count _trace_instance_termination 325syn keyword oraKeywordUndObs _wakeup_timeout _lgwr_async_write 326"7.3 327syn keyword oraKeywordUndObs _standby_lock_space_name _enable_dba_locking 328"8.0.5 329syn keyword oraKeywordUnd _NUMA_instance_mapping _NUMA_pool_size 330syn keyword oraKeywordUnd _advanced_dss_features _affinity_on _all_shared_dblinks 331syn keyword oraKeywordUnd _allocate_creation_order _allow_resetlogs_corruption 332syn keyword oraKeywordUnd _always_star_transformation _bump_highwater_mark_count 333syn keyword oraKeywordUnd _column_elimination_off _controlfile_enqueue_timeout 334syn keyword oraKeywordUnd _corrupt_blocks_on_stuck_recovery _corrupted_rollback_segments 335syn keyword oraKeywordUnd _cr_deadtime _cursor_db_buffers_pinned 336syn keyword oraKeywordUnd _db_block_cache_clone _db_block_cache_map _db_block_cache_protect 337syn keyword oraKeywordUnd _db_block_hash_buckets _db_block_hi_priority_batch_size 338syn keyword oraKeywordUnd _db_block_max_cr_dba _db_block_max_scan_cnt 339syn keyword oraKeywordUnd _db_block_med_priority_batch_size _db_block_no_idle_writes 340syn keyword oraKeywordUnd _db_block_write_batch _db_handles _db_handles_cached 341syn keyword oraKeywordUnd _db_large_dirty_queue _db_no_mount_lock 342syn keyword oraKeywordUnd _db_writer_histogram_statistics _db_writer_scan_depth 343syn keyword oraKeywordUnd _db_writer_scan_depth_decrement _db_writer_scan_depth_increment 344syn keyword oraKeywordUnd _disable_incremental_checkpoints 345syn keyword oraKeywordUnd _disable_latch_free_SCN_writes_via_32cas 346syn keyword oraKeywordUnd _disable_latch_free_SCN_writes_via_64cas 347syn keyword oraKeywordUnd _disable_logging _disable_ntlog_events 348syn keyword oraKeywordUnd _dss_cache_flush _dynamic_stats_threshold 349syn keyword oraKeywordUnd _enable_cscn_caching _enable_default_affinity 350syn keyword oraKeywordUnd _enqueue_debug_multi_instance _enqueue_hash 351syn keyword oraKeywordUnd _enqueue_hash_chain_latches _enqueue_locks 352syn keyword oraKeywordUnd _fifth_spare_parameter _first_spare_parameter _fourth_spare_parameter 353syn keyword oraKeywordUnd _gc_class_locks _groupby_nopushdown_cut_ratio 354syn keyword oraKeywordUnd _idl_conventional_index_maintenance _ignore_failed_escalates 355syn keyword oraKeywordUnd _init_sql_file 356syn keyword oraKeywordUnd _io_slaves_disabled _ioslave_batch_count _ioslave_issue_count 357syn keyword oraKeywordUnd _kgl_bucket_count _kgl_latch_count _kgl_multi_instance_invalidation 358syn keyword oraKeywordUnd _kgl_multi_instance_lock _kgl_multi_instance_pin 359syn keyword oraKeywordUnd _latch_miss_stat_sid _latch_recovery_alignment _latch_wait_posting 360syn keyword oraKeywordUnd _lm_ast_option _lm_direct_sends _lm_dlmd_procs _lm_domains _lm_groups 361syn keyword oraKeywordUnd _lm_non_fault_tolerant _lm_send_buffers _lm_statistics _lm_xids 362syn keyword oraKeywordUnd _log_blocks_during_backup _log_buffers_debug _log_checkpoint_recovery_check 363syn keyword oraKeywordUnd _log_debug_multi_instance _log_entry_prebuild_threshold _log_io_size 364syn keyword oraKeywordUnd _log_space_errors 365syn keyword oraKeywordUnd _max_exponential_sleep _max_sleep_holding_latch 366syn keyword oraKeywordUnd _messages _minimum_giga_scn _mts_load_constants _nested_loop_fudge 367syn keyword oraKeywordUnd _no_objects _no_or_expansion 368syn keyword oraKeywordUnd _number_cached_attributes _offline_rollback_segments _open_files_limit 369syn keyword oraKeywordUnd _optimizer_undo_changes 370syn keyword oraKeywordUnd _oracle_trace_events _oracle_trace_facility_version 371syn keyword oraKeywordUnd _ordered_nested_loop _parallel_server_sleep_time 372syn keyword oraKeywordUnd _passwordfile_enqueue_timeout _pdml_slaves_diff_part 373syn keyword oraKeywordUnd _plsql_dump_buffer_events _predicate_elimination_enabled 374syn keyword oraKeywordUnd _project_view_columns 375syn keyword oraKeywordUnd _px_broadcast_fudge_factor _px_broadcast_trace _px_dop_limit_degree 376syn keyword oraKeywordUnd _px_dop_limit_threshold _px_kxfr_granule_allocation _px_kxib_tracing 377syn keyword oraKeywordUnd _release_insert_threshold _reuse_index_loop 378syn keyword oraKeywordUnd _rollback_segment_count _rollback_segment_initial 379syn keyword oraKeywordUnd _row_cache_buffer_size _row_cache_instance_locks 380syn keyword oraKeywordUnd _save_escalates _scn_scheme 381syn keyword oraKeywordUnd _second_spare_parameter _session_idle_bit_latches 382syn keyword oraKeywordUnd _shared_session_sort_fetch_buffer _single_process 383syn keyword oraKeywordUnd _small_table_threshold _sql_connect_capability_override 384syn keyword oraKeywordUnd _sql_connect_capability_table 385syn keyword oraKeywordUnd _test_param_1 _test_param_2 _test_param_3 386syn keyword oraKeywordUnd _third_spare_parameter _tq_dump_period 387syn keyword oraKeywordUnd _trace_archive_dest _trace_archive_start _trace_block_size 388syn keyword oraKeywordUnd _trace_buffers_per_process _trace_enabled _trace_events 389syn keyword oraKeywordUnd _trace_file_size _trace_files_public _trace_flushing _trace_write_batch_size 390syn keyword oraKeywordUnd _upconvert_from_ast _use_vector_post _wait_for_sync _walk_insert_threshold 391"dunno which version; may be 8.1.x, may be obsoleted 392syn keyword oraKeywordUndObs _arch_io_slaves _average_dirties_half_life _b_tree_bitmap_plans 393syn keyword oraKeywordUndObs _backup_disk_io_slaves _backup_io_pool_size 394syn keyword oraKeywordUndObs _cleanup_rollback_entries _close_cached_open_cursors 395syn keyword oraKeywordUndObs _compatible_no_recovery _complex_view_merging 396syn keyword oraKeywordUndObs _cpu_to_io _cr_server 397syn keyword oraKeywordUndObs _db_aging_cool_count _db_aging_freeze_cr _db_aging_hot_criteria 398syn keyword oraKeywordUndObs _db_aging_stay_count _db_aging_touch_time 399syn keyword oraKeywordUndObs _db_percent_hot_default _db_percent_hot_keep _db_percent_hot_recycle 400syn keyword oraKeywordUndObs _db_writer_chunk_writes _db_writer_max_writes 401syn keyword oraKeywordUndObs _dbwr_async_io _dbwr_tracing 402syn keyword oraKeywordUndObs _defer_multiple_waiters _discrete_transaction_enabled 403syn keyword oraKeywordUndObs _distributed_lock_timeout _distributed_recovery _distribited_recovery_ 404syn keyword oraKeywordUndObs _domain_index_batch_size _domain_index_dml_batch_size 405syn keyword oraKeywordUndObs _enable_NUMA_optimization _enable_block_level_transaction_recovery 406syn keyword oraKeywordUndObs _enable_list_io _enable_multiple_sampling 407syn keyword oraKeywordUndObs _fairness_treshold _fast_full_scan_enabled _foreground_locks 408syn keyword oraKeywordUndObs _full_pwise_join_enabled _gc_latches _gc_lck_procs 409syn keyword oraKeywordUndObs _high_server_treshold _index_prefetch_factor _kcl_debug 410syn keyword oraKeywordUndObs _kkfi_trace _large_pool_min_alloc _lazy_freelist_close _left_nested_loops_random 411syn keyword oraKeywordUndObs _lgwr_async_io _lgwr_io_slaves _lock_sga_areas 412syn keyword oraKeywordUndObs _log_archive_buffer_size _log_archive_buffers _log_simultaneous_copies 413syn keyword oraKeywordUndObs _low_server_treshold _max_transaction_branches 414syn keyword oraKeywordUndObs _mts_rate_log_size _mts_rate_scale 415syn keyword oraKeywordUndObs _mview_cost_rewrite _mview_rewrite_2 416syn keyword oraKeywordUndObs _ncmb_readahead_enabled _ncmb_readahead_tracing 417syn keyword oraKeywordUndObs _ogms_home 418syn keyword oraKeywordUndObs _parallel_adaptive_max_users _parallel_default_max_instances 419syn keyword oraKeywordUndObs _parallel_execution_message_align _parallel_fake_class_pct 420syn keyword oraKeywordUndObs _parallel_load_bal_unit _parallel_load_balancing 421syn keyword oraKeywordUndObs _parallel_min_message_pool _parallel_recovery_stopat 422syn keyword oraKeywordUndObs _parallel_server_idle_time _parallelism_cost_fudge_factor 423syn keyword oraKeywordUndObs _partial_pwise_join_enabled _pdml_separate_gim _push_join_predicate 424syn keyword oraKeywordUndObs _px_granule_size _px_index_sampling _px_load_publish_interval 425syn keyword oraKeywordUndObs _px_max_granules_per_slave _px_min_granules_per_slave _px_no_stealing 426syn keyword oraKeywordUndObs _row_cache_cursors _serial_direct_read _shared_pool_reserved_min_alloc 427syn keyword oraKeywordUndObs _sort_space_for_write_buffers _spin_count _system_trig_enabled 428syn keyword oraKeywordUndObs _trace_buffer_flushes _trace_cr_buffer_creates _trace_multi_block_reads 429syn keyword oraKeywordUndObs _transaction_recovery_servers _use_ism _yield_check_interval 430 431 432syn cluster oraAll add=oraKeyword,oraKeywordGroup,oraKeywordPref,oraKeywordObs,oraKeywordUnd,oraKeywordUndObs 433syn cluster oraAll add=oraValue,oraModifier,oraString,oraSpecial,oraComment 434 435"============================================================================== 436" highlighting 437 438" Only when an item doesn't have highlighting yet 439 440hi def link oraKeyword Statement "usual keywords 441hi def link oraKeywordGroup Type "keywords which group other keywords 442hi def link oraKeywordPref oraKeywordGroup "keywords which act as prefixes 443hi def link oraKeywordObs Todo "obsolete keywords 444hi def link oraKeywordUnd PreProc "undocumented keywords 445hi def link oraKeywordUndObs oraKeywordObs "undocumented obsolete keywords 446hi def link oraValue Identifier "values, like true or false 447hi def link oraModifier oraValue "modifies values 448hi def link oraString String "strings 449 450hi def link oraSpecial Special "special characters 451hi def link oraError Error "errors 452hi def link oraParenError oraError "errors caused by mismatching parantheses 453 454hi def link oraComment Comment "comments 455 456 457 458let b:current_syntax = "ora" 459 460if main_syntax == 'ora' 461 unlet main_syntax 462endif 463 464" vim: ts=8 465