/* -- Handle deadlocks
View the current process or deadlock process and automatically kill the dead Process
Because it is intended for dead, if there is a deadlock process, you can only view the deadlock ProcessOf course, you can use Parameter Control to check only the deadlock process, whether there is a deadlock or not.
-- Producer build 2004.4 --*/
/* -- Call
* -- Process deadlocks to view the current process, or deadlocked process, and automatically kill the dead process because it is targeted to death. if there is a deadlock process, you can only view the deadlocked process, you can use parameter control to check only the deadlock process -- deadlock creation 2004.4 -- ** -- call example execp_lockinfo -- * createpr
Process
/*--Handle Deadlocks
View the current process, or the deadlock process, and automatically kill the process
Because it is dead, so if there is a deadlock process, only the deadlock process can be viewedOf course, you can control by parameter, whether or not deadlock, only check the view lock process
--Jiangjian 2004.4--*/
/*--Call Example
EXEC P_lockinfo--
How to view the permissions or roles of the current Login User in Oracle
View the role of the current user
SQL> select * from user_role_privs;
SQL> select * from session_privs
View the system and table-level permissions of the current
How do I see the current number of MySQL connections in real time?How to view the current number of MySQL connections in real time?1, view the details of all current connections:./mysqladmin-uadmin-p-h10.140.1.1processlist2, view
[Go] view the current IP address of ubuntu at a.m. on February 19 ,.
ifconfig eth0 |awk '/inet/ {split($2,x,":");print x[2]}':Network Query NIC address based on IP AddressArping IP AddressCheck the computer name based on the IP addressNmblookup-a ip AddressView current IP Addressifconfig eth0 |awk '/inet/ {split($2,x,":");print x[2]}'
Tags: how to view Oracle current session informationHow to view the current session information for OracleHow do I see the current number of connections to Oracle? Just use the following SQL statement to query it.#查看当前不为空的连接SELECT * FROM v$session where username are not null
Oracle View Current User informationFirst, view the current user information:1. View the current user-owned Role Permissions information: SELECT * from Role_sys_privs;2. View the detail
First, view the current user information:1. View the current user-owned Role Permissions information: SELECT * from Role_sys_privs;2. View the details of the current User: SELECT * from User_users;3.
Tags: group by connection useful NVL SSI sed from ACL Select--View the relationship between the user and the default table spaceSelect Username,default_tablespace from Dba_users;--View the tables that the current user can accessSELECT * from User_tables;--oracle Querying user tablesSELECT * from User_all_tables; --oracle Querying user viewsSELECT * from User_view
Label:To view the relationship between a user and a default table spaceSelect Username,default_tablespace from Dba_users;--View the tables that the current user can accessSELECT * from User_tables;--oracle Querying user tablesSELECT * from User_all_tables; --oracle Querying user viewsSELECT * from User_views;--Querying all functions and stored procedures:SELECT *
One, Linux under the memory View command free detailed:
You can use Free-m to view current memory usage in Linux, and the M parameter is displayed in megabytes, examples:
$ free-m Total used free shared buffers cached mem:1002 769 23 2 0 421-/+ buffers/cache:286 715 swap:1153 0 1153The first part mem line:
Total Memory: 1002MNumber of memory used has used: 769
InOracle DatabaseOperation, sometimes we need to view some information about the current user, including the information owned by the userRole PermissionsInformation, user tablespace, and user andDefault tablespaceThis article introduces the implementation methods of these operations. Next we will introduce them one by one.
-- View the role permissions of a user
4 ways to view your system's current logged-on user information under LinuxAs a system administrator, you can often (at some point) need to see which users in your system are active. Sometimes you even need to know what they are doing. This article summarizes 4 ways to view system user information (by number (ID)).1. Use the W command to
How can I view the current auto-increment values of database tables?
Because the auto-increment field of the database table is unique, after a record is deleted, the auto-increment value of the record actually exists, therefore, if you want to query the current starting value of the auto-increment field of the current
Some time ago, Insus.net shared a "Activate Current View menu highlighting" http://www.cnblogs.com/insus/p/5287093.html This is just the same controller menu.Share one today, with different controllers, presenting a site menu-oriented. Find a website: http://www.engtek.com/services.html, this site in addition to the home page, the other sub-pages have a menu-oriented:3 tags, it will vary according to the su
reprinted from: http://www.cnblogs.com/gaojun/archive/2013/10/24/3385885.htmlFirst, view and manage the currently logged in user
1. Use the W command to view the process information that the logged-on user is using,and the W command to display the names of the users who have logged in to the system and what they are doing. The information used by this command originates from the/var/run/utmp file.
Oracle views the role permissions of the current user 1. view the role permissions of the current user www.2cto.com select * from role_sys_privs; 2. View All users: select * from all_users; 3. view the details of the current user:
MySQL View details of all current connections:Mysqladmin-u root-p ProcesslistMySQL view current number of connections (threads is the number of connections)Mysqladmin-u root-p Statusuptime:1047464 threads:22 questions:1494780 Slow queries:0 opens:31357 Flush tables:1 Open tables:1981 Queri Es per second avg:1.427MySQL
Close a view usually hides the view (hide. View the Code directly:
1. Disable the current (active) view
Public class closeaction extends action
{
Public closeaction ()
{
Settext ("close ");
Setactiondefinitionid ("org. Eclipse. UI. file. Close"); // we recommend that you se
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.