Master Yavor from Tryavna

??????? ?????

дек 232011

????? ???????? ??????: Table1 ??????? ????? ?? ????????? ?? ???-???????? ????????? ??????? ? ??????, ? Table2 ??????? ???????? ?? ?????? ??????. ???? ?? ????? ?? ???????? ?? ?????? ????????? ? ?????????.
?? ???????????, ?? ??????? ?? First Name (FNAME), Last Name (LNAME), CITY, COUNTRY.

???-????????????? ??????? ? ????????:

SELECT *
FROM table2 t2
WHERE EXISTS (SELECT 1
FROM table1 t1
WHERE t1.fname = t2.fname
AND t1.lname = t2.lname
AND t1.city = t2.city
AND t1.country = t2.country)

???? ?? ?? ???? ???????? ??? ?????? ????? ?? ???????? ?? ???????. ?? ????? ?????? ?????, ??????? ?? ?????? ?? ???? ?????. ???????? ???????? Schmitt ?? ???????? ???? ?? ? ??????? ? ????????? ???? Schmidt; ????????? Pavlovich ???? ?? ? Pavlovic; John Smith ?? ??????? ? John Smit ? ?.?. ??? ?????? ???? ??-?????.

??? ???? ???????, ????? ?? ?????? ?? ????? ????????? ???????????? (?????? ???? ?? ????????!) ? ???? ? soundex. ?????? ? ?? ???????? ? ??????????? ????? ? ? ?????? ???. ?? ????? ????? ????? ? ???:

SELECT *
FROM table2 t2
WHERE EXISTS (SELECT 1
FROM table1 t1
WHERE SOUNDEX(t1.fname) = SOUNDEX(t2.fname)
AND SOUNDEX(t1.lname) = SOUNDEX(t2.lname)
AND t1.city = t2.city
AND t1.country = t2.country)

(?? ????????, ??? ?? ?????????, ??????? ?? ????????? ? ????????? ?? ???????? ???????. ????? ???? ?? ?? ??????? ?????? ?????????????)

???… ???????? ?????? ????? ?????????. ?? ??? ???? ???? ???? ????? Marko Mjagkov ? Marica Moisejevs, ?? ?? soundex ?? ?????? ??????? – M620 M221. ?? ??????? ???? ?????

??? ???? ??????, ??????????? ??? ?????, ???????? ???? utl_match. ? ???? ????? ??? ??????????? 2 ??????????, ??????????? ?? ????? ? ????? ????? ??????? – ?????????? ?? ?????. ??????? ? ???????? ?? ?????? ????????? ???????? ????????? ???? ????????? 1965 (????????? EDIT_DISTANCE), ? ?????? ????? ? ? ??????????? ????????, ???????? ?? ????????????? ???? ?? ????????? Matthew Jaro ? William Winkler, ?????????? ???? 1990. ??????? ? ?? ??? ????? ? ???????????? ???? ?????? ? ???????, ???? ??? ???????? ?????? ? ?????????????? ?????? ?? ? ?????? ??????; ?? ??? ???? ?? ????????? ????????? ???????? ? ??? ?? ?? ????? ?????, ?? ??????? ????? ?? „??????“ ???????:

SELECT *
FROM table2 t2
WHERE EXISTS (SELECT 1
FROM table1 t1
WHERE utl_match.jaro_winkler(t1.fname, t2.fname) > 0.9
AND utl_match.jaro_winkler(t1.lname, t2.lname) > 0.9
AND t1.city = t2.city
AND t1.country = t2.country)

???, ?????, ???????? ?? ???? ??????? – ???? ????????? ????? ? ?????? ????????. ??? ????????? ??? 10 000 ??????? ?? ??????, ? ?????? ??? 500 000 ???? ? ?????? ?? ????, ?? ????? ?????? ???? ?? ???????? ????????? utl_match.jaro_winkler ??? 5 000 000 000 ????. ??? ???? ?? ????????, ????????, ????? ? ????? – ???? ????. ??????? ??????? ??? ??????????? ?? ???????, ?????? ????? ????. ???? ?? ?????? ????? (??????????) ?????.

? ????, ?? ??????? ?? ????? ?????????? ?? ????????? ?? ???????? ??????????? ???????

SELECT *
FROM table2 t2
WHERE EXISTS (SELECT 1
FROM table1 t1
WHERE SOUNDEX(t1.fname) = SOUNDEX(t2.fname)
AND SOUNDEX(t1.lname) = SOUNDEX(t2.lname)
AND utl_match.jaro_winkler(t1.fname, t2.fname) > 0.9
AND utl_match.jaro_winkler(t1.lname, t2.lname) > 0.9
AND t1.city = t2.city
AND t1.country = t2.country)

??? ??? soundex ??????????? ??????? ?????????? ??????????, ????? ? ?? ????? ????? false positives. ?? ??-????????? ?????? ???? ?? ???????? ???????????? ?????? ?? soundex.
????? ? utl_match.jaro_winkler ??????? ???-?????????? ?????????? ?? ???? ????????? ?????. ??????? ??? ??, ???? ????? ????? ????? – ??? ??????? ? 20? ? 2M ???? (???????? ?? ???? ????), ?????? ?? ??????? ??????? ? ???? ????? ???????? ?????????. ??????? ??, ????? ?? ???????????? ???? ?? ?? ???????? – ?? ???? ???? ???????? ?? ????? ???? ????. ?? ??? ??? ? ??????? ??????.

P.S. ?? ????? ?? research-? ?????????? ?? ??????????????? ?????. ????????? ?? ?? ????, ?????? ???? extproc, ? ??? ????????? ???? ????????? ?????? ???? ?? ?????? ????? ? ???????????. ????? ???????? ?????????

Upgrading to Oracle 11.2 – BGOUG’11

???? No Responses »

ное 202011

????????????? ?? „The adventure of upgrading to 11.2″ ?? ??????? ??????? ?? ???? ? ????? – ???

?????? ????????? ????? ??????? ????????????? ? ?????????? ?? ??????, ??? ? ??????? ????????????, ????? ?????????? ????? ?? ??????? ?? ????? ? ??????? ?? ?? ???????? ???? ????????. ????????? ??????, ??????!

11g: no more „AUDIT … BY SESSION“

Oracle No Responses »

ное 102011

???? ? ???? ????? ????????? ?????? ??? upgrade ?? 10g ?? 11g. ?? ????? ?? ???????????????? ??????? ???????????, ?? audit trail ????????? ?? ??????? ? ????? ??????? ? ???? ?????????? ???? ?? IO ?????????? ?? ?????? ?????? ? SYS.AUD$.

???????? ???????? ???? ? Metalink:
Huge/Large/Excessive Number Of Audit Records Are Being Generated In The Database [ID 1171314.1]

1.) Starting with Oracle 11g the BY SESSION clause is obsolete. This is documented in the Database Security Guide :

“ The BY SESSION clause of the AUDIT statement now writes one audit record for every audited event. In previous releases, BY SESSION wrote one audit record for all SQL statements or operations of the same type that were executed on the same schema objects in the same user session. Now, both BY SESSION and BY ACCESS write one audit record for each audit operation. In addition, there are separate audit records for LOGON and LOGOFF events. “

Because of the above change it is expected that the number of the audit records/files will grow considerably.
…

?????????? ?? ??? ?????????????? ?????? ????????:
Oracle� Database SQL Language Reference 11g Release 1 (11.1)

BY SESSION

In earlier releases, BY SESSION caused the database to write a single record for all SQL statements or operations of the same type executed on the same schema objects in the same session. Beginning with this release of Oracle Database, both BY SESSION and BY ACCESS cause Oracle Database to write one audit record for each audited statement and operation. BY SESSION continues to populate different values to the audit trail compared with BY ACCESS. If you specify neither clause, then BY SESSION is the default.

?? ???????? ?????? ???? ? ? Oracle� Database SQL Language Reference 11g Release 2 (11.2)

??? ??-?????? ? ?????????? ? Oracle� Database Security Guide 11g Release 2 (11.2)

