*** *** ORA-04063: package body "SYS.DBMS_SHARED_POOL" has errors ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SHARED_POOL" *** While trying to pin selected SQL: DBMS_SHARED_POOL.KEEP('27ED2E7C,1768835873', 'C'); *** If SQL is not pinned, it may age out from memory before it is fully analyzed by SQLT, thus SQLT reports may be incomplete. *** To install DBMS_SHARED_POOL you need to connect as SYS and execute 2 commands below: *** @$ORACLE_HOME/rdbms/admin/dbmspool.sql *** GRANT EXECUTE ON SYS.DBMS_SHARED_POOL TO SQLTXPLAIN; *** Further details regarding DBMS_SHARED_POOL are available under Note:91229.1 *** Process continues (safe to ignore error)... *** ORA-04063: package body "SYS.DBMS_SQLDIAG" has errors ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SQLDIAG" *** sqlt$d.create_tuning_task *** p_sql_source:V$SQL *** p_sql_id:gtyp03pnqwkt1 *** p_plan_hash_value:2196188739 *** p_task_name:s5656_ORA11R1_DANXP *** p_description:Created by SQLT.SQLT$D.CREATE_TUNING_TASK on 2009-09-22 21:05:26 *** *** ORA-04063: package body "SYS.DBMS_SHARED_POOL" has errors ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SHARED_POOL" *** While trying to unpin selected SQL: DBMS_SHARED_POOL.UNKEEP('27ED2E7C,1768835873', 'C'); *** Process continues (safe to ignore error)...
General
Bind Variables
SQL Execution
| Execution Plans
Plan Control
| Schema Objects and CBO Stats
|
Method Used: | XTRACT |
Script Used: | sqltxtract.sql |
Host Name: | DANXP |
CPUs: | 2 |
RAC: | NO |
Platform: | 32-bit Windows |
Product Version: | Oracle Database 11g Enterprise Edition (Production) |
RDBMS Version: | 11.1.0.6.0(11.1.X) |
RDBMS Release: | 11.1 |
Language: | us:american_america.we8mswin1252 |
Database Name: | ORA11R1(2470457352) |
Instance Name: | ora11r1(1) |
Generated 10053: | Y |
User: | USER0 (89) |
CBO Stats Exp Rows - Schema Objects: | 64 |
Fixed Objects in Plan: | 0 |
Trace Directory: | c:\oracle\diag\rdbms\ora11r1\ora11r1\trace (VALID) |
Stage Directory: | c:\oracle\diag\rdbms\ora11r1\ora11r1\trace (VALID) |
Temporary Tablespace: | TEMP (TEMPORARY) |
OPTIMIZER_FEATURES_ENABLE: | 11.1.0.6 |
DB_BLOCK_SIZE: | 8192 |
CPUSPEEDNW: | 1845.90945194599 |
IOSEEKTIM: | 10 |
IOTFRSPEED: | 4096 |
MBRC: | 128 |
SREADTIM: | 12 |
MREADTIM: | 266 |
CPU Cost Scale Factor: | 4.5145e-08 |
CPU Cost Inverse Scale Factor: | 22150914 |
Statement ID: | 5656 |
Stat ID: | s5656_ORA11R1_DANXP |
Inst ID: | 1 |
Hash Value: | 1768835873 |
Address: | 27ED2E7C |
SQL ID: | gtyp03pnqwkt1 |
SQL Signature (for Stored Outlines): | E924AD25B1A0C45902078AC973AA7E03 |
SQL Signature (for SQL Profiles): | 17315877379555196788 |
Child Number: | 0 |
Plan Hash Value: | 2196188739 |
SQLT Plan HV: | 3963354750 |
Plan Source: | V$SQL |
SQL Source: | V$SQL |
Plan Cost: | 149 |
Plan IO Cost: | 145 |
Plan CPU Cost: | 84621783 |
Estim Cardinality: | 61 |
Estim Bytes: | 1281 |
Estim Performance (secs): | 1.788 |
Actual Performance (secs): | .033 |
Other XML: | [+] |
select t.team_id, count(*) from managers mg, master ma, teams t where t.win_pct > .5 and t.team_id = mg.team_id and mg.lahmanid = ma.lahmanid and ma.debut_season_yyyy = 1965 group by t.team_idBack to Top
# | Object Type | Object Name | Observation |
---|---|---|---|
1 | CURSOR | V$SQL | There exist(s) 1 Child Cursor(s) in memory for this SQL |
2 | PLAN | V$SQL | There exist(s) 1 distinct SQL Plans(s) in memory for this SQL |
3 | PLAN | AWR | There exist(s) 1 distinct SQL Plans(s) in AWR for this SQL |
4 | SYSTEM STATS | CPUSPEED | WORKLOAD SYSTEM STATISTICS are missing. Consider gathering workload system stats |
5 | TABLE | USER0.MANAGERS | CBO Stats seem gathered using deprecated ANALYZE command. Consider gathering stats with DBMS_STATS |
6 | TABLE | USER0.MASTER | CBO Stats seem gathered using deprecated ANALYZE command. Consider gathering stats with DBMS_STATS |
7 | TABLE | USER0.TEAMS | CBO Stats seem gathered using deprecated ANALYZE command. Consider gathering stats with DBMS_STATS |
8 | INDEX | USER0.TEAMS_PK | CBO Stats seem gathered using deprecated ANALYZE command Consider gathering stats with DBMS_STATS |
9 | TABLE COLUMN | USER0.MANAGERS.DATE_YYYY | Candidate for NNull constraint. Consider creating it |
10 | TABLE COLUMN | USER0.MANAGERS.TEAM_ID | Candidate for NNull constraint. Consider creating it |
11 | TABLE COLUMN | USER0.MANAGERS.LEAGUE_ID | Candidate for NNull constraint. Consider creating it |
12 | TABLE COLUMN | USER0.TEAMS.ATTENDENCE_QTY | Candidate for NNull constraint. Consider creating it |
# | Owner | Constraint Name | Const Type | Table Name | Search Condition | Ref Owner | Ref Const Name | Delete Rule | Status | Deferrable | Deferred | Validated | Generated | Bad | Rely | Last Change | Index Owner | Index Name | Invalid | View Related |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | USER0 | SYS_C0010565 | C | MANAGERS | "RECNUM" IS NOT NULL | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | 24-AUG-09 | |||||||||
2 | USER0 | SYS_C0010566 | C | MANAGERS | "LAHMANID" IS NOT NULL | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | 24-AUG-09 | |||||||||
3 | USER0 | SYS_C0010567 | C | TEAMS | "RECNUM" IS NOT NULL | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | 24-AUG-09 | |||||||||
4 | USER0 | SYS_C0010568 | C | TEAMS | "DATE_YYYY" IS NOT NULL | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | 24-AUG-09 | |||||||||
5 | USER0 | SYS_C0010569 | C | TEAMS | "LEAGUE_ID" IS NOT NULL | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | 24-AUG-09 | |||||||||
6 | USER0 | SYS_C0010570 | C | TEAMS | "TEAM_ID" IS NOT NULL | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | 24-AUG-09 | |||||||||
7 | USER0 | SYS_C0010571 | C | MASTER | "LAHMANID" IS NOT NULL | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | 24-AUG-09 |
# | Tablespace | Block Size | Initial Extent | Next Extent | Min Extents | Max Extents | Pct Increase | Min ExtLen | Status | Contents | Logging | Force Logging | Extent Management | Allocation Type | Plugged In | Segment Space Management | Def Tab Compression | Retention | Big File |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | EXAMPLE | 8192 | 65536 | 1 | 2147483645 | 65536 | ONLINE | PERMANENT | NOLOGGING | NO | LOCAL | SYSTEM | YES | AUTO | DISABLED | NOT APPLY | NO | ||
2 | SYSAUX | 8192 | 65536 | 1 | 2147483645 | 65536 | ONLINE | PERMANENT | LOGGING | NO | LOCAL | SYSTEM | NO | AUTO | DISABLED | NOT APPLY | NO | ||
3 | SYSTEM | 8192 | 65536 | 1 | 2147483645 | 65536 | ONLINE | PERMANENT | LOGGING | NO | LOCAL | SYSTEM | NO | MANUAL | DISABLED | NOT APPLY | NO | ||
4 | TEMP | 8192 | 1048576 | 1048576 | 1 | 0 | 1048576 | ONLINE | TEMPORARY | NOLOGGING | NO | LOCAL | UNIFORM | NO | MANUAL | DISABLED | NOT APPLY | NO | |
5 | UNDOTBS1 | 8192 | 65536 | 1 | 2147483645 | 65536 | ONLINE | UNDO | LOGGING | NO | LOCAL | SYSTEM | NO | MANUAL | DISABLED | NOGUARANTEE | NO | ||
6 | USERS | 8192 | 65536 | 1 | 2147483645 | 65536 | ONLINE | PERMANENT | LOGGING | NO | LOCAL | SYSTEM | NO | AUTO | DISABLED | NOT APPLY | NO |
Auto Stats Target: | AUTO |
Publish: | TRUE |
Incremental: | FALSE |
Stale Percent: | 10 |
Estimate Percent: | DBMS_STATS.AUTO_SAMPLE_SIZE(DEFAULT 0) |
Degree: | NULL(DEFAULT NULL:1) |
Cascade: | DBMS_STATS.AUTO_CASCADE(DEFAULT NULL) |
No Invalidate: | DBMS_STATS.AUTO_INVALIDATE(DEFAULT NULL) |
Method Opt: | FOR ALL COLUMNS SIZE AUTO |
Granularity: | AUTO |
Client Name: | auto optimizer stats collection |
Status: | ENABLED |
Consumer Group: | ORA$AUTOTASK_STATS_GROUP |
Client Tag: | OS |
Priority Override: | INVALID |
Attributes: | ON BY DEFAULT, VOLATILE, SAFE TO KILL |
Window Group: | ORA$AT_WGRP_OS |
Resource Percentage: | 25 |
Use Resource Estimates: | FALSE |
Mean Job Duration: | +000000000 00:01:16.185714285 |
Mean Job CPU: | +000000000 00:00:34.360142857 |
Mean Job Attempts: | 0 |
Mean incoming Tasks 7 days: | 2.5 |
Mean incoming Tasks 30 days: | 2 |
Total CPU last 7 days: | +000000000 00:12:08.070000000 |
Total CPU last 30 days: | +000000000 00:59:36.300000000 |
Max duration last 7 days: | +000 00:01:11 |
Max duration last 30 days: | +000 00:02:18 |
Window duration last 7 days: | +000000020 05:03:00.329000000 |
Window duration last 30 days: | +000000028 17:27:45.673000000 |
# | Operation | Start Time | End Time |
---|---|---|---|
1 | gather_database_stats(auto) | 20-SEP-09 08.17.57.703000 PM -05:00 | 20-SEP-09 08.18.49.593000 PM -05:00 |
2 | gather_database_stats(auto) | 20-SEP-09 10.02.21.187000 AM -05:00 | 20-SEP-09 10.03.25.625000 AM -05:00 |
3 | gather_database_stats(auto) | 19-SEP-09 08.15.10.390000 AM -05:00 | 19-SEP-09 08.15.57.015000 AM -05:00 |
4 | gather_database_stats(auto) | 14-SEP-09 10.00.06.562000 PM -05:00 | 14-SEP-09 10.00.58.750000 PM -05:00 |
5 | gather_database_stats(auto) | 08-SEP-09 12.55.13.296000 AM -05:00 | 08-SEP-09 12.56.03.171000 AM -05:00 |
6 | gather_database_stats(auto) | 06-SEP-09 11.19.22.468000 AM -05:00 | 06-SEP-09 11.19.49.765000 AM -05:00 |
7 | gather_database_stats(auto) | 06-SEP-09 07.19.19.843000 AM -05:00 | 06-SEP-09 07.19.56.062000 AM -05:00 |
8 | gather_database_stats(auto) | 05-SEP-09 11.33.13.078000 AM -05:00 | 05-SEP-09 11.34.10.140000 AM -05:00 |
9 | gather_database_stats(auto) | 05-SEP-09 06.40.57.750000 AM -05:00 | 05-SEP-09 06.41.30.937000 AM -05:00 |
10 | gather_database_stats(auto) | 04-SEP-09 10.00.06.640000 PM -05:00 | 04-SEP-09 10.01.04.172000 PM -05:00 |
11 | gather_database_stats(auto) | 30-AUG-09 12.53.46.906000 PM -05:00 | 30-AUG-09 12.54.51.406000 PM -05:00 |
12 | gather_database_stats(auto) | 28-AUG-09 10.00.05.734000 PM -05:00 | 28-AUG-09 10.02.21.156000 PM -05:00 |
13 | gather_database_stats(auto) | 26-AUG-09 10.00.01.062000 PM -05:00 | 26-AUG-09 10.00.36.656000 PM -05:00 |
14 | gather_database_stats(auto) | 26-AUG-09 01.20.09.562000 AM -05:00 | 26-AUG-09 01.21.05.968000 AM -05:00 |
15 | gather_database_stats(auto) | 24-AUG-09 10.00.05.484000 PM -05:00 | 24-AUG-09 10.00.54.406000 PM -05:00 |
16 | gather_database_stats(auto) | 24-AUG-09 12.07.38.515000 AM -05:00 | 24-AUG-09 12.08.04.109000 AM -05:00 |
17 | gather_database_stats(auto) | 23-AUG-09 04.42.08.468000 PM -05:00 | 23-AUG-09 04.42.33.843000 PM -05:00 |
18 | gather_database_stats(auto) | 23-AUG-09 12.01.54.671000 PM -05:00 | 23-AUG-09 12.02.29.843000 PM -05:00 |
19 | gather_database_stats(auto) | 22-AUG-09 06.20.25.421000 AM -05:00 | 22-AUG-09 06.20.56.062000 AM -05:00 |
Parameter Name | Value | Description |
---|---|---|
CPUSPEEDNW | 1845.90945194599 | Average CPU speed, in millions of instructions/second, as per no-workload (statistics collected using 'NOWORKLOAD' option) |
IOSEEKTIM | 10 | I/O seek time + latency time + operating system overhead time, in milliseconds (default is 10) |
IOTFRSPEED | 4096 | I/O transfer speed, in bytes/millisecond (default is 4096) |
CPUSPEED | Average CPU speed, in millions of instructions/second, as per workload (statistics collected using 'INTERVAL' or 'START' and 'STOP' options) | |
MBRC | Average multiblock read count for full scans, in blocks | |
SREADTIM | Average time for a single-block read request (random read), in milliseconds | |
MREADTIM | Average time for a multi-block read request (for full scans), in milliseconds | |
MAXTHR | Maximum throughput the I/O subsystem can deliver, in bytes/second | |
SLAVETHR | Average parallel slave I/O throughput, in bytes/second |
Parameter Name | Value |
---|---|
DSTART | 10-15-2007 11:32 |
DSTOP | 10-15-2007 11:32 |
FLAGS | |
STATUS | COMPLETED |
# | Is Default | Parameter | Current Value |
---|---|---|---|
1 | Y | optimizer_mode_hinted | false |
2 | Y | optimizer_features_hinted | 0.0.0 |
3 | Y | parallel_execution_enabled | true |
4 | Y | parallel_query_forced_dop | 0 |
5 | Y | parallel_dml_forced_dop | 0 |
6 | Y | parallel_ddl_forced_degree | 0 |
7 | Y | parallel_ddl_forced_instances | 0 |
8 | Y | _query_rewrite_fudge | 90 |
9 | Y | optimizer_features_enable | 11.1.0.6 |
10 | Y | _optimizer_search_limit | 5 |
11 | Y | cpu_count | 2 |
12 | Y | active_instance_count | 1 |
13 | Y | parallel_threads_per_cpu | 2 |
14 | Y | hash_area_size | 131072 |
15 | Y | bitmap_merge_area_size | 1048576 |
16 | Y | sort_area_size | 65536 |
17 | Y | sort_area_retained_size | 0 |
18 | Y | _sort_elimination_cost_ratio | 0 |
19 | Y | _optimizer_block_size | 8192 |
20 | Y | _sort_multiblock_read_count | 2 |
21 | Y | _hash_multiblock_io_count | 0 |
22 | Y | _db_file_optimizer_read_count | 8 |
23 | Y | _optimizer_max_permutations | 2000 |
24 | Y | pga_aggregate_target | 262144 KB |
25 | Y | _pga_max_size | 204800 KB |
26 | Y | _query_rewrite_maxdisjunct | 257 |
27 | Y | _smm_auto_min_io_size | 56 KB |
28 | Y | _smm_auto_max_io_size | 248 KB |
29 | Y | _smm_min_size | 262 KB |
30 | Y | _smm_max_size | 52428 KB |
# | Is Default | Parameter | Current Value |
31 | Y | _smm_px_max_size | 131072 KB |
32 | Y | _cpu_to_io | 0 |
33 | Y | _optimizer_undo_cost_change | 11.1.0.6 |
34 | Y | parallel_query_mode | enabled |
35 | Y | parallel_dml_mode | disabled |
36 | Y | parallel_ddl_mode | enabled |
37 | Y | optimizer_mode | all_rows |
38 | Y | sqlstat_enabled | false |
39 | Y | _optimizer_percent_parallel | 101 |
40 | Y | _always_anti_join | choose |
41 | Y | _always_semi_join | choose |
42 | Y | _optimizer_mode_force | true |
43 | Y | _partition_view_enabled | true |
44 | Y | _always_star_transformation | false |
45 | Y | _query_rewrite_or_error | false |
46 | Y | _hash_join_enabled | true |
47 | Y | cursor_sharing | exact |
48 | Y | _b_tree_bitmap_plans | true |
49 | Y | star_transformation_enabled | false |
50 | Y | _optimizer_cost_model | choose |
51 | Y | _new_sort_cost_estimate | true |
52 | Y | _complex_view_merging | true |
53 | Y | _unnest_subquery | true |
54 | Y | _eliminate_common_subexpr | true |
55 | Y | _pred_move_around | true |
56 | Y | _convert_set_to_join | false |
57 | Y | _push_join_predicate | true |
58 | Y | _push_join_union_view | true |
59 | Y | _fast_full_scan_enabled | true |
60 | Y | _optim_enhance_nnull_detection | true |
# | Is Default | Parameter | Current Value |
61 | Y | _parallel_broadcast_enabled | true |
62 | Y | _px_broadcast_fudge_factor | 100 |
63 | Y | _ordered_nested_loop | true |
64 | Y | _no_or_expansion | false |
65 | Y | optimizer_index_cost_adj | 100 |
66 | Y | optimizer_index_caching | 0 |
67 | Y | _system_index_caching | 0 |
68 | Y | _disable_datalayer_sampling | false |
69 | Y | query_rewrite_enabled | true |
70 | Y | query_rewrite_integrity | enforced |
71 | Y | _query_cost_rewrite | true |
72 | Y | _query_rewrite_2 | true |
73 | Y | _query_rewrite_1 | true |
74 | Y | _query_rewrite_expression | true |
75 | Y | _query_rewrite_jgmigrate | true |
76 | Y | _query_rewrite_fpc | true |
77 | Y | _query_rewrite_drj | true |
78 | Y | _full_pwise_join_enabled | true |
79 | Y | _partial_pwise_join_enabled | true |
80 | Y | _left_nested_loops_random | true |
81 | Y | _improved_row_length_enabled | true |
82 | Y | _index_join_enabled | true |
83 | Y | _enable_type_dep_selectivity | true |
84 | Y | _improved_outerjoin_card | true |
85 | Y | _optimizer_adjust_for_nulls | true |
86 | Y | _optimizer_degree | 0 |
87 | Y | _use_column_stats_for_function | true |
88 | Y | _subquery_pruning_enabled | true |
89 | Y | _subquery_pruning_mv_enabled | false |
90 | Y | _or_expand_nvl_predicate | true |
# | Is Default | Parameter | Current Value |
91 | Y | _like_with_bind_as_equality | false |
92 | Y | _table_scan_cost_plus_one | true |
93 | Y | _cost_equality_semi_join | true |
94 | Y | _default_non_equality_sel_check | true |
95 | Y | _new_initial_join_orders | true |
96 | Y | _oneside_colstat_for_equijoins | true |
97 | Y | _optim_peek_user_binds | true |
98 | Y | _minimal_stats_aggregation | true |
99 | Y | _force_temptables_for_gsets | false |
100 | Y | workarea_size_policy | auto |
101 | Y | _smm_auto_cost_enabled | true |
102 | Y | _gs_anti_semi_join_allowed | true |
103 | Y | _optim_new_default_join_sel | true |
104 | Y | optimizer_dynamic_sampling | 2 |
105 | Y | _pre_rewrite_push_pred | true |
106 | Y | _optimizer_new_join_card_computation | true |
107 | Y | _union_rewrite_for_gs | yes_gset_mvs |
108 | Y | _generalized_pruning_enabled | true |
109 | Y | _optim_adjust_for_part_skews | true |
110 | Y | _force_datefold_trunc | false |
111 | Y | statistics_level | typical |
112 | Y | _optimizer_system_stats_usage | true |
113 | Y | skip_unusable_indexes | true |
114 | Y | _remove_aggr_subquery | true |
115 | Y | _optimizer_push_down_distinct | 0 |
116 | Y | _dml_monitoring_enabled | true |
117 | Y | _optimizer_undo_changes | false |
118 | Y | _predicate_elimination_enabled | true |
119 | Y | _nested_loop_fudge | 100 |
120 | Y | _project_view_columns | true |
# | Is Default | Parameter | Current Value |
121 | Y | _local_communication_costing_enabled | true |
122 | Y | _local_communication_ratio | 50 |
123 | Y | _query_rewrite_vop_cleanup | true |
124 | Y | _slave_mapping_enabled | true |
125 | Y | _optimizer_cost_based_transformation | linear |
126 | Y | _optimizer_mjc_enabled | true |
127 | Y | _right_outer_hash_enable | true |
128 | Y | _spr_push_pred_refspr | true |
129 | Y | _optimizer_cache_stats | false |
130 | Y | _optimizer_cbqt_factor | 50 |
131 | Y | _optimizer_squ_bottomup | true |
132 | Y | _fic_area_size | 131072 |
133 | Y | _optimizer_skip_scan_enabled | true |
134 | Y | _optimizer_cost_filter_pred | false |
135 | Y | _optimizer_sortmerge_join_enabled | true |
136 | Y | _optimizer_join_sel_sanity_check | true |
137 | Y | _mmv_query_rewrite_enabled | true |
138 | Y | _bt_mmv_query_rewrite_enabled | true |
139 | Y | _add_stale_mv_to_dependency_list | true |
140 | Y | _distinct_view_unnesting | false |
141 | Y | _optimizer_dim_subq_join_sel | true |
142 | Y | _optimizer_disable_strans_sanity_checks | 0 |
143 | Y | _optimizer_compute_index_stats | true |
144 | Y | _push_join_union_view2 | true |
145 | Y | _optimizer_ignore_hints | false |
146 | Y | _optimizer_random_plan | 0 |
147 | Y | _query_rewrite_setopgrw_enable | true |
148 | Y | _optimizer_correct_sq_selectivity | true |
149 | Y | _disable_function_based_index | false |
150 | Y | _optimizer_join_order_control | 3 |
# | Is Default | Parameter | Current Value |
151 | Y | _optimizer_cartesian_enabled | true |
152 | Y | _optimizer_starplan_enabled | true |
153 | Y | _extended_pruning_enabled | true |
154 | Y | _optimizer_push_pred_cost_based | true |
155 | Y | _optimizer_null_aware_antijoin | true |
156 | Y | _optimizer_extend_jppd_view_types | true |
157 | Y | _sql_model_unfold_forloops | run_time |
158 | Y | _enable_dml_lock_escalation | false |
159 | Y | _bloom_filter_enabled | true |
160 | Y | _update_bji_ipdml_enabled | 0 |
161 | Y | _optimizer_extended_cursor_sharing | udo |
162 | Y | _dm_max_shared_pool_pct | 1 |
163 | Y | _optimizer_cost_hjsmj_multimatch | true |
164 | Y | _optimizer_transitivity_retain | true |
165 | Y | _px_pwg_enabled | true |
166 | Y | optimizer_secure_view_merging | true |
167 | Y | _optimizer_join_elimination_enabled | true |
168 | Y | flashback_table_rpi | non_fbt |
169 | Y | _optimizer_cbqt_no_size_restriction | true |
170 | Y | _optimizer_enhanced_filter_push | true |
171 | Y | _optimizer_filter_pred_pullup | true |
172 | Y | _rowsrc_trace_level | 0 |
173 | Y | _simple_view_merging | true |
174 | Y | _optimizer_rownum_pred_based_fkr | true |
175 | Y | _optimizer_better_inlist_costing | all |
176 | Y | _optimizer_self_induced_cache_cost | false |
177 | Y | _optimizer_min_cache_blocks | 10 |
178 | Y | _optimizer_or_expansion | depth |
179 | Y | _optimizer_order_by_elimination_enabled | true |
180 | Y | _optimizer_outer_to_anti_enabled | true |
# | Is Default | Parameter | Current Value |
181 | Y | _selfjoin_mv_duplicates | true |
182 | Y | _dimension_skip_null | true |
183 | Y | _force_rewrite_enable | false |
184 | Y | _optimizer_star_tran_in_with_clause | true |
185 | Y | _optimizer_complex_pred_selectivity | true |
186 | Y | _optimizer_connect_by_cost_based | true |
187 | Y | _gby_hash_aggregation_enabled | true |
188 | Y | _globalindex_pnum_filter_enabled | true |
189 | Y | _px_minus_intersect | true |
190 | Y | _fix_control_key | 0 |
191 | Y | _force_slave_mapping_intra_part_loads | false |
192 | Y | _force_tmp_segment_loads | false |
193 | Y | _query_mmvrewrite_maxpreds | 10 |
194 | Y | _query_mmvrewrite_maxintervals | 5 |
195 | Y | _query_mmvrewrite_maxinlists | 5 |
196 | Y | _query_mmvrewrite_maxdmaps | 10 |
197 | Y | _query_mmvrewrite_maxcmaps | 20 |
198 | Y | _query_mmvrewrite_maxregperm | 512 |
199 | Y | _query_mmvrewrite_maxmergedcmaps | 50 |
200 | Y | _query_mmvrewrite_maxqryinlistvals | 500 |
201 | Y | _disable_parallel_conventional_load | false |
202 | Y | _trace_virtual_columns | false |
203 | Y | _replace_virtual_columns | true |
204 | Y | _virtual_column_overload_allowed | true |
205 | Y | _kdt_buffering | true |
206 | Y | _first_k_rows_dynamic_proration | true |
207 | Y | _optimizer_sortmerge_join_inequality | true |
208 | Y | _aw_row_source_enabled | true |
209 | Y | _optimizer_aw_stats_enabled | true |
210 | Y | _bloom_pruning_enabled | true |
# | Is Default | Parameter | Current Value |
211 | Y | result_cache_mode | MANUAL |
212 | Y | _px_ual_serial_input | true |
213 | Y | _optimizer_skip_scan_guess | false |
214 | Y | _enable_row_shipping | true |
215 | Y | _row_shipping_threshold | 80 |
216 | Y | _row_shipping_explain | false |
217 | Y | transaction_isolation_level | read_commited |
218 | Y | _optimizer_distinct_elimination | true |
219 | Y | _optimizer_multi_level_push_pred | true |
220 | Y | _optimizer_group_by_placement | true |
221 | Y | _optimizer_rownum_bind_default | 10 |
222 | Y | _enable_query_rewrite_on_remote_objs | true |
223 | Y | _optimizer_extended_cursor_sharing_rel | simple |
224 | Y | _optimizer_adaptive_cursor_sharing | true |
225 | Y | _direct_path_insert_features | 0 |
226 | Y | _optimizer_improve_selectivity | true |
227 | Y | optimizer_use_pending_statistics | false |
228 | Y | _optimizer_enable_density_improvements | true |
229 | Y | _optimizer_aw_join_push_enabled | true |
230 | Y | _optimizer_connect_by_combine_sw | true |
231 | Y | _enable_pmo_ctas | 0 |
232 | Y | _optimizer_native_full_outer_join | force |
233 | Y | _bloom_predicate_enabled | false |
234 | Y | _optimizer_enable_extended_stats | true |
235 | Y | _is_lock_table_for_ddl_wait_lock | 0 |
236 | Y | _pivot_implementation_method | choose |
237 | Y | optimizer_capture_sql_plan_baselines | false |
238 | Y | optimizer_use_sql_plan_baselines | true |
239 | Y | _optimizer_star_trans_min_cost | 0 |
240 | Y | _optimizer_star_trans_min_ratio | 0 |
# | Is Default | Parameter | Current Value |
241 | Y | _with_subquery | OPTIMIZER |
242 | Y | _optimizer_fkr_index_cost_bias | 10 |
243 | Y | _optimizer_use_subheap | true |
244 | Y | _parallel_policy | manual |
245 | Y | parallel_degree | 0 |
246 | Y | _parallel_time_threshold | 10 |
247 | Y | _parallel_time_unit | 10 |
248 | Y | _optimizer_or_expansion_subheap | true |
249 | Y | _optimizer_free_transformation_heap | true |
250 | Y | _optimizer_reuse_cost_annotations | true |
251 | Y | _result_cache_auto_size_threshold | 100 |
252 | Y | _result_cache_auto_time_threshold | 1000 |
253 | Y | _optimizer_nested_rollup_for_gset | 100 |
254 | Y | _nlj_batching_enabled | 1 |
255 | Y | parallel_query_default_dop | 0 |
256 | Y | is_recur_flags | 0 |
257 | Y | optimizer_use_invisible_indexes | false |
258 | Y | flashback_data_archive_internal_cursor | 0 |
259 | Y | _optimizer_extended_stats_usage_control | 240 |
# | Fix | Current Value | Is Default | Optimizer1 Features Enable | Description |
---|---|---|---|---|---|
1 | 3834770 | 1 | Y | 8.0.0 | Lift restriction on unnest subquery with a view |
2 | 3746511 | enabled | Y | 8.0.0 | do not combine predicates from LNNVL |
3 | 4519016 | enabled | Y | 9.2.0 | Pick view card from view qb instead of parent qb |
4 | 3118776 | enabled | Y | 9.2.0 | Check for obj# for named view estimated card |
5 | 4488689 | enabled | Y | 10.2.0.2 | ignore IS NOT NULL predicate as an index filter |
6 | 2194204 | disabled | Y | disable push predicate driven by functional index into partition | |
7 | 2660592 | enabled | Y | 8.1.7 | do not trigger bitmap plans if no protential domain index driver |
8 | 2320291 | enabled | Y | 9.2.0 | push into table with RLS |
9 | 2324795 | enabled | Y | 8.1.7 | add(remove) cluster index for push view |
10 | 4308414 | enabled | Y | 10.1.0.3 | outer query must have more than one table unless lateral view |
11 | 3499674 | disabled | Y | enable tiny index improvements: consider small indexes as cachhe | |
12 | 4569940 | enabled | Y | 10.1.0.5 | Use index heuristic for join pred being pushed |
13 | 4631959 | enabled | Y | 10.2.0.2 | Refine criteria for additional phase in JPPD |
14 | 4519340 | enabled | Y | 10.2.0.2 | Generate distinct view in SU if candidate for JPPD |
15 | 4550003 | enabled | Y | 10.1.0 | do not consider no sel predicates in join selectivity sanity |
16 | 1403283 | enabled | Y | 8.1.6 | CBO do not count 0 rows partitions |
17 | 4554846 | enabled | Y | 10.2.0.2 | tbl$or$idx$part$num() predicate causing peformance problems |
18 | 4602374 | enabled | Y | 10.2.0.2 | optimize top-level predicate chain |
19 | 4584065 | enabled | Y | 10.2.0.2 | do not disable cartesian products if ORDERED hint is used |
20 | 4545833 | enabled | Y | 10.2.0.2 | no selectivity for transitive inequality predicates |
21 | 4611850 | enabled | Y | 10.2.0.2 | do not clobber predicate during first-k row estimate phase |
22 | 4663698 | enabled | Y | 10.2.0.2 | for cached NL table set tab_cost_io to zero |
23 | 4663804 | enabled | Y | 10.2.0.2 | use smallest table as first table in join card. initial ordering |
24 | 4666174 | enabled | Y | 11.1.0.6 | consider subqueries for pruning only from optimizer-refined set |
25 | 4567767 | enabled | Y | 11.1.0.6 | do not re-evaluate density on rowcache reload |
26 | 4556762 | 15 | Y | 10.2.0.2 | min # of join permutations for starting table, new initial order |
27 | 4728348 | enabled | Y | 10.2.0.2 | consider mjc if equi-joined pred is dropped in kkoipt |
28 | 4708389 | enabled | Y | 10.2.0.2 | Use inner table and index DOP for costing NL join |
29 | 4175830 | enabled | Y | 10.2.0.1 | generate transitive predicates across anti join predicates |
30 | 4752814 | enabled | Y | 11.1.0.6 | treat ansi char constant as varchar2 if operator is not ANSI |
# | Fix | Current Value | Is Default | Optimizer1 Features Enable | Description |
31 | 4583239 | enabled | Y | 10.2.0.1 | enable common expr elimination, pred move around 4 insert stmt |
32 | 4386734 | enabled | Y | 11.1.0.6 | f()=f() => f() is not null, selectivity for f() is not null |
33 | 4887636 | enabled | Y | 11.1.0.6 | remove restriction from first K row optimization |
34 | 4483240 | enabled | Y | 9.2.0 | Favor unique index in case of cost tie |
35 | 4872602 | disabled | Y | Disable unnesting of SQ under certain conditions | |
36 | 4711525 | enabled | Y | 9.2.0 | Enable code optimization for bitmap access path |
37 | 4545802 | enabled | Y | 10.2.0.2 | Adjust inner card for post filters for outer joins |
38 | 4605810 | enabled | Y | 10.1.0 | apafio - do not set DONE if the matching failed |
39 | 4704779 | enabled | Y | 11.1.0.6 | Fix histogram type determination macro |
40 | 4900129 | enabled | Y | 10.2.0.1 | Only use relevant check constraints for transitive pred. generat |
41 | 4924149 | enabled | Y | 10.2.0.2 | Allow secure view merging if outside of view is zero-argument |
42 | 4663702 | enabled | Y | 10.2.0.3 | Use base NDV instead of scaled NDV when computing index selectiv |
43 | 4878299 | enabled | Y | 10.2.0.3 | FKR: also prorate index ABK (avg blocks per key) |
44 | 4658342 | enabled | Y | 9.2.0 | do not push predicates into deeply nested predicate trees |
45 | 4881533 | enabled | Y | 11.1.0.6 | Limit # of slave groups to DOP |
46 | 4676955 | enabled | Y | 11.1.0.6 | kkojcio: Get view card using kkotbS not kkotbC |
47 | 4273361 | enabled | Y | 10.2.0.4 | convert range scan to unique access if possible |
48 | 4967068 | enabled | Y | 11.1.0.6 | outer join table elimination |
49 | 4969880 | disabled | Y | upgrade to row-read access instead of row-write | |
50 | 5005866 | enabled | Y | 9.2.0 | remove null first element from multicolumn inlist if possible |
51 | 5015557 | enabled | Y | 9.2.0 | add new predicate to the VC-EXPR mapping |
52 | 4705343 | enabled | Y | 11.1.0.6 | Relax view merging security checks for SYS PL/SQL functions |
53 | 4904838 | enabled | Y | 9.2.0 | allow index skip scan with no index keys |
54 | 4716096 | enabled | Y | 11.1.0.6 | Relax view merging security checks for domain indexes |
55 | 4483286 | disabled | Y | Discount FFS cost using optimizer_index_cost_adj. | |
56 | 4722900 | enabled | Y | 10.2.0.1 | kkoidc: add SI caching for index branch blocks |
57 | 4615392 | enabled | Y | 10.2.0.3 | ANSI syntax prevents table elimination |
58 | 5096560 | enabled | Y | 10.2.0.2 | use sql text from qbcqutxt for reparse |
59 | 5029464 | enabled | Y | 9.2.0 | inline view in a stored view |
60 | 4134994 | enabled | Y | 10.2.0.2 | multiple signatures for selectivity func |
# | Fix | Current Value | Is Default | Optimizer1 Features Enable | Description |
61 | 4904890 | enabled | Y | 11.1.0.6 | do not copy kcc of columns in non-view side of a JPPD |
62 | 5104624 | enabled | Y | 10.2.0.2 | multiple signatures for selectivity func |
63 | 5014836 | enabled | Y | 11.1.0.6 | Enable CBQT for INSERT statements |
64 | 4768040 | enabled | Y | 11.1.0.6 | Enable CBQT for CTAS statements |
65 | 4600710 | enabled | Y | 10.2.0.3 | Cost inlists as index filters as well as keys |
66 | 5129233 | enabled | Y | 10.2.0.3 | peek at any foldable exprssion during pruning |
67 | 4595987 | enabled | Y | 10.2.0.3 | skip internal ref columns for index only check for update/delete |
68 | 4908162 | enabled | Y | 10.2.0.3 | Enable star plan for 2 column part pruning index |
69 | 5139520 | enabled | Y | 11.1.0.6 | kkoDMcos: For PWJ on list dimension, use part/subpart bits |
70 | 5084239 | enabled | Y | 10.2.0.3 | try for subqueries before forcing in star trans with FACT hint |
71 | 5143477 | disabled | Y | disable the fix for the bug # 5011764 | |
72 | 2663857 | enabled | Y | 8.0.0 | Use extended index caching discount |
73 | 4717546 | enabled | Y | 9.2.0 | avoid semantically redundant predicates to be used |
74 | 5240264 | enabled | Y | 10.2.0.3 | Share single copy of coldef within an expression |
75 | 5099909 | enabled | Y | 10.2.0.3 | Consider subquery pruning using view containing single table pre |
76 | 5240607 | enabled | Y | 10.2.0.3 | avoid NL with fts on right side in fkr mode |
77 | 5195882 | enabled | Y | 10.2.0.3 | Enhance view merging security checks for PL/SQL functions |
78 | 5220356 | enabled | Y | 10.2.0.4 | Allow predicate push for predicates that partition prune |
79 | 5263572 | enabled | Y | 10.1.0.5 | correct selectivity of col LIKE func(:b1) |
80 | 5385629 | enabled | Y | 11.1.0.6 | Remove restrictions on unsupported view structures for JPPD |
81 | 5302124 | enabled | Y | 10.2.0.4 | Allow CBQT for queries with window functions |
82 | 5391942 | enabled | Y | 10.1.0 | Favor rowid= over any other access path regardless of statistics |
83 | 5384335 | enabled | Y | 11.1.0.6 | Add heuristic for group-by placement |
84 | 5482831 | enabled | Y | 10.2.0.4 | discount for partitioned range scan in fkr mode |
85 | 4158812 | enabled | Y | 11.1.0.6 | SQ to view transform - remove dual from qbcfro |
86 | 5387148 | enabled | Y | 11.1.0.6 | Propagate interleaved CVM flag from CBQT analysis |
87 | 5383891 | enabled | Y | 10.1.0.6 | Limit join permutations considered to 2000 for star plans |
88 | 5466973 | enabled | Y | 10.1.0 | Do colocate join if columns in fro->frojand are on the same node |
89 | 5396162 | enabled | Y | 10.2.0.4 | Lift restriction on semi-join elimination |
90 | 5394888 | enabled | Y | 10.2.0.4 | don't over-write prorated cardinalities on switch to Amode plan |
# | Fix | Current Value | Is Default | Optimizer1 Features Enable | Description |
91 | 5395291 | enabled | Y | 10.2.0.4 | prefer index access when joining first non 1-row table in K mode |
92 | 5236908 | enabled | Y | 9.2.0 | Allow _optimizer_index_caching to affect IOT primary keys |
93 | 5509293 | enabled | Y | 11.1.0.6 | Relax semi/antijoin restrictions with remote tables |
94 | 5449488 | enabled | Y | 10.2.0.4 | In bitmap costing use real sel for transitive negated predicates |
95 | 5567933 | enabled | Y | 11.1.0.6 | no view with having for group-by placement |
96 | 5570494 | enabled | Y | 11.1.0.6 | ignore KKOIXMSU flag and match index filter preds with index key |
97 | 5288623 | enabled | Y | 10.1.0.6 | also try for sort eliminating index with maximum columns |
98 | 5505995 | enabled | Y | 11.1.0.6 | Consider pushing into each of two views sharing join predicate |
99 | 5505157 | enabled | Y | 11.1.0.6 | relax type matching in pre-rewrite transitive predicate generati |
100 | 5112460 | enabled | Y | 11.1.0.6 | Make table elimination independent of CVM |
101 | 5554865 | enabled | Y | 11.1.0.6 | Allow inner join table elimination on unique col |
102 | 5112260 | enabled | Y | 11.1.0.6 | semi join table elimination |
103 | 5112352 | enabled | Y | 11.1.0.6 | anti join table elimination |
104 | 5547058 | enabled | Y | 10.2.0.4 | Promote column min/max values in OJPPD for UNION [ALL] views |
105 | 5618040 | enabled | Y | 10.2.0.4 | amend costing for index use to avoid sort with old FIRST_ROWS |
106 | 5585313 | enabled | Y | 11.1.0.6 | enable index prefetching for NLJ with unique scan as inner acces |
107 | 5547895 | enabled | Y | 10.2.0.4 | controls generating transitive predicates in presence of UDFs |
108 | 5634346 | enabled | Y | 10.2.0.4 | Relax equality operator restrictions for multicolumn inlists |
109 | 5620485 | enabled | Y | 10.2.0.4 | do not push into UV if target table is outer joinded |
110 | 5483301 | enabled | Y | 10.1.0.6 | Use min repeat count in freq histogram to compute the density |
111 | 5657044 | enabled | Y | 11.1.0.6 | consider new alternate index to avoid ORDER BY sort |
112 | 5694984 | enabled | Y | 10.2.0.4 | scale index num distinct keys with Watkins func in first_rows(k) |
113 | 5868490 | enabled | Y | 8.0.0 | disallow CVM for top QB views for DELETE |
114 | 5650477 | enabled | Y | 10.2.0.4 | set correlation flag if outer col is set func |
115 | 5611962 | enabled | Y | 10.2.0.4 | use index keys as filters when considering index min/max |
116 | 4279274 | enabled | Y | 11.1.0.6 | Cache user-defined operator stats across transformations |
117 | 5741121 | enabled | Y | 10.2.0.4 | avoid zero selectivity for negated predicate |
118 | 5714944 | enabled | Y | 11.1.0.6 | set IO cost for index skip scan to at least 1.0 |
119 | 5391505 | enabled | Y | 10.2.0.3 | add subheap for physical optimization |
120 | 5762598 | enabled | Y | 10.2.0.4 | improve selectivity for character strings of numeric data |
# | Fix | Current Value | Is Default | Optimizer1 Features Enable | Description |
121 | 5578791 | enabled | Y | 10.2.0.4 | do not discount branch io cost if inner table io cost is already |
122 | 5259048 | enabled | Y | 10.2.0.4 | undo unused inlist |
123 | 5882954 | enabled | Y | 10.1.0.6 | Avoid unnecessary column stats load for partitioned tables |
124 | 2492766 | enabled | Y | 9.2.0 | use OR'ed predicates in index filter |
125 | 5707608 | enabled | Y | 10.1.0.4 | do not load statistics for non access partitions |
126 | 5891471 | enabled | Y | 10.2.0.4 | no transitive generation across logical join check constraints |
127 | 5884780 | enabled | Y | 10.2.0.4 | consider list of values dimensions during star transformation |
128 | 5680702 | enabled | Y | 10.2.0.4 | adjust anti/semijoin index selectivity only if join preds as key |
129 | 5371452 | enabled | Y | 10.2.0.2 | put false predicate ahead in the predicate chain |
130 | 5838613 | enabled | Y | 10.2.0.4 | Sort tables for initial join order during star transformation |
131 | 5949981 | enabled | Y | 10.2.0.4 | amend selectivity for match of a single-row frequency bucket |
132 | 5624216 | enabled | Y | 10.2.0.4 | disable union all transformation if qbc does not have whr |
133 | 5741044 | enabled | Y | 10.2.0.2 | consider predicate with subquery when determine 1-row tables |
134 | 5976822 | enabled | Y | 10.2.0.4 | check dynamic sampling index selecticity for nested loops join |
135 | 6006457 | enabled | Y | 11.1.0.6 | merge single-table anti-joined view |
136 | 5872956 | enabled | Y | 10.2.0.4 | push constant filter predicates on PRIORs to connect by pump |
137 | 5923644 | enabled | Y | 11.1.0.6 | Enable outer to inner join conversion for inlist |
138 | 5943234 | enabled | Y | 8.0.0 | Change drop column, set unused to take X DML lock |
139 | 5844495 | enabled | Y | 11.1.0.6 | Eliminate group-by from [NOT] EXISTS subqueries |
140 | 4168080 | enabled | Y | 11.1.0.6 | Eliminate unneeded bitmap conversion |
141 | 6020579 | enabled | Y | 11.1.0.6 | Allow semi-join elimination with multi column operand |
142 | 5842686 | disabled | Y | compute avg col length for LONG RAW column | |
143 | 5996801 | enabled | Y | 11.1.0.6 | use subpartition-level statistics |
144 | 5593639 | enabled | Y | 11.1.0.6 | Push USERENV filter predicate into view |
145 | 6133948 | enabled | Y | 11.1.0.6 | allocate ckydef on the compilation heap |
146 | 6239909 | enabled | Y | 11.1.0.6 | Fix out-of-bound value in self induced caching |
# | Inst ID | Parameter | Current Value | Is Modified |
---|---|---|---|---|
1 | 1 | max_dump_file_size | UNLIMITED | MODIFIED |
2 | 1 | tracefile_identifier | IGNORE_ME_SQLT | MODIFIED |
# | Inst ID | Parameter | Current Value |
---|---|---|---|
1 | 1 | audit_file_dest | C:\ORACLE\ADMIN\ORA11R1\ADUMP |
2 | 1 | audit_trail | DB |
3 | 1 | compatible | 11.1.0.0.0 |
4 | 1 | control_files | C:\ORACLE\ORADATA\ORA11R1\CONTROL01.CTL |
5 | 1 | control_files | C:\ORACLE\ORADATA\ORA11R1\CONTROL02.CTL |
6 | 1 | control_files | C:\ORACLE\ORADATA\ORA11R1\CONTROL03.CTL |
7 | 1 | db_block_size | 8192 |
8 | 1 | db_domain | |
9 | 1 | db_name | ora11r1 |
10 | 1 | db_recovery_file_dest | C:\oracle\flash_recovery_area |
11 | 1 | db_recovery_file_dest_size | 2147483648 (2G) |
12 | 1 | diagnostic_dest | C:\ORACLE |
13 | 1 | dispatchers | (PROTOCOL=TCP) (SERVICE=ora11r1XDB) |
14 | 1 | memory_target | 805306368 (768M) |
15 | 1 | open_cursors | 300 |
16 | 1 | processes | 150 |
17 | 1 | remote_login_passwordfile | EXCLUSIVE |
18 | 1 | undo_tablespace | UNDOTBS1 |
19 | 1 | user_dump_dest | c:\oracle\diag\rdbms\ora11r1\ora11r1\trace |
# | Inst ID | Parameter | Current Value | Type | Is Default | Is System Modifiable | Is Instance Modifiable | Is Session Modifiable | Is Modified | Is Adjusted | Is Deprecated |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | active_instance_count | 3 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | |
2 | 1 | aq_tm_processes | 0 | 3 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
3 | 1 | archive_lag_target | 0 | 3 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
4 | 1 | asm_diskgroups | 2 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE | |
5 | 1 | asm_diskstring | 2 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE | |
6 | 1 | asm_power_limit | 1 | 3 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
7 | 1 | asm_preferred_read_failure_groups | 2 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE | |
8 | 1 | audit_file_dest | C:\ORACLE\ADMIN\ORA11R1\ADUMP | 2 | FALSE | DEFERRED | TRUE | FALSE | FALSE | FALSE | FALSE |
9 | 1 | audit_sys_operations | FALSE | 1 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
10 | 1 | audit_trail | DB | 2 | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
11 | 1 | background_core_dump | partial | 2 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
12 | 1 | background_dump_dest | c:\oracle\diag\rdbms\ora11r1\ora11r1\trace | 2 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | TRUE |
13 | 1 | backup_tape_io_slaves | FALSE | 1 | TRUE | DEFERRED | TRUE | FALSE | FALSE | FALSE | FALSE |
14 | 1 | bitmap_merge_area_size | 1048576 | 3 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
15 | 1 | blank_trimming | FALSE | 1 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
16 | 1 | buffer_pool_keep | 2 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | TRUE | |
17 | 1 | buffer_pool_recycle | 2 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | TRUE | |
18 | 1 | circuits | 3 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE | |
19 | 1 | client_result_cache_lag | 3000 | 6 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
20 | 1 | client_result_cache_size | 0 | 6 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
21 | 1 | cluster_database | FALSE | 1 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
22 | 1 | cluster_database_instances | 1 | 3 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
23 | 1 | cluster_interconnects | 2 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | |
24 | 1 | commit_logging | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE | |
25 | 1 | commit_point_strength | 1 | 3 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
26 | 1 | commit_wait | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE | |
27 | 1 | commit_write | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | TRUE | |
28 | 1 | compatible | 11.1.0.0.0 | 2 | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
29 | 1 | control_file_record_keep_time | 7 | 3 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
30 | 1 | control_files | C:\ORACLE\ORADATA\ORA11R1\CONTROL01.CTL | 2 | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
# | Inst ID | Parameter | Current Value | Type | Is Default | Is System Modifiable | Is Instance Modifiable | Is Session Modifiable | Is Modified | Is Adjusted | Is Deprecated |
31 | 1 | control_files | C:\ORACLE\ORADATA\ORA11R1\CONTROL02.CTL | 2 | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
32 | 1 | control_files | C:\ORACLE\ORADATA\ORA11R1\CONTROL03.CTL | 2 | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
33 | 1 | control_management_pack_access | DIAGNOSTIC+TUNING | 2 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
34 | 1 | core_dump_dest | c:\oracle\diag\rdbms\ora11r1\ora11r1\cdump | 2 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
35 | 1 | cpu_count | 2 | 3 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
36 | 1 | create_bitmap_area_size | 8388608 | 3 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
37 | 1 | create_stored_outlines | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE | |
38 | 1 | cursor_sharing | EXACT | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
39 | 1 | cursor_space_for_time | FALSE | 1 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
40 | 1 | db_16k_cache_size | 0 | 6 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
41 | 1 | db_2k_cache_size | 0 | 6 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
42 | 1 | db_32k_cache_size | 0 | 6 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
43 | 1 | db_4k_cache_size | 0 | 6 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
44 | 1 | db_8k_cache_size | 0 | 6 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
45 | 1 | db_block_buffers | 0 | 3 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
46 | 1 | db_block_checking | FALSE | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
47 | 1 | db_block_checksum | TYPICAL | 2 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
48 | 1 | db_block_size | 8192 | 3 | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
49 | 1 | db_cache_advice | ON | 2 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
50 | 1 | db_cache_size | 0 | 6 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
51 | 1 | db_create_file_dest | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE | |
52 | 1 | db_create_online_log_dest_1 | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE | |
53 | 1 | db_create_online_log_dest_2 | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE | |
54 | 1 | db_create_online_log_dest_3 | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE | |
55 | 1 | db_create_online_log_dest_4 | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE | |
56 | 1 | db_create_online_log_dest_5 | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE | |
57 | 1 | db_domain | 2 | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | |
58 | 1 | db_file_multiblock_read_count | 128 | 3 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
59 | 1 | db_file_name_convert | 2 | TRUE | FALSE | FALSE | TRUE | FALSE | FALSE | FALSE | |
60 | 1 | db_files | 200 | 3 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
# | Inst ID | Parameter | Current Value | Type | Is Default | Is System Modifiable | Is Instance Modifiable | Is Session Modifiable | Is Modified | Is Adjusted | Is Deprecated |
61 | 1 | db_flashback_retention_target | 1440 | 3 | TRUE | IMMEDIATE | FALSE | FALSE | FALSE | FALSE | FALSE |
62 | 1 | db_keep_cache_size | 0 | 6 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
63 | 1 | db_lost_write_protect | NONE | 2 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
64 | 1 | db_name | ora11r1 | 2 | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
65 | 1 | db_recovery_file_dest | C:\oracle\flash_recovery_area | 2 | FALSE | IMMEDIATE | FALSE | FALSE | FALSE | FALSE | FALSE |
66 | 1 | db_recovery_file_dest_size | 2147483648 (2G) | 6 | FALSE | IMMEDIATE | FALSE | FALSE | FALSE | FALSE | FALSE |
67 | 1 | db_recycle_cache_size | 0 | 6 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
68 | 1 | db_securefile | PERMITTED | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
69 | 1 | db_ultra_safe | OFF | 2 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
70 | 1 | db_unique_name | ora11r1 | 2 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
71 | 1 | db_writer_processes | 1 | 3 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
72 | 1 | dbwr_io_slaves | 0 | 3 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
73 | 1 | ddl_lock_timeout | 0 | 3 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
74 | 1 | dg_broker_config_file1 | C:\ORACLE\PRODUCT\11.1.0\DB_1\DATABASE\DR1ORA11R1.DAT | 2 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
75 | 1 | dg_broker_config_file2 | C:\ORACLE\PRODUCT\11.1.0\DB_1\DATABASE\DR2ORA11R1.DAT | 2 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
76 | 1 | dg_broker_start | FALSE | 1 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
77 | 1 | diagnostic_dest | C:\ORACLE | 2 | FALSE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
78 | 1 | disk_asynch_io | TRUE | 1 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
79 | 1 | dispatchers | (PROTOCOL=TCP) (SERVICE=ora11r1XDB) | 2 | FALSE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
80 | 1 | distributed_lock_timeout | 60 | 3 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
81 | 1 | dml_locks | 748 | 3 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
82 | 1 | drs_start | FALSE | 1 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | TRUE |
83 | 1 | enable_ddl_logging | FALSE | 1 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
84 | 1 | event | 2 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | |
85 | 1 | fal_client | 2 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE | |
86 | 1 | fal_server | 2 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE | |
87 | 1 | fast_start_io_target | 0 | 3 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | TRUE |
88 | 1 | fast_start_mttr_target | 0 | 3 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
89 | 1 | fast_start_parallel_rollback | LOW | 2 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
90 | 1 | file_mapping | FALSE | 1 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
# | Inst ID | Parameter | Current Value | Type | Is Default | Is System Modifiable | Is Instance Modifiable | Is Session Modifiable | Is Modified | Is Adjusted | Is Deprecated |
91 | 1 | fileio_network_adapters | 2 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | |
92 | 1 | filesystemio_options | 2 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | |
93 | 1 | fixed_date | 2 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE | |
94 | 1 | gc_files_to_locks | 2 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | |
95 | 1 | gcs_server_processes | 0 | 3 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
96 | 1 | global_context_pool_size | 2 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | TRUE | |
97 | 1 | global_names | FALSE | 1 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
98 | 1 | global_txn_processes | 1 | 3 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
99 | 1 | hash_area_size | 131072 | 3 | TRUE | FALSE | FALSE | TRUE | FALSE | FALSE | FALSE |
100 | 1 | hi_shared_memory_address | 0 | 3 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
101 | 1 | hs_autoregister | TRUE | 1 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
102 | 1 | ifile | 4 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | |
103 | 1 | instance_groups | 2 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | TRUE | |
104 | 1 | instance_name | ora11r1 | 2 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
105 | 1 | instance_number | 0 | 3 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
106 | 1 | instance_type | RDBMS | 2 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
107 | 1 | java_jit_enabled | TRUE | 1 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
108 | 1 | java_max_sessionspace_size | 0 | 3 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
109 | 1 | java_pool_size | 0 | 6 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
110 | 1 | java_soft_sessionspace_limit | 0 | 3 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
111 | 1 | job_queue_processes | 1000 | 3 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
112 | 1 | large_pool_size | 0 | 6 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
113 | 1 | ldap_directory_access | NONE | 2 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
114 | 1 | ldap_directory_sysauth | no | 2 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
115 | 1 | license_max_sessions | 0 | 3 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
116 | 1 | license_max_users | 0 | 3 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
117 | 1 | license_sessions_warning | 0 | 3 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
118 | 1 | local_listener | 2 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE | |
119 | 1 | lock_name_space | 2 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | TRUE | |
120 | 1 | lock_sga | FALSE | 1 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
# | Inst ID | Parameter | Current Value | Type | Is Default | Is System Modifiable | Is Instance Modifiable | Is Session Modifiable | Is Modified | Is Adjusted | Is Deprecated |
121 | 1 | log_archive_config | 2 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE | |
122 | 1 | log_archive_dest | 2 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE | |
123 | 1 | log_archive_dest_1 | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE | |
124 | 1 | log_archive_dest_10 | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE | |
125 | 1 | log_archive_dest_2 | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE | |
126 | 1 | log_archive_dest_3 | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE | |
127 | 1 | log_archive_dest_4 | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE | |
128 | 1 | log_archive_dest_5 | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE | |
129 | 1 | log_archive_dest_6 | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE | |
130 | 1 | log_archive_dest_7 | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE | |
131 | 1 | log_archive_dest_8 | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE | |
132 | 1 | log_archive_dest_9 | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE | |
133 | 1 | log_archive_dest_state_1 | enable | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
134 | 1 | log_archive_dest_state_10 | enable | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
135 | 1 | log_archive_dest_state_2 | enable | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
136 | 1 | log_archive_dest_state_3 | enable | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
137 | 1 | log_archive_dest_state_4 | enable | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
138 | 1 | log_archive_dest_state_5 | enable | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
139 | 1 | log_archive_dest_state_6 | enable | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
140 | 1 | log_archive_dest_state_7 | enable | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
141 | 1 | log_archive_dest_state_8 | enable | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
142 | 1 | log_archive_dest_state_9 | enable | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
143 | 1 | log_archive_duplex_dest | 2 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE | |
144 | 1 | log_archive_format | ARC%S_%R.%T | 2 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
145 | 1 | log_archive_local_first | TRUE | 1 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | TRUE |
146 | 1 | log_archive_max_processes | 4 | 3 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
147 | 1 | log_archive_min_succeed_dest | 1 | 3 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
148 | 1 | log_archive_start | FALSE | 1 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | TRUE |
149 | 1 | log_archive_trace | 0 | 3 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
150 | 1 | log_buffer | 5653504 | 3 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
# | Inst ID | Parameter | Current Value | Type | Is Default | Is System Modifiable | Is Instance Modifiable | Is Session Modifiable | Is Modified | Is Adjusted | Is Deprecated |
151 | 1 | log_checkpoint_interval | 0 | 3 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
152 | 1 | log_checkpoint_timeout | 1800 | 3 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
153 | 1 | log_checkpoints_to_alert | FALSE | 1 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
154 | 1 | log_file_name_convert | 2 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | |
155 | 1 | max_commit_propagation_delay | 0 | 3 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | TRUE |
156 | 1 | max_dispatchers | 3 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE | |
157 | 1 | max_dump_file_size | UNLIMITED | 2 | TRUE | IMMEDIATE | TRUE | TRUE | MODIFIED | FALSE | FALSE |
158 | 1 | max_enabled_roles | 150 | 3 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | TRUE |
159 | 1 | max_shared_servers | 3 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE | |
160 | 1 | memory_max_target | 805306368 (768M) | 6 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
161 | 1 | memory_target | 805306368 (768M) | 6 | FALSE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
162 | 1 | nls_calendar | 2 | TRUE | FALSE | FALSE | TRUE | FALSE | FALSE | FALSE | |
163 | 1 | nls_comp | BINARY | 2 | TRUE | FALSE | FALSE | TRUE | FALSE | FALSE | FALSE |
164 | 1 | nls_currency | 2 | TRUE | FALSE | FALSE | TRUE | FALSE | FALSE | FALSE | |
165 | 1 | nls_date_format | 2 | TRUE | FALSE | FALSE | TRUE | FALSE | FALSE | FALSE | |
166 | 1 | nls_date_language | 2 | TRUE | FALSE | FALSE | TRUE | FALSE | FALSE | FALSE | |
167 | 1 | nls_dual_currency | 2 | TRUE | FALSE | FALSE | TRUE | FALSE | FALSE | FALSE | |
168 | 1 | nls_iso_currency | 2 | TRUE | FALSE | FALSE | TRUE | FALSE | FALSE | FALSE | |
169 | 1 | nls_language | AMERICAN | 2 | TRUE | FALSE | FALSE | TRUE | FALSE | FALSE | FALSE |
170 | 1 | nls_length_semantics | BYTE | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
171 | 1 | nls_nchar_conv_excp | FALSE | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
172 | 1 | nls_numeric_characters | 2 | TRUE | FALSE | FALSE | TRUE | FALSE | FALSE | FALSE | |
173 | 1 | nls_sort | 2 | TRUE | FALSE | FALSE | TRUE | FALSE | FALSE | FALSE | |
174 | 1 | nls_territory | AMERICA | 2 | TRUE | FALSE | FALSE | TRUE | FALSE | FALSE | FALSE |
175 | 1 | nls_time_format | 2 | TRUE | FALSE | FALSE | TRUE | FALSE | FALSE | FALSE | |
176 | 1 | nls_time_tz_format | 2 | TRUE | FALSE | FALSE | TRUE | FALSE | FALSE | FALSE | |
177 | 1 | nls_timestamp_format | 2 | TRUE | FALSE | FALSE | TRUE | FALSE | FALSE | FALSE | |
178 | 1 | nls_timestamp_tz_format | 2 | TRUE | FALSE | FALSE | TRUE | FALSE | FALSE | FALSE | |
179 | 1 | o7_dictionary_accessibility | FALSE | 1 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
180 | 1 | object_cache_max_size_percent | 10 | 3 | TRUE | DEFERRED | TRUE | TRUE | FALSE | FALSE | FALSE |
# | Inst ID | Parameter | Current Value | Type | Is Default | Is System Modifiable | Is Instance Modifiable | Is Session Modifiable | Is Modified | Is Adjusted | Is Deprecated |
181 | 1 | object_cache_optimal_size | 102400 | 3 | TRUE | DEFERRED | TRUE | TRUE | FALSE | FALSE | FALSE |
182 | 1 | olap_page_pool_size | 0 | 6 | TRUE | DEFERRED | TRUE | TRUE | FALSE | FALSE | FALSE |
183 | 1 | open_cursors | 300 | 3 | FALSE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
184 | 1 | open_links | 4 | 3 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
185 | 1 | open_links_per_instance | 4 | 3 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
186 | 1 | optimizer_capture_sql_plan_baselines | FALSE | 1 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
187 | 1 | optimizer_dynamic_sampling | 2 | 3 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
188 | 1 | optimizer_features_enable | 11.1.0.6 | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
189 | 1 | optimizer_index_caching | 0 | 3 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
190 | 1 | optimizer_index_cost_adj | 100 | 3 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
191 | 1 | optimizer_mode | ALL_ROWS | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
192 | 1 | optimizer_secure_view_merging | TRUE | 1 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
193 | 1 | optimizer_use_invisible_indexes | FALSE | 1 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
194 | 1 | optimizer_use_pending_statistics | FALSE | 1 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
195 | 1 | optimizer_use_sql_plan_baselines | TRUE | 1 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
196 | 1 | os_authent_prefix | OPS$ | 2 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
197 | 1 | os_roles | FALSE | 1 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
198 | 1 | parallel_adaptive_multi_user | TRUE | 1 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
199 | 1 | parallel_automatic_tuning | FALSE | 1 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | TRUE |
200 | 1 | parallel_execution_message_size | 2148 | 3 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
201 | 1 | parallel_instance_group | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE | |
202 | 1 | parallel_io_cap_enabled | FALSE | 1 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
203 | 1 | parallel_max_servers | 20 | 3 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
204 | 1 | parallel_min_percent | 0 | 3 | TRUE | FALSE | FALSE | TRUE | FALSE | FALSE | FALSE |
205 | 1 | parallel_min_servers | 0 | 3 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
206 | 1 | parallel_server | FALSE | 1 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | TRUE |
207 | 1 | parallel_server_instances | 1 | 3 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | TRUE |
208 | 1 | parallel_threads_per_cpu | 2 | 3 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
209 | 1 | pga_aggregate_target | 0 | 6 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
210 | 1 | plscope_settings | IDENTIFIERS:NONE | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
# | Inst ID | Parameter | Current Value | Type | Is Default | Is System Modifiable | Is Instance Modifiable | Is Session Modifiable | Is Modified | Is Adjusted | Is Deprecated |
211 | 1 | plsql_ccflags | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE | |
212 | 1 | plsql_code_type | INTERPRETED | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
213 | 1 | plsql_debug | FALSE | 1 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | TRUE |
214 | 1 | plsql_native_library_dir | 2 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE | |
215 | 1 | plsql_native_library_subdir_count | 0 | 3 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
216 | 1 | plsql_optimize_level | 2 | 3 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
217 | 1 | plsql_v2_compatibility | FALSE | 1 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | TRUE |
218 | 1 | plsql_warnings | DISABLE:ALL | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
219 | 1 | pre_page_sga | FALSE | 1 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
220 | 1 | processes | 150 | 3 | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
221 | 1 | query_rewrite_enabled | TRUE | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
222 | 1 | query_rewrite_integrity | enforced | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
223 | 1 | rdbms_server_dn | 2 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | |
224 | 1 | read_only_open_delayed | FALSE | 1 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
225 | 1 | recovery_parallelism | 0 | 3 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
226 | 1 | recyclebin | on | 2 | TRUE | DEFERRED | TRUE | TRUE | FALSE | FALSE | FALSE |
227 | 1 | redo_transport_user | 2 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE | |
228 | 1 | remote_dependencies_mode | TIMESTAMP | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
229 | 1 | remote_listener | 2 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE | |
230 | 1 | remote_login_passwordfile | EXCLUSIVE | 2 | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
231 | 1 | remote_os_authent | FALSE | 1 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | TRUE |
232 | 1 | remote_os_roles | FALSE | 1 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
233 | 1 | replication_dependency_tracking | TRUE | 1 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
234 | 1 | resource_limit | FALSE | 1 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
235 | 1 | resource_manager_cpu_allocation | 2 | 3 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
236 | 1 | resource_manager_plan | 2 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE | |
237 | 1 | result_cache_max_result | 5 | 3 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
238 | 1 | result_cache_max_size | 2031616 (1984K) | 6 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
239 | 1 | result_cache_mode | MANUAL | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
240 | 1 | result_cache_remote_expiration | 0 | 3 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
# | Inst ID | Parameter | Current Value | Type | Is Default | Is System Modifiable | Is Instance Modifiable | Is Session Modifiable | Is Modified | Is Adjusted | Is Deprecated |
241 | 1 | resumable_timeout | 0 | 3 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
242 | 1 | rollback_segments | 2 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | |
243 | 1 | sec_case_sensitive_logon | TRUE | 1 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
244 | 1 | sec_max_failed_login_attempts | 10 | 3 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
245 | 1 | sec_protocol_error_further_action | CONTINUE | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
246 | 1 | sec_protocol_error_trace_action | TRACE | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
247 | 1 | sec_return_server_release_banner | FALSE | 1 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
248 | 1 | serial_reuse | disable | 2 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | TRUE |
249 | 1 | service_names | ora11r1 | 2 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
250 | 1 | session_cached_cursors | 50 | 3 | TRUE | FALSE | FALSE | TRUE | FALSE | FALSE | FALSE |
251 | 1 | session_max_open_files | 10 | 3 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
252 | 1 | sessions | 170 | 3 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
253 | 1 | sga_max_size | 536870912 (512M) | 6 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
254 | 1 | sga_target | 0 | 6 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
255 | 1 | shadow_core_dump | none | 2 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
256 | 1 | shared_memory_address | 0 | 3 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
257 | 1 | shared_pool_reserved_size | 10276044 | 6 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
258 | 1 | shared_pool_size | 0 | 6 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
259 | 1 | shared_server_sessions | 3 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE | |
260 | 1 | shared_servers | 1 | 3 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
261 | 1 | skip_unusable_indexes | TRUE | 1 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
262 | 1 | smtp_out_server | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE | |
263 | 1 | sort_area_retained_size | 0 | 3 | TRUE | DEFERRED | TRUE | TRUE | FALSE | FALSE | FALSE |
264 | 1 | sort_area_size | 65536 | 3 | TRUE | DEFERRED | TRUE | TRUE | FALSE | FALSE | FALSE |
265 | 1 | spfile | C:\ORACLE\PRODUCT\11.1.0\DB_1\DATABASE\SPFILEORA11R1.ORA | 2 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
266 | 1 | sql92_security | FALSE | 1 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
267 | 1 | sql_trace | FALSE | 1 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | TRUE |
268 | 1 | sql_version | NATIVE | 2 | TRUE | FALSE | FALSE | TRUE | FALSE | FALSE | TRUE |
269 | 1 | sqltune_category | DEFAULT | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
270 | 1 | standby_archive_dest | %ORACLE_HOME%\RDBMS | 2 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | TRUE |
# | Inst ID | Parameter | Current Value | Type | Is Default | Is System Modifiable | Is Instance Modifiable | Is Session Modifiable | Is Modified | Is Adjusted | Is Deprecated |
271 | 1 | standby_file_management | MANUAL | 2 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
272 | 1 | star_transformation_enabled | FALSE | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
273 | 1 | statistics_level | TYPICAL | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
274 | 1 | streams_pool_size | 0 | 6 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
275 | 1 | tape_asynch_io | TRUE | 1 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
276 | 1 | thread | 0 | 3 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
277 | 1 | timed_os_statistics | 0 | 3 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
278 | 1 | timed_statistics | TRUE | 1 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
279 | 1 | trace_enabled | TRUE | 1 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
280 | 1 | tracefile_identifier | IGNORE_ME_SQLT | 2 | TRUE | FALSE | FALSE | TRUE | MODIFIED | FALSE | FALSE |
281 | 1 | transactions | 187 | 3 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
282 | 1 | transactions_per_rollback_segment | 5 | 3 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
283 | 1 | undo_management | AUTO | 2 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
284 | 1 | undo_retention | 900 | 3 | TRUE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
285 | 1 | undo_tablespace | UNDOTBS1 | 2 | FALSE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | FALSE |
286 | 1 | use_indirect_data_buffers | FALSE | 1 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
287 | 1 | user_dump_dest | c:\oracle\diag\rdbms\ora11r1\ora11r1\trace | 2 | FALSE | IMMEDIATE | TRUE | FALSE | FALSE | FALSE | TRUE |
288 | 1 | utl_file_dir | 2 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | |
289 | 1 | workarea_size_policy | AUTO | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
290 | 1 | xml_db_events | enable | 2 | TRUE | IMMEDIATE | TRUE | TRUE | FALSE | FALSE | FALSE |
ID | Exec Order | Plan Operation | Object ID | Cost | Estim Card |
Search Cols | Indexed Cols | AP: FP: | CBO Stats | Metadata |
---|---|---|---|---|---|---|---|---|---|---|
0: | 11 | SELECT STATEMENT | 149 | |||||||
1: | 10 | SORT GROUP BY NOSORT | 149 | 61 | ||||||
2: | 9 | . MERGE JOIN | 149 | 1019 | ||||||
3: | 6 | .. SORT JOIN | 113 | 63 | ||||||
4: | 5 | ... VIEW VW_GBC_17 | 113 | 63 | ||||||
5: | 4 | .... HASH GROUP BY | 113 | 63 | ||||||
6: | 3 | ....+ HASH JOIN | 112 | 2225 | [+] | |||||
7: | 1 | ....+. TABLE ACCESS FULL MASTER | 74055 | 104 | 472 | [+] | Stats | Metadata | ||
8: | 2 | ....+. TABLE ACCESS FULL MANAGERS | 74052 | 7 | 2895 | Stats | Metadata | |||
9: | 8 | .. SORT JOIN | 36 | 1019 | [+] | |||||
10: | 7 | ... TABLE ACCESS FULL TEAMS | 74053 | 35 | 1019 | [+] | Stats | Metadata |
ID | Object Owner | Object Name | Object Type | Object ID | Parent ID | Pos | Obj Inst | Search Cols | Estim Card | Estim Bytes | Operation Cost (IO + CPU) | Plan Table Cost | IO Cost | CPU Cycles | Time | Temp Space | Query Block | Alias | Remarks |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0: | 149 | 0 | 149 | ||||||||||||||||
1: | 0 | 1 | 0 | 61 | 1281 | 148.820239 | 149 | 145 | 84621783 | 2 | SEL$6989E656 | ||||||||
2: | 1 | 1 | 0 | 1019 | 21399 | 148.820239 | 149 | 145 | 84621783 | 2 | |||||||||
3: | 2 | 1 | 0 | 63 | 1008 | 112.721843 | 113 | 110 | 60291309 | 2 | |||||||||
4: | VW_GBC_17 | VIEW | 3 | 1 | 0 | 63 | 1008 | 112.721843 | 113 | 110 | 60291309 | 2 | SEL$207703A3 | VW_GBC_17@SEL$6989E656 | |||||
5: | 4 | 1 | 0 | 63 | 1701 | 112.721843 | 113 | 110 | 60291309 | 2 | SEL$207703A3 | ||||||||
6: | 5 | 1 | 0 | 2225 | 60075 | 111.67152 | 112 | 110 | 37025697 | 2 | |||||||||
7: | USER0 | MASTER | TABLE | 74055 | 6 | 1 | 0 | 472 | 5664 | 104.118765 | 104 | 103 | 24781661 | 2 | SEL$207703A3 | MA@SEL$1 | |||
8: | USER0 | MANAGERS | TABLE | 74052 | 6 | 2 | 0 | 2895 | 43425 | 7.03649 | 7 | 7 | 808279 | 1 | SEL$207703A3 | MG@SEL$1 | |||
9: | 2 | 2 | 0 | 1019 | 5095 | 36.098396 | 36 | 35 | 24330474 | 1 | |||||||||
10: | USER0 | TEAMS | TABLE | 74053 | 9 | 1 | 0 | 1019 | 5095 | 35.077684 | 35 | 35 | 1720779 | 1 | SEL$6989E656 | T@SEL$1 |
ID | Column Name | Column Value |
---|---|---|
1: | Projection | (#keys=1) "T"."TEAM_ID"[VARCHAR2,3], SUM("ITEM_2")[22] |
2: | Projection | "T"."TEAM_ID"[VARCHAR2,3], "ITEM_2"[NUMBER,22] |
3: | Projection | (#keys=1) "ITEM_1"[VARCHAR2,3], "ITEM_2"[NUMBER,22] |
4: | Projection | "ITEM_1"[VARCHAR2,3], "ITEM_2"[NUMBER,22] |
5: | Projection | "MG"."TEAM_ID"[VARCHAR2,3], COUNT(*)[22] |
6: | Access Predicates | "MG"."LAHMANID"="MA"."LAHMANID" |
6: | Projection | (#keys=1) "MG"."TEAM_ID"[VARCHAR2,3] |
7: | Filter Predicates | "MA"."DEBUT_SEASON_YYYY"=1965 |
7: | Projection | "MA"."LAHMANID"[VARCHAR2,12] |
8: | Projection | "MG"."LAHMANID"[VARCHAR2,12], "MG"."TEAM_ID"[VARCHAR2,3] |
9: | Access Predicates | "T"."TEAM_ID"="ITEM_1" |
9: | Filter Predicates | "T"."TEAM_ID"="ITEM_1" |
9: | Projection | (#keys=1) "T"."TEAM_ID"[VARCHAR2,3] |
10: | Filter Predicates | "T"."WIN_PCT">.5 |
10: | Projection | "T"."TEAM_ID"[VARCHAR2,3] |
# | Table Name | Access Type | Index Name |
---|---|---|---|
1 | MA | TABLE ONLY | |
2 | MG | TABLE ONLY | |
3 | T | TABLE ONLY |
# | Query Block Name | Oper ID | Table Name | Object Alias | Access Type | Table Access | Table Access Cost | Table Orig Card | Table Estim Card | Table Starts | Table Actual Rows | Index Name | Index Access | Index Access Cost | Index Estim Card | Index Starts | Index Actual Rows |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | SEL$207703A3 | 7 | USER0.MASTER | MA@SEL$1 | TABLE ONLY | FULL | 104 | 61400 | 472 | ||||||||
2 | SEL$207703A3 | 8 | USER0.MANAGERS | MG@SEL$1 | TABLE ONLY | FULL | 7 | 2895 | 2895 | ||||||||
3 | SEL$6989E656 | 10 | USER0.TEAMS | T@SEL$1 | TABLE ONLY | FULL | 35 | 2327 | 1019 |
# | Plan Hash Value | Child Count | Total Execs | Total Buffer Gets | Total Elapsed Time (secs) | Avg Buffer Gets | Avg Elapsed Time (secs) | Max Elapsed Time (secs) | Not Shareable Reason1 (and cursor count) |
---|---|---|---|---|---|---|---|---|---|
1 | 2196188739 | 1 | 7 | 3857 | .23 | 551 | .033 | .23 |
# | Inst ID | Child Number | Child Address | Execs | Buffer Gets | Elapsed Time (secs) | Not Shareable Reason1 | Plan Hash Value | Child Count under this Plan HV |
---|---|---|---|---|---|---|---|---|---|
1 | 1 | 0 | 27EDCD18 | 7 | 3857 | .23 | 2196188739 | 1 |
Hash Value: | 1768835873 |
Old Hash Value: | 2766922883 |
Type Chk Heap: | 00 |
Address: | 27ED2E7C |
Child Address: | 27EDCD18 |
Child Latch: | 0 |
SQL ID: | gtyp03pnqwkt1 |
Command Type: | 3 |
Service: | ora11r1 |
Service Hash: | 0 |
Module: | SQL*Plus |
Module Hash: | -625018272 |
Action Hash: | 0 |
Program ID: | 69261 |
Program Line #: | 455 |
Serializable Aborts: | 0 |
Parsing Schema ID: | 89 |
Parsing Schema Name: | USER0 |
Parsing User ID: | 89 |
Parsing User Name: | USER0 |
SQL Type: | 6 |
Remote: | N |
Object Status: | VALID |
Literal Hash Value: | 0 |
Optimizer Cost: | 149 |
Optimizer Mode: | ALL_ROWS |
Optimizer Env Hash Value: | 3981172680 |
CPU Time (secs): | .094 |
Elapsed Time (secs): | .23 |
Application Wait Time (secs): | 0 |
Concurrency Wait Time (secs): | 0 |
Cluster Wait Time (secs): | 0 |
User I/O Wait Time (secs): | .117 |
PL/SQL Execution Time (secs): | 0 |
Java Execution Time (secs): | 0 |
Rows Processed: | 70 |
Parse Calls: | 7 |
Fetches: | 14 |
End-of-fetch Count: | 7 |
Executions: | 7 |
PX Servers Executions: | 0 |
Buffer Gets: | 3857 |
Disk Reads: | 526 |
Direct Writes: | 0 |
Sorts: | 14 |
Sharable Memory (bytes): | 16814 |
Persistent Memory (bytes): | 9024 |
Runtime Memory (bytes): | 8416 |
Outline Category: | "none was used" |
Exact Matching Signature: | 17315877379555196788 |
Force Matching Signature: | 18003452728971213200 |
SQL Profile: | "none was used" |
SQL Patch: | "none was used" |
SQL Patch Baseline: | "none was used" |
Loaded Versions: | 1 |
Open Versions: | 1 |
Users Opening: | 1 |
Users Executing: | 0 |
Loads: | 1 |
Invalidations: | 0 |
Kept Versions: | 0 |
First Load Time: | 2009-09-22/20:31:18 |
Last Load Time: | 2009-09-22/20:31:18 |
Last Active Time: | 2009-09-22/20:46:46 |
Is Obsolete: | N |
Is Bind Sensitive: | N |
Is Bind Aware: | N |
Is Shareable: | Y |
Type Check Mem: | 0 |
Oper ID | Plan Operation | Object ID | Object Owner | Cost | Estim Card | Last* Starts | Last* Output Rows | Total* Starts | Total* Output Rows | Search Cols | Indexed Cols | AP: FP: | Total* Buffer Gets | Total* Disk Reads | Total* Elapsed Time in secs |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0: | SELECT STATEMENT | 149 | |||||||||||||
1: | SORT GROUP BY NOSORT | 149 | 61 | ||||||||||||
2: | . MERGE JOIN | 149 | 1019 | ||||||||||||
3: | .. SORT JOIN | 113 | 63 | ||||||||||||
4: | ... VIEW VW_GBC_17 | 113 | 63 | ||||||||||||
5: | .... HASH GROUP BY | 113 | 63 | ||||||||||||
6: | ....+ HASH JOIN | 112 | 2225 | [+] | |||||||||||
7: | ....+. TABLE ACCESS FULL MASTER | 74055 | USER0 | 104 | 472 | [+] | |||||||||
8: | ....+. TABLE ACCESS FULL MANAGERS | 74052 | USER0 | 7 | 2895 | ||||||||||
9: | .. SORT JOIN | 36 | 1019 | [+] | |||||||||||
10: | ... TABLE ACCESS FULL TEAMS | 74053 | USER0 | 35 | 1019 | [+] |
Oper ID | Workarea Address | Operation Type | Policy | Estimated Optimal Size Bytes | Estimated Onepass Size Bytes | Last Memory Used Bytes | Last Execution | Last Degree | Total Executions | Optimal Executions | Onepass Executions | Multipasses Executions | Active Time | Max Tempseg Size | Last Tempseg Size |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3: | 265AA88C | SORT (v2) | AUTO | 2048 | 2048 | 2048 | OPTIMAL | 1 | 7 | 7 | 0 | 0 | 0 | ||
5: | 265AA834 | GROUP BY (HASH) | AUTO | 900096 | 900096 | 821248 | OPTIMAL | 1 | 7 | 7 | 0 | 0 | 9218 | ||
6: | 265AA7DC | HASH-JOIN | AUTO | 957440 | 957440 | 1217536 | OPTIMAL | 1 | 7 | 7 | 0 | 0 | 6887 | ||
9: | 265AA8E4 | SORT (v2) | AUTO | 29696 | 29696 | 26624 | OPTIMAL | 1 | 7 | 7 | 0 | 0 | 0 |
# | Plan Hash Value | Inst | Total Execs | Total Buffer Gets | Total Elapsed Time (secs) | Avg Buffer Gets | Avg Elapsed Time (secs) |
---|---|---|---|---|---|---|---|
1 | 2196188739 | 1 | 1 | 689 | .17 | 689 | .17 |
DB ID: | 2470457352 |
Inst: | 1 |
Inst Startup: | 21-SEP-09 06.00.21.000 PM |
Snap ID: | 825 |
Begin Interval: | 22-SEP-09 08.00.02.062 PM |
End Interval: | 22-SEP-09 08.32.12.125 PM |
SQL ID: | gtyp03pnqwkt1 |
Module: | SQL*Plus |
Parsing Schema ID: | 89 |
Parsing Schema Name: | USER0 |
Parsing User ID: | 89 |
Parsing User Name: | USER0 |
Optimizer Cost: | 149 |
Optimizer Mode: | ALL_ROWS |
CPU Time Total (secs): | .047 |
CPU Time Delta (secs): | .047 |
Elapsed Time Total (secs): | .17 |
Elapsed Time Delta (secs): | .17 |
Application Wait Time Total (secs): | 0 |
Application Wait Time Delta (secs): | 0 |
Concurrency Wait Time Total (secs): | 0 |
Concurrency Wait Time Delta (secs): | 0 |
Cluster Wait Time Total (secs): | 0 |
Cluster Wait Time Delta (secs): | 0 |
User I/O Wait Time Total (secs): | .117 |
User I/O Wait Time Delta (secs): | .117 |
PL/SQL Execution Time Total (secs): | 0 |
PL/SQL Execution Time Delta (secs): | 0 |
Java Execution Time Total (secs): | 0 |
Java Execution Time Delta (secs): | 0 |
Rows Processed Total: | 10 |
Rows Processed Delta: | 10 |
Parse Calls Total: | 1 |
Parse Calls Delta: | 1 |
Fetches Total: | 2 |
Fetches Delta: | 2 |
End-of-fetch Count Total: | 1 |
End-of-fetch Count Delta: | 1 |
Executions Total: | 1 |
Executions Delta: | 1 |
Buffer Gets Total: | 689 |
Buffer Gets Delta: | 689 |
Disk Reads Total: | 526 |
Disk Reads Delta: | 526 |
Direct Writes Total: | 0 |
Direct Writes Delta: | 0 |
Sorts Total: | 2 |
Sorts Delta: | 2 |
Sharable Memory (bytes): | 16814 |
SQL Profile: | "none was used" |
Force Matching Signature: | 18003452728971213200 |
Loaded Versions: | 1 |
Version Count: | 1 |
Loads Total: | 1 |
Loads Delta: | 0 |
Invalidations Total: | 0 |
Invalidations Delta: | 0 |
PX Servers Executions Total: | 0 |
PX Servers Executions Delta: | 0 |
Oper ID | Plan Operation | Object ID | Object Owner | Cost | Estim Card | Search Cols | Indexed Cols | AP: FP: |
---|---|---|---|---|---|---|---|---|
0: | SELECT STATEMENT | 149 | ||||||
1: | SORT GROUP BY NOSORT | 149 | 61 | |||||
2: | . MERGE JOIN | 149 | 1019 | |||||
3: | .. SORT JOIN | 113 | 63 | |||||
4: | ... VIEW VW_GBC_17 | 113 | 63 | |||||
5: | .... HASH GROUP BY | 113 | 63 | |||||
6: | ....+ HASH JOIN | 112 | 2225 | |||||
7: | ....+. TABLE ACCESS FULL MASTER | 74055 | USER0 | 104 | 472 | |||
8: | ....+. TABLE ACCESS FULL MANAGERS | 74052 | USER0 | 7 | 2895 | |||
9: | .. SORT JOIN | 36 | 1019 | |||||
10: | ... TABLE ACCESS FULL TEAMS | 74053 | USER0 | 35 | 1019 |
# | Inst ID | Type | Object Owner.Name | Hash Value | Address | Object ID | Script Version | Metadata | Ref Object Owner.Name | Ref Hash Value | Ref Address | Ref Source |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | TABLE | USER0.MANAGERS | 781870466 | 27D44638 | 74052 | Metadata | 1768835873 | 27ED2E7C | V$OBJECT_DEPENDENCY | ||
2 | 1 | TABLE | USER0.MASTER | 2944979179 | 27EE10F0 | 74055 | Metadata | 1768835873 | 27ED2E7C | V$OBJECT_DEPENDENCY | ||
3 | 1 | TABLE | USER0.TEAMS | 1385284558 | 27EE0EA4 | 74053 | Metadata | 1768835873 | 27ED2E7C | V$OBJECT_DEPENDENCY |
# | Object Type | Owner | Object Name | Sub Object Name | Object ID | Data Object ID | Created | Last DDL | Timestamp | Segment Blocks | Extents | Status | Temporary | Generated | Secondary | Metadata |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | TABLE | USER0 | MANAGERS | 74052 | 74052 | 24-AUG-09 04:33:37 | 24-AUG-09 04:33:37 | 2009-08-24:04:33:37 | 128 | 16 | VALID | N | N | N | Metadata | |
2 | TABLE | USER0 | MASTER | 74055 | 74055 | 24-AUG-09 04:33:37 | 24-AUG-09 04:33:37 | 2009-08-24:04:33:37 | 512 | 4 | VALID | N | N | N | Metadata | |
3 | TABLE | USER0 | TEAMS | 74053 | 74053 | 24-AUG-09 04:33:37 | 24-AUG-09 04:33:37 | 2009-08-24:04:33:37 | 256 | 2 | VALID | N | N | N | Metadata | |
4 | INDEX | USER0 | TEAMS_PK | 74054 | 74054 | 24-AUG-09 04:33:37 | 24-AUG-09 04:33:37 | 2009-08-24:04:33:37 | 16 | 2 | VALID | N | N | N | Metadata |
# | Owner.Table Name | Current COUNT |
Num* Rows | Sample* Size | Last* Analyzed | Avg* Row Len | Chain* Cnt | Segment Blocks | Blocks* | Empty* Blocks | Avg* Space | Global* Stats | User* Stats |
CBO Stats |
Metadata | Stats Type Locked | Data Stats Locked | Cache Stats Locked | Monitor | Stale Stats | Inserts | Updates | Deletes | Timestamp | Avg Cached Blocks | Avg Cache Hit Ratio |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | USER0.MANAGERS | 2895 | 2895 | 2895 | 24-AUG-09 05:12:22 | 49 | 0 | 128 | 20 | 108 | 750 | NO | NO | Stats | Metadata | NO | YES | NO | ||||||||
2 | USER0.MASTER | 61400 | 61400 | 61400 | 24-AUG-09 05:12:23 | 43 | 0 | 512 | 376 | 136 | 685 | NO | NO | Stats | Metadata | NO | YES | NO | ||||||||
3 | USER0.TEAMS | 2327 | 2327 | 2327 | 24-AUG-09 05:12:22 | 256 | 0 | 256 | 124 | 132 | 3233 | NO | NO | Stats | Metadata | NO | YES | NO |
# | Owner.Table Name | Object ID | Tablespace | Temporary | Duration | Partitioned | Logging | Degree | Cache | IOT Type | Nested | Dependencies | Compression | Ini Trans | Max Trans | Freelist Groups | Freelists |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | USER0.MANAGERS | 74052 | USERS | N | NO | YES | 1 | N | NO | DISABLED | DISABLED | 1 | 255 | ||||
2 | USER0.MASTER | 74055 | USERS | N | NO | YES | 1 | N | NO | DISABLED | DISABLED | 1 | 255 | ||||
3 | USER0.TEAMS | 74053 | USERS | N | NO | YES | 1 | N | NO | DISABLED | DISABLED | 1 | 255 |
Col ID | Column Name | Data Type | Data Type Mod | Data Type Owner | Data Length | Data Precision | Data Scale | Nullable | Character Set Name | Char Length | Char Used | Index Count | Leading Index Count | Avg* Col Len | Equality Preds | Equijoin Preds | Non Equijoin Preds | Range Preds | LIKE Preds | NULL Preds | Timestamp |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | RECNUM | NUMBER | 22 | N | 0 | 3 | |||||||||||||||
2 | LAHMANID | VARCHAR2 | 12 | N | CHAR_CS | 12 | B | 9 | 0 | 6 | 0 | 0 | 0 | 0 | 22-SEP-09 20:47:46 | ||||||
3 | DATE_YYYY | NUMBER | 22 | Y | 0 | 3 | 4 | 4 | 0 | 0 | 0 | 0 | 22-SEP-09 20:47:46 | ||||||||
4 | SEASON_HALF_ID | VARCHAR2 | 1 | Y | CHAR_CS | 1 | B | 1 | |||||||||||||
5 | TEAM_ID | VARCHAR2 | 3 | Y | CHAR_CS | 3 | B | 3 | 0 | 6 | 0 | 0 | 0 | 0 | 22-SEP-09 20:47:46 | ||||||
6 | LEAGUE_ID | VARCHAR2 | 2 | Y | CHAR_CS | 2 | B | 2 | 0 | 4 | 0 | 0 | 0 | 0 | 22-SEP-09 20:47:46 | ||||||
7 | DIVISION_ID | VARCHAR2 | 1 | Y | CHAR_CS | 1 | B | 1 | |||||||||||||
8 | GAME_QTY | NUMBER | 22 | Y | 0 | 3 | |||||||||||||||
9 | WIN_QTY | NUMBER | 22 | Y | 0 | 3 | |||||||||||||||
10 | LOSS_QTY | NUMBER | 22 | Y | 0 | 3 | |||||||||||||||
11 | WIN_PCT | NUMBER | 22 | 5 | 2 | Y | 0 | 3 | |||||||||||||
12 | PLACE_FINISHED_NR | NUMBER | 22 | Y | 0 | 2 | |||||||||||||||
13 | ORDER_MANAGED_ID | VARCHAR2 | 10 | Y | CHAR_CS | 10 | B | 3 | |||||||||||||
14 | PLAY_MANAGE_Y_N | VARCHAR2 | 1 | Y | CHAR_CS | 1 | B | 1 |
Col ID | Column Name | Num* Rows | Sample* Size | Last* Analyzed | Global* Stats | User* Stats | Num* Nulls | Num* Distinct | Num* Popular Values | Density* | New* Density |
Histogram* |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | RECNUM | 2895 | 2895 | 24-AUG-09 05:12:22 | NO | NO | 0 | 2895 | 3.4542e-04 | NONE | ||
2 | LAHMANID | 2895 | 2895 | 24-AUG-09 05:12:22 | NO | NO | 0 | 614 | 1.6287e-03 | NONE | ||
3 | DATE_YYYY | 2895 | 2895 | 24-AUG-09 05:12:22 | NO | NO | 0 | 129 | 7.7519e-03 | NONE | ||
4 | SEASON_HALF_ID | 2895 | 2895 | 24-AUG-09 05:12:22 | NO | NO | 2802 | 2 | 5.0000e-01 | NONE | ||
5 | TEAM_ID | 2895 | 2895 | 24-AUG-09 05:12:22 | NO | NO | 0 | 63 | 1.5873e-02 | NONE | ||
6 | LEAGUE_ID | 2895 | 2895 | 24-AUG-09 05:12:22 | NO | NO | 0 | 7 | 1.4286e-01 | NONE | ||
7 | DIVISION_ID | 2895 | 2895 | 24-AUG-09 05:12:22 | NO | NO | 1888 | 3 | 3.3333e-01 | NONE | ||
8 | GAME_QTY | 2895 | 2895 | 24-AUG-09 05:12:22 | NO | NO | 0 | 165 | 6.0606e-03 | NONE | ||
9 | WIN_QTY | 2895 | 2895 | 24-AUG-09 05:12:22 | NO | NO | 0 | 114 | 8.7719e-03 | NONE | ||
10 | LOSS_QTY | 2895 | 2895 | 24-AUG-09 05:12:22 | NO | NO | 0 | 117 | 8.5470e-03 | NONE | ||
11 | WIN_PCT | 2895 | 2895 | 24-AUG-09 05:12:22 | NO | NO | 0 | 1122 | 8.9127e-04 | NONE | ||
12 | PLACE_FINISHED_NR | 2895 | 2895 | 24-AUG-09 05:12:22 | NO | NO | 0 | 13 | 7.6923e-02 | NONE | ||
13 | ORDER_MANAGED_ID | 2895 | 2895 | 24-AUG-09 05:12:22 | NO | NO | 1961 | 29 | 3.4483e-02 | NONE | ||
14 | PLAY_MANAGE_Y_N | 2895 | 2895 | 24-AUG-09 05:12:22 | NO | NO | 2263 | 1 | 1.0000e+00 | NONE |
Col ID | Column Name | Low Value*# | High Value*# | Num* Buckets |
Buckets* Pop Vals |
Histogram* | Rows per Bucket |
Mutating Number of EndPoints |
EndPoints1 History |
Hidden Column |
Qualified Col Name |
Data Default |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | RECNUM | "1" | "2895" | 1 | NONE | NO | 0: | NO | RECNUM | |||
2 | LAHMANID | "adairbi99" | "zimmedo01" | 1 | NONE | NO | 0: | NO | LAHMANID | |||
3 | DATE_YYYY | "1871" | "1999" | 1 | NONE | NO | 0: | NO | DATE_YYYY | |||
4 | SEASON_HALF_ID | "1" | "2" | 1 | NONE | NO | 0: | NO | SEASON_HALF_ID | |||
5 | TEAM_ID | "ALT" | "WOR" | 1 | NONE | NO | 0: | NO | TEAM_ID | |||
6 | LEAGUE_ID | "A" | "U" | 1 | NONE | NO | 0: | NO | LEAGUE_ID | |||
7 | DIVISION_ID | "C" | "W" | 1 | NONE | NO | 0: | NO | DIVISION_ID | |||
8 | GAME_QTY | "1" | "165" | 1 | NONE | NO | 0: | NO | GAME_QTY | |||
9 | WIN_QTY | "0" | "116" | 1 | NONE | NO | 0: | NO | WIN_QTY | |||
10 | LOSS_QTY | "0" | "120" | 1 | NONE | NO | 0: | NO | LOSS_QTY | |||
11 | WIN_PCT | "0" | "100" | 1 | NONE | NO | 0: | NO | WIN_PCT | |||
12 | PLACE_FINISHED_NR | "1" | "13" | 1 | NONE | NO | 0: | NO | PLACE_FINISHED_NR | |||
13 | ORDER_MANAGED_ID | "1 of 2" | "9 of 9" | 1 | NONE | NO | 0: | NO | ORDER_MANAGED_ID | |||
14 | PLAY_MANAGE_Y_N | "Y" | "Y" | 1 | NONE | NO | 0: | NO | PLAY_MANAGE_Y_N |
Col ID | Column Name | Data Type | Data Type Mod | Data Type Owner | Data Length | Data Precision | Data Scale | Nullable | Character Set Name | Char Length | Char Used | Index Count | Leading Index Count | Avg* Col Len | Equality Preds | Equijoin Preds | Non Equijoin Preds | Range Preds | LIKE Preds | NULL Preds | Timestamp |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | LAHMANID | VARCHAR2 | 12 | N | CHAR_CS | 12 | B | 9 | 0 | 6 | 0 | 0 | 0 | 0 | 22-SEP-09 20:47:46 | ||||||
2 | LAST_NAME_TX | VARCHAR2 | 25 | Y | CHAR_CS | 25 | B | 7 | |||||||||||||
3 | FIRST_NAME_TX | VARCHAR2 | 20 | Y | CHAR_CS | 20 | B | 5 | |||||||||||||
4 | BATS_RIGHT_LEFT_ID | VARCHAR2 | 1 | Y | CHAR_CS | 1 | B | 1 | |||||||||||||
5 | THROWS_RT_LEFT_ID | VARCHAR2 | 1 | Y | CHAR_CS | 1 | B | 1 | |||||||||||||
6 | BIRTH_DATE_MM | NUMBER | 22 | Y | 0 | 2 | |||||||||||||||
7 | BIRTH_DATE_DD | NUMBER | 22 | Y | 0 | 2 | |||||||||||||||
8 | BIRTH_DATE_YYYY | NUMBER | 22 | Y | 0 | 3 | |||||||||||||||
9 | DEBUT_SEASON_YYYY | NUMBER | 22 | Y | 0 | 3 | 6 | 0 | 0 | 0 | 0 | 0 | 22-SEP-09 20:47:46 |
Col ID | Column Name | Num* Rows | Sample* Size | Last* Analyzed | Global* Stats | User* Stats | Num* Nulls | Num* Distinct | Num* Popular Values | Density* | New* Density |
Histogram* |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | LAHMANID | 61400 | 61400 | 24-AUG-09 05:12:23 | NO | NO | 0 | 15350 | 6.5147e-05 | NONE | ||
2 | LAST_NAME_TX | 61400 | 61400 | 24-AUG-09 05:12:23 | NO | NO | 0 | 8277 | 1.2082e-04 | NONE | ||
3 | FIRST_NAME_TX | 61400 | 61400 | 24-AUG-09 05:12:23 | NO | NO | 244 | 1839 | 5.4377e-04 | NONE | ||
4 | BATS_RIGHT_LEFT_ID | 61400 | 61400 | 24-AUG-09 05:12:23 | NO | NO | 5540 | 3 | 3.3333e-01 | NONE | ||
5 | THROWS_RT_LEFT_ID | 61400 | 61400 | 24-AUG-09 05:12:23 | NO | NO | 4528 | 2 | 5.0000e-01 | NONE | ||
6 | BIRTH_DATE_MM | 61400 | 61400 | 24-AUG-09 05:12:23 | NO | NO | 524 | 13 | 7.6923e-02 | NONE | ||
7 | BIRTH_DATE_DD | 61400 | 61400 | 24-AUG-09 05:12:23 | NO | NO | 524 | 32 | 3.1250e-02 | NONE | ||
8 | BIRTH_DATE_YYYY | 61400 | 61400 | 24-AUG-09 05:12:23 | NO | NO | 524 | 147 | 6.8027e-03 | NONE | ||
9 | DEBUT_SEASON_YYYY | 61400 | 61400 | 24-AUG-09 05:12:23 | NO | NO | 524 | 129 | 7.7519e-03 | NONE |
Col ID | Column Name | Low Value*# | High Value*# | Num* Buckets |
Buckets* Pop Vals |
Histogram* | Rows per Bucket |
Mutating Number of EndPoints |
EndPoints1 History |
Hidden Column |
Qualified Col Name |
Data Default |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | LAHMANID | "aaronha01" | "zwilldu01" | 1 | NONE | NO | 0: | NO | LAHMANID | |||
2 | LAST_NAME_TX | "AARON" | "ZWILLING" | 1 | NONE | NO | 0: | NO | LAST_NAME_TX | |||
3 | FIRST_NAME_TX | "A. J." | "ZOILO" | 1 | NONE | NO | 0: | NO | FIRST_NAME_TX | |||
4 | BATS_RIGHT_LEFT_ID | "B" | "R" | 1 | NONE | NO | 0: | NO | BATS_RIGHT_LEFT_ID | |||
5 | THROWS_RT_LEFT_ID | "L" | "R" | 1 | NONE | NO | 0: | NO | THROWS_RT_LEFT_ID | |||
6 | BIRTH_DATE_MM | "0" | "12" | 1 | NONE | NO | 0: | NO | BIRTH_DATE_MM | |||
7 | BIRTH_DATE_DD | "0" | "31" | 1 | NONE | NO | 0: | NO | BIRTH_DATE_DD | |||
8 | BIRTH_DATE_YYYY | "1800" | "1979" | 1 | NONE | NO | 0: | NO | BIRTH_DATE_YYYY | |||
9 | DEBUT_SEASON_YYYY | "1871" | "1999" | 1 | NONE | NO | 0: | NO | DEBUT_SEASON_YYYY |
Col ID | Column Name | Data Type | Data Type Mod | Data Type Owner | Data Length | Data Precision | Data Scale | Nullable | Character Set Name | Char Length | Char Used | Index Count | Leading Index Count | Avg* Col Len | Equality Preds | Equijoin Preds | Non Equijoin Preds | Range Preds | LIKE Preds | NULL Preds | Timestamp |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | RECNUM | NUMBER | 22 | N | 0 | 3 | |||||||||||||||
2 | DATE_YYYY | NUMBER | 22 | N | 0 | 1 | 1 | 3 | 4 | 4 | 0 | 0 | 0 | 0 | 22-SEP-09 20:47:46 | ||||||
3 | LEAGUE_ID | VARCHAR2 | 2 | N | CHAR_CS | 2 | B | 1 | 2 | 0 | 4 | 0 | 0 | 0 | 0 | 22-SEP-09 20:47:46 | |||||
4 | POSITION_PLAYED_ID | NUMBER | 22 | Y | 0 | 2 | |||||||||||||||
5 | TEAM_ID | VARCHAR2 | 3 | N | CHAR_CS | 3 | B | 1 | 3 | 0 | 6 | 0 | 0 | 0 | 0 | 22-SEP-09 20:47:46 | |||||
6 | GAME_PLAYED_QTY | NUMBER | 22 | Y | 0 | 3 | |||||||||||||||
7 | WIN_QTY | NUMBER | 22 | Y | 0 | 3 | |||||||||||||||
8 | LOSS_QTY | NUMBER | 22 | Y | 0 | 3 | |||||||||||||||
9 | WIN_PCT | NUMBER | 22 | 5 | 2 | Y | 0 | 2 | 0 | 0 | 0 | 6 | 0 | 0 | 22-SEP-09 20:47:46 | ||||||
10 | GAMES_BEHIND_QTY | NUMBER | 22 | Y | 0 | 2 | 0 | 0 | 0 | 4 | 0 | 0 | 22-SEP-09 20:47:46 | ||||||||
11 | RUN_QTY | NUMBER | 22 | Y | 0 | 3 | |||||||||||||||
12 | OPPONENT_RUN_QTY | NUMBER | 22 | Y | 0 | 3 | |||||||||||||||
13 | AT_BAT_QTY | NUMBER | 22 | Y | 0 | 3 | |||||||||||||||
14 | HIT_QTY | NUMBER | 22 | Y | 0 | 3 | |||||||||||||||
15 | DOUBLE_QTY | NUMBER | 22 | Y | 0 | 3 | |||||||||||||||
16 | TRIPLE_QTY | NUMBER | 22 | Y | 0 | 3 | |||||||||||||||
17 | HOME_RUN_QTY | NUMBER | 22 | Y | 0 | 3 | |||||||||||||||
18 | WALK_QTY | NUMBER | 22 | Y | 0 | 3 | |||||||||||||||
19 | STRIKE_OUT_QTY | NUMBER | 22 | Y | 0 | 3 | |||||||||||||||
20 | BATTING_AVG | NUMBER | 22 | 4 | 3 | Y | 0 | 3 | |||||||||||||
21 | ON_BASE_PCT | NUMBER | 22 | 4 | 3 | Y | 0 | 3 | |||||||||||||
22 | SLUGGING_PCT | NUMBER | 22 | 4 | 3 | Y | 0 | 3 | |||||||||||||
23 | STOLEN_BASE_QTY | NUMBER | 22 | Y | 0 | 3 | |||||||||||||||
24 | CAUGHT_STEALING_QY | NUMBER | 22 | Y | 0 | 2 | |||||||||||||||
25 | EARNED_RUN_AVG | NUMBER | 22 | 4 | 2 | Y | 0 | 3 | |||||||||||||
26 | COMPLETE_GAME_QTY | NUMBER | 22 | Y | 0 | 3 | |||||||||||||||
27 | SHUTOUT_QTY | NUMBER | 22 | Y | 0 | 2 | |||||||||||||||
28 | SAVE_QTY | NUMBER | 22 | Y | 0 | 2 | |||||||||||||||
29 | INNING_PITCHED_QTY | NUMBER | 22 | 6 | 2 | Y | 0 | 3 | |||||||||||||
30 | HIT_BY_OPP_QTY | NUMBER | 22 | Y | 0 | 3 | |||||||||||||||
Col ID | Column Name | Data Type | Data Type Mod | Data Type Owner | Data Length | Data Precision | Data Scale | Nullable | Character Set Name | Char Length | Char Used | Index Count | Leading Index Count | Avg* Col Len | Equality Preds | Equijoin Preds | Non Equijoin Preds | Range Preds | LIKE Preds | NULL Preds | Timestamp |
31 | HOME_RUN_BY_OPP_QY | NUMBER | 22 | Y | 0 | 3 | |||||||||||||||
32 | WALK_BY_OPP_QTY | NUMBER | 22 | Y | 0 | 3 | |||||||||||||||
33 | STRIKE_OUT_OPP_QTY | NUMBER | 22 | Y | 0 | 3 | |||||||||||||||
34 | PARK_BAT_FACTOR | NUMBER | 22 | Y | 0 | 3 | |||||||||||||||
35 | PARK_PITCH_FACTOR | NUMBER | 22 | Y | 0 | 3 | |||||||||||||||
36 | BALLPARK_NAME | VARCHAR2 | 200 | Y | CHAR_CS | 200 | B | 124 | |||||||||||||
37 | ATTENDENCE_QTY | NUMBER | 22 | Y | 0 | 4 | 0 | 0 | 0 | 4 | 0 | 0 | 22-SEP-09 20:47:46 |
Col ID | Column Name | Num* Rows | Sample* Size | Last* Analyzed | Global* Stats | User* Stats | Num* Nulls | Num* Distinct | Num* Popular Values | Density* | New* Density |
Histogram* |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | RECNUM | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 0 | 2327 | 4.2974e-04 | NONE | ||
2 | DATE_YYYY | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 0 | 129 | 7.7519e-03 | NONE | ||
3 | LEAGUE_ID | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 0 | 7 | 1.4286e-01 | NONE | ||
4 | POSITION_PLAYED_ID | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 0 | 13 | 7.6923e-02 | NONE | ||
5 | TEAM_ID | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 0 | 61 | 1.6393e-02 | NONE | ||
6 | GAME_PLAYED_QTY | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 2 | 122 | 8.1967e-03 | NONE | ||
7 | WIN_QTY | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 2 | 112 | 8.9286e-03 | NONE | ||
8 | LOSS_QTY | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 2 | 112 | 8.9286e-03 | NONE | ||
9 | WIN_PCT | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 2 | 72 | 1.3889e-02 | NONE | ||
10 | GAMES_BEHIND_QTY | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 2 | 68 | 1.4706e-02 | NONE | ||
11 | RUN_QTY | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 2 | 603 | 1.6584e-03 | NONE | ||
12 | OPPONENT_RUN_QTY | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 2 | 594 | 1.6835e-03 | NONE | ||
13 | AT_BAT_QTY | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 2 | 1069 | 9.3545e-04 | NONE | ||
14 | HIT_QTY | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 2 | 722 | 1.3850e-03 | NONE | ||
15 | DOUBLE_QTY | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 2 | 297 | 3.3670e-03 | NONE | ||
16 | TRIPLE_QTY | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 2 | 123 | 8.1301e-03 | NONE | ||
17 | HOME_RUN_QTY | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 2 | 231 | 4.3290e-03 | NONE | ||
18 | WALK_QTY | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 2 | 561 | 1.7825e-03 | NONE | ||
19 | STRIKE_OUT_QTY | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 144 | 865 | 1.1561e-03 | NONE | ||
20 | BATTING_AVG | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 2 | 125 | 8.0000e-03 | NONE | ||
21 | ON_BASE_PCT | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 2 | 159 | 6.2893e-03 | NONE | ||
22 | SLUGGING_PCT | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 2 | 223 | 4.4843e-03 | NONE | ||
23 | STOLEN_BASE_QTY | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 148 | 323 | 3.0960e-03 | NONE | ||
24 | CAUGHT_STEALING_QY | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 863 | 136 | 7.3529e-03 | NONE | ||
25 | EARNED_RUN_AVG | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 2 | 372 | 2.6882e-03 | NONE | ||
26 | COMPLETE_GAME_QTY | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 2 | 146 | 6.8493e-03 | NONE | ||
27 | SHUTOUT_QTY | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 2 | 32 | 3.1250e-02 | NONE | ||
28 | SAVE_QTY | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 2 | 64 | 1.5625e-02 | NONE | ||
29 | INNING_PITCHED_QTY | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 2 | 544 | 1.8382e-03 | NONE | ||
30 | HIT_BY_OPP_QTY | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 2 | 720 | 1.3889e-03 | NONE | ||
Col ID | Column Name | Num* Rows | Sample* Size | Last* Analyzed | Global* Stats | User* Stats | Num* Nulls | Num* Distinct | Num* Popular Values | Density* | New* Density |
Histogram* |
31 | HOME_RUN_BY_OPP_QY | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 2 | 217 | 4.6083e-03 | NONE | ||
32 | WALK_BY_OPP_QTY | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 2 | 557 | 1.7953e-03 | NONE | ||
33 | STRIKE_OUT_OPP_QTY | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 34 | 883 | 1.1325e-03 | NONE | ||
34 | PARK_BAT_FACTOR | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 32 | 41 | 2.4390e-02 | NONE | ||
35 | PARK_PITCH_FACTOR | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 32 | 38 | 2.6316e-02 | NONE | ||
36 | BALLPARK_NAME | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 36 | 180 | 5.5556e-03 | NONE | ||
37 | ATTENDENCE_QTY | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 0 | 2039 | 4.9044e-04 | NONE |
Col ID | Column Name | Low Value*# | High Value*# | Num* Buckets |
Buckets* Pop Vals |
Histogram* | Rows per Bucket |
Mutating Number of EndPoints |
EndPoints1 History |
Hidden Column |
Qualified Col Name |
Data Default |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | RECNUM | "1" | "2327" | 1 | NONE | NO | 0: | NO | RECNUM | |||
2 | DATE_YYYY | "1871" | "1999" | 1 | NONE | NO | 0: | NO | DATE_YYYY | 0 | ||
3 | LEAGUE_ID | "A" | "U" | 1 | NONE | NO | 0: | NO | LEAGUE_ID | |||
4 | POSITION_PLAYED_ID | "1" | "13" | 1 | NONE | NO | 0: | NO | POSITION_PLAYED_ID | |||
5 | TEAM_ID | "ALT" | "WOR" | 1 | NONE | NO | 0: | NO | TEAM_ID | |||
6 | GAME_PLAYED_QTY | "6" | "165" | 1 | NONE | NO | 0: | NO | GAME_PLAYED_QTY | |||
7 | WIN_QTY | "0" | "116" | 1 | NONE | NO | 0: | NO | WIN_QTY | |||
8 | LOSS_QTY | "4" | "134" | 1 | NONE | NO | 0: | NO | LOSS_QTY | |||
9 | WIN_PCT | "0" | ".89" | 1 | NONE | NO | 0: | NO | WIN_PCT | |||
10 | GAMES_BEHIND_QTY | "0" | "84" | 1 | NONE | NO | 0: | NO | GAMES_BEHIND_QTY | |||
11 | RUN_QTY | "24" | "1220" | 1 | NONE | NO | 0: | NO | RUN_QTY | |||
12 | OPPONENT_RUN_QTY | "34" | "1252" | 1 | NONE | NO | 0: | NO | OPPONENT_RUN_QTY | |||
13 | AT_BAT_QTY | "211" | "5779" | 1 | NONE | NO | 0: | NO | AT_BAT_QTY | |||
14 | HIT_QTY | "33" | "1783" | 1 | NONE | NO | 0: | NO | HIT_QTY | |||
15 | DOUBLE_QTY | "3" | "373" | 1 | NONE | NO | 0: | NO | DOUBLE_QTY | |||
16 | TRIPLE_QTY | "0" | "150" | 1 | NONE | NO | 0: | NO | TRIPLE_QTY | |||
17 | HOME_RUN_QTY | "0" | "264" | 1 | NONE | NO | 0: | NO | HOME_RUN_QTY | |||
18 | WALK_QTY | "0" | "835" | 1 | NONE | NO | 0: | NO | WALK_QTY | |||
19 | STRIKE_OUT_QTY | "3" | "1268" | 1 | NONE | NO | 0: | NO | STRIKE_OUT_QTY | |||
20 | BATTING_AVG | ".156" | ".349" | 1 | NONE | NO | 0: | NO | BATTING_AVG | |||
21 | ON_BASE_PCT | ".156" | ".418" | 1 | NONE | NO | 0: | NO | ON_BASE_PCT | |||
22 | SLUGGING_PCT | ".18" | ".489" | 1 | NONE | NO | 0: | NO | SLUGGING_PCT | |||
23 | STOLEN_BASE_QTY | "0" | "581" | 1 | NONE | NO | 0: | NO | STOLEN_BASE_QTY | |||
24 | CAUGHT_STEALING_QY | "1" | "191" | 1 | NONE | NO | 0: | NO | CAUGHT_STEALING_QY | |||
25 | EARNED_RUN_AVG | "1.22" | "8" | 1 | NONE | NO | 0: | NO | EARNED_RUN_AVG | |||
26 | COMPLETE_GAME_QTY | "1" | "148" | 1 | NONE | NO | 0: | NO | COMPLETE_GAME_QTY | |||
27 | SHUTOUT_QTY | "0" | "32" | 1 | NONE | NO | 0: | NO | SHUTOUT_QTY | |||
28 | SAVE_QTY | "0" | "68" | 1 | NONE | NO | 0: | NO | SAVE_QTY | |||
29 | INNING_PITCHED_QTY | "54" | "1506" | 1 | NONE | NO | 0: | NO | INNING_PITCHED_QTY | |||
30 | HIT_BY_OPP_QTY | "49" | "1993" | 1 | NONE | NO | 0: | NO | HIT_BY_OPP_QTY | |||
Col ID | Column Name | Low Value*# | High Value*# | Num* Buckets |
Buckets* Pop Vals |
Histogram* | Rows per Bucket |
Mutating Number of EndPoints |
EndPoints1 History |
Hidden Column |
Qualified Col Name |
Data Default |
31 | HOME_RUN_BY_OPP_QY | "0" | "241" | 1 | NONE | NO | 0: | NO | HOME_RUN_BY_OPP_QY | |||
32 | WALK_BY_OPP_QTY | "0" | "827" | 1 | NONE | NO | 0: | NO | WALK_BY_OPP_QTY | |||
33 | STRIKE_OUT_OPP_QTY | "0" | "1245" | 1 | NONE | NO | 0: | NO | STRIKE_OUT_OPP_QTY | |||
34 | PARK_BAT_FACTOR | "54" | "129" | 1 | NONE | NO | 0: | NO | PARK_BAT_FACTOR | |||
35 | PARK_PITCH_FACTOR | "54" | "129" | 1 | NONE | NO | 0: | NO | PARK_PITCH_FACTOR | |||
36 | BALLPARK_NAME | "23rd Street Grounds Update the b" | "Yankee Stadium Update the ball p" | 1 | NONE | NO | 0: | NO | BALLPARK_NAME | |||
37 | ATTENDENCE_QTY | "0" | "4483350" | 1 | NONE | NO | 0: | NO | ATTENDENCE_QTY |
# | Table Owner.Table Name | Index Owner.Index Name | Oper ID | Index Type | Uniqueness | Num Cols | Idx Col Ids | Indexed Column Names | CBO Stats |
Metadata | Stats Type Locked | Stale Stats | Avg Cached Blocks | Avg Cache Hit Ratio |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | USER0.TEAMS | USER0.TEAMS_PK | NORMAL | UNIQUE | 3 | 2 3 5 | DATE_YYYY LEAGUE_ID TEAM_ID | Stats | Metadata | NO |
# | Table Owner.Table Name | Index Owner.Index Name | Num* Rows | Sample* Size | Last* Analyzed | Global* Stats | User* Stats | Distinct* Keys | Blevel* | Segment Blocks | Leaf* Blocks | Avg* Leaf Blocks per Key | Avg* Data Blocks per Key | Clustering* Factor | Table* Blocks | Table* Num Rows | Max Idx Sel |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | USER0.TEAMS | USER0.TEAMS_PK | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 2327 | 1 | 16 | 11 | 1 | 1 | 114 | 124 | 2327 | 0.1638 |
# | Table Owner.Table Name | Index Owner.Index Name | Object ID | Tablespace | Temporary | Partitioned | Logging | Degree | Ini Trans | Max Trans | Freelist Groups | Freelists | Status | Domidx Status | Funcidx Status |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | USER0.TEAMS | USER0.TEAMS_PK | 74054 | USERS | N | NO | YES | 1 | 2 | 255 | VALID |
# | Table Owner.Table Name | Index Owner.Index Name | Save Time | Analyze Time | Num Rows | Sample Size | Distinct Keys | Blevel | Leaf Blocks | Avg Leaf Blocks per Key | Avg Data Blocks per Key | Clustering Factor | Global Stats | User Stats | Guessq | Cache Dblk | Cache Hit | Logical Read |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | USER0.TEAMS | USER0.TEAMS_PK | 24-AUG-09 05.12.22.890000 AM -05:00 | NO | NO |
Col ID | Column Name | TEAMS PK | Column Name | Col ID |
---|---|---|---|---|
2 | DATE_YYYY | 1 | DATE_YYYY | 2 |
3 | LEAGUE_ID | 2 | LEAGUE_ID | 3 |
5 | TEAM_ID | 3 | TEAM_ID | 5 |
Col ID | Column Name | Data Type | Data Type Mod | Data Type Owner | Data Length | Data Precision | Data Scale | Nullable | Character Set Name | Char Length | Char Used | Index Count | Leading Index Count | Avg* Col Len | Equality Preds | Equijoin Preds | Non Equijoin Preds | Range Preds | LIKE Preds | NULL Preds | Timestamp |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | DATE_YYYY | NUMBER | 22 | N | 0 | 1 | 1 | 3 | 4 | 4 | 0 | 0 | 0 | 0 | 22-SEP-09 20:47:46 | ||||||
3 | LEAGUE_ID | VARCHAR2 | 2 | N | CHAR_CS | 2 | B | 1 | 2 | 0 | 4 | 0 | 0 | 0 | 0 | 22-SEP-09 20:47:46 | |||||
5 | TEAM_ID | VARCHAR2 | 3 | N | CHAR_CS | 3 | B | 1 | 3 | 0 | 6 | 0 | 0 | 0 | 0 | 22-SEP-09 20:47:46 |
Col ID | Column Name | Num* Rows | Sample* Size | Last* Analyzed | Global* Stats | User* Stats | Num* Nulls | Num* Distinct | Num* Popular Values | Density* | New* Density |
Histogram* |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | DATE_YYYY | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 0 | 129 | 7.7519e-03 | NONE | ||
3 | LEAGUE_ID | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 0 | 7 | 1.4286e-01 | NONE | ||
5 | TEAM_ID | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 0 | 61 | 1.6393e-02 | NONE |
Col ID | Column Name | Low Value*# | High Value*# | Num* Buckets |
Buckets* Pop Vals |
Histogram* | Rows per Bucket |
Mutating Number of EndPoints |
EndPoints1 History |
Hidden Column |
Qualified Col Name |
Data Default |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | DATE_YYYY | "1871" | "1999" | 1 | NONE | NO | 0: | NO | DATE_YYYY | 0 | ||
3 | LEAGUE_ID | "A" | "U" | 1 | NONE | NO | 0: | NO | LEAGUE_ID | |||
5 | TEAM_ID | "ALT" | "WOR" | 1 | NONE | NO | 0: | NO | TEAM_ID |
Col Pos | Col ID | Column Name | Descend | Data Type | Data Type Mod | Data Type Owner | Data Length | Data Precision | Data Scale | Nullable | Character Set Name | Char Length | Char Used | Index Count | Leading Index Count | Avg* Col Len | Equality Preds | Equijoin Preds | Non Equijoin Preds | Range Preds | LIKE Preds | NULL Preds | Timestamp |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2 | DATE_YYYY | ASC | NUMBER | 22 | N | 0 | 1 | 1 | 3 | 4 | 4 | 0 | 0 | 0 | 0 | 22-SEP-09 20:47:46 | ||||||
2 | 3 | LEAGUE_ID | ASC | VARCHAR2 | 2 | N | CHAR_CS | 2 | B | 1 | 2 | 0 | 4 | 0 | 0 | 0 | 0 | 22-SEP-09 20:47:46 | |||||
3 | 5 | TEAM_ID | ASC | VARCHAR2 | 3 | N | CHAR_CS | 3 | B | 1 | 3 | 0 | 6 | 0 | 0 | 0 | 0 | 22-SEP-09 20:47:46 |
Col Pos | Col ID | Column Name | Num* Rows | Sample* Size | Last* Analyzed | Global* Stats | User* Stats | Num* Nulls | Num* Distinct | Num* Popular Values | Density* | New* Density |
Histogram* |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2 | DATE_YYYY | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 0 | 129 | 7.7519e-03 | NONE | ||
2 | 3 | LEAGUE_ID | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 0 | 7 | 1.4286e-01 | NONE | ||
3 | 5 | TEAM_ID | 2327 | 2327 | 24-AUG-09 05:12:22 | NO | NO | 0 | 61 | 1.6393e-02 | NONE |
Col Pos | Col ID | Column Name | Low Value*# | High Value*# | Num* Buckets |
Buckets* Pop Vals |
Histogram* | Rows per Bucket |
Mutating Number of EndPoints |
EndPoints1 History |
Hidden Column |
Qualified Col Name |
Data Default |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2 | DATE_YYYY | "1871" | "1999" | 1 | NONE | NO | 0: | NO | DATE_YYYY | 0 | ||
2 | 3 | LEAGUE_ID | "A" | "U" | 1 | NONE | NO | 0: | NO | LEAGUE_ID | |||
3 | 5 | TEAM_ID | "ALT" | "WOR" | 1 | NONE | NO | 0: | NO | TEAM_ID |
CREATE TABLE "USER0"."MANAGERS" ( "RECNUM" NUMBER NOT NULL ENABLE, "LAHMANID" VARCHAR2(12) NOT NULL ENABLE, "DATE_YYYY" NUMBER, "SEASON_HALF_ID" VARCHAR2(1), "TEAM_ID" VARCHAR2(3), "LEAGUE_ID" VARCHAR2(2), "DIVISION_ID" VARCHAR2(1), "GAME_QTY" NUMBER, "WIN_QTY" NUMBER, "LOSS_QTY" NUMBER, "WIN_PCT" NUMBER(5,2), "PLACE_FINISHED_NR" NUMBER, "ORDER_MANAGED_ID" VARCHAR2(10), "PLAY_MANAGE_Y_N" VARCHAR2(1) ) PCTFREE 5 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 1024000 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" ;Back to Metadata
CREATE TABLE "USER0"."MASTER" ( "LAHMANID" VARCHAR2(12) NOT NULL ENABLE, "LAST_NAME_TX" VARCHAR2(25), "FIRST_NAME_TX" VARCHAR2(20), "BATS_RIGHT_LEFT_ID" VARCHAR2(1), "THROWS_RT_LEFT_ID" VARCHAR2(1), "BIRTH_DATE_MM" NUMBER, "BIRTH_DATE_DD" NUMBER, "BIRTH_DATE_YYYY" NUMBER, "DEBUT_SEASON_YYYY" NUMBER ) PCTFREE 5 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 3686400 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" ;Back to Metadata
CREATE TABLE "USER0"."TEAMS" ( "RECNUM" NUMBER NOT NULL ENABLE, "DATE_YYYY" NUMBER DEFAULT 0 NOT NULL ENABLE, "LEAGUE_ID" VARCHAR2(2) NOT NULL ENABLE, "POSITION_PLAYED_ID" NUMBER, "TEAM_ID" VARCHAR2(3) NOT NULL ENABLE, "GAME_PLAYED_QTY" NUMBER, "WIN_QTY" NUMBER, "LOSS_QTY" NUMBER, "WIN_PCT" NUMBER(5,2), "GAMES_BEHIND_QTY" NUMBER, "RUN_QTY" NUMBER, "OPPONENT_RUN_QTY" NUMBER, "AT_BAT_QTY" NUMBER, "HIT_QTY" NUMBER, "DOUBLE_QTY" NUMBER, "TRIPLE_QTY" NUMBER, "HOME_RUN_QTY" NUMBER, "WALK_QTY" NUMBER, "STRIKE_OUT_QTY" NUMBER, "BATTING_AVG" NUMBER(4,3), "ON_BASE_PCT" NUMBER(4,3), "SLUGGING_PCT" NUMBER(4,3), "STOLEN_BASE_QTY" NUMBER, "CAUGHT_STEALING_QY" NUMBER, "EARNED_RUN_AVG" NUMBER(4,2), "COMPLETE_GAME_QTY" NUMBER, "SHUTOUT_QTY" NUMBER, "SAVE_QTY" NUMBER, "INNING_PITCHED_QTY" NUMBER(6,2), "HIT_BY_OPP_QTY" NUMBER, "HOME_RUN_BY_OPP_QY" NUMBER, "WALK_BY_OPP_QTY" NUMBER, "STRIKE_OUT_OPP_QTY" NUMBER, "PARK_BAT_FACTOR" NUMBER, "PARK_PITCH_FACTOR" NUMBER, "BALLPARK_NAME" VARCHAR2(200), "ATTENDENCE_QTY" NUMBER ) PCTFREE 5 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 2048000 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" ;Back to Metadata
CREATE UNIQUE INDEX "USER0"."TEAMS_PK" ON "USER0"."TEAMS" ("DATE_YYYY", "LEAGUE_ID", "TEAM_ID") PCTFREE 5 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 16384 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" ;Back to Metadata