select table_name, num_rows, blocks, avg_row_len from dba_tables where table_name='EMP';
select table_name, monitoring from dba_tables where owner='SCOTT' ORDER BY 2;
Insert into scott.EMP (EMPNO, ENAME, JOB, MGR, HIREDATE,SAL, COMM, DEPTNO) Values
(7999, 'SMITH', 'CLERK', 7902, TO_DATE('12/17/1980 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 800, NULL, 20);
COMMIT;
exec DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO();
SELECT * FROM SYS.DBA_TAB_MODIFICATIONS where table_owner='SCOTT' ;
No comments:
Post a Comment