NAV: SLTechnology News&Howtos > Database >

• 

  Oracle maintenance common command collection

  Query database tablespace capacity and data volume SELECT a.tablespace_name, total,free, (total-free), total / (1024 * 1024 * 1024) "TS (G)

  2022-06-01 16:42:26 Views: 221
• 

  Create a sequence in oracel

  Oracle sequence-- create sequence create sequence SEQ_IMMUNIZATIONincrement by 1start with 1maxvalue 999999999-query sequence s

  2022-06-01 16:42:23 Views: 240
• 

  Optimize it through case study-- Oracle data blocks (block)

  Through case study tuning-Oracle data block (data block) data block overview Oracle manages the storage space in the database data file (datafile) is the data block (data block). The data block is the smallest in the database

  2022-06-01 16:42:23 Views: 251
• 

  Oracle EBS upload Form compilation

  1. Back up cd $CUXWL_TOP/12.0.0/forms/ZHS/d01/CWTEST/apps/apps_st/appl/cuxwl/12.0.0/forms/ZHSll CUXWL_PO_RC

  2022-06-01 16:42:23 Views: 232
• 

  Database optimization

  (1) the connection usually comes from the Web server. Some parameters related to the connection and how to set them are listed below. 1. Max_connections this is the maximum number of connections allowed by the Web server. Remember to use session memory for each connection (about session memory)

  2022-06-01 16:42:22 Views: 245
• 

  Oracle modifies the database character set

  1. (Window:) under cmd, type set ORACLE_SID= the sid (Linux:) of the database you want to enter and switch to oracle user: export ORACLE_SID= the sid2 of the database you want to enter.

  2022-06-01 16:42:22 Views: 220
• 

  Download fnd_gfm fnd_lobs from EBS attachment

  Use the fnd_gfm package to download standard attachments from the EBS system, download files in the fnd_lobs table, or write to files. 1. Download the file declare v_file_id NUMBER; url

  2022-06-01 16:42:22 Views: 235
• 

  Detailed explanation of DB2 data dictionary

  For each database, a set of system catalog tables is created and maintained. These tables contain information about the definition of database objects, such as tables, views, indexes, and packages, as well as security information about the types of user access to these objects. For DB2 databases, these tables are stored in SYSCA

  2022-06-01 16:42:22 Views: 232
• 

  Oracle data recovery after WINDOWS reinstalled system

  Today, customers reinstall the Windows 2008 R2 system on the IBM server, and then because Oracle is installed on disk D, they need to continue the original library, so they need to restore the original library. The specific steps are as follows: backup the original installation directory and reinstall Ora.

  2022-06-01 16:42:21 Views: 219
• 

  Oracle 11g installation and uninstallation

  1. Before installing Oracle 11g, you should first determine your computer configuration. Take windows as an example. If it is a system below win7, such as xp, you can choose Oracle 10g. Because the program files of 10g only have more than 200 megabytes, while 11g and reach 2G

  2022-06-01 16:42:14 Views: 299
• 

  Xtrabackup2.4 backup Precona5.6 database for incremental backup and restore

  1. Full backuop, be sure to do it first: innobackupex-defaults-file=/etc/my.cnf-user=root-password=evlink / home/my

  2022-06-01 16:42:13 Views: 261
• 

  The solution of Chinese garbled code when Tomcat inserts data into MySQL under Linux

  Solution for inserting data into MySQL in Tomcat under Linux 1. The problem is on windows. The project developed with eclipse runs well on windows. When it is deployed to Tencent Cloud, data is inserted into the MySQL database.

  2022-06-01 16:41:40 Views: 273
• 

  Installation steps for oracle

  About Oracle database 1, brief introduction of Oracle database Oracle is a database management system, is the core product of Oracle company. It has excellent performance in data security and security control, as well as data operation across operating systems and hardware platforms.

  2022-06-01 16:41:40 Views: 210
• 

  Oracle date and time are stored in processing

  This chapter includes: processing and storing a specific date and time. The DATE type can store century, 4-digit year, month, day, hour, minute, and second using a timestamp timestamp, which can store a specific date and time. The advantage of timestamps is that they can be stored with decimal places

  2022-06-01 16:41:40 Views: 242
• 

  The problem of incorrect connection of SQL Server Mirror Library in C # Program

  A problem encountered in the operation and maintenance is that SQL Server is configured with mirroring, and the C# program fails to log in when connecting to the SQL Servr database. The application log is as follows: there is no abnormal log in the SQL Server main library, and the image library log record is as follows: Login fai

  2022-06-01 16:41:34 Views: 232
• 

  Compile and install the postfix mail service

  First, the preparation before installation. Basic knowledge of mail service: wget http://sourceforge.net/pSMTP: (Simple Mail Transfer Protocol) that is simple Mail transfer Protocol POP3: post office

  2022-06-01 16:41:14 Views: 290
• 

  Mysql recovers the solution of automatic disconnection of oversized files

  Recently, backup files have been used for mysqdump recovery. Due to the large data, it will be disconnected automatically in 2 hours, so try the following settings to solve the problem? set global max_allowed_packet=100 000000; set

  2022-06-01 16:41:01 Views: 237
• 

  Recommend! Devart four high-profile database management tools, you deserve to have

  "data is everything!" We've all heard this bold statement before, but it's true, and the data are everywhere. Nowadays, the development of every enterprise and organization needs to rely on a large amount of data, and the data has become the most valuable asset of the enterprise. In order to maximize the value of data, we usually

  2022-06-01 16:41:01 Views: 290
• 

  Small instance of Entity Framework: add an entity class to the project and insert it

  Small example of Entity Framework: add an entity class to the project and insert operation 1 >. Create a console program 2 >. Add an ADO.NET entity data model, and select the corresponding database and table (StudentModel.

  2022-06-01 16:41:01 Views: 225
• 

  The maximum value of sorting within the mysql group

  Recently, the business reported a query exception problem, which requires DBA to explain the query result exception and help them solve the problem. The essence of the problem is that the order within the group takes the maximum value. According to the business requirements, I built the test case test case-- build table create table t.

  2022-06-01 16:41:00 Views: 266