NAV: SLTechnology News&Howtos > Database >

• 

  SQL execution of Oracle

  1. Oracle Concepts Guide explains every part of SQL language and database in detail. People who are advised to use Oracle should read "Oracle Concepts Guide". 2. Shared pool and database cache

  2022-06-01 12:08:36 Views: 246
• 

  Index Series Nine-- ordered Optimization of Index characteristics distinct

  -- preparation before DISTINCT testing drop table t purge;create table t as select * from dba_objects;update t set object_i

  2022-06-01 12:08:36 Views: 260
• 

  Oracle extends the tablespace of the database

  After logging in to the host directly, if you need to convert the instance of the database, enter it in Windows, enter set oracle_id=..., in the root directory of ORACLE, and enter export ORACLE_SID=. in the AIX system.

  2022-06-01 12:08:36 Views: 236
• 

  How to modify the system default time format by Oracle

  The solutions are as follows: 1. Temporary modification of alter session set nls_date_format='YYYY-MM-DD HH24:MI:SS'; can only change the date display format in the current session, and when a new one is established

  2022-06-01 12:08:36 Views: 272
• 

  Disable transparent HugePages

  1. Check if Transparent HugePages Red Hat Enterprise Linux Kernel is enabled: # cat / sys/kernel/mm/redhat_transparent_hugepage/enabled other

  2022-06-01 12:08:32 Views: 250
• 

  Bbed repair data file header

  Copy the good data file header under the same table space to the problematic data file header, for example: copy file x block 1 to file y block 1, and then press offset below to confirm and modify it. Rdba_kcbh (of

  2022-06-01 12:08:32 Views: 218
• 

  Tencent excellent testing and sharing practical information selection | Android dual card dual standby adaptation-Hidden

  Tencent Pretest is a professional app automated testing platform. In addition to providing multi-dimensional testing services such as compatibility testing and remote real machine rental, there are also excellent sharing-selection of Tencent's internal mobile R & D testing practical information ~ many APP want to obtain user address book contacts and use address book relationship chain information to enrich production.

  2022-06-01 12:08:32 Views: 259
• 

  Oracle counts the rows of all the tables of the user

  DECLARE CURSOR c1 is select table_name from user_tables; V_TABLE_NAME user_tables.TABLE_NAME%TYPE

  2022-06-01 12:08:31 Views: 300
• 

  Personal notes: ORACLE large page memory hugepage and SGA, PGA experience, SGA is not the bigger the better

  Background: ORACLE 11.2 SGA 64G mins 8G, stress test showed that the operating system ran out of memory WARNING: Heavy swapping observed on system in last 5 mins.

  2022-06-01 12:08:31 Views: 222
• 

  OGG logdump skip the operation of sth.

  In a charging system, the monitoring alarm shows that the ogg process is abnormal. Colleagues log in to the system to check to confirm that the ogg process stopped abnormally. Check ggserr.log and find an alarm for undo tablespace, followed by an abnormal stop of ABENDING2017-07-05

  2022-06-01 12:08:19 Views: 226
• 

  Oracle custom function record

  The function is mainly used to manipulate all kinds of data and return the corresponding operation results. A user-defined function is a block of code stored in a database that can return values to the caller. Syntax of the function: Create [or replace] function function

  2022-06-01 12:08:19 Views: 240
• 

  Elasticsearch indexed document

  The content comes mainly through the translation of official documents, version 7.10 indexing document operation (implemented through curl) curl-X PUT "localhost:9200/twitter/_doc/1"-H 'Content-Type: a

  2022-06-01 12:07:56 Views: 208
• 

  Is the PPT file too large? How to compress PPT? These tricks will help you get it done.

  Sometimes the leader will ask us to make a PPT. In order to show our words more subjectively in front of people, we usually add some pictures, videos, tables, etc., to the PPT. Then the volume of the PPT will become larger, and in the process of uploading, we will fail to send the file because the file is too large.

  2022-06-01 12:07:56 Views: 217
• 

  MySQL Internal Temporary

  What is Internal Temporary? There are two kinds of temporary tables. One is some intermediate result sets, called internal temporary, that MySQL automatically creates when some SQL is executed. These intermediate result sets may be placed in memor.

  2022-06-01 12:07:49 Views: 280
• 

  Import dmp file report "is not a valid export file, header verification failed"

  When importing the dmp file given by someone, imp em/123456@orcl fromuser=em touser=em file=c:\ em1013.dmp reported the wrong title under the dos environment because that person was in oracle11.

  2022-06-01 12:07:49 Views: 209
• 

  Understanding of Hbase architecture

  1. Hbase's cluster architecture first of all, hbase is a component of hadoop. There are many components within hadoop, almost all of which are built on the two core things of hadoop, one is the hdfs file system, the other is mapre.

  2022-06-01 12:07:49 Views: 232
• 

  Pgwatch2 monitored by PostgreSQL

  Although the author has launched the docker version, it only needs one button (one command) to complete the construction. But in the spirit of learning, you still have to toss around on your own. One button is good but not clear. The official has written down the installation in great detail, but it is English .pgwatch after all.

  2022-06-01 12:07:19 Views: 279
• 

  Programmer's Notes | step by step interpretation of Oracle AWR performance Analysis report

  AWR in Oracle, full name is Automatic Workload Repository, automatic load information base. It collects operational statistics and other statistics about a specific database, and Oracle at regular intervals (default is 1 hour

  2022-06-01 12:07:13 Views: 281
• 

  Mysql grouping function

  # grouping function: used for statistics, can be nested to use USE myemployees;#sum summation SELECT SUM (salary) FROM employees;#avg to find the average SELECT AVG (salary

  2022-06-01 12:07:13 Views: 236
• 

  Install openresty, mariadb and php7 services with yum source and source code package

  Before starting the deployment, it is necessary to give a brief introduction! OpenResty is a high-performance Web platform based on Nginx and Lua, which integrates a large number of excellent Lua libraries, third-party modules and most dependencies. Used to build energy conveniently

  2022-06-01 12:07:07 Views: 280