7
|
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
|