Pomaga w organizacji kodu.
Składają się ze specyfikacji (SPEC) i kodu (BODY). Body można zaszyfrować (wrap function)
Common packages:
-standard
commit, rollback, round
select round(3.14) from dual;
select sys.standard.round(3.14) from dual;
desc sys.standard; – opis danego package
-dbms_output
dbms_output.put_line(‘name’);
-dbms_stats
exec dbms_stats.gather_table_stats(‘SCOTT’,'PERSON’);
select table_name, to_char(last_analyzed,’hh23:mi’) analyzed
from user_tables where table_name=’PERSON’;
-dbms_schduler
(dbms_job – oracle 9)
grant create job to scott;
select snap_id,to_char(snap_time,’dd-mm-yyyy hh24:mi:ss’) from stats$snapshot
select text from dba_source where name=’MISC’;
Kompilacja obiektów w schemacie
SQL> dbms_utility.compile_schema(‘SCOTT’);
UNDO TABLESPACE
SELECT tablespace_name,status,CONTENTS FROM dba_tablespaces;
show parameter undo
SELECT file_name FROM dba_data_files;
SELECT file_name, bytes FROM dba_data_files WHERE tablespace_name=’UNDOTBS1′;
SELECT DISTINCT owner,tablespace_name, bytes, status FROM dba_undo_extents WHERE status = ‘ACTIVE’;
SELECT DISTINCT owner,tablespace_name, bytes, status FROM dba_undo_extents;