?????
???Oracle??????
SI Object Browser??????????
?????????????????????
????????????????????????????????????????????
???Oracle??????????????Oracle SQL Developer??????
JDeveloper????????????Oracle SQL Developer?????????????
???Oracle??????
SI Object Browser??????????
?????????????????????
????????????????????????????????????????????
???Oracle??????????????Oracle SQL Developer??????
JDeveloper????????????Oracle SQL Developer?????????????
10g??DBMS_DEBUG?????PL/SQL???????????
???????????????DEBUG CONNECT SESSION??????????
????EXECUTE???DEBUG???
Oracle Sql Developer?????????????????
?????????????????
?????PLW-XXXXX???????????????????????????????
????????????
1.???????[Tools]-[Preferences]???
2.[PL/SQL Compiler Options ]???
3.[Generate PL/SQL Debug Information]?????????
4.???[DISABLE]???
?????????????????????????????????
[????]
http://????:?????/em
[????????]
$ORACLE_HOME/install/portlist.ini????????
[?]
http://127.0.0.1:5500/em
{???????????}
SELECT * FROM RECYCLEBIN
{???????????}
PURGE RECYCLEBIN
{?????????????}
PURGE TABLE ?????
{???????????????}
PURGE INDEX ???????
{?????????????????}
PURGE TABLESPACE ?????????
?DBA_SYS_PRIVS??????????????????????
SELECT * FROM DBA_SYS_PRIVS
??CONNECT??????????????????
SELECT * FROM DBA_SYS_PRIVS WHERE GRANTEE = 'CONNECT'
????Oracle????????CONNECT,DBA,RESOURCE ????????????????
??????
??????????
SELECT * FROM DBA_ROLES
??????????????????????????
SELECT * FROM DBA_ROLE_PRIVS
select * from v$version
DBMS_OUTPUT????????????????????????????
ORACLE 10G R1?????????????2K????1M????????255????
?????????????????
DBMS_OUTPUT.ENABLE(1000000);
ORACLE 10G R2??????????2K????????????32K???
DBMS_OUTPUT.ENABLE(NULL);
+-----------------+----------------------------------+
| ORU-10027 | ??????????? |
+-----------------+----------------------------------+
| ORU-10028 | ??????????? |
+-----------------+----------------------------------+
??????????
?PROCEDURE?FUNCTION?PACKAGE?PACKAGE BODY?TRIGGER?TYPE?TYPE BODY?
????????????????USER_PLSQL_OBJECT_SETTINGS?????
SELECT * FROM USER_PLSQL_OBJECT_SETTINGS
1.???????[Tools]-[Preferences]???
2.[Code Editer] - [Line Gutter]???
3.[Show Line Numbers]?????????
?UNDO????????
??????UNDO????????????
select tablespace_name,retention from dba_tablespaces where tablespace_name = 'UNDOTBS1'
?UNDO?????
alter tablespace 'UNDOTBS1' retention GUARANTEE;
?SCN??????????????
select current_scn,scn_to_timestamp(current_scn) from v$database
select timestamp_to_scn(systimestamp), systimestamp from dual
????????????
SCN??
select name from test as of scn 344387777 where id = 2
??????????????????
SCN??
select
versions_xid XID,
versions_startscn START_SCN,
versions_endscn END_SCN,
versions_operation OPERATION,
id,name
from test versions between scn minvalue and maxvalue
?????????????????????
SCN??
select * from flashbak_transaction_query where table_name='TEST'
?oracle flashbak query
update test set name= (select name from test as of scn 344387777 where id = 2) where id=2
?oracle flushbak table
?flashback table ?? or flashback any table ?? ???
?????????????
alter table test enable row movement
???????????
???????????NG
??????????????NG
?????????????????????
flashback table test to scn 344494686
?oracle flushbak drop
flashback table test to before drop rename to 'test2'
????????????????????????????????NG
??????????????????
--??????
select index_name from user_indexes where table_name='TEST';
--????
alter index "BINXXXXXXXXXXXXX" rename to pk_test;
??SQLPlus?????????
???????
WinXP
SQL*Plus: Release 9.2.0.1.0 - Production
??????????????????????
?????????????
Web???????,
HD???????????????????????????????
?????????????????????????????
???????????????????????
??????????
????????http_proxy?????????????????
?????????
???????????????????????????
????? hoge.com:8080
??? ? http://hoge.com:8080
sqlplus?????????????????
??????eclipse??????????????
??????????????????????????????
PLSQL?????????????
???????????????DELETE??????
?????????????????TRUNCATE????????????
TRUNCATE????????????????????COMMIT?????
PLSQL?????????????SQL???????????????????
????????????????????
??????????????????????????????????????
???
DELETE FROM WORK;
???
EXECUTE IMMEDIATE 'TRUNCATE TABLE WORK';
ServerType?VAR?VARCHAR2?ORATYPE_RAW_BIN?ORAPARM_OUTPUT??????????
??????128????
MinimumSize????????????????????????
[VB??]
OraDatabase.Parameters.Add "ret", 0, ORAPARM_OUTPUT
Set pret = OraDatabase.Parameters("ret")
pret.ServerType = ORATYPE_VARCHAR2
pret.MinimumSize = 1024
??V$LOCK?V$SESSION??SID?SERIAL#?????
SELECT SID, SERIAL#,USERNAME,STATUS,MACHINE,PROGRAM
FROM V$SESSION
WHERE SID IN (
SELECT SID
FROM V$LOCK
WHERE TYPE IN ('TM','TX')
);
??????????
ALTER SYSTEM KILL SESSION 'SID,SERIAL#'???ALTER SYSTEM KILL SESSION '10,5000';
????????????
????????????????
????????????????
5??????????Web????
??? Oracle Database 10g Gold ???????
??????????????????
????????????
???????????????????
?????????????????????????
????10gR2?30??????????????????????
OS ?WinXP
CPU?Pen4 3GHz
????1GB
???????500MB???????????????????
?????????????
?????????DB????????????????????
CPU???100%?????????????1GB???
?????????????????????????????????????
????????????????????????????
????????????????????????????
PC????F8?????XP??????????????
OEM?JOB?iSQL???????????????????????
???OracleDBConsoleSID
???OracleJobSchedulerSID
???OracleOraDB10_home1iSQL*Plus
???????
?????????
| Sun | Mon | Tue | Wed | Thu | Fri | Sat |
|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | ||
| 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| 13 | 14 | 15 | 16 | 17 | 18 | 19 |
| 20 | 21 | 22 | 23 | 24 | 25 | 26 |
| 27 | 28 | 29 | 30 | 31 |