NAV: SLTechnology News&Howtos > Database >

• 

  About datapump parallel

  For Data Pump Export, the value that is specified for the parallel parameter should be less than or

  2022-06-01 06:44:20 Views: 233
• 

  Install MySQL 5.7.13

  Install MySQL 5.7.13 I. introduction: MySQL 5.7. main features: 1, native support for Systemd2, better performance: better optimization for multicore CPU, solid state disk, lock 3, better lnnoDB storage engine 4, more robust replication

  2022-06-01 06:44:20 Views: 284
• 

  Install GRID silently in an Oracle:Linux environment

  First, the environment introduction system: Redhat 6.5database: Oracle 11gR2 11.2.0.3 II, install Oracle Grid Infrastructure to write grid_install.rsp configuration file foot

  2022-06-01 06:44:19 Views: 207
• 

  Summary of MySQL Recursive query

  Note: the parent_id value is associated with the value of the table's own id column. If the value is-1, it means that the record does not have a parent record, otherwise it means that the record has a parent record (assuming that the parent_ id value is 5, then the parent record id is 5). For the time being, the record itself is called a child record.

  2022-06-01 06:44:19 Views: 228
• 

  [Enmo College] take stock of the 10 major performance impacts caused by the new features in Oracle 11g (part two)

  [Enmo College] take stock of the 10 performance impacts brought about by the new features in Oracle 11g (part two). Do you remember the top 10 performance impacts of Oracle 11g that we checked a few days ago? Any new version of Oracle will always bring a lot of attention.

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

  2011-10-05 COLLECTION

  Which PLSQL block of the http://www.itpub.net/thread-1499223-1-1.html1 building will display the following three lines of numbers after execution? 012ADECLARE TYPE numbers_t

  2022-06-01 06:44:18 Views: 229
• 

  Logical backup of oracle database

  The technical level of document writing has been complained about all the time, but it is also very depressed. The document can be completed and implemented, but it lacks embellishments, so I haven't written a blog all the time, but I can't help but want to record something so as not to leave regret. after all, as a technocrat, I only read other people's blogs and didn't write them.

  2022-06-01 06:44:17 Views: 351
• 

  PostgreSQL source code interpretation (236)-background process # 14 (autovacuum process # 2)

  This section briefly introduces the background process of PostgreSQL: autovacuum, and mainly analyzes the implementation logic of the launch_worker function. 1. Data structure AutoVacuumShmem main autovacuum shared memory structure

  2022-06-01 06:44:17 Views: 225
• 

  Master-slave copy Replication of mysql learning notes

  Copy master-slave Replication3.1 architecture figure 3.2Parametric configuration 3.2.1 create an opening and closing script login.shrunken _ bind _ bind _ MySQL-h227.0.0.1-uroot-P3306-p'Yxc

  2022-06-01 06:44:11 Views: 261
• 

  Vnc activation key, vnc activation key how to get? And how to use it?

  What is the vnc activation key? general vnc software should be required, because only the activated software can be used, so where can I get the vnc activation key? How do I use it? Next, I'll tell you what the vnc activation key is. Usage tools: IIS7 server management tools this tool

  2022-06-01 06:44:10 Views: 298
• 

  Ocp | ocm textual research series!

  In order to give you a comprehensive understanding of the process of ocp research, so that you can free up more time to study oracle... wholeheartedly. I have written a series of articles related to ocp,ocm textual research or the career of oracle dba for your reference. The theme and content of the article are also

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

  The influence of Oracle 11g Test shutdown on job

  Environment: OS:Centos 7.5DB:Oracle 11.2.0.4.0 single instance scenario 1: job does not start, the library is stopped, and after starting the library again, the time to start the library is the start time of job, and the job will be run automatically. It will not automatically make up for the job missed during the shutdown. Field

  2022-06-01 06:44:08 Views: 263
• 

  Ora-600 [rwoirw: check ret val] with count distinct and order by

  Invalid DB saw ORA-00600 [rwoirw: check ret val] Mon Mar 02 09:32:06 2015 ORA-00600 triggered by web program: internal error code, parameter: [rwoir

  2022-06-01 06:44:08 Views: 286
• 

  XtraBackup partial backup

  You can use the Xtrabackup tool to recover data from only a few tables. Experimental scenario: there is a table T3 on the instance of port 3306, but not on the instance of port 3308. The purpose of the experiment is to restore the T3 table of port 3306 to the instance of port 3308. Steps: 1.

  2022-06-01 06:44:07 Views: 230
• 

  A strange diagnostic process of ora-4030 error

  The diagnosis process of a strange ora-4030 error I received a rather strange ora-4030 problem reported by a client a few days ago, and I would like to share it with you. According to the customer's description, he is trying to put an Oracle 1 on the Solaris 10 Sparc

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

  Switching between 11g RAC archiving and non-archiving

  Switch between 11 g RAC archiving and non-archiving non-archiving-> archiving 1. Set the archive path SYS@rac1 > alter system set log_archive_dest_1='LOCATION=+fra

  2022-06-01 06:44:07 Views: 298
• 

  In-depth analysis of InnoDB Redo Flush and dirty page refresh mechanism

  Summary: we know that InnoDB uses Write Ahead Log strategy to prevent downtime data loss, that is, when a transaction commits, the redo log is written first, and then the in-memory data page is modified, resulting in dirty pages. Since there is a redo log to ensure data persistence, you can also query directly from the buffer

  2022-06-01 06:44:07 Views: 224
• 

  Oracle data type number

  Oracle numberNUMBER [(p [, s])] Number having precision p and scale s. Theprecision p can range fro

  2022-06-01 06:44:06 Views: 208
• 

  Mysql:The server quit without updating PID file & # 40scarp EIPDB 1. PIDPIDATION 41.

  Environment: mysql master and slave, one host, one standby. They're all virtual machines. The standby machine is only used for backup, not for business. Turn off the host mysql service, shut down the host system, and add memory. The standby phone remains the same. Turn on the mainframe. Add up the memory. EIPDB1:~ # fr

  2022-06-01 06:44:02 Views: 278
• 

  Oracle RAC database individual resources cannot be started automatically

  Recently I have dealt with several cases where individual resources cannot be started when RAC is restarted, such as instance, tns, and so on. The resources are as follows:-

  2022-06-01 06:44:02 Views: 302