Benefits of Using the BY ACCESS Clause in the AUDIT Statement

By default, Oracle Database writes a new audit record for every audited event, using the BY ACCESS clause functionality. To use this functionality, either include BY ACCESS in the AUDIT statement, or if you want, you can omit it because it is the default. (As of Oracle Database 11g Release 2 (11.2.0.2), the BY ACCESS clause is the default setting.)

Oracle recommends that you audit BY ACCESS and not BY SESSION in your AUDIT statements. The benefits of using the BY ACCESS clause in the AUDIT statement are as follows:
…

?????? ?? ??????, ??? ???? ?? ?????? ???? „????… ?? ???? ?? ??????? ??? BY SESSION, ??? ??????? ?? ?? ??????????, ????? ?? ???? ?????? ????? ???? BY ACCESS“

???????? ?? ????????????? audit ?????????? ?? ????? upgrade-a. ?? ?????? ???????? noaudit ???????? ?????? online. ?????????? noaudit execute ????? ????? ??????????? ? ???????? ?? ?? ?????? ?? ????? ?? downtime.

??? ? ???? ??????? query ?? ???????:

SELECT 'noaudit select on ' || owner || '.' || object_name || ' WHENEVER SUCCESSFUL;'
FROM DBA_OBJ_AUDIT_OPTS
WHERE sel LIKE 'S/%'
AND owner IN ('…application schemas…')
AND object_name NOT IN ('…exclusions…')
UNION ALL
SELECT 'noaudit execute on ' || owner || '.' || object_name || ' WHENEVER SUCCESSFUL;'
FROM DBA_OBJ_AUDIT_OPTS
WHERE exe LIKE 'S/%'
AND owner IN ('…application schemas…')
AND object_name NOT IN ('…exclusions…')
UNION ALL
SELECT 'noaudit update on ' || owner || '.' || object_name || ' WHENEVER SUCCESSFUL;'
FROM DBA_OBJ_AUDIT_OPTS
WHERE upd LIKE 'S/%'
AND owner IN ('…application schemas…')
AND object_name NOT IN ('…exclusions…')
UNION ALL
SELECT 'noaudit insert on ' || owner || '.' || object_name || ' WHENEVER SUCCESSFUL;'
FROM DBA_OBJ_AUDIT_OPTS
WHERE ins LIKE 'S/%'
AND owner IN ('…application schemas…')
AND object_name NOT IN ('…exclusions…')
UNION ALL
SELECT 'noaudit delete on ' || owner || '.' || object_name || ' WHENEVER SUCCESSFUL;'
FROM DBA_OBJ_AUDIT_OPTS
WHERE del LIKE 'S/%'
AND owner IN ('…application schemas…')
AND object_name NOT IN ('…exclusions…')

? ??? ???? ????? ?????: ?? ?????????? ?? ?? ?????????? ????? ???? ? ALL_DEF_AUDIT_OPTS ????? upgrade. ????? catupgrd ?? ?? ??????? ?????? ?????? ?????? ? ????? auditing.

TM locks ???? upgrade ??? 11g

Oracle No Responses »

ное 022011

???? ?? ?? ???????. ?????????? ? ?????? ?????? ?? Oracle ?????? ???????? ??-?????; ??? ??-????? ???????????? ?? ?????????? ??????. ????, ????? ?? ?????, ? ???? ?? 11g

????? ?? ?????, ?? ???? ? ????????? ?????? ?? ????????????. ????? ????, ?? foreign key ???????? ?????? ?? ?? ??????????. ????? ? 10g ???? ?????? ?? ??-????? ????????? ?? parent ?????????, ??? ??-????? update ?? primary key ? ??? (?????? ?? ??????? child ????????? ?? ????????? ??????). ? ???? ????? ?????? ???? ????????? – ??????????, ????? ???? ?? ???????? ?????????? ????? ?????. ???? ????? INSERT ? parent ????????? ???? ?? ??????? ?????? ????? ?????, ????? ?? ??????? ?? ???????? UPDATE ??? DELETE (??? ?? parent ?????????). ??? ?????? ?? ??????? ?? ??????? ? child ????????? – ?????????? ? ?? ? ???, ??? ?? ? ??????. ? ?? ?? ?? ? ??-??????, ??? ?????????? ??? ?????? ? child ??????? ?? 724 ????, ?? ????? full scan-? ? 10g ? ??????? ??????????? ? ?? ??? ??????? ??????? ???????.

* * *

??? ? ?????????????. Note 1343365.1 ????? ????????

There is change in lock modes behavior introduced intentionally by fix 5909305 in 11.1 onward.

Change has been made to DML (TM) lock modes for foreign key constraints (Doc ID 5909305.8).

The change in behavior mentioned in note 5909305.8 , introduces higher level of lock on parent table while running DML against Child table. ( SX vs SS )

There are cases unrelated to this bug which lack of indexes on foreign key columns increase the time locks take place. This reflect as wait on TM-enq.

????? ?????????. ??????????? ?? SS ? SX ? ????? ???????. ??? 2 ??????? – SX ?? ? ????????? ? ????? S ? SSX (Share ? Share Sub-eXclusive) ???????????. ?? ??? ????? ?? ?? ?????? ? ??????????? ?????? ? DML ??????. ?????.

??? ?? ??????? ?????????????? foreign key. ???? ? ??????????? DML ?? ????? ????, ????? ????? S ?????????? ?? ?????? child ???????. ? ????, ??? ???????? ?????? ?????? ?? ??????? ?? ?? ??????? ????? ??? ?? 11.2.0.2:

1. ????????? ?? ??????? ? ?????

DROP TABLE t2 purge;
DROP TABLE t1 purge;
CREATE TABLE t1 (pk NUMBER primary key);
CREATE TABLE t2 (pk NUMBER primary key, fk NUMBER references t1(pk));
INSERT INTO t1 VALUES (1);
INSERT INTO t1 VALUES (2);
INSERT INTO t1 VALUES (3);
INSERT INTO t1 VALUES (4);
INSERT INTO t2 VALUES (11, 1);
INSERT INTO t2 VALUES (21, 2);
INSERT INTO t2 VALUES (22, 2);
INSERT INTO t2 VALUES (31, 3);
INSERT INTO t2 VALUES (32, 3);
INSERT INTO t2 VALUES (33, 3);
COMMIT;

2. ??????? ?????? ?? ????? 1

INSERT INTO t1 VALUES (5);

?????? ?????? ??? v$lock ???????, ?? ?????? ????? 1 ????? 3 ???????????? (???????? ????? ?????? ? 11g, ?? ????? ?? ???-?????????)
- mode 6 (eXclusive) TX lock ????? ????? ???
- mode 3 (Sub eXclusive) TM lock ????? ????????? t1 (????? parent ?????????). ???????? ????????, ?? ???? ? ?????????? ?? ?????????, ? ?? ?? ????? ??? ? ???
- mode 2 (Sub Share) ??? 10g ??? Mode 3 (Sub eXclusive) ??? 11g, TM lock ?? ??????? t2 (???? ? child ?????????). ?????? ???? ?? ? ???????? ? ??????? ?????? ? ??? – ???? ?? ???, ???? ? ?? ???? ????????? ??????. ?????? ??????????? ??? ?? ?????? ???????, ????? ???? foreign key constraint, ????? ??? ????? parent.

3. ???????? ?? ???????? ??? ??????? ?????????? (????) ??? ?? parent ????????? ?? ????? 2:

DELETE FROM t1 WHERE pk=4;

???

UPDATE t1 SET pk=2 WHERE pk=2;

? 10g ???? ?????? ?????????. ????? ? 11g ? ????? ????????, ????????? ?? ?? ??????? Mode 4 (Share) lock ?? child ????????? – ?????? foreign key ???????? ?? ? ???????????.

??? ?? ?? ??????? ??????????????? ???????:
F???????? ?? ?????????? ???????, ?????? ?? TM locks ? Grid Control. ??? ??????? ???? ??????? ????, ????? ?? ??????. ???? ?? ?? ????? ? ??? V$SESSION:

