NAV: SLTechnology News&Howtos > Database >

• 

  ERROR OGG-01668 PROCESS ABENDING.

  The error in oracle ogg is as follows: ERROR OGG-01172 Discard file & # 40. Exceeded max.

  2022-06-01 14:55:04 Views: 208
• 

  Simple use of Sql Loader

  The previous summary of the use of SQL*Loader is used again today to see that SQL*Loader can load data from external files into the table of Oracle DB. It has a powerful data analysis engine, so the lattice of the data in the data file

  2022-06-01 14:55:04 Views: 210
• 

  One of Oracle Hint learning

  APPEDND hint: used to control whether insert statements can insert data in a direct path insert. CACHE hint: LR that controls whether the target sql puts blocks of the full table scan target table into the buffer cache during execution

  2022-06-01 14:55:04 Views: 255
• 

  Mysql starts slow query and uses mysqldumpslow for log analysis

  Mysql slow query log is a kind of log record provided by mysql, which is used to record statements that exceed the threshold for the corresponding time in mysql, that is, sql whose running time exceeds the value of long_query_ time will be recorded in the slow query log. Long_qu

  2022-06-01 14:55:00 Views: 288
• 

  Exception error handling of Oracle topic 13

  1. The concept and classification of exception handling. What is an exception? Exception: an unexpected event that occurs during the normal execution of a program. B. what is exception handling? Exception handling is to improve the robustness of the program. Using the exception handling part can effectively solve the problems that may occur during the normal execution of the program.

  2022-06-01 14:55:00 Views: 255
• 

  User and permissions

  Every time I talk about users and permissions, I always feel that there is nothing to share and communicate. In fact, it is not appropriate to describe it as if you are a customer to buy a house, you go to see a 200W house and a 1000W house that is absolutely different, and the service level is also very different. Users and permissions in the database are like money

  2022-06-01 14:54:59 Views: 268
• 

  OGG operation and maintenance optimization script (10)-query maintenance class-process details query

  File: processinfo.sh path: $HOME/ggscript/ggupload function: this script is designed to check the detailed source and destination side, definition files and other information of all goldengate processes when maintaining the configuration if it is not in accordance with the script

  2022-06-01 14:54:56 Views: 286
• 

  Log mode of informix database

  Today, when operating the database for batch DML operations, I reported an error that I had never seen before, java.sql.SQLException: No Transaction Isolation on non-logging db

  2022-06-01 14:54:55 Views: 258
• 

  ORACLE ADF11g: getting started with ManagedBean

  In ORACLE ADF, ManagedBean can be said to be the main place to write logic code. It has six different scopes, the most common of which is the default request scope. Next, we will show you the simplest way to use mangedBean. Illustration:

  2022-06-01 14:54:25 Views: 228
• 

  ORACLE series script 1: life-saving emergency session handling script

  Background: database deadlock session soaring situation through the following expectations can quickly locate common locks, rapid intervention processing, restore database performance. Long-term operation and maintenance through the following statements? t or above database? Yes, it works every time. First, query the deadlock SID and other information SELECT l.ses

  2022-06-01 14:54:25 Views: 243
• 

  MySQL (4)-AB master-slave replication and read-write separation

  This blog introduces how to synchronize data through master-slave replication (Master-Slave), and then improve the concurrent load capacity of the database to achieve mysql high availability through read-write separation (MySQL-Proxy). First of all, let's learn about AB master-slave replication.

  2022-06-01 14:53:55 Views: 249
• 

  Oracle sets scheduled tasks job scheduling executes stored procedures or pl/sql code blocks

  At present, there are generally two ways to set job scheduling for scheduled tasks in oracle database, which are dbms_scheduler to create job scheduling and dbms_job to create job scheduling. Dbms_scheduler created the job schedule after 10g.

  2022-06-01 14:53:55 Views: 248
• 

  Data Table Control statement of MySQL

  Blog outline: 1. Constraint related statement Primary key constraint non-empty constraint setting value uniqueness setting column default value setting since increment 2. ALTER directive using data length modification field name to insert a new field into the table add a constraint add a foreign key delete foreign key delete

  2022-06-01 14:53:25 Views: 218
• 

  Backup and recovery of oracle vote disk and ocr disk

  The problem of forgetfulness of 1.ocr disk introduction is caused by the fact that each node has a copy of the configuration information and the configuration information of the modified node is out of sync. The solution adopted by Oracle is to put the configuration file on the shared storage, which is called OCR Disk. The entire OCR

  2022-06-01 14:53:24 Views: 280
• 

  Get the definition text that creates the SQL Server object

  Quote from "SQL Server 2012 Internals"As views, these metadata objects are based on an underlying Transact-"

  2022-06-01 14:53:24 Views: 205
• 

  Detailed explanation of redis- configuration file

  1. Basic configuration: the number of database created by whether daemonize no starts databases 16 with background process (database 0 is selected by default) save 9001 # refresh snapshot to hard disk must meet both requirements

  2022-06-01 14:53:24 Views: 298
• 

  A simple shell script that generates files in a fixed format

  #! / bin/shfile1=$ (date +% Y%m%d%H%M%S) # define variable get current time ALM_TYPE=BOSS4ZC # define variable INSTANCE_ID=62100408# define variable STATU

  2022-06-01 14:53:24 Views: 259
• 

  Port conflict between hbase and regionserver in hbase

  Port conflict between hmaster and regionserver in hbase java.lang.RuntimeException: Failed construction of Regionserver:

  2022-06-01 14:53:10 Views: 299
• 

  Tidy up-install rlwrap to realize the callback function of sqlplus history commands under Oracle

  Install rlwrap compiler has been reporting errors You need the GNU readline library (ftp://ftp.gnu.org/gnu/readline/) to build this prog

  2022-06-01 14:53:10 Views: 259
• 

  MySQL query data

  MySQL query data MySQL database uses SQL SELECT statements to query data. You can query the data in the database from the mysql > command prompt window, or query the data through the PHP script. The syntax below is to look up in the MySQL database

  2022-06-01 14:53:10 Views: 274