第27次活动：2017-10-25（星期三晚上7:00-9:30）
索引的树高的小实验：SQL> conn hr/oracle_4U
Connected.
SQL> create table t05111_c ( a char(2000)) ;
Table created.
SQL> create index i05111_con t05111_c(a) ;
Index created.
SQL> insert into t05111_c values ('A') ;
1 row created.
SQL> commit;
Commit complete.
SQL> insert into t05111_c values ('B') ;
1 row created.
SQL> commit;
Commit complete.
SQL> insert into t05111_c values ('C') ;
1 row created.
SQL> commit;
Commit complete.
SQL> insert into t05111_c values ('D') ;
1 row created.
SQL> commit;
Commit complete.
SQL> insert into t05111_c values ('E') ;
1 row created.
SQL> commit;
Commit complete.
SQL> insert into t05111_c values ('F') ;
1 row created.
SQL> commit;
Commit complete.
SQL> selecta, dbms_rowid.rowid_block_number(rowid) from t05111_c;
A
--------------------------------------------------------------------------------
DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
------------------------------------
D
A
--------------------------------------------------------------------------------
DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
------------------------------------
A
--------------------------------------------------------------------------------
DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
------------------------------------
891
A
--------------------------------------------------------------------------------
DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
------------------------------------
E
A
--------------------------------------------------------------------------------
DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
------------------------------------
A
--------------------------------------------------------------------------------
DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
------------------------------------
891
A
--------------------------------------------------------------------------------
DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
------------------------------------
F
A
--------------------------------------------------------------------------------
DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
------------------------------------
A
--------------------------------------------------------------------------------
DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
------------------------------------
891
A
--------------------------------------------------------------------------------
DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
------------------------------------
A
A
--------------------------------------------------------------------------------
DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
------------------------------------
A
--------------------------------------------------------------------------------
DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
------------------------------------
895
A
--------------------------------------------------------------------------------
DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
------------------------------------
B
A
--------------------------------------------------------------------------------
DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
------------------------------------
A
--------------------------------------------------------------------------------
DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
------------------------------------
895
A
--------------------------------------------------------------------------------
DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
------------------------------------
C
A
--------------------------------------------------------------------------------
DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
------------------------------------
A
--------------------------------------------------------------------------------
DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
------------------------------------
895
6 rows selected.
SQL> insert into t05111_c values ('G') ;
1 row created.
SQL> commit;
Commit complete.
SQL> exec dbms_stats.gather_table_stats('HR','T05111_C') ;
PL/SQL procedure successfully completed.
SQL> truncate table t05111_c;
Table truncated.
SQL> exec dbms_stats.gather_table_stats('HR','T05111_C') ;
PL/SQL procedure successfully completed.
SQL> insert into t05111_c values ('A') ;
1 row created.
SQL> insert into t05111_c values ('B') ;
1 row created.
SQL> insert into t05111_c values ('C') ;
1 row created.
SQL> commit;
Commit complete.
SQL> exec dbms_stats.gather_table_stats('HR','T05111_C') ;
PL/SQL procedure successfully completed.
SQL> insert into t05111_c values ('D') ;
1 row created.
SQL> commit;
Commit complete.
SQL> exec dbms_stats.gather_table_stats('HR','T05111_C') ;
PL/SQL procedure successfully completed.
SQL>
索引的日常维护：
alter index hr.i05111_c coalesce ;
alter index hr.i05111_c rebuild online;
关于job1：
alter user sysman identified by oracle_4U account unlock;
alter user dbsnmp identified by oracle_4U account unlock;
select* from dba_scheduler_job_run_details s
where s.job_name='JOB1';
select * from dba_scheduler_jobs s
where s.job_name='JOB1';
select * from dba_scheduler_programss
where s.program_name='PROGRAM1';
select* from dba_scheduler_running_jobss
where s.job_name='JOB1';
select* from dba_scheduler_schedules s
where s.schedule_name='SCHEDULE1';
页:
[1]