SQL> SELECT sid, final_blocking_session
2 FROM v$session
3 WHERE event = 'enq: TM – contention';
SID FINAL_BLOCKING_SESSION
———- ———————-
132 332

?? ?? ??????? ?????????? ?????? (? ????? ???? – ????????? ??? ??????), ??????? ????:

SQL> SELECT SID, TYPE, id1, lmode, request, block
2 FROM v$lock
3 WHERE sid IN (132, 332)
4 AND TYPE = 'TM';
SID TYPE ID1 LMODE REQUEST BLOCK
———- —- ———- ———- ———- ———-
132 TM 950744 3 0 0
132 TM 950746 0 4 0
332 TM 950744 3 0 0
332 TM 950746 3 0 1

?? ??? ????? 4 ???? BLOCK=1, ?.?. ???? ?????????? *???????* ????? ????. ?? ??? ????? 2 ??????? REQUEST=4 ? LMODE=0 – ???? ???????, ?? ??????? ??? ????? ?? mode 4 lock, ????? ?? ???? ?? ?? ?????. ???????? ID1 ? ?????? ? object ID (?? TM locks):

SQL> SELECT owner, object_name, object_type
2 FROM dba_objects
3 WHERE object_id = 950746;
OWNER OBJECT_NAM OBJECT_TYPE
———- ———- ——————-
YAVOR T2 TABLE

????????? ? ?????, ???? ???? ??? ??????? ????????. ?????? ????????? ?????? ?? foreign key ???????? ?? child ?????????

CREATE INDEX t2_fk ON t2(fk);

???? ??????????? ?? ??????, ????????? ????? parent ????????? ???? ?? ????? S ?????????? ?? child. ?????? ???? ?? ????? SX ??????????, ????? ? ?????? ?????????? ? ?????? SX.

???? ????????? ? ?????? ?? ????????? ?? develpers. ?????? ??????, ???? ? ?? ?? ???? ?? ?? ?????? ??? ??????? ???????? ??????? ?? S lock ? ?? ?????? ?? SX. ??? ?? ???????? ??????? ?????? ? child ?????????. ???… ???? ?? ?? ?????????.

???????… ??????

Personal 1 Response »

окт 232011

?????????, ?????? ????? ??????? ??????? ?????? ?? ?? ?????????? ????? ?? ?????? ? ?????????. ? ?? ???????????? ????? ????? ???????, ?? ?? ? ? ??-?????, ? ??????????? – „?? ???????? ?? ???? ? ????, ?????? ???? ? ?????“. ?????, ?? ?????? ?????? ?????, ?? ? ????????.
????????? ??????? ?? ???? ???? ??????????? ?????. ????????? ??? ?? ????? ?? ?? ???????? ???? ? ???????? ??????.
????? ? ?? ????????. ? ??? ?? ???????? ?? ????, ???? ? – ??????????! ??? ?? ?????, ???????? ???? ? ???-?????????? „????????? ???“ ????? ?????????? ?? ???????. ?????, ?????? ??? ????????, ? ?????.

… ? ???????

Oracle, Personal, ????? No Responses »

окт 092011

? ????? ?? ????????? ?? ????? 8 ????. ????? ?????? ?? ???????? ?? ??????????????? ??????? ? ??????? ?? ?? ??????? ??????. ????? ??????????????? ??????: ?? ???????? ? ???????? ?????? ?? ??????? ????? 2 ????. ???????? ?? ?? ???????? ?? ?????? ?????? ? ?? ????????? ??????? ??? ???; ????? ??? ????? ?????? ? ????, ??? ????? ????????? ? ????. ??????????? ???????, ??????? ?? ?? ????? ??? (? ???????????? ?? ??????), ?? ?????? ??????? ??????????? ?? ?? ?? ??????? ?? ?? ??????? ?????? ?? ????????, ?? ????? ???? ?????????. ? ?? ? ???? ?? ???? ?????????? (???? ?? ???????) ???? ????? – ???????? ???????, ???? ????? ???????, ??????????, ??. ????? ?? ???? ? ????????????? ? ?.?.
(???????? ?????? ??????? ???????? ??????? ???? ? ?????? ?? ???????? ?? ???????, ?? ???? ???????? ?? ????? ?? ? ???????)

????? ????????? ?????? – ???? ??? ????? ?????? ?? ?? ??????? ?? 12 – ? ??????? ?????? ?? ??????????. ????? ?? ????????? ????????? ???????? ???? ? ????-???????? ?? ???????. ???? ? ??? ??????? ???????? ?? ????????, ????? ? ???? ?? ???-??????? ??????: ?? ?? ?????? ??????? ????? ? ?????? San Francisco.

? ????, ??????? ?????? ?? ??? ?????????. ??? ???? ??????? ????-?????:

?? ?????? ??-?????? ????? ??? ??????? ???? ?? ????:

??????? ???????, ?? ????? ?? ??????? ? ??????, ?? ?? ???????. ?? ? ?????? ? ?? ????? ??? ??????.

??? Union Square:

?????????? ???? ?????? ??????????? ?????????. ??????? ? ????? ?????? ?? ?? ????? ? ???.

???? ???????????? ???????? ?? ???????? ??????? ?? Union Square. ??? ?? ?????, ??? ?????? ?? ?????????. ? ???? ????? ???? ?? ??????, ????? ????? ?????? ? ?? ?? ??????? ?? cable car:

??????????? ???? ??????????? ????? ????? ??????????. ???????? ??????? ??????, ?????? ?????? „??????????“ ? ???????? ?????, ?????? ? ?????????. ?? ????? ????????? ??? ????????? ?????????:

???????? ????: ????-?????? ???????. ?????? ???????? ????????. ???????? ?? ???????????? ?? ????????? ? ?? ????????, ?????? ????? ??-???????? ?????? ???????? ???? ?? ?? ?? ???? ?? ?????:

??? ? ?????? ?? Yerba Buena gardens. ????? ?? ????? ???? ????? ??????????? ????? – Marriott. ????? ????? – ???? 30, ????????? ??????????? ? ????? ??????????? ???? ? ???? – ???? ?? ??????? ???? ? ????.

? ??????? ??? ?? ????? ????????????? ?????? ????? ??????. ??? ? ? ?????:

?? ? ??? ? ????? ??????, ? ???? ?????? ISO. ???????? ?? ?? ??????? ??????? ??????, ?????? ????? ????? ?? ??????????. ??? ? ?????? ?? ????????:

? ???? ? ???????? ?????, ?????? ???????:

????? ????????? ???????????. ? ???????????, ??? ???? ??? ? ????????????? ? ??????.

? ????, ???????? ???? ??? 2 ????, ? ?? ??????? ????????? ??????? ? ??????? ?????. ? ?? ????? ?????? ?? ?? ????, ????????????? ?? – ???? ?? 15-20 ???????? ??????? ?? ????? ????. ?? ?? ??? ??, ???????? ??????? ? ??????? China Town:

??? ??????? ????????? ????? ??????? ?? ??????. ??????????? ???? ????? ???????, ??????? ?? ????????. ????? ?? ?????, ? ?? ?????????? ?????? ?? ????? ?? ? ????? ?? ?? ????????? ? ????????. ?????? ???? ????????? – 600 ?????? ?? Nikkor 10-24 (? ?? ? 1500 ??). ?? ?????? ?? ?? ?? ?????, ?? – ???? ???? ???? ??????? ??????????. ??? ? ??? ?? ????? ????, ????? ???? ????? ????????.

? ????. ????? ?? ??????? ? ????? ?????? ?? ???????? ????????. ??? ?????? ?? ???????? ? ??? 13:15, ?? ????? ? 18 ????. ?? ??????? ? 21, ???? ?? ????? ?? ?? ?? ??????? ?????. ??????? ?? ???????? ? „????????????“ ?????????, ??????? ?? ?????? ? ??????? ??? BART.

