发布时间:2013-04-23 17:20:10
In 10g, parallel execution in RAC instances is controlled with two initialization parameters: INSTANCE_GROUPS and PARALLEL_INSTANCE_GROUP. Both must be used together in 10g.INSTANCE_GROUPS can have multiple values but it is static; PARALLEL_INSTANCE_GROUP can be modified dynamically at the s.........【阅读全文】
发布时间:2013-04-23 17:14:19
ssh -X now says "Warning: untrusted X11 forwarding setup failed: xauth key data not generated"Technical details: ssh tried to run xauth generate to create a untrusted cookie for the session, which failed because the server isn't compiled with the XCSECURITY extension built-in.X11Forwarding does.........【阅读全文】
发布时间:2013-04-09 11:01:47
点击(此处)折叠或打开1. Enabling now.SQL> ALTER SYSTEM SET EVENTS '10442 trace name context forever, level 10';2. Disabling now.SQL> ALTER SYSTEM SET EVENTS '10442 trace name context off';.........【阅读全文】
发布时间:2013-03-13 18:39:03
create profile one_session limit sessions_per_user 1;alter user scott profile one_session; alter system set resource_limit=true;connect scott/tigerConnected.host sqlplus scott/tigerERROR:ORA-02391: exceed如果是RAC,则每个instance都会允许有一个session.......【阅读全文】
发布时间:2013-03-12 18:54:00
点击(此处)折叠或打开SQL> create profile one_session limit sessions_per_user 1;SQL> create user test identified by test;User created.SQL> grant connect,resource to test;Grant suc.........【阅读全文】