ORA-00001: violation of unique constraints (.) ORA-00017: Request session to set trace event ORA-00018: exceeds Max sessions ORA-00019: exceeds Max session licenses ORA-00020: exceeds Max processes () ORA-00021: Session is attached to some other
Sometimes it is necessary for oracle to terminate the current session. For example, if you want to perform a management operation, you need to terminate all non-Administrator sessions. The following describes how to terminate sess.
Sometimes it is
Sometimes it is necessary for Oracle to terminate the current session. For example, if you want to perform a management operation, you need to terminate all non-Administrator sessions. The following describes all aspects of session termination,
C # troubleshooting of Oracle Database Connection timeout Creation Time: 2007/08/09 Recently, I found a strange problem when using C # To operate Oracle databases. When there is a timeout limit for database sessions, even if the client reconnects to
Oracle Error Code Encyclopedia-the latest and most complete Oracle error code is helpful for finding Oracle database errors quickly
ORA-00001: Violation of UNIQUE constraint (.)
ORA-00017: Request session to set trace event
ORA-00018: Maximum
This article will introduce you to your experience. When using ipve, rac hang is suspended due to the mistaken killing process, next, I will analyze the cause and provide a reference for the solution.
If the customer feedback system hang is in place
Customer feedback system Hang live, can not be archived, we need urgent intervention analysisNode 1st logRedo cannot be archived, redo logs have been filled, and the database has been manually executing alter SYSTEM ARCHIVE log current, but the
Query and delete sessions in Oracle
Query and delete sessions in Oracle1. query the current session
SQL> select username, sid, serial # from v $ session where username is not null;Username sid serial #-------------------------------------------------
Query and delete of Oracle's next session1. Query the current sessionsql> Select username,sid,serial# from v$session where username are not null; USERNAME SID serial#------------------------------ ---------- ----------SYS 144 4HYL 146SCOTT 147HR 159-
Oracle Exception classification
Oracle predefined exception (that is, a defined inner exception)
Oracle Non-predefined exception (that is, undefined inner exception)
User-defined exceptions
Common pre-defined exceptionsThe
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.