?? ???????? ?? ???? ?? ??????? ????? – ??? ? ???? ????. ????? ???? ????? ??????? ???? 4-5, ???? ?? ?? „??????“ ??????? ??? ????? ?? ??????. ?????? ?? ?? ?? ???? ?? ???, ?? ????? ???? „San Francisco Airport“. ???????.

???????? ?? ?? ????????????? ???????? ??? 15:30. ??? ?????????, check in-? ?? ????????? ?????? ?? 17:45. ???? ????. ??? ?? ?? ???? ??????, ??????? ????? – ???????. ??????? ?? ?????? ??? 18:00 ???? – ?????? ????????? ???? ???. ????? ?? ?? ?????. ????? ??, ?? ???? ?????????? ?? ? ??-???????. ???? ??????? ?? ?? ??????? ?? ????? ?? ?? ?? ?????? ???????, ?? ??? ???? ?????????? (??????? ????????) ??? ???? ? ? ?????? – ???????????? ?? ????? ??-??????????.

Security check-? ?? ?????? ????? ??????? ? ?????, ?? ????? ??????. ????????? ?? ?????????? ???????? ? ??????, ?? ?? ? ???? ?????; ????? ???????????? ?? ??????? – ???????? ??????? ???? ??????? ?? ????? ?????. ??????????? ?, ?? ??? ?? ?? ??????? ???? ???????? ?? ??????? „?? ????“ – ????? ???? ???? ??????? ????????. ????? ?? ???? ???????? ? ?????? ????? ? ??? ??? duty free-to.

????? ????? ?? ?????? ??????? ????????????? ????. ???? ???? ???. ????? ???? ?????? ?? ?????? ?? ??????, ?? ?? ???? ???????? ? ?????? ?????? ????????????. ? ? ??????? ?? ???? ?? ?? ?????? ? ?? ???? ????. ????? ??????? – ??? ?????????? (???? ? ??????) ?? ?? ??????? ??????? ????????.

??? ???? ?? ?????? ? ??????????? ????? ??????????, ?? ????

?? ? ??? ? ????? VR-?.

?? ???? ?? ?? ?? ????? ? ?? ????. ?????????? ?? ??????? ??? ?????? ????. ? ? ???? ?????? ?? ???? ?????????????? ?????:
„Passenger Ivanov, please identify yourself at gate G99″
??, ?? ?????? ?? ??????? ??????… ??, ??? ?? – ????? ??, ?? ???? ?????? ?? ?? ?????? ???????. ???? ????????, ????? ?? ??? ?? ????????, ?? ?????? ?????.

Airbus A340-600 ??? ? ???????? ? ???-?????? ???????. ?????? ?? 440 ???????, ??? ???? ? ???? ?? ???? ????. ??????????? (?? ???) ??????? ?, ?? ?????????? ?? ?? „?????? ????“ – ???? ??? ?????? ??????? ?? ?????? ?? ??-????? ??????? ?????????. ? ?? ???????? ? ????????? ???????????? – ??? ?????, ?? ????? ???? ?? ?? ??????? ?????? ?? ? ???? ?? ????????? (??? ??????????? – ?? 10 ?????? – ?????? ??? ??? ???? ??????? ?????????? ?????). ?? ?? ???? ???????? ??????? ????????, ???????, ????, ???? ? ?.?.

??? ??? boot-?? ??????? ??????? ?? ??????????:

Windows CE. ?????????? ? ??????? ?? ??? ?? A380, ?? ??????????? ? ??-????. ?, ??? ??? ? ???????? ? ??-?????????.

????????? ? ????? ?????????? – ???? ?? 10-20 ??????. ?????? ?? ?????? ? ??-?????? (????? 10 ???? ? ????????), ??? ?????? ? ??????? ??? ??-????? ?? ?????????. ?????????, ?????, ?? ?? ??????? ??????? ??????? ??????? – ?? ?????????? ????????? ???? ???-????? ????, ????? ????? ???? ?? ???????? ? ???????? ??? ????????? (? ?? ??? ????????). ????? ???? ???? ?????? ????? ??????? ? ??? 950 ??/?, ???? ????? ??? 1000. ??? ???????? ?????????? ? 1070.

?????? ????? 2 ????? – ????? ?????? ??? ???? ???? ???????? ? ??? ???? ????? ??????. ???? ???????? ????? ?????? ?????, ?????? ???????? ???? ?????????, ?????????? – ???????. ???? ? ??, ? ??????? ?? ????? ?? ??????, ?????? 4 ????.

? ?????? ?? ?????????? ??? ?????, ???? ? ????. ??????? ??????? ???? ???? ???? ???????? ? ?? ??????? ??? ?? ???????? ????. ?? ???? ???????????????? ? ?? ????? ?? ???????? ? ?? ???????, ?? ? ? ????? ??????? ? ?????.

??? ???? ????????? ?????? ?? ????????? ? ??????:

????????? ???????? ????, ????? ? ??????, ????? ????? ????? ???? ????????. ????? ?? ??? – ?????????? (? ???????? ????? ????????????) ?? ???????? ???????????? ?? ???????? ???????.

??? ???? ?????????:

??? ?? ?? ??? ????? ?????? ?? ?? ?????, ????? ?? ???? ?????? ??? 6 (????!) ????????, ????? ????? ?? 2 ?????. ????????? ????? ????????? ? ??? ??????. ? ???? ? ????? ??????! ? ???? ???? ???? ????? ????? ?????? ?? ????? (?????? ??????).

2 ???? ??????? ? ?????? ????? ?? boarding. ????? ???? ?? ??? ? ?????? ?????? – ???? ??? ????????????? ??????????. ????? ????????? ?? ????????? ?? ????????? ? ?? ??????? ?? ???????. ??? ???????, ???????, ? ?? ?????? ?? ???? A319-100. ?? ?? ? ???? ???????? – ???? ? ?????????. ????? ?? ????? ?? ???? ????? ??-?????? ? ?? ???????? ???? ? ?????????. ????????? ? ?????? ?????.

????? ?????? ???? ???????. ???? ???? ??????? ???? ??????, ?? ?? ?????? ?? ?? ??????????. ??????? ??, ??? ??????? – ??????? ? ????? ???? ? ?????? ? ?????? ????? 22:20 (-10 ???? ???????).

??? ????? ?????????, ?? ?????? ?? ???????? ???????? ?? ? ?????? ??????????. ????????? ???????????? ??????. ????? ?????? ? ??????? (??????? ?????????? ??????) – ?? ????? ???-???-??, ??? ????, ????????? ????? ?????. ??? ? ????? ????????, ???? ?? ?? ???? ???????, ?? ????? ?? ??????????. ?? ???? ????????, ?? ?? ?? ??? ?????????. ????????? ?? ?????, ??? ?? ???? ??? ????? ?????? „?? ?? ????????? ??????. ??? ????? ?? ?? ??????? – ?? ?? ???????“. ?, ???? ?? ????? ? ????????? ????????.

???????? ?? ????? ? ????????!

?????????

Oracle, ????? 2 Responses »

окт 072011

???? ?? ???????? ??-?????. ??? ??????????, ????????, ?? ?????.

??????? ?? ??? 6 ? ???????? ????? ??? ??? ????. ???? ??? ????? ????????? ? �????????� (?.?. ?????? ??????? ? ?????????) ? 7. ?, ???????? ??? ? ???, ????, ?????, ???? ????. ? ??????? ???? ??????. ??? ???? ??????? ?????.

????? ????? ?? ????? ??????????? ? ?????, ????? ???????? ? ?? ????. ??? ??? ?? ??????? ??-????? � ???? ??????? ????? ? ?? 9:00. ?????? ???????, ????? ?? ??????, ?? ???? ?????. ????? ????? ?? ?????? ?? Moscone ??-???????? ????????. ????? ?? ??? ??????????, ??? ? ????-???? ????? ????????.

