Mercurial > vim

comparison runtime/syntax/ora.vim @ 7:3fc0f57ecb91 v7.0001

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