Database Administrator

View and remove blocked sessions in Oracle For more information about how to view and remove Oracle blocking sessions, here we will only talk about the operation steps, not the principles. Session 1 update object ticket not submitted When

Solutions for full ORA-00257 archiving logsBackground: In the previous blog, we mentioned how to enable or disable the ARCHIVELOG mode () of Oracle. After I set the database to archive mode, I tried to connect to the database again the next day,

Oracle static parameter file Oracle static parameter file) A static parameter file is a text file. The Oralce instance reads the content of this file at startup, So if you modify the content of this file, you must restart the Oracle instance to

Troubleshooting of errors in PL/SQL In PL/SQL, error handling is an important part, just like the exception handling in the Write Program. The normal process implementation in the program may not be very complicated, but it takes more than half of

Some RAC services are resolved in the UNKOWN state. After restarting the RAC server, we found that: Rac1-> crs_stat-tName Type Target State Host------------------------------------------------------------Ora... CRM. cs application online unknown rac1

ORA-00904: "T1". "AREA_ID": Invalid identifier, ora-00904area_id 1. Error description ORA-00904: "T1". "AREA_ID": Invalid identifier 00904. 00000-"% s: invalid identifier" * Cause * Action An error occurred while listing 45 columns and 8

ORACLE Database FAQ summary, oracle FAQ Summary Prompt when submitting the transaction (solution for locking the database by a user) Select object_id, session_id, locked_mode from v $ locked_object; Select t2.username, t2.sid, t2.serial #, t2.logon

Archive logs and oracle archive logs RACSqlplus/as sysdbaSQL> alter system set cluster_database = false scope = spfile; -- in node1SQL> create pfile = '/opt/oracle/pfile_20120301' from spfile; -- in node1SQL> alter system set log_archive_format =

SQL sending email, SQL SQL version: SQL Server 2008 R2 Reference resources: Http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/ Http://msdn.microsoft.com/zh-tw/library/ms190307 (v =

Preliminary specifications for MySQL Database Design: V1.0 and mysqlv1.0   Database Design specifications:1. Table design specifications 1.1 Table Design A) The table name and column name must be annotated. B) The name should contain meaningful

Oracle exports the table as a txt file, oracletxt This article lists several methods to export data from an oracle table to a txt file. Currently, only three methods are listed. If better methods are found later, they will be added continuously.   1.

Database architecture components and architecture Components 1. Oracle's important position and extensive application in the company. 2. In the Oracle overview, the role of root is emphasized, that is, the overall Oracle architecture. If you have

HIVE 0.11 and hive0.11bugHIVE 0.11 bugTwice {group by} bug https://issues.apache.org/jira/browse/HIVE-5149 SELECT key, COUNT (*) FROM (SELECT key, value, COUNT (*) FROM src group by key, value) aGROUP BY key; It is characterized by two group by

Connect to a PDB of Oracle12c, pdboracle12cStory about CDB and PDB Oracle12c has a new feature and definition of CDB and PDB. if you first use 12c you will get confused like me. so that is necessary to know some basic definitions before you start.

How can I query my wife's opening records? QQ1622863529, wife qq1622863529Query serviceConsult QQ: 1622863529 to query QQ chat records, chat content queries, QQ audio queries, video content queries, delete QQ chat records, modify QQ chat records,

TNS-01251: Cannot set trace/log directory under ADR, tns-01251adr 11204 RAC environment error TNS-01251: Cannot set trace/log directory under ADR   LSNRCTL> set current_listener listenerCurrent Listener is listenerLSNRCTL> set current_listener

MySQL trigger: differentiation between after and before, mysqltriggerAfter: add, delete, modify, and then trigger the data. The triggered statement is later than the added, deleted, and modified statement, which cannot affect the previous add,

Sets the MySQL transaction isolation level and mysql transaction level.Select @ tx_isolation; // view isolation levelSet transaction isolation level read uncommitted; // you can specify the read uncommitted level.Start transaction; // open the

In linux, back up the MySQL database and delete the Backup Data seven days ago. #! /Bin/bash # backup database hz jshuabo sdhuaboname =$ (date + % Y % m % d) /alidata/server/mysql-5.1.73/bin/mysqldump-u root-p123456 hz>/root/sqlBackup/hz. $ name.

Trace log, traceDisable ORACLE trace LoggingAlter system set trace_enabled = falseSelect * from v $ parameter where NAME like '% trace % ';How to disable the oracle listenerr trace log First, go to the listener:LsnrctlView log status:Show