??????? ??????, ?? ????? ?????? , ???? �Trends in Database Administration and the Changing Role of the DBA� ?? Michael Corey. ?????, ????? ????? ???. ????, ?? ?????? ? Oracle ?? ?????? 3 (!) ? ????? ?????????, ?????? ???? ?????? ? ????? ???????? ?? ???????. ????????? ?????? ?????????? ?? Oracle ? ???? 3 ????? ? ?????? ? ???? ????. ???? ??????????????, ??? ?? ????????? ? ??????? ?? ???????, ?? ??????? ?????? ????? ?? ????????????? ????; ? ??????? ????? ?? ??????? ?? ????? ?? ????? ??????, ????? ????????? ????? ??-????? ??? ??????? ??????????????. ? ??? ?? ? ???? ??? ??? ?????. ? ????? ????? ????????? ???? � ??? ?? ?? ?????? DBA, ???? ???? ?? ?? ??????? ?????; ??? ?? ?? ????????, ???? ?? ???? ?? ??????; ????? ???????????, ?? ????? DBA-related ????. ??? ??? ????????????? ???????? (????? ?????, ????? ??????? ??-?????).

???? ???? ?????? ?? ???? ?? �Real-World Performance Questions and Answers� � ????? ?? Weal-World Performance Group. ?? ?? ?????? ????? ?????? ? ?? ?????????? ????? ?????. ????????? ?? ??????, ???????, ? ?????? ?? ?????; Oracle, ???????, ?????????????, e-mail-???, ??????????? ? ????? ?? ??? ??. ?????? ?? ? ???????? ?? Oracle Certified ??????, ?????? ?? ?????? OCM ??????? ????. ?????? ? ??????? ???????? ? ???????, ???????? ?? ?? ???? ??? ?? ?????? ?????? ? ??????. ??? ???? ???? ?? ?? ???????? ???? ?? ????? � ??? ???? ??? ????, ?? ?????? ?? ?? ?? ???? ? ?????????.

????? ?????? ? ?????? ??????? ?? �Oracle Data Guard Switchover and Failover Internals: How Fast Can You Go?� � ?????? ?? ????? ??? ?? ??????. ???? ???? ?????, ?????? ????????? ?? ????, ????? ???? ?? ?????? ? ????????? ????????. ????? ???? � ?????????, ?? ????? ????????, ???? ??????? ??????, ??????? ???????. Intel ?? ?????? ????? ?????????? Factory Automation database ?? ??????? Windows ?????? (?????? failover cluster ??????????? MSCS!!!) ? ???? 1 (1!) async remote standby, ????? ? ?????????? ?? storage. ????? ????? ?? ????????? ??? ???????? ?? ???????? ????????? standby ? ????? ???????? ?? ????…. ??????? ??????.

????? ???????, ???????? ????????, ? ?????? Craig Shallahamer ? ???????? SQL Elapsed Time Analysis. ???????? ?? ??? ??? ?? ????? ???????????, ???? ?? ???? ????? ???? ?? ??????? ?????. ??? ?? ?????? ? ?????? ?????? ? ??????? ???????? � ?????? ???????????. ??? ? ????? ?? ??????? ?????? � ???? ?????? ???? ???????, ?? ???????? �?? ????�. ??? ?????.

?????????? ?? OOW�11 ????? ???? ???? ?? ???-?????: �Under the Hood of Oracle Automatic Storage Management: Fault Tolerance� ?? Alex Gorbachev. ? ??? ??????? ?? ?????. ???? ? ??????? ????? ????? ???? ?? ASM, Failover, rebalancing ? ?.?. ?, ?? ??????? ?? ???? ???, ???? ?? ?????? ???? Exadata ?? ? ????????? disaster ?? availability. ??????, ?? ? ???? Database Machine, ??? ??????? ???? ????, ????? ?? ???? rebalance, ????? ?? ?????? ?? ?????? ????? ? ??????? – ?????????? ?? ???? ??? ???? (?? 156). ??, ??? ?? ????? ????. ????? ? ?? ?, ??? ???????, ?? ????? ?? ? ??????? ???????, ??????? ??????. ???? ???????? ????????? ??????? ? live demo ? 42 ????? (?????????, ?? ??????? ??).
???? ?? ??????????? ?????, ????? ?? ????? � ??????? ? redundancy ?? ????? ? ASM ???????, ?????? (DBWR/LGWR/ARC/�) ? ????, ????? ???? ?? 2 (??? 3) ?????. ? ?????? ?? ???? ?? ???? ?? ???????, ????? ?? ?????? primary; mirror ???????? ?? ?? ?????? ?? ??????. ????? ??? stretch clusters, ??? ???? ? ?????????? ??????????.
????????? ?? ??? ??, ?? ??????? ? 2 failure groups ? ????? ?????? ?? ?????? ????? ?? availability? ??? ??????? ?????? ?????, ???? ? ?? ? ????? ??????, ??????? ?? ???? ?? ??????? rebalance.

* * *

OOW ?? ????????? ???? ????????. ?????, ?????????. ?? ????? ?? ???????. ??? ???? ?????, ??? ???? ????… ???? ????????? ?????. ??????????? ?? ???-????? ?????. ? ?? ?????? ?????? ?????????? 5 ????. ??????….

?????? ?? ?? ?? ????? ??????? ?? ????????, ????? ?? ?????? ???? ???? ???? ????????? ? ????? � ???? ??????? ?? ????? ? ???????? ?? ??????? ???????. ??? ?????? ? ?? ?? ????????.

? ????, ???? ??? ??????????? ??????? ?? ??????. ? – ?? – ????? ????? ?? ?? ???????, ?? ??? ?? ?????! ???? ???? ??????????? ???? ?? ? 10 ?????? – ???? ??????? ? 9 ??????? ? (? 2 ???? ??????? ? ??????) ?? ?? ??????? ? 10 ??????? ? ?????? (????). ????????? ????? ?? ???????????? ?????. ?? ???? ???? ????? ?? ? ??????? ? ????????? ?????? ?? ????????? ?? ?????…

?????

Oracle, Personal, ????? 1 Response »

окт 062011

??????? ?? ? ???????? ???????. ????? ??? ????? � ????? ???????. ?????? ? ?????? ??? ??????? ???. ?????? ?? ?? ????? ? ??????, ?????? ???????? ??????? ??????? ???. ???? ??? ?? ???????? ??????????. ? ??? ???? ??????? ?????? ?? ???? ? ? 10:15…

??????? ?? ???? ? ????????? ?? ??????? ??????? ?? ????????? ????? ???? ? ? ?????. ???? ? ?????????? ?? ???? ????????, ???????? ?? ??????? 2 ?????? ???? ???????????? � ?? ?? ?????? ?? ??????.

WTF? 15:30??? ????…. ??? ?? ???? ??? ? ????????, ? ?? ????? ? ????????. ????, ??? ????? ?? ?? ??????? ??????? ???????? ? ???? ???? ??? ????????, ???? ?? ???? ?? ????? ?? ?????. ??????? ??????????. ???????? ????????????? ??? ???, ????? ?? ??????? ? ??????. ? ??? ???? ?????????? ?? ???? ???? ?? ?? ??? ? ???? ??… ?? ??????? ??? ???? ??? ????.

(???????? ?? ????, 21:00 ????, ?? ?? ???????? ????-???? ?????. ???? ???????? ??? ?? ??????)

?????? ?? ?????????? ???????? ?? ???????????? ????. ?????? ???????? ??? ?????, ?????? ?? ?????????. ???????, ?????????, ???????? ? ???????? ? ??? ?????. ???????? ?? Moscone west � ????? ??? ?? ???????? ???????, ?? ?? ?????????? ????????.

