NAV: SLTechnology News&Howtos > Database >

• 

  When installing 11.2.0.1 on the Centos 6.3 x64 platform, Hang remained unchanged to 65%.

  When installing Oracle grid with a native vmware virtual machine, the system always stops when it is installed to 65%, and then check the log and find that the log does not respond: [root@linux01 app] # tail-f / app/oraIn

  2022-06-01 07:59:40 Views: 289
• 

  ORACLE 11G disable SQL TUNING ADVISOR

  There is a set of 11g database alert.log error ORA-16957: SQL Analyze time limit interrupt in production. Query MOS related documents Troubleshooting: ORA-169

  2022-06-01 07:59:39 Views: 272
• 

  Mysql master-slave cluster configuration

  First edit the master configuration: vim / etc/my.cnf (plus the red box). # server id section: each is distinguished by a unique id, which can be distinguished by the last three digits of the server ip. # binary log: log. # state

  2022-06-01 07:59:19 Views: 218
• 

  Construction and use of tools for Anemometer graphical display of MySQL slow logs

  Introduction: Anemometer is a tool for graphically displaying MySQL slow logs. Combined with pt-query-digest,Anemometer, it can easily help you analyze slow query logs, so that you can easily find out which SQL needs to optimize Thi.

  2022-06-01 07:58:52 Views: 251
• 

  Execute root.sh error report: CLSRSC-196: ACFS d

  Oracle 19c has been released for almost a year, it has been installed on AIX and Linux a lot, and installation methods have emerged one after another. the most commonly used is graphical, which can avoid problems that can not be found by silent installation. Today, I helped a friend install oracle 19c

  2022-06-01 07:58:49 Views: 301
• 

  The meaning and difference between DML and DDL-be sure to understand

  1. The meaning of DML and DDL: 1. DML (Data Manipulation Language) data manipulation language-the basic operation of the database, and the operations such as dealing with data in SQL are collectively referred to as data manipulation language. In short, it realizes the basic addition, deletion, modification and query.

  2022-06-01 07:58:37 Views: 269
• 

  The study of JDBC

  A short day ago spent a long time learning MySQL, Oracle database, now it is time to learn JDBC, the following do some of their own learning notes. The full name of JDBC is Java Data Base Connectivity (java number)

  2022-06-01 07:58:37 Views: 293
• 

  Skills that programmers should have with 3 years of work experience

  Every programmer, or every worker, should have his own career plan. If you see that the friends here do not have their own career plan, I hope you can think about your future. I have this article because I have an appointment with my colleagues, and LZ himself also likes to sum up after he has done something.

  2022-06-01 07:58:36 Views: 241
• 

  Use expdp/impdp to transport tablespaces

  -Source database prodSQL > select name from vs. tablespace

  2022-06-01 07:58:36 Views: 300
• 

  Summary of beginner Learning for SQL Server Database (3)

  4. Views, indexes and transaction views are virtual tables or query tables derived from one or more data tables (basic tables). They are important mechanisms for relational database systems to provide users with multiple perspectives to observe the data in the database. The benefits of the view: it can simplify the operation of the user; the view can provide security to confidential data

  2022-06-01 07:58:36 Views: 293
• 

  NBU backup oracle full script comments

  Root@gzwgnbu1 # more hotspot databasepacking backup.shroudinUnipletBingray sh# $Header: hot_database_backup.sh,v 1.3 2010 Greater 08 /

  2022-06-01 07:58:36 Views: 246
• 

  Operation of msyql data table

  MySQL add columns, modify columns, delete columns ALTER TABLE: add, modify, delete table columns, constraints and other table definitions. View table structure: desc table name; modify table name: alter table table name rename to new table name; add column

  2022-06-01 07:58:35 Views: 225
• 

  Delete oracle10g completely

  Http://wenku.baidu.com/link?url=Z5VuyGVMAYL5u2xJpVOaAHdRhEHrj-j50orYnTDFreTTNjLEBH9U34jq14A46e7vtukT

  2022-06-01 07:58:35 Views: 301
• 

  Pt-ioprofile

  Pt-ioprofile is a tool belonging to percona-toolkit. It uses strace and lsof to check the IO of the monitoring process and print table files and active IO. By default, it monitors the mysqld process for 30 seconds warning and risk: pt-iopr.

  2022-06-01 07:58:35 Views: 244
• 

  Summary of Oracle 11g R2 log structure

  Starting from 11g, Oracle has made great adjustments to the log structure, and the log storage directory and storage format have changed. The following summarizes the storage directories and directory knots of Oracle Database, Oracle snooping, ASM and Oracle GI logs

  2022-06-01 07:58:35 Views: 260
• 

  Write down the troubleshooting of garbled Chinese characters in mysql

  Today, it is normal to develop programs that respond differently to insert data into one library, while it is garbled to insert data into another library. The first reaction is that the two databases have different configurations for character sets. View the parameter in the two libraries: show variables like "% char

  2022-06-01 07:58:34 Views: 233
• 

  Protocol adapter error occurred in sqlplus

  Environment and version: OS:win10-64-bit DatabaseServer:oracle12c edition 2 (personal version) performance: sqlplus, error after entering user name and password DRA-12560:TNS: protocol adapter

  2022-06-01 07:58:34 Views: 269
• 

  Basic query of mysql field

  Basic query / * syntax: select select, filter, view similar to System.out.println ("...") Printing features: 1. The query list can be: fields in the table, constants, expressions, function 2, the result of the query is a virtual table *

  2022-06-01 07:58:34 Views: 289
• 

  01-initialize the Activiti database

  Package cn.itcast.activiti.db;import org.activiti.engine.ProcessEngine;import org.activiti.engine.Pr

  2022-06-01 07:58:31 Views: 257
• 

  6. Plural SQL talk-comments, conversion of data types, scope of variables and qualifier tags

  1. Letters, numbers, spaces and special symbols can be used in the lexical PL/SQL of PL/SQL blocks, including identifiers-variables, keywords, reserved word separators-semicolons, commas, plus or minus signs and other constants-strings, numbers, Boolean variable comments-one-line comments,

  2022-06-01 07:58:31 Views: 257