NAV: SLTechnology News&Howtos > Database >

• 

  Oracle 11g R2 DBA Operation Guide for oracle Reading Notes (the first three chapters)

  Oracle 11g R2 DBA operation guide is the first book I learned about oracle database knowledge. I record my learning notes here, and verify the knowledge points in the book through practical operation. 1.Oracle Database Foundation 1.1. Correlation coefficient

  2022-06-01 10:05:14 Views: 246
• 

  12cR1 PDB read-only and read-write conversion

  PDB read-only and read-write conversion 1, pdb to mount status SQL > alter pluggable database pdb11 close immediate;Pluggable database alter

  2022-06-01 10:05:14 Views: 291
• 

  SQL Server database permission settings

  First, login rights: there are two authentication modes of SQL server: 1. Windows authentication mode: when using Windows authentication, SQL server will use the Windows user and password in the operating system. That is to say,

  2022-06-01 10:05:02 Views: 228
• 

  Basic understanding of mybatis

  1. The main class 1.1 SqlSessionFactoryBuilder is used to create SqlSessionFactory, which can also be code through the configuration file. The main method SqlSessionFactory build (I)

  2022-06-01 10:04:53 Views: 292
• 

  Oracle 11g and oracle 10g memory management

  The MEMORY_MAX_TARGET parameter is added to 11g, which is as refreshing as the first appearance of SGA_MAX_SIZE parameter in 10g. Memory_max_target is set to be occupied by Oracle

  2022-06-01 10:04:53 Views: 266
• 

  The ORA-00064 processes setting is too large so that the database cannot be opened.

  The processes setting is too large so that the database cannot be opened. After the processes setting is too large, the database may not be opened. After opening the database, an error will be reported: SQL > startupORA-00064: object is too large

  2022-06-01 10:04:53 Views: 272
• 

  How to implement the date addition and subtraction function in MySQL

  Editor to share with you this time is how MySQL to achieve the date addition and subtraction function, the article is rich in content, interested friends can come to understand, I hope you can get something after reading this article. 1. Addtime () is the date plus the specified number of seconds select ad

  2022-06-01 10:04:53 Views: 234
• 

  How Oracle SQLPlus exports data to csv files

  This article mainly shows you how Oracle SQLPlus exports data to csv files, the content is easy to understand, I hope you can learn, after learning there will be gains, the following let the editor to take a look at it. From time to time, we need to export some data for

  2022-06-01 10:04:53 Views: 254
• 

  Configure always on mode of SQL 2016 for SharePoint 2016 (2)

  At this point, we have successfully installed two SQL Server 2016 servers and configured them with a failover cluster. First of all, let's configure the Always On mode on two SQL Server 2016 servers

  2022-06-01 10:04:23 Views: 290
• 

  Some code optimizations in the work

  (1) avoid unnecessary loop nesting in the code. If there are nested loops in the code, look at the refactoring code. (2) Select into creates tables, resulting in DDL transactions, so the DDL operation is best done independently of a transaction (for Oracle). (3) avoid loop execution

  2022-06-01 10:04:22 Views: 204
• 

  [MySQL failure handling] Seconds_Behind_Master= NULL Error_code: 1197

  The process of handling the master-slave fault is recorded here: fault 1 recording error code: 1197 (max_binlog_cache_size) Database version: 5.7.9 error message: [ERROR] Slave SQL for cha

  2022-06-01 10:04:22 Views: 265
• 

  Create the storage process of MYSQL

  Create a stored procedure for MYAQL 1 create the stored procedure CREATE PROCEDURE procedure name without parameters () procedure body SELECT VERSION (); call the first CALL procedure name of the stored procedure ()

  2022-06-01 10:04:22 Views: 294
• 

  Oracle multi-instance auto-startup script

  #! / bin/sh#start mutli oralce instance#create by zwy#date 2017-10-25 portals cnt = `ss-lnp | grep 1521 | wc-l

  2022-06-01 10:04:15 Views: 266
• 

  Mysql looks at the table structure from the command line

  Mysql looks at table structure 1. 0 from the command line. Syntax: DESC table name; 2. Syntax parsing: DESC table name: list the relevant information of the table 3. Example: DESC student;4. Screenshot of the running result:

  2022-06-01 10:04:15 Views: 299
• 

  MySQL specification recommendation

  1. MySQL data modeling recommendations: 1.1 rational use bigint (20) numerical type: type: BIGINT size: 8 byte range (signed): (- 9 233 372 036 854

  2022-06-01 10:04:15 Views: 252
• 

  SQL Server database cannot be logged in with sa account

  DMBS production environment: SQL Server 2005 problems are shown in the following figure: 4064 and 18456 errors. Solution to the problem: change Named Pipes from disabled to enabled. Restart the sql server service and you can log in with your sa account

  2022-06-01 10:04:03 Views: 249
• 

  Prohibit users from DDL operations on their own tables

  Just flipping through the materials, I found a small skill of database management, which can prohibit users from DDL the table under their schema. The principle is to disable the lock on the table. SQL > alter table T1 disable table lock;Table

  2022-06-01 10:04:02 Views: 262
• 

  EBS 11i log log

  1. Default network port: 1), all ports used by EBS11i s_dbport=1521s_webport=8000s_webport_pls=8200s_oprocmgr_port=8100s_formspo

  2022-06-01 10:03:53 Views: 231
• 

  Installation and configuration of Heavenly Rabbit

  Official download and installation documentation: http://www.lepus.cc/page/product has a lot of frustrations when installing the Heavenly Rabbit due to referring to the official documentation, so I have this note: environment CentOS 6.5 + xampp-linux-

  2022-06-01 10:03:53 Views: 213
• 

  How to convert the SQL Server time (2) type after it is stored as int

  The time (2) type retains two bits in milliseconds. After the application converts the time (2) type to int and stores it to SQL Server, the following two methods can convert int to time (2):-- method 1DECLARE @ T intSET @ T

  2022-06-01 10:03:52 Views: 261