| Bram Moolenaar | 071d427 | 2004-06-13 20:20:40 +0000 | [diff] [blame] | 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 |