???? ?? ? ??? ?? ??????????? � ?????????? ????? 9:00. ??????? ?? ??? ?????? ????, ?? ?? ?? ????? ????????? ??? ?? ???? (???? 3 ? ??????). ?????? ??? ??? ????? ?? ??????. ????? ?? ?? ???????? ??????? ????. ?????? ?? ????? ???? ? � ????????! ??????? ????, ?????? ?? ????? User Groups, ???? ? ??? ???? ?????? ?? ????????. ?????????? ??????. ????? ???? ?? ???????? ???? ????? (Sting ? ????? ?????) � ????????? ?? ??????????? ? OOW, ?? ????? ?????? ??????? ?? ?????? ?? ?????. ?? ? ??? ???? ???? ????????? ?? ???? � ? ???? ??????? ? ??????? ??????? ?? ??????? ????? ?????. ????? ?? ??????, ??? ????? ?????? ???????, ?? ?? ????? for free.

??? 9:50 ????? ?? ?? ????? ? ??? ? ?? ??????? ??? ??????? ????? ?? ???? – Oracle Active Data Guard: Lessons Learned from Real-Life Implementations. ?? ???????? ??, real life ???????, ????????? ?? ???????, ????? ???????? ?? ?? ?????? ? ????. ?? ????????? ? ???????? ???? ????? ?????? ?????, ?? ?? ???? ??? (??????? ?????????? ???????? ???? ?? ????, ?????, ?????, ?? ?????? ?? ??????).
????? ? ?? ?. ??????? ??????? ?? ???? ? ??????????? �This is not an Exadata presentation�, ????? ???? ?????????? ? ????? ????????????. ??????? ?????????? database ????? ???? ?????? ?? ????????? ?? Exadata.
??? ????? ??????? ?? ????? ???????, ??? ?????? ???????. ??????? ???????? ???? ???????? ??? ?? ????????? Active Data Guard ?? ?????? ?? Peoplesoft, Hyperion ? OBIEE. ????? applicatoion-specific. ?????? ??????, ?????, ??????? ??-????????? ??????? ? ?????? ??????. ???????? ????????? ?? ??? ?? ??? ?? ????? performance tab-? ?? Enterprise Manager ????? ADG ????? ?? ????????? ??? ??????? ????? ?????? (???? ????? ??????? ?? ASH), ????? ????? ???? ??????? ?? Primary ?????? � ??? ?????? ? dba_hist_*. ????? ??????? ???????? ??, ?? ?? ?????? ???? ???? auditing � ???? ???? ???? ?? ????. ???? ?? ??????? logon triggers ?, ????? ???, ????????????? ?????????????? ?? ????????? ??????. ?????? ???? ? ???????, ??? ?????? ?? ?? ?????. ? ????? ???????? ?????????, ??? ?? ?? ?? ?????????.

???? ???? ?????? ?? ???????? ?? How Oracle GoldenGate Breaks Scalability Barriers at Western Union. ???? ???? � ? ??????? ?????????? ? ??????????? ?? active/active ?? ?????? ??????. ??????? ???? ????????? ????????? ????. ?, ????? release ????? ???????, major release ????? ????? � ?????? ???? ??? downtime ???????????? ?? Golden Gate.

?????? ????? ??????? ? ?? ??????? ??? ???? ????? ????? – Understanding Oracle RAC Internals. ?????? ??????, ??????? ???? ??????????? � ?? ????????? ???-???? ????? internals. ??-????? ???????? ?? CRS/HAS ???? ????. ?? ???? ?? ??????????? ????? ????. ?, ? ?????????, ????? ???? ?????? ??? ? 11.2.0.2. ?????? 11.2.0.1. ???????? ???? node fencing (??????????) ?? ????????????? node eviction, ?.?. ?? ?????????? ????, ? ?? ?????? ?? ?????????? ???? CRS. ?? ???? ??, ??? ?????? ???? ???? PSOT-? ?? ? 10-15 ??????. ?????????? ??????.

? ???? ???? � 2 ???? ?????. ???? ???? ?????, ?? ??????? ????. ?????? ???? ???? ??? keynote ? ?????? ?????? ?? ?????? ????. ?, ?? ??? ?? ????? ?? ?? ??????? ?? ?? ??????. ???????? ??????? ?????? ?? ????? ??????? ????????? ????. ????, ????? ????? ???????? iPad. ? ??? ???????, ?? ?? ??????? ?? ? ???????? � ??? ??, ???? ???? ? ??????. ??? ?????? ?? ???????? ??????.

??????? ????? ?????? ?? ????? ?? Accenture ? ?????????? ? ? ???? ????? ????????. ????? ?? ??????? ??? ????? ? ?????? ?? ?????????? ?? ???? ????? – So You Think You Know Everything About Oracle Partitioning? ? ?? ???????? ?? ? ????????? ?? ??????, ??? ????? ? ????????? ?????? ?? ????? ?? ????? ?????? ????? ???????. ??????? ? ???? ??? ?? Oracle. ??????? ??, ?? ??? exchange partition ???????? ?? ????? ??????? ?????? ?? ?? ? ??????? ??? ? ????, ?? ???? ?? ?? ? ???????? ?????? ?? ?? ? ????? ???????, ??? ??? ?? ??????????.

?? ??????. ??????? ??????? ?? ???? ??? ? ??????? ??????? ?????? ???. ????? ? ?????? �?????�, ????? ???????? ???? ????? ?? ??????? ? ???-??? ????? ? ????? ?????. ???? ?? ?? ??????? ????????? ?? ????, ?? ?? ?????? ????????? ? ????. ?????? ???? ???? ??? ? ????? ???? ?? ????????. ??…

???????

Oracle, ????? 1 Response »

окт 052011

???? ??? ????? ??-?????

????? ?? ??? ?????? ??? ? ???????? ?? ??? ??????. ??, ?????? ? ???? ??????? ?????, ?? ??? ??? ??? ? ???????? ?????. ??? ? ??????? ?? ???????? � ?? ???? ???? ????? ??????, ?? ?????. ?? ???? ??? ????, ????? ? ?????. ? ??????? ??????.

???????? ??? ????????? ?????? � ??????, ????????? ?? ?????, ????????????? ???????. ????????? ????? ???? ?? ???? ???????? ???????, ????? ?? ???? ?? ???????? ?????. ???????, ???? ??? ?? ???????? ??? ????, ? ?? ?? ???? ????? ?? ???? (? ???? �????????�).

?? ???? ??? ?? ??????? ?? 2-3 ?????? ?? ????. ?? ?? ??????? ? ????? ?? ????????? ?????? Exhibition hall � ?? ???? ?????, ??????, ???????? ???????. ?????????? ?? ????? ?????????? ?????, ???? ??????? ?????? ??????, ????? ?? ???????. ???????? ?? ????? ????? ?? ?????????? ???-??????????? (?? 3 ?? ????). ? ????? ??????? ?? ?????.

?? ???? ????? ?? ???????? ?????????, ?? ????? ???? ????. ? ?? ?? ????????? ???? ????? ? 3 ??????? ?????? (?? 20-30 ?????), ??????????? ??????. ??, ?????? ?? ??…

? ????? ???? ???? ?? ???????

?????? ?? Java one. ?? ?? ?????? ??? ?? Moscone. ????????? ?? ??? ?? ????? ???? ???????? ???? ?? ??? ??????? ???? OOW? Marquee sponsor, Diamond sponsors, Premier sponsors, Elite sponsor, Grande sponsors, Platinum sponsors, Golden sponsors, Silver sponsor, Bronze sponsors, Signature sponsors, Media sponsors � 11 ????.

????? ???? ???????? ???? ? ?????? ?? Christian Antognini: Challenges and Changes in the Oracle Database 11g Query Optimizer. ????? ???? ?????? (????? ?? ???? ? ?? ???????? ?????, ????? ? ???????). ?? ??????, ?? ? 11.2 ?????????? ?????????? ?? ??? ????????, ?????? ?? ?? ????? ??? 9842771. ? ????? ????????? ???? � ???????? ??? ?????? ?? ??????? ??????, ???? ?? ???????? ???????, ?????? ?? ?? ????????? ???? invisible. ???? ???????????? ???? ?? ?? ????????. ??? ?????? ????? ??, ???? 2-3 ??? ??? ??????? (??? ?????), ???? ???????? ?? ?? ????????. ? ????? ??, ???? ????? ?? ????. ????? ???? ???? ?????? ?? ??????? ?? IO. ??, ????! ???? ????? ?????? ??????? ?? ???????? ?? ?? (? ?? ?? ????????????) ?? ???????? ?? foreign key, ???? ?????? ? invisible.
? ????? ???????????? ????, ??? ?? ????? ?? ?? ????.

