utworzone przez | mar 5, 2010 | Oracle
OPMNCTL (Oracle Process Management and Notification Server) $ORACLE_AS_HOME/opmn/bin/opmnctl help $ORACLE_AS_HOME/opmn/bin/opmnctl status help $ORACLE_AS_HOME/opmn/bin/opmnctl status -l $ORACLE_AS_HOME/opmn/bin/opmnctl stopall $ORACLE_AS_HOME/opmn/bin/opmnctl startall...
utworzone przez | lut 12, 2010 | Oracle
Oracle Enterprise Manager => Advisor CentralAWR (Automatic Workload Repository)statystyki przechowywane w tabelach WRH$ w przestrzeni SYSAUXwarunki:STATISTICL_LEVEL= TYPICAL | ALLwidoki:memory:DBA_HIST_SGADBA_HIST_PGASTATDBA_HIST_PGA_TARGET_DEVICE...
utworzone przez | lut 4, 2010 | Oracle
SELECT * FROM dba_db_links;SELECT * FROM user_db_links;DROP DATABASE LINK [link_name]; CREATE DATABASE LINK [link_name] CONNECT TO [user] IDENTIFIED BY [password] USING '[tns_alias]’;SELECT count(*) FROM user_tables@[link_name];
utworzone przez | gru 23, 2009 | Oracle
shrink undo tablespace:* CREATE UNDO TABLESPACE [name] DATAFILE '[path]’ size [nr]G ;* ALTER SYSTEM SET UNDO_TABLESPACE = [name];* DROP TABLESPACE [old_name] including contents and datafiles;check rollback status:SELECT used_urec FROM v$transaction;...
utworzone przez | gru 17, 2009 | Oracle
create database manualy:* create PFILEmain changes:- db_name- control_files- audit_file_dest- background_dump_dest- user_dump_dest- core_dump_destexample...
utworzone przez | gru 15, 2009 | Oracle
find locks:select oracle_username os_user_name, locked_mode, object_name, object_typefrom v$locked_object a,dba_objects bwhere a.object_id = b.object_id select l1.sid, ’ BLOCK ’, l2.sid from v$lock l1, v$lock l2 where l1.block =1 and l2.request...
