grant drop database link to user in oracle

0Job_queue_processes Integer 10Log_archive_max_processes Integer 2Processes integer 450Sql>Concurrency refers to active,i seeSql> Select COUNT (*) from V$session #连接数Sql> Select Count (*) from v$session where status= ' ACTIVE ' #并发连接数Sql> Show parameter Processes #最大连接Sql> alter system SET processes = value scope = spfile; Restart database #修改连接Unix 1 user session corresponds to an operating system process

is known as the above 10.69.1.11 IP attempt multiple failed login caused by the lock 　　Note: The normal database defaults to locking the user after 10 unsuccessful attempts 1, view the value of failed_login_attempts SELECT * FROM Dba_profiles 2, modified to 30 times Alter profile default limit failed_login_attempts 30; 3. Change to unlimited times (for security reasons, not rec

Tags: using SP data on BS AD as management databaseThe database has been installed for a long time, but it is not used locally, this is often happening, now how to solve this matter.First Enter PlusCmd-sqlplus commandThen in the linked database will be helpless to find you entered the user name know how to writecan query under General

If you manage some application projects under the Oracle database that have a large number of modifications to delete operations, data indexing needs to be periodically rebuilt. It can not only improve query performance, but also increase the amount of free space in index table space. After a large number of records were deleted in Oracle, the block space occup

Tags: Oracle client IPBy creating a trigger to log user login, audit the logged-in user, record the login user, host, system users and IP address:1. Create a table in SYS mode that records the details of the client's login to the database server.createtablelogin_history ( u

Tags: Oracle alt img Specifies session HTTP using 9.png technologyOpen Toad,1, menu bar session->new Connection .... Open the following window:2, after entry, menu Datebaseàsechema brower ... Find Table Space tabAfter opening, the following interface is displayed:Then switch to another tab: Date Feiles ()After a bit of opening:Click here to open:After specifying, click OKThe next step is to create the user:This allows you to use the

Tags: remove user including path XXX login Constrain GPO delete Table tabLog on as a system user to find the user who needs to be deleted:--Find UsersSELECT * from dba_users;--Find the path to the workspaceSELECT * from dba_data_files;--Delete UserDrop user name cascade;--Delete Table spaceDrop tablespace tablespace na