???? ???? ?????? ?? Performance of Oracle Database 11g Release 2 Flash Cache with Solid-State Disks. ?????? ??????, ???????? ?? ?? ???? ?????? ?????????? ???????. ??? ??? ?????? ?? ?? ???????? SSD ?? Oracle � ??? ???? ?????????? ?? buffer cache (??? ???? ? 11.2 ? ???? ?? Solaris ? OEL � ???????????? ?? RHEL ???? ?? ?? ???????); ??? ?? ????? ??????? ?? SSD ? ?? ?? ????? ????? ????? ??????. ???? ???? ???????? ?????? ?? DELLL, ????? ???? ???? ????????? ?????? ?? ??????? ?? ????. ?? ????????? ???? ?????????????, ?????? ??????? ?????? ????????. ???? ?? ????????? ????…

????? ?? ???? ??????????? ?????????? ?? ?????. ??????? (? ?????? ? ??????), ??????? ??????? (? ?????? ???????? ????, ????? ? ????????) ? ?????????. ??? ????????? ???????.

????? ????? ?? ??? ???? ?????, ???????? ?? ??????: Oracle Database 11g Release 2 and Oracle GoldenGate: Best Practices at Banka of America. ??????? ????. ??? Golden Gate ???? ????? ?? ????????. ?????? ?? ?????????? downtime-? ?? ????? ?? release (?????? ?? ????? ????? ????? � 6 ?? 9 ???? ???????!). ? ???? ? ??? database upgrade, platform/hardware change ? ?????, ??? ???? ?? ?? ?? ???????? � ?? ?? ? ???????? ?? ????? ???? Golden Gate. ????? ?????? ?????? ?? ??? ?????? ??????? ?? ????? (???? ???? ???????), ?? Golden gate ???? ???????? ? ??????? ?????????? ?? ???? ?? ??????? ??????? update-?, ?? ??????? ?? streams/logical standby.
? ?????? ??????, ??? ????? ?????? ?? Bank of America, ?????? ? ??? ??? ?? ?????????.

???? ???? ?? ???????? ?? ??????????? ???? � ??????? ???? ? ????????? ?? ??? ?? ??

????? ?? ??????????? ?? ???? ???????, ???? ? ???? ?? ?? ???????. ?? ??????? ? ??????, ???? Blackberry Play ? ???-???? iPad2 (????? ????? ????????), Apple TV (EMC2) ?? ??? ?? ??????????? ? ??????????. ???? ???? ?? ???????? ???? ????? ?????????… ? ????? ?? ?? ????????. ?? ????? ?? ?? ??????? ?????? ? 11g Data Dictionary ?? TUSC, ????? ? ????? ???????. ????? ?? ????????? ?? ???? ?.???. database appliance ? ?? ?????????? ???? ??????? ?? ???????????. ?????? ???????, ??? ??? ???????, ?? ?? ????? ???????? ?? ?? ????????? ? exadata. ??? 12 TB raw disk storage, ????? ?? ???????? ???????????? ? ASM ????? ? ?????? ?????? � ????? 4 TB. ? ????? ?? ?? ?????????, ?? ??? ??? ?? ? ?????, ???? ?????????? ?????????? � ?????? ??? ?????? ? ????? ???? ? ?????? ???? ?????, ??? ???????????? ?? ???? ???? ?? ?? ??????? ?????? � ?? ???? ??? ?????. ? ??? ???????? ?? ?????? �????�, ?? ?? ??????? ????????? 4 TB ?? 60% flash recovery area ? 40% data. ????? ?? ???????? 12 ????????? ??????????? ? 1.6. ????, ???? ?? ??? ?????? ????? ?? ????? ??!
????? ??????????? ??, ?? ??? 4 SSD ????? ?? 72 GB , ????? ?? ????? ? ??????? ????? REDO, ?????? ?????? ???????? � ????? 96 GB. ??? ? ????? ?? redo, ??? ????? ?? temp. ? ?? ???? ?? ?? ?? ??????????????? ? normal redundancy � ?????? unsupported.
? ????? ?????? ??? ???? ?????? ??? ???????????! ??????? ????? ????????? ?????… ??, ???? ?????????, ???? ?? ???? (?? ???? ??????, ???? ? ?? ??? � ????? ?? ????????? ??? ?? 2 e-sata ????????? ???????? ? ???? ?????? ?? ?????? ?????).
???? ????????? ???? ???? ?? FusionIO. ??? ?????? ???????, ?? ?????? flash ????? ?? NAND ??????. ??????? ?? (?????????) ? ???? PCI-E ?????, ?? ????? ????? 1.8 TB. ???????, ?? ???? ????? ?? 320 GB ?? 10 TB (?? ???? ?????!!!). ?? ????????? ?? ?????? ???? ????? ?? ???????. ????? ?? ?? ??????? ?? ?? ?????? ? ??????? – ?????? ?? ???? ???????.

????? ?????? ?? ?????? ???? ????? ????? DBA ?? Cisco, ????? ??????? ?? ???????? ????? ? Oracle RAT (Oracle Real Application Testing Meets the Real World). ??????? ??? ?? ??????? ? ???? EBS, ????? ?? ???????, ???? ?????? ?? ?????? ?? RAC ??????? ?? 3 HP Integrity Superdome ??? 128 core-? ?? ?????, 512 GB RAM ? 8000+ ?????. ?????? ?? ????? ?? ??-?????? ???????, ??? ??????, ? ?? ????????? RAC ?? ????? ??-?????????? 12 ??????. ??????? ??????? ? RAT-?, ??????? ????.

?? ???????? ?????? ?? Making the Most of Solid-State Disk in Oracle Database 11g. ????? ??-??????? ?? ?????????? ??????? ?? Dell ?? ????????. ?????? ???????? ?? ???????, ???????, ???????, ?????. ???-???????????, ????? ????, ? ?? ???? ??????? ???????? ?? ?? ?????? online redo logs ?? SSD. ?????? ??????? ?????, ????? ???. ????? ?? TEMP ?????????? ? ??????, ??????? ??? ????? ????? multi-pass sorts (????? ????, ?? ? ????? reporting). ? ??? ?? ?????? ? ?????? ??, ??????? ??????? � ????? ??????????????????, ???? ? ??????. ?????? ????-???? ? ??? ?????? ?????? ??????? ?? ???????? ?? SSD � flash cache, ????? ??????????? ?? buffer cache .

?? ???? ???? ?????? ?? ???????? ????? ?? Oracle, ????? ??????? ??? ???? ??-????? ?? ?????? (?.?. ? 30 ??/? ??? ????? ?? 10 ??/?).

�????????� ? ??????? ??????, ?? ?? ?? ?????? ? ?????????? ? Moscone West, ???? ?? ?? ?? ??????? ?? ??????. ??? ?? ???? – ????? ?? ?? ??????? ?????? ?? ?????? ????? ? ?? ????????…

? ?? ????, ??? ????? „??????????“
- ??? ? ????? ????? (??? ???????? ???? ?? ?????????? ? ?????????, ??? ???? ? ?????????), ???????? ?????? ???? – ? ????? ??? ?????. ????? ? ????? ???????, ??? ?? ?? ?????/???????? ???? ???
- ?????? ?? ?? ??????????? ?? ????? ?? ?????? – ? ?????????? ?????? ??????, ? ????????, ?????????. ????? ??, ????? ??????? ? ?????
- ???? ????? ??????? – ?? ?? ????? ?????? ???????. ????? ????? ?????? ???????, ?? ??????? ???????. ? ???? ?? ????????, ?????? ??. ??? ?? ????? ?? ????? ???????, ?????? ? ??? ???? ?? ???? ?? ?? ???? ??????? ?? ???? – ???? ?? ???????. ? ????? ????? ??? ???????? ????? ???? ?? ??????

