x$abstract_lob | |
x$activeckpt | |
x$all_ash | referenced in x$kqfdt |
x$all_keswxmon | referenced in x$kqfdt |
x$all_keswxmon_plan | referenced in x$kqfdt |
x$all_kqlfxpl | referenced in x$kqfdt |
x$aq_message_cache_advice | |
x$aq_opt_cached_subshard | |
x$aq_opt_inactive_subshard | |
x$aq_opt_stats | |
x$aq_opt_uncached_subshard | |
x$aq_remote_deqaff | |
x$aq_subscriber_load | |
x$aq_subtrans | |
x$ash | |
x$ash_for_awr | |
x$aud_dpapi_actions | |
x$aud_dp_actions | |
x$aud_dv_obj_events | |
x$aud_obj_actions | |
x$aud_ols_actions | |
x$aud_protocol_actions | |
x$aud_xs_actions | |
x$bh | Buffer header |
x$bmapnondursub | |
x$buffer | |
x$buffer2 | |
x$buffered_publishers | |
x$buffered_queues | |
x$buffered_subscribers | |
x$cdbvw$ | |
x$cell_name | |
x$ckptbuf | |
x$comvw$ | |
x$con | |
x$context | |
x$con_kewmdrmv | |
x$con_kewmsmdv | |
x$con_kewssysv | |
x$con_kslei | |
x$con_kslscs | |
x$con_kslseshist_micro | |
x$con_ksusgsta | |
x$dbgalertext | Content of the alert log. |
x$dbgatflist | |
x$dbgdirext | |
x$dbglogext | |
x$dbgricx | |
x$dbgrifx | |
x$dbgrikx | |
x$dbgripx | |
x$dbgtflist | |
x$dbgtfoptt | |
x$dbgtfsoptt | |
x$dbgtfsqlt | |
x$dbgtfssqlt | |
x$dbgtfview | Contents of trace files? |
x$dbkece | |
x$dbkefafc | |
x$dbkefdeafc | |
x$dbkefefc | |
x$dbkefiefc | |
x$dbkfdg | |
x$dbkfset | |
x$dbkh_check | |
x$dbkh_check_param | |
x$dbkincmetcfg | |
x$dbkincmetinfo | |
x$dbkincmetsummary | |
x$dbkinfo | |
x$dbkreco | |
x$dbkrun | Executions of database structure integrity checks? |
x$dbreplay_patch_info | |
x$dglparam | |
x$dglxdat | |
x$diag_adr_control | |
x$diag_adr_control_aux | |
x$diag_adr_invalidation | |
x$diag_alert_ext | Alert file? |
x$diag_ams_xaction | |
x$diag_dde_user_action | |
x$diag_dde_user_action_def | |
x$diag_dde_usr_act_param | |
x$diag_dde_usr_act_param_def | |
x$diag_dde_usr_inc_act_map | |
x$diag_dde_usr_inc_type | |
x$diag_dfw_config_capture | |
x$diag_dfw_config_item | |
x$diag_dfw_patch_capture | |
x$diag_dfw_patch_item | |
x$diag_dfw_purge | |
x$diag_dfw_purge_item | |
x$diag_diagv_incident | |
x$diag_dir_ext | |
x$diag_em_diag_job | |
x$diag_em_target_info | |
x$diag_em_user_activity | |
x$diag_hm_fdg_set | |
x$diag_hm_finding | |
x$diag_hm_info | |
x$diag_hm_message | |
x$diag_hm_recommendation | |
x$diag_hm_run | |
x$diag_incckey | |
x$diag_incident | |
x$diag_incident_file | |
x$diag_inc_meter_config | |
x$diag_inc_meter_impt_def | |
x$diag_inc_meter_info | |
x$diag_inc_meter_pk_impts | |
x$diag_inc_meter_summary | |
x$diag_info | |
x$diag_ips_configuration | |
x$diag_ips_file_copy_log | |
x$diag_ips_file_metadata | |
x$diag_ips_package | |
x$diag_ips_package_file | |
x$diag_ips_package_history | |
x$diag_ips_package_incident | |
x$diag_ips_pkg_unpack_hist | |
x$diag_ips_progress_log | |
x$diag_ips_remote_package | |
x$diag_log_ext | |
x$diag_pdb_problem | |
x$diag_pdb_space_mgmt | |
x$diag_pickleerr | |
x$diag_problem | |
x$diag_relmd_ext | |
x$diag_sweeperr | |
x$diag_vadr_control | |
x$diag_vem_user_actlog | |
x$diag_vem_user_actlog1 | |
x$diag_vhm_run | |
x$diag_view | |
x$diag_viewcol | |
x$diag_vincident | |
x$diag_vincident_file | |
x$diag_vinc_meter_info | |
x$diag_vips_file_copy_log | |
x$diag_vips_file_metadata | |
x$diag_vips_package_file | |
x$diag_vips_package_history | |
x$diag_vips_package_main_int | |
x$diag_vips_package_size | |
x$diag_vips_pkg_file | |
x$diag_vips_pkg_inc_cand | |
x$diag_vips_pkg_inc_dtl | |
x$diag_vips_pkg_inc_dtl1 | |
x$diag_vips_pkg_main_problem | |
x$diag_vnot_exist_incident | |
x$diag_vpdb_problem | |
x$diag_vproblem | |
x$diag_vproblem1 | |
x$diag_vproblem2 | |
x$diag_vproblem_bucket | |
x$diag_vproblem_bucket1 | |
x$diag_vproblem_bucket_count | |
x$diag_vproblem_int | |
x$diag_vproblem_lastinc | |
x$diag_vshowcatview | |
x$diag_vshowincb | |
x$diag_vshowincb_i | |
x$diag_vtest_exists | |
x$diag_v_actinc | |
x$diag_v_actprob | |
x$diag_v_inccount | |
x$diag_v_incfcount | |
x$diag_v_inc_meter_info_prob | |
x$diag_v_ipsprbcnt | |
x$diag_v_ipsprbcnt1 | |
x$diag_v_nfcinc | |
x$diag_v_swperrcount | |
x$dir | |
x$dnfs_channels | |
x$dnfs_files | |
x$dnfs_hist | |
x$dnfs_meta | |
x$dnfs_servers | |
x$dnfs_stats | |
x$dra_failure | |
x$dra_failure_check | |
x$dra_failure_check_map | |
x$dra_failure_param | |
x$dra_failure_parent_map | |
x$dra_failure_repair | |
x$dra_failure_repair_map | |
x$dra_repair | |
x$dra_repair_param | |
x$drc | Related to Data Guard? |
x$drm_history | |
x$drm_history_stats | |
x$drm_wait_stats | |
x$dual | |
x$durable_sharded_subs | |
x$estimated_mttr | |
x$gcractions | |
x$gcrlog | |
x$gcrmetrics | |
x$gcrstatus | |
x$gimsa | |
x$globalcontext | |
x$gsmregions | |
x$gwmraff | |
x$heatmapsegment | |
x$heatmapsegment1 | |
x$hofp | |
x$hs_session | |
x$iee | |
x$iee_condition | |
x$iee_orpiece | |
x$imcsegextmap | |
x$imcsegments | |
x$imctbsextmap | |
x$imhmseg | |
x$imhmseg1 | |
x$instance_cache_transfer | |
x$ipcor_topo_domain | |
x$ipcor_topo_ndev | |
x$ir_manual_option | |
x$ir_repair_option | |
x$ir_repair_step | |
x$ir_rs_param | |
x$ir_wf_param | |
x$ir_working_failure_set | |
x$ir_working_repair_set | |
x$ir_wr_param | |
x$joxdrc | referenced in x$kqfdt |
x$joxdrr | referenced in x$kqfdt |
x$joxfc | referenced in x$kqfdt |
x$joxfd | referenced in x$kqfdt |
x$joxfr | referenced in x$kqfdt |
x$joxfs | referenced in x$kqfdt |
x$joxfm | |
x$joxft | |
x$joxmag | referenced in x$kqfdt |
x$joxmex | referenced in x$kqfdt |
x$joxmfd | referenced in x$kqfdt |
x$joxmic | referenced in x$kqfdt |
x$joxmif | referenced in x$kqfdt |
x$joxmmd | referenced in x$kqfdt |
x$joxmob | referenced in x$kqfdt |
x$joxobj | referenced in x$kqfdt |
x$joxref | referenced in x$kqfdt |
x$joxrsv | referenced in x$kqfdt |
x$joxscd | referenced in x$kqfdt |
x$jsimtft | |
x$jskjobq | |
x$jskmimmd | |
x$jskmimrt | |
x$jskslv | |
x$k2gte | 2PC global transaction entries. The column k2gtdses has the session state object and can be joined to the saddr column of v$session . x$k2gte can thus be used to find open database links, see v$dblink . |
x$k2gte2 | |
x$kauvrstat | |
x$kbrpstat | |
x$kcbbes | |
x$kcbbf | |
x$kcbbhs | |
x$kcbdbk | |
x$kcbdwobj | |
x$kcbdws | |
x$kcbfcio | |
x$kcbfwait | |
x$kcbinstview | |
x$kcbkpfs | |
x$kcbkwrl | |
x$kcbldrhist | |
x$kcblsc | |
x$kcbmkid | |
x$kcbmmav | |
x$kcbobh | |
x$kcboqh | |
x$kcbpdbrm | |
x$kcbpintime | |
x$kcbprfh | |
x$kcbsc | |
x$kcbsds | |
x$kcbsh | |
x$kcbsw | |
x$kcbtek | |
x$kcbuwhy | |
x$kcbwait | |
x$kcbwbpd | Working pool descriptions? |
x$kcbwds | Working data set? |
x$kcbwh | |
x$kccacm | |
x$kccadfc | |
x$kccagf | |
x$kccal | Archived logs |
x$kccbf | |
x$kccbi | |
x$kccbl | |
x$kccblkcor | |
x$kccbp | Autobackup? |
x$kccbs | |
x$kcccc | |
x$kcccf | Name and characteristics(?) of Control files. |
x$kcccp | Checkpoint progress |
x$kccdc | |
x$kccdfhist | |
x$kccdi | |
x$kccdi2 | |
x$kccdl | |
x$kccfc | |
x$kccfe | File Entries (from Control files) |
x$kccfle | |
x$kccfn | Database files and log files (fntyp = 3 ) |
x$kccic | |
x$kccirt | |
x$kccle | Log information |
x$kcclh | log history |
x$kccnrs | |
x$kccor | |
x$kccpa | |
x$kccpd | |
x$kccpdb | |
x$kccpic | |
x$kccrdi | Base for v$recovery_file_dest |
x$kccrl | |
x$kccrm | RMAN configuration? |
x$kccrs | |
x$kccrsp | |
x$kccrsr | |
x$kccrt | (Current?) redo thread? |
x$kccsl | |
x$kcctf | |
x$kcctir | |
x$kcctkh | |
x$kccts | Tablespaces |
x$kcfio | (Data?)file I/O statistics |
x$kcfiofchist | |
x$kcfiohist | |
x$kcfiscap | Capabilities? |
x$kcfisoss | |
x$kcfisossawr | |
x$kcfisossc | |
x$kcfisossl | |
x$kcfisossn | |
x$kcfisosst | |
x$kcfistcap | |
x$kcfistsa | |
x$kcftio | |
x$kclcrst | |
x$kclcurst | |
x$kclfx | |
x$kclls | |
x$kclpingpin | |
x$kclpingwev | |
x$kclrcvst | |
x$kcmscn | |
x$kcnt | |
x$kcpdbinc | |
x$kcpxpl | |
x$kcrfdebug | |
x$kcrfstrand | |
x$kcrfws | |
x$kcrfx | |
x$kcrmf | |
x$kcrmt | |
x$kcrmx | |
x$kcrrarch | |
x$kcrrastats | |
x$kcrrdstat | |
x$kcrrlns | |
x$kcrrnhg | |
x$kcticw | |
x$kctlax | |
x$kcvdf | |
x$kcvfh | File headers |
x$kcvfhall | referenced in x$kqfdt |
x$kcvfhmrr | referenced in x$kqfdt |
x$kcvfhonl | referenced in x$kqfdt |
x$kcvfhtmp | |
x$kdkvimhashindex | |
x$kdkvimhashindex_objects | |
x$kdlt | |
x$kdlu_stat | |
x$kdmadoelements | |
x$kdmadotaskdetails | |
x$kdmadotasks | |
x$kdmimccol | |
x$kdmimchead | |
x$kdmimdeltahead | |
x$kdmimeucol | |
x$kdmimeuhead | |
x$kdmufaststartarea | |
x$kdmuglobaldict | |
x$kdmuglobaldictpmap | |
x$kdmuglobaldictso | |
x$kdmuglobaldictver | |
x$kdnssf | |
x$kdxhs | |
x$kdxst | |
x$kdzcolcl | |
x$kd_column_statistics | |
x$keacmdn | SQL (advisory) commands; dba_advisor_commands selects from x$keacmdn |
x$keafdgn | |
x$keaobjt | |
x$kecpdentry | |
x$kecprt | |
x$kecptc | |
x$kecuc_cache | |
x$kec_component_timing | |
x$kec_progress | |
x$keheclmap | |
x$kehetsx | |
x$kehevtmap | |
x$kehf | |
x$kehosmap | |
x$kehprmmap | |
x$kehr | |
x$kehrp | |
x$kehr_child | |
x$kehsqt | |
x$kehsysmap | |
x$kehtimmap | |
x$keiut | |
x$keiut_info | |
x$kelrsga | |
x$kelrtd | |
x$kelrxmr | |
x$keltgsd | |
x$keltosd | |
x$keltsd | |
x$keomm_dbop_list | |
x$keomnmon_sesstat | |
x$kerpirepreq | |
x$kerpistats | |
x$kesmasmon | |
x$kesmasmon_stat | |
x$kesmasmon_hist | |
x$kesplan | |
x$kesspamet | |
x$keswxmon | |
x$keswxmon_plan | |
x$keswxmon_statname | |
x$ketcl | Referenced in dba_autotask_job_history |
x$ketop | |
x$kettg | |
x$keumlinktb | |
x$keumregtb | |
x$keumsvctb | |
x$keumtb | |
x$keumtoptb | |
x$kewam | |
x$kewash | |
x$kewcimpstgtb | |
x$kewecls | |
x$kewefxt | |
x$kewepcs | |
x$kewesmas | |
x$kewesms | |
x$kewflinfo | |
x$kewmafmv | |
x$kewmchkmv | |
x$kewmdrmv | |
x$kewmdsm | |
x$kewmevmv | |
x$kewmflmv | |
x$kewmgsm | |
x$kewmiofmv | |
x$kewmrmgmv | |
x$kewmrmpdbmv | |
x$kewmrsm | |
x$kewmrwmv | |
x$kewmsemv | |
x$kewmsmdv | |
x$kewmsrgmv | |
x$kewmsvcmv | |
x$kewmwcrmv | |
x$kewmwpcmv | |
x$kewpdbinsnap | |
x$kewrattrnew | |
x$kewrattrstale | |
x$kewrcache | |
x$kewrconidlookup | |
x$kewrimsegstat | |
x$kewripsl | |
x$kewrsqlcrit | |
x$kewrsqlidtab | |
x$kewrsqlsum | |
x$kewrstgtb | |
x$kewrtb | |
x$kewrtbgm | |
x$kewrtb_all | |
x$kewrtoptenv | |
x$kewrtsegstat | |
x$kewrtsqlplan | |
x$kewrtsqltext | |
x$kewssesv | |
x$kewssmap | |
x$kewssvcv | |
x$kewssysv | |
x$kewxocf | |
x$kewx_indexes | |
x$kewx_lobs | |
x$kewx_segments | |
x$kexsvfu | |
x$kexsvus | |
x$kfals | |
x$kfbf | |
x$kfbh | |
x$kfbtyp | |
x$kfcbh | |
x$kfcce | |
x$kfclle | |
x$kfcsga | |
x$kfcstat | |
x$kfcte | |
x$kfctet | |
x$kfctet_delta | |
x$kfdap | |
x$kfdat | |
x$kfddd | |
x$kfdfs | |
x$kfdpartner | |
x$kfdsd | |
x$kfdsk | |
x$kfdsk_sparse | |
x$kfdsk_sparse_stat | |
x$kfdsk_stat | |
x$kfdsr | |
x$kfdxext | |
x$kfenv | |
x$kffg | |
x$kffgf | |
x$kffgpt | |
x$kffil | |
x$kffil_sparse | |
x$kffof | |
x$kffscrub | |
x$kffxp | |
x$kfgbrb | |
x$kfgbrc | |
x$kfgbrs | |
x$kfgbrw | |
x$kfgmg | |
x$kfgrp | |
x$kfgrp_sparse | |
x$kfgrp_stat | |
x$kfgxp | |
x$kfias_clnt | |
x$kfias_file | |
x$kfias_proc | |
x$kfipcompat | |
x$kfkid | |
x$kfklib | |
x$kfklsod | |
x$kfmdgrp | |
x$kfncl | |
x$kfncwcl | |
x$kfndiosprs | |
x$kfnrcl | |
x$kfnsdskiost | |
x$kfqg | |
x$kfrc | |
x$kftmta | |
x$kfvacfs | |
x$kfvacfsa | |
x$kfvacfsadmin | |
x$kfvacfscmdrule | |
x$kfvacfsencr | |
x$kfvacfsrealm | |
x$kfvacfsrealmfilter | |
x$kfvacfsrealmgroup | |
x$kfvacfsrealms | |
x$kfvacfsrealmuser | |
x$kfvacfsrepl | |
x$kfvacfsrepltag | |
x$kfvacfsrule | |
x$kfvacfsruleset | |
x$kfvacfsrulesetrule | |
x$kfvacfss | |
x$kfvacfstag | |
x$kfvacfsv | |
x$kfvol | |
x$kfvolstat | |
x$kfzgdr | |
x$kfzpblk | |
x$kfzuagr | |
x$kfzudr | |
x$kghlu | summary of shared pool (sub)heap allocations and how many of these chunks are in the «transient list» (used once) vs. «recurrent list» (used more than once). (Does it show one record per shared pool area? Does it add another record if there is a Java pool?) |
x$kgics | |
x$kglau | |
x$kglbody | referenced in x$kqfdt |
x$kglcluster | referenced in x$kqfdt |
x$kglcursor | referenced in x$kqfdt |
x$kglcursor_child | referenced in x$kqfdt |
x$kglcursor_child_sqlid | referenced in x$kqfdt |
x$kglcursor_child_sqlidph | referenced in x$kqfdt |
x$kglcursor_parent | referenced in x$kqfdt |
x$kgldp | Object dependency |
x$kglindex | Indices? referenced in x$kqfdt |
x$kgljmem | |
x$kgljsim | |
x$kgllk | List all library object locks, held or requested. |
x$kglmem | |
x$kglna | Names? |
x$kglna1 | |
x$kglob | Objects? |
x$kglobxml | |
x$kglpn | |
x$kglrd | |
x$kglsim | |
x$kglsn | |
x$kglsqltxl | referenced in x$kqfdt |
x$kglst | |
x$kgltable | Tables? referenced in x$kqfdt |
x$kgltr | |
x$kgltrigger | Triggers? referenced in x$kqfdt |
x$kglxs | Library cache access |
x$kgscc | |
x$kgskasp | |
x$kgskcft | |
x$kgskcp | |
x$kgskdopp | |
x$kgskmeminfo | |
x$kgskncft | |
x$kgskpdbft | |
x$kgskpdbhistft | |
x$kgskpft | |
x$kgskpp | |
x$kgskquep | |
x$kgskscs | |
x$kgskte | |
x$kgskto | |
x$kgskvft | |
x$kjac_config | |
x$kjac_id | |
x$kjac_my_id | |
x$kjbfpbr | |
x$kjbl | |
x$kjblfx | |
x$kjbr | |
x$kjbrfx | |
x$kjcisot | |
x$kjcispt | |
x$kjctfr | |
x$kjctfri | |
x$kjctfs | |
x$kjdddeadlocks | |
x$kjdddeadlockses | |
x$kjdrbh | |
x$kjdrhv | |
x$kjdrmafnstats | |
x$kjdrmhvstats | |
x$kjdrmreadmostlystats | |
x$kjdrmreq | |
x$kjdrpcmhv | |
x$kjdrpcmpf | |
x$kjfmhbacl | |
x$kjicvt | |
x$kjidt | |
x$kjilft | |
x$kjilkft | |
x$kjirft | |
x$kjisft | |
x$kjitrft | |
x$kjkmkga | |
x$kjkmlock | |
x$kjkmreq | |
x$kjleqfp | |
x$kjmddp | |
x$kjmsdp | |
x$kjpmprc | |
x$kjpnpx | |
x$kjreqfp | |
x$kjrtbcfp | |
x$kjr_chunk_stats | |
x$kjr_freeable_chunks | |
x$kjscapkat | |
x$kjscasvcat | |
x$kjxgna_stats | |
x$kjxm | |
x$kjzncbhangs | |
x$kjznhangs | |
x$kjznhangses | |
x$kjznhmlsi | |
x$kjznhngmgrsts | |
x$kjznhngstats | |
x$kjznrslnrc | |
x$kjznwlmpcrank | |
x$kjzsiwtevt | |
x$kkaeet | |
x$kkcnereg | |
x$kkcneregstat | |
x$kkcnrstat | |
x$kkkicr | |
x$kkoar_hint | |
x$kkocs_histogram | |
x$kkocs_selectivity | |
x$kkocs_statistics | |
x$kksai | … allocation info |
x$kksbv | … bind variables |
x$kkscs | («reason») |
x$kkspcib | |
x$kkssqlstat | ? SQL/Cursor statistics ? |
x$kkssqlstat_plan_hash | referenced in x$kqfdt |
x$kkssrd | |
x$kksxsqlstat | |
x$klcie | |
x$klpt | |
x$kmcqs | |
x$kmcvc | |
x$kmgsbsadv | |
x$kmgsbsmemadv | |
x$kmgsct | Referenced in v$memory_dynamic_components and v$memory_dynamic_components . See also the result of the query select * from v$fixed_view_definition where view_name in ('GV$SGA_DYNAMIC_COMPONENTS', 'GV$MEMORY_DYNAMIC_COMPONENTS'); . See also x$ksmge . |
x$kmgsop | |
x$kmgstfr | |
x$kmmdi | |
x$kmmdp | |
x$kmmhst | |
x$kmmnv | |
x$kmmrd | |
x$kmmsas | |
x$kmmsg | |
x$kmmsi | |
x$kmpcmon | |
x$kmpcp | |
x$kmpcso | |
x$kmpdh | |
x$kmpsrv | |
x$kngfl | |
x$kngfle | |
x$knlarow | |
x$knlasg | |
x$knlpmsgstat | |
x$knlp_actv_msgs | |
x$knlp_pend_msgs | |
x$knstacr | |
x$knstanr | |
x$knstasl | |
x$knstcap | |
x$knstcapcache | |
x$knstcaps | |
x$knstmt | |
x$knstmvr | |
x$knstoggc | |
x$knstord | |
x$knstpsts | |
x$knstrpp | |
x$knstrqu | |
x$knstsess | |
x$knsttxn | |
x$knstxsts | |
x$kocst | |
x$kpdbvproxy | |
x$kpondconstat | |
x$kpondestat | |
x$kponestat | |
x$kponjstat | |
x$kpoqsta | |
x$kpoxft | |
x$kpplcc_info | |
x$kpplcc_stats | |
x$kpplconn_info | |
x$kpplcp_stats | |
x$kqdpg | |
x$kqfco | Columns of fixed tables |
x$kqfdt | |
x$kqfopt | |
x$kqfp | |
x$kqfsz | Sizes (in bytes) of some database components, to be used to estimate data block capacity. |
x$kqfta | Exhibits the names of the X$ tables. |
x$kqftvrttst0 | |
x$kqfvi | names of the V$ (dynamic performance) views. |
x$kqfvt | Select statement of V$ (dynamic performance) views. |
x$kqlfbc | Bind variable capture? |
x$kqlfsqce | |
x$kqlfxpl | SQL execution plan |
x$kqlset | |
x$kqpxinv | |
x$kqrfp | |
x$kqrfs | |
x$kqrpd | |
x$kqrsd | |
x$kqrst | |
x$krasga | |
x$krbabrstat | |
x$krbaff | |
x$krbmca | |
x$krbmrot | |
x$krbmrst | |
x$krbmsft | |
x$krbpdata | |
x$krbpdir | |
x$krbphead | |
x$krbppbctx | |
x$krbppbtbl | |
x$krbpsparse | |
x$krbza | |
x$krcbit | |
x$krccde | |
x$krccdr | |
x$krccds | |
x$krcext | |
x$krcfbh | |
x$krcfde | |
x$krcfh | |
x$krcgfe | |
x$krcstat | |
x$krdevthist | |
x$krdmmira | |
x$krdrsbrov | |
x$krfblog | |
x$krfgstat | |
x$krfsthrd | |
x$krsnissrt | |
x$krsoproc | |
x$krssms | |
x$krssrtt | |
x$krstalg | |
x$krstappstats | |
x$krstdest | |
x$krstdgc | |
x$krstpvrs | |
x$krvslv | |
x$krvslvpg | |
x$krvslvs | |
x$krvslvst | |
x$krvslvthrd | |
x$krvxdka | |
x$krvxdta | |
x$krvxispchk | |
x$krvxisplcr | |
x$krvxop | |
x$krvxsv | |
x$krvxthrd | |
x$krvxtx | |
x$krvxwarnv | |
x$ksacltab | |
x$ksast | |
x$ksbdd | |
x$ksbdp | |
x$ksbdpneeded | |
x$ksbft | |
x$ksbsrvdt | |
x$ksbtabact | |
x$ksbucpuwtm | |
x$ksdaf | |
x$ksdaft | |
x$ksdhng_cache_history | |
x$ksdhng_chains | Hang analysis results, see $ORACLE_HOME/rdmbs/admin/hangdiag.sql |
x$ksdhng_session_blockers | |
x$ksfdftyp | |
x$ksfdfunnm | |
x$ksfdftynm | File types? |
x$ksfdkll | |
x$ksfdsscloneinfo | |
x$ksfdstblk | |
x$ksfdstcg | |
x$ksfdstcmp | |
x$ksfdstfile | |
x$ksfdsthist | |
x$ksfdstll | |
x$ksfdstthist | |
x$ksfmcompl | |
x$ksfmelem | |
x$ksfmextelem | |
x$ksfmfile | |
x$ksfmfileext | |
x$ksfmiost | |
x$ksfmlib | |
x$ksfmsubelem | |
x$ksfqdvnt | RMAN devices? |
x$ksfqp | Compare with the latch with the same name and the hidden parameter _ksfqp_row_count . |
x$ksfvqst | |
x$ksfvsl | |
x$ksfvsta | |
x$ksimat | |
x$ksimav | |
x$ksimsi | |
x$ksimtsr | |
x$ksipcip | |
x$ksipcip_ci | |
x$ksipcip_kggpnp | |
x$ksipcip_osd | |
x$ksipc_info | |
x$ksipc_proc_stats | |
x$ksipc_skgsndomain | |
x$ksirestyp | |
x$ksirgd | |
x$ksirpinfo | |
x$ksi_reuse_stats | |
x$kskcdbplw | |
x$kskcgmetric | |
x$kskpdbmetric | |
x$kskplw | |
x$kskqdft | |
x$kskqvft | |
x$kslcs | |
x$ksleclass | |
x$ksled | |
x$kslei | |
x$kslemap | |
x$kslepx | |
x$ksles | |
x$kslhot | |
x$ksllclass | |
x$kslld | Latch |
x$kslltr | |
x$kslltr_children | referenced in x$kqfdt |
x$kslltr_osp | referenced in x$kqfdt |
x$kslltr_parent | referenced in x$kqfdt |
x$ksllw | L(ist of) L(atches): W(here) |
x$kslpo | |
x$kslscs | |
x$kslseshist | |
x$kslseshist_micro | |
x$kslsesout | |
x$kslwh | |
x$kslwsc | |
x$kslwsc_osp | referenced in x$kqfdt |
x$kslwt | |
x$ksmdd | Segmented arrays? |
x$ksmdut1 | |
x$ksmfs | |
x$ksmfsv | Variable names and their addresses in the SGA |
x$ksmge | Memory granules: sizes, start address, states (allocated, free, invalid…)? |
x$ksmhp | |
x$ksmjch | |
x$ksmjs | |
x$ksmlru | |
x$ksmls | kernel service, memory large pool summary |
x$ksmmem | Allows to read the value of every byte in the SGA |
x$ksmmgapid | |
x$ksmmgaseg | |
x$ksmnim | |
x$ksmns | |
x$ksmpdbcsd | |
x$ksmpgdp | |
x$ksmpgdst | |
x$ksmpgdsta | |
x$ksmpgst | |
x$ksmpp | PGA heap |
x$ksmsd | Sizes of the four main components of the SGA (the basis for v$sga ). |
x$ksmsgmap | Seems to call fopen_maps2 under the hood. |
x$ksmsgmem | |
x$ksmsp | SGA heap |
x$ksmspr | |
x$ksmsp_dsnew | |
x$ksmsp_nwex | |
x$ksmss | |
x$ksmssinfo | |
x$ksmsst | |
x$ksmstrs | |
x$ksmup | UGA heap |
x$ksmupgastats | |
x$ksmxminfo | |
x$ksnsobj | |
x$ksnsresinfo | |
x$ksolsfts | |
x$ksolsstat | |
x$ksoltd | |
x$kso_prespawn_pool | |
x$kso_sched_delay_history | |
x$kspcs_cpu_stat | |
x$ksppcv | Current session value of init parameter. Compare with x$ksppsv . |
x$ksppcv2 | |
x$ksppi | (Init-) parameter names and description, including hidden parameters. |
x$ksppo | |
x$ksppscv | |
x$ksppsv | Current system value of init parameter. This object is selected from in v$system_parameter . Compare with x$ksppcv . |
x$ksppsv2 | |
x$ksprstv | |
x$ksprstv2 | |
x$kspspfh | |
x$kspspfile | |
x$ksptch | |
x$kspvld_values | Valid values for init parameters (also hidden parameters). See also ORA-00096. |
x$ksqdn | |
x$ksqeq | |
x$ksqeqtyp | |
x$ksqrs | |
x$ksqst | |
x$ksrcctx | |
x$ksrcdes | |
x$ksrchdl | |
x$ksrmpctx | |
x$ksrmsgdes | |
x$ksrmsgo | |
x$ksrpcios | |
x$kssquar | |
x$kssquar_reg | |
x$kssquar_sum | |
x$kstex | |
x$ksucf | |
x$ksuclndpcc | |
x$ksuclnproc | |
x$ksucpustat | |
x$ksugblnetstat | Apparently a wrapper over the tcp_info struct. |
x$ksugblnetstatawr | |
x$ksuinststat | |
x$ksull | |
x$ksulop | |
x$ksulv | |
x$ksumysta | |
x$ksunetstat | |
x$ksupdbses | |
x$ksupgp | |
x$ksupgs | |
x$ksupl | |
x$ksupr | Kernel Service User Processes? |
x$ksuprlat | Latch holder? |
x$ksurlmt | |
x$ksuru | |
x$ksusd | Session statistics |
x$ksuse | Sessions |
x$ksusecon | |
x$ksusecst | |
x$ksusesta | |
x$ksusex | |
x$ksusgif | |
x$ksusgsta | |
x$ksusio | |
x$ksusm | |
x$ksutm | |
x$ksuvmstat | |
x$ksuxsinst | |
x$kswsaftab | |
x$kswsastab | |
x$kswsclstab | |
x$kswscrssvctab | |
x$kswscrstab | |
x$kswsevtab | |
x$kswsinttab | |
x$kswsjpopertab | |
x$kswsjptab | |
x$ksxafa | |
x$ksxmcolst | |
x$ksxmme | |
x$ksxm_mae | |
x$ksxm_dft | |
x$ksxm_exp_stats | |
x$ksxm_zut | |
x$ksxpclient | |
x$ksxpia | |
x$ksxpif | |
x$ksxpping | |
x$ksxptesttbl | |
x$ksxp_stats | |
x$ksxrch | |
x$ksxrconq | |
x$ksxrmsg | |
x$ksxrrepq | |
x$ksxrsg | |
x$ktadm | |
x$ktatl | |
x$ktatrfil | |
x$ktatrfsl | |
x$ktcnclauses | |
x$ktcninband | |
x$ktcnqrow | |
x$ktcnquery | |
x$ktcnreg | |
x$ktcnregquery | |
x$ktcsp | |
x$ktcxb | Transaction object |
x$ktfbfe | blocks(?) / bitmaps(?) of free extents? |
x$ktfbhc | Data files: number of blocks, max number of blocks etc. |
x$ktfbnstat | |
x$ktfbue | blocks(?) / bitmaps(?) of used extents? |
x$ktfsan | |
x$ktfsbi | Block heatmap? |
x$ktfsimstat | |
x$ktfsri | Extent heatmap? |
x$ktfstat | |
x$ktftbtxngraph | |
x$ktftbtxnmods | |
x$ktfthc | |
x$ktftme | |
x$ktifb | |
x$ktiff | |
x$ktifp | |
x$ktifv | |
x$ktmtxnchunk | |
x$ktmtxncrclone | |
x$ktmtxndelta | |
x$ktmtxnhead | |
x$ktprhist | |
x$ktprxrs | |
x$ktprxrt | |
x$ktrso | |
x$ktsimapool | |
x$ktsimau | |
x$ktsimxmemarea | |
x$ktsjproc | |
x$ktsjtask | |
x$ktsjtaskclass | |
x$ktskstat | |
x$ktslchunk | |
x$ktspgs_stat | |
x$ktspstat | |
x$ktsp_repair_list | |
x$ktsso | |
x$ktsspu | |
x$ktstfc | |
x$ktstssd | |
x$ktstusc | |
x$ktstusg | |
x$ktstuss | |
x$kttefinfo | |
x$kttets | |
x$kttvs | Save undo for each tablespace (name in kttvsnm ) |
x$ktucus | |
x$ktugd | |
x$ktumascn | |
x$ktuqqry | |
x$kturd | |
x$kturhist | |
x$ktusmst | |
x$ktusmst2 | |
x$ktusus | |
x$ktutst | |
x$ktuxche | |
x$ktuxe | Kernel Transaction: Undo transaXtion Entry |
x$kupva | |
x$kupvj | |
x$kvii | |
x$kvis | Used to store information like db block size (select kvisval from x$kvis where kvistag = 'kcbbkl' ). Not anymore? |
x$kvit | |
x$kwddef | |
x$kwqbpmt | |
x$kwqdlstat | |
x$kwqitcx | |
x$kwqmnc | |
x$kwqmnjit | |
x$kwqmnsctx | |
x$kwqmntask | |
x$kwqmntaskstat | |
x$kwqpd | |
x$kwqps | |
x$kwqsi | |
x$kwrsnv | |
x$kwsbgaqpcstat | |
x$kwsbgqmnstat | |
x$kwsbjcsqjit | |
x$kwsbsmslvstat | |
x$kwscpjobstat | |
x$kwssubustats | |
x$kxdbio_stats | |
x$kxdcm_db | |
x$kxdcm_db_history | |
x$kxdcm_disk | |
x$kxdcm_disk_history | |
x$kxdcm_global | |
x$kxdcm_global_history | |
x$kxdcm_ioreason | |
x$kxdcm_ioreason_name | |
x$kxdcm_metric_desc | |
x$kxdcm_open_alerts | |
x$kxdrs | |
x$kxdspphysmp | |
x$kxfbbox | |
x$kxfpbs | |
x$kxfpcds | |
x$kxfpcms | |
x$kxfpcst | |
x$kxfpdp | |
x$kxfpig | |
x$kxfpns | |
x$kxfppft | |
x$kxfppig | |
x$kxfpreminstload | |
x$kxfpsds | |
x$kxfpsms | |
x$kxfpsst | |
x$kxfpys | |
x$kxfqsrow | |
x$kxfrsvchash | |
x$kxfsource | |
x$kxftask | |
x$kxsbd | Related to bind variable data. Compare with value of kxsbbbfp in 10046 trace file |
x$kxscc | |
x$kxsreplay | |
x$kxsreplaydate | |
x$kxsreplayguid | |
x$kxsreplaylob | |
x$kxsreplayseq | |
x$kxsreplaytime | |
x$kxttstecs | |
x$kxttstehs | |
x$kxttsteis | |
x$kxttstets | Session private stats for GTTs. (TODO: See here). |
x$kxtt_ptt | |
x$kywmcltab | |
x$kywmnf | |
x$kywmpcmn | |
x$kywmpcs | |
x$kywmpctab | |
x$kywmwrctab | |
x$kzahist | |
x$kzajobs | |
x$kzaloadjobs | |
x$kzaparams | |
x$kzats | |
x$kzckmcs | |
x$kzckmek | |
x$kzdos | Operating system roles |
x$kzdpsupsf | |
x$kzekmencwal | |
x$kzekmfvw | |
x$kzpopr | |
x$kzrtpd | |
x$kzspr | |
x$kzsro | Granted role(?) in current session(?). (select obj# from sys.objauth$ where granteee# in (select kzsrorol from x$kzsrc) ) |
x$kzsrpwfile | |
x$kzsrt | |
x$kzvdvclause | |
x$le | Lock element: contains an entry for each PCM lock held for the buffer cache. x$le can be left outer joined to x$bh on le_addr . gv$lock_element selects from x$le . |
x$lobsegstat | |
x$lobstat | |
x$lobstathist | |
x$lockdown | |
x$logbuf_readhist | |
x$logmnr_attrcol$ | |
x$logmnr_attribute$ | |
x$logmnr_callback | |
x$logmnr_cdef$ | |
x$logmnr_clu$ | |
x$logmnr_col$ | |
x$logmnr_coltype$ | |
x$logmnr_contents | |
x$logmnr_dictionary | |
x$logmnr_dictionary_load | |
x$logmnr_enc$ | |
x$logmnr_encrypted_obj$ | |
x$logmnr_encryption_profile$ | |
x$logmnr_file$ | |
x$logmnr_ind$ | |
x$logmnr_indcompart$ | |
x$logmnr_indpart$ | |
x$logmnr_indsubpart$ | |
x$logmnr_kopm$ | |
x$logmnr_ktfbue | |
x$logmnr_latch | |
x$logmnr_lob$ | |
x$logmnr_lobfrag$ | |
x$logmnr_log | |
x$logmnr_logfile | |
x$logmnr_logs | |
x$logmnr_ntab$ | |
x$logmnr_obj$ | |
x$logmnr_opqtype$ | |
x$logmnr_parameters | |
x$logmnr_partobj$ | |
x$logmnr_process | |
x$logmnr_props$ | |
x$logmnr_refcon$ | |
x$logmnr_root$ | |
x$logmnr_seg$ | |
x$logmnr_session | |
x$logmnr_subcoltype$ | |
x$logmnr_tab$ | |
x$logmnr_tabcompart$ | |
x$logmnr_tabpart$ | |
x$logmnr_tabsubpart$ | |
x$logmnr_ts$ | |
x$logmnr_type$ | |
x$logmnr_uet$ | |
x$logmnr_undo$ | |
x$logmnr_user$ | |
x$memoptimize_write_area | |
x$messages | |
x$message_cache | |
x$mmon_action | |
x$mmon_autotask | |
x$mmon_tracking_debug | |
x$modact_length | |
x$msgbm | |
x$mutex_sleep | |
x$mutex_sleep_history | |
x$nfsclients | |
x$nfslocks | |
x$nfsopens | |
x$nls_parameters | |
x$nondursub | |
x$nondursub_lwm | |
x$nsv | |
x$object_policy_statistics | |
x$obj_bin_exceptions | |
x$oblnk$ | |
x$oct | |
x$ofsmount | |
x$ofs_rw_latency_stats | |
x$ofs_rw_size_stats | |
x$ofs_stats | |
x$oparg | |
x$opdesc | |
x$operators | |
x$optim_calib_stats | |
x$option | |
x$opversion | |
x$orafn | |
x$persistent_publishers | |
x$persistent_queues | |
x$persistent_subscribers | |
x$policy_history | |
x$pqscanrate | |
x$prmsltyx | |
x$props | Database properties. Base table for database_properties view. Compare with sys.props$ . |
x$qerfxtst | |
x$qesblstat | |
x$qesmmahist | |
x$qesmmapadv | |
x$qesmmiwh | |
x$qesmmiwt | |
x$qesmmsga | |
x$qesrcdep | |
x$qesrcdr | |
x$qesrcmem | |
x$qesrcmsg | |
x$qesrcobj | Objects in the result cache. |
x$qesrcrd | |
x$qesrcrr | |
x$qesrcsta | |
x$qesrstat | |
x$qesrstatall | |
x$qesxl | |
x$qksbgses | |
x$qksbgsys | |
x$qksceses | |
x$qkscesys | |
x$qkscr | |
x$qkscr_rsn | |
x$qksfgi_cursor | |
x$qksfm | |
x$qksfmdep | |
x$qksfmprt | |
x$qksht | |
x$qksmmwds | |
x$qksxa_reason | Some pages on the internet suggest that x$qksxa_reason gives the textual reason for a DOP downgrade code. |
x$qosadvactiondef | |
x$qosadvfindingdef | |
x$qosadvrationaledef | |
x$qosadvrecdef | |
x$qosadvruledef | |
x$quiesce | |
x$rfafo | |
x$rfahist | |
x$rfdgpdb | |
x$rfmp | |
x$rfmprop | Related to Data Guard? |
x$rfmte | |
x$rfob | |
x$rma_latch | |
x$ro_user_account | |
x$rpop_filestats | |
x$rule | |
x$rule_set | |
x$rxs_session_roles | |
x$shadow_datafile | |
x$skgxpia | |
x$skgxp_connection | |
x$skgxp_misc | |
x$skgxp_port | |
x$sql_shard | |
x$sql_testcases | |
x$targetrba | |
x$temporary_lob_refcnt | |
x$timezone_file | |
x$timezone_names | |
x$trace | |
x$trace_events | |
x$uganco | |
x$unflushed_dequeues | |
x$unified_audit_record_format | |
x$unified_audit_trail | |
x$version | |
x$vinst | |
x$xml_audit_trail | |
x$xplton | |
x$xpltoo | |
x$xsaggr | |
x$xsagop | |
x$xsawso | |
x$xslongops | |
x$xsobject | |
x$xsoqmehi | |
x$xsoqojhi | |
x$xsoqophi | |
x$xsoqoplu | |
x$xsoqsehi | |
x$xssinfo | |
x$xs_sessions | |
x$xs_session_ns_attributes | |
x$xs_session_roles | |
x$zasaxtab | |
x$zasaxtd1 | referenced in x$kqfdt |
x$zasaxtd2 | referenced in x$kqfdt |
x$zasaxtd3 | referenced in x$kqfdt |