NAV: SLTechnology News&Howtos > Database >

• 

  Oracle Series: (32) Summary

  (01) what are the components of a complete PLSQL? [declare] / begin/ [exception] / end;/ (02) pename emp.ename%type and emp_rec emp%rowtype

  2022-06-01 06:16:44 Views: 273
• 

  Oracle 12C RAC error ORA-20001: Statistics Advisor

  Recently, there have been a lot of problems in a certain oracle 12C RAC database. We have just solved the ora-07445 problem. Some deal with new problems, and the main errors are as follows: alert log error message: ORA-12012: error on auto ex

  2022-06-01 06:16:43 Views: 214
• 

  PostgreSQL Source Code interpretation (247)-HTAB dynamic extension Diagram # 1

  This section provides a brief introduction to the dynamic extension of HTAB in PostgreSQL, which is part 1. 1. Data structure / * * Top control structure for a hashtable-in a share

  2022-06-01 06:16:38 Views: 213
• 

  Library cache lock and pin Simulation of 1OG Database combined with hanganalyze location and systemdump location

  Session 1:SQL > select sid from v$mystat where rownum=1;SID-148SQL > create or replace proced

  2022-06-01 06:16:37 Views: 281
• 

  Recycling wasted segment space using on-line contraction (ONLINE SEGMENT SHRINK)

  ONLINE TABLE REDEFINITION (online redefinition table) (for details, see: "perform an online redefinition table using DBMS_REDEFINITION packages (ONLINE TABLE REDEFINITION)": http

  2022-06-01 06:16:36 Views: 267
• 

  The solution of line wrapping in SQL Server export Excel

  Fields with newline characters are enclosed in double quotes before and after the field name in the Select statement. The Target field has a newline character, so put double quotation marks before and after it. Select'"'+ Target+'" 'from wms

  2022-06-01 06:16:36 Views: 261
• 

  Detailed steps to configure PLSQL Developer

  As an excellent development management tool of oracle, PL/SQL Developer can bring great convenience in daily work. It is really a great help for us to make good use of some tools. This article will talk about PL/SQL Developer in detail.

  2022-06-01 06:16:31 Views: 205
• 

  Mysql 5.6.46 installation to winserver2012 (x64) encountered MSVCR100.dll is missing

  After downloading the mysql5.6.46 x64 zip package on the official website, there is no error in MSCVR100.dll when you are ready to register for the system service. Is the reason why the system lacks VC++. Note: msvcp, msvcr, vcomp140.dll

  2022-06-01 06:16:30 Views: 208
• 

  PostgreSQL DBA (27)-MVCC#7 (avoid long transactions)

  For Update/Delete operations, PostgreSQL's MVCC mechanism still retains previous versions of data, which will be erased during VACUUM. However, if there are active transactions that precede VACUUM operations when performing VACUUM, assume that these

  2022-06-01 06:16:30 Views: 206
• 

  Scnhealthcheck.sql script

  Installing, Executing and Interpreting output from the "scnhealthcheck.sql" script (document ID 1393363.1)

  2022-06-01 06:16:30 Views: 238
• 

  Oracle data file collection

  -- Analog data is inserted into DECLAREI NUMBER (10); BEGINFOR I IN 1. 50000 LOOPINSERT INTO TEST_TAB VALUES (I, 'TESTSTRING)

  2022-06-01 06:16:30 Views: 226
• 

  # insertion buffering of MySQL# INNODB storage engine

  In the insert operation of mysql, the page that needs insert include clustered index page, unique index page, and non-unique index page. Normally, for the ins of a clustered index (self-incrementing as a primary key)

  2022-06-01 06:16:29 Views: 297
• 

  Real-world SQL optimization case 2 _ access path optimization

  1. Problem description generated database AWR report: August 22nd 10:00 to 18ghu0000TOP1 SQL: 3g5996z6awjux, run times: 217677 times, each execution time 7.38s, occupy total database resources (elaps

  2022-06-01 06:16:29 Views: 251
• 

  Change and immutability: exceptions to Undo Construction Conformance reads

  The carnival listened to a theme of Enmo College: "recreating ORA-01555 on Oracle 12c Undo data Management". Teacher Lu Xinghao introduced the concept of UNDO and the emergence of ORA-1555, as well as the UNDO of Oracle since 12c.

  2022-06-01 06:16:27 Views: 235
• 

  Cursors and SQL for Oracle performance Optimization

  First, we need to talk about the concept of cursors. From the Oracle database administrator's point of view, cursors are a general term for executable objects stored in the library cache. The SQL statement is stored in the library cache, which is a cursor. In addition to it, there is storage for Oracle.

  2022-06-01 06:16:25 Views: 300
• 

  Causes and Solutions of TNS-12535 TNS-00505 reported in 11gr2 alert Log

  11GR2 RAC was newly installed in front of me. One day, when I was doing patrol inspection, I found the following error in alert log: Fatal NI connect error 12170.VERSION INFORMATION:TNS for So

  2022-06-01 06:16:25 Views: 230
• 

  MySQL stored procedure explains mysql stored procedure in detail

  Detailed explanation of mysql stored procedure 1. A brief introduction to stored procedures SQL statements, which are commonly used to operate the database, need to be compiled and then executed, and stored procedures (Stored Procedure) are a set of SQL statements compiled in order to accomplish specific functions.

  2022-06-01 06:16:24 Views: 297
• 

  Mysqldumper multithreaded export and import data

  Tar-xvf mydumper-0.9.1.tar.gzcd mydumper-0.9.1cmake. Makemake installmydumper-- socket=/home/mysql/

  2022-06-01 06:16:24 Views: 214
• 

  ORA-39142: incompatible version number 5.1 in dump file

  Error: ORA-39142: incompatible version number 5.1 in dump file.I did get this error while I was impo

  2022-06-01 06:16:24 Views: 275
• 

  DoDBA tools, a new real-time performance monitoring tool for MySQL

  Http://mp.weixin.qq.com/s?__biz=MjM5NzAzMTY4NQ==&mid=2653929717&idx=1&sn=0774d10e4e2271334dd7fd1c4c7

  2022-06-01 06:16:24 Views: 207