??????????

Oracle, Personal, ????? 1 Response »

окт 042011

??????? ?? ???????.

???? ?? ?????? ?? ?? ???? – ??????? ???????? ??? ???? ??-?????. ?? ? ????? ????? ????, ??????? ?? 12000 ?? ?? ????. ?? ???? ?? ?????, ??? ? ??????? ?? ?????? ????? – ???????, ????????, ? ??? ???????? ???? – ?????, ?? ?????.

???? ?? ???? ????? ???. ??? ???? ?? ????????? ????? ??-??????????: ??? ???? ???? „????“, ????? ??? ???? ????????? ????? ??????? ????. ????? ?????? ??????? ? ?????? ?????? ?? ?????? (???????? ??????? ??????). ???? ??????? ?? ????????/???????? ?? ?????? – ????? ?? ? ?’?? ?.

(??? ????????? ?????? ?? ??????: ???? ???????? ????? ????)

?????? continental breakfast ? ????? ?????? ?? ???? ???. ??????? ?? ????? ? ??????? ??? ??????? (???? ?? ??????????? Moscone). ?? ???? ?? ??? ??????? ??????? ?????, ?? ???????? ?? ?? ??????? ? ???????. ???????? ? ???? ?????? ??? 98 (!!!) ????????? ?????.

?? ???? ?????? ???????? ?? ????????? ??????. ???? ?? ??????, ? ????? ? ???????? ??? ????????? ?? ?.???. cable cars, ??? ???????, ????? ???????? ??????? ???????. ???? ? ?? ?? ??? ???????? ??? ???????. ? ?? ??????? ????? – ????????? ?? ???? ???????????? ?????????, „???????“ ????? ? ???????? ?? ??????? ?? ??????? ??? ????????? ?????. ??????????? ? ???????, ?? ???? ???????? ???????? ????? ????? ?????? ?????????:

???????? ? „Think Outside Your Interconnect“ When Optimizing Your Oracle RAC Environment. ????? ?? ????? ??????, ????? ????? ???????? ??????????? ?? Result cache – ??? ??????? ?? ? ??? ?? ?????????? ???? ?????. ??? ????? ?? ????, ??? ????? ???? (????, ?? ? ????????? ??? 100 ????????, ???-??????? ? 12 ????), ??? ??? ????? ???????? ? ????????? ???????. ??????? ???? ?? ????, ???????, ??? ? ????? ???????? ????????.

???? ???? ?????? ?? Successful Oracle Database 10.2 to 11.2 Migration with Oracle RAT – ????????? ????? ?? ????? ??????-? ?? CERN ? Product Manager Director-? ?? RAT ? Oracle (RAT -Real Application Testing, a.k.a. capture/replay). ??????? ?? ???? ????????? ??????? ?? ??? ???? ??-????? ?? ???????, ?? ?? ?? – ????? ???????? ? ??? ??-????? ????…. ???????? ?????? (Katarzyna Dziedziniewicz-Wojcik). ?, ??, ? ??? ???????? – ????????? ?? Oracle ?? ????? Prabhaker Gongloor. ????? ?????? ?? ?????? ?????????. ????????? ????? ??????, ????? ??? ????? ????? 2 ??????, ??? ?? ??????? ?? ???? ?????. ???-????? ?? ????????, ?? ??? ??????? ?? ???? ??? ???????, ????? ????????? ????? ?? ?? ???????. ?? ????? ???? ?? ?? ?????, ??. ?? ?? ?? ??????????? ????? ?? ???????.

?????? ?? ??? ?? ????????? ??????? ?????? ???? ?? ??? ????? ???????? ?? ????, ?? ??? ???? ?? ???????????. ??? ????????????? ?? ????? ?????????, ?? ???? ?? ????? ??? (old scool, yea!). ?? ????, ?? ???? ????? ?????? ??????, ? ????? ??? ??????, ?? ???????? ???? ???? ? ?????? ?????, ?? ????? ??? ????? LUNCH. ??????????? ?? ???? ??????? ?????, ???? ?? ?????? ?????? ?? ?? ???????. ????? ? ? ?????-??????? ???? ???????, ??????? ???? ?????? ?????. ??? ????? ?? 2-3 ???? ????????, ?? ???? ?? ?????, ? ????? ??????? ? ???? ?. ?????? ??????? ?????? ?? ?? ?????? ?? 1000 ??????, ?? ???? ?????? ?? ??????? ????????????, ?! ??? ? ???????? ???????, ???????, ??????????? ???????? ? ???? ???? ???? ?????? ?? ????? ?? ???????. ????? ? ?????????? exibition halls ?? ??? ?? ?? – ??????????? NG:

? ???? ? ?????????? ?? ??-???????? ??????:

??? 5 ???????? ?????, ????? ??????? ?? Moscone West. ???? ? ?? ???? ??? ?????? ?????? ???.

???? ??. ???????? ????? ?? ????? Golden Gate. ????? ?????? GoldenGate: Customer Panel: Achieving Zero-Downtime Upgrades and Migrations – ????? ???????? ??????, ??? ???????? ?? ? ???????? ? ??????? ??? ?????. ?, ???? ??-?????? ???????. ???? ????? ???? ? ????? InterContinental – ???? InterContinental Ballroom B. ?? ?? ?? ????? ??? ???? Ballroom B ? ????? ?????, ????? ? ??? ????? ??-????? ? ??? ?? ??????? ?? PeopleSoft. ??? ?? ? ????, ????????? ? ? ????? – ?????? ???? ??? ????? ?? ?????? ? ????????. ???, ??

????? ?????? ??? ????????? ??????? ?? ???? ????????? ? Golden Gate: Active/Active ? Thomson-Reuters. ??????? ?? ????: our application is designed for active/active from the beginning, so we do not have conflicts. ?????????.

????????? ?? ??? ?? ????? ????? ???? ?? ?????? ???? ?????????? ?????:

???? ???? ?? ??????? ??? ????? Marriott Marquis ?? Deep Dive into Oracle GoldenGate 11g. ??? ?? ??????????, ?? ?? hands-on lab ?????? ?? ?? ??????? ?????????????? ??????? ?? ?????? ? ?? ?????? „?? ??? ? ???????, ?????? ?? ???????? ?? ?? ???????? ?????“. ????????? ??????? ?????? – ???????????? ?????? – ? ?????, ?? ???? ?? ?? ????. ??????? ????? ?? Moscone South, ?????? ?????? ?? ???????? ???? ?????? ?? 11g, ????? ?? ?????? ????? ????. ??????, ??????, ??? ???????? ???? ?????. ??? ???????? ?? ?????.

????? ??????. ??????? ??, ???????? ??????. ???????, ??? ?????, ???? ????? ???? ???????. ???? ???? ?? ????? ?? ????????? ??????? ???????? – ???????? ??????????? – ??? ???. ?? ???? ???? ??????? ??????? ?? ???????, ????? ???????? ?? ???????? ??????? ?? ?????????? ?? ????????. ?? ?????. ???? ? ???? ???? ??????? ?. ? ??????, ? ????.

?????????? ? ??????????? ????? ???? ?????, ???? ?? ???? ??????????. ? ???? ????????? ???????????. ?? ???????? ????? ?????? ? ?????? ?? ???.

??????? ???????!

P.S. ??????? Jonathan Lewis ? ?? ??????????? ?????. ????????? ? ?? ?????? ????????? ?????????! ?? ????????? ??? ???? ?????? ??? ???????

Older Entries

Master Yavor from Tryavna

??????? ?????

Upgrading to Oracle 11.2 – BGOUG’11

11g: no more „AUDIT … BY SESSION“

TM locks ???? upgrade ??? 11g

???????… ??????

… ? ???????

?????????

?????

???????

??????????

Languages

Архиви

Meta

Категории

oracle blogs