Oracle

Previously learned Oracle database notes plus some personal experience summary, share it.If there are deficiencies, please correct them.-----------------------------------------------------------------------------Database composition:Physical

Select Ename,hiredate,sysdate from Scott.emp; can find out the date of employee's entry to presentSelect Ename,sysdate-hiredate from Scott.emp; See how many days the employee has been in service;Select Ename,months_between (sysdate,hiredate) from

is the Partition operation related to Controlfile?To judge by experiments:Compare the operations before and after Partition to see if there is a record in the Controlfile dump information,The results found no information recorded in the Controlfile.#

Oracle users, roles, permissions, etc.Privilege Management is the essence of Oracle systems, where different users log in to the same database, may see different numbers of tables, and have different permissions. Oracle's permissions are divided

Modifying the Oracle Database SGA and PGA sizeSize of the SGA: general physical memory 20% is used as the operating system reservation, and the other 80% is for the database.The SGA Normal database can be allocated between 40%-60% and the PGA can be

[Oracle] Why Archivelog was not removed immediatelyThe customer has set up the Archivelog deletion policy is CONFIGURE Archivelog deletion policy to applied on all STANDBY;So, he thinks that as long as the standby side commits, it should be

Problem phenomenon:Alter user Scott account unlock;ERROR at line 1:Ora-01034:oracle Not availableProcess id:0Session id:0 Serial number:0[[Email protected] ~]$ Echo $ORACLE _sidxxxx[[email protected]~]$ Sqlplus/

1.**entityframework Add Oracle EF-related NuGet package Oracle.ManagedDataAccess.EntityFramework (Auto add oracle.manageddataaccess)2.**web Add Oracle.ManagedDataAccess.EntityFramework (Auto add oracle.manageddataaccess)Overriding onmodelcreating

--Query The SQL statement being executedSelect A.program, B.spid, c.sql_text,c.sql_fulltext,c.sql_idFrom V$session A, v$process B, V$sqlarea cwhere a.paddr = B.addrand A.sql_hash_value = C.hash_valueAnd a.username is not null;--- query executed SQL

A quick way to generate large amounts of simulated data:CREATE table TEST (ID integer, test_number number (18,6));INSERT INTO TESTSelect I+j, I+jFrom (With DATA2 (j) as (Select 0 J from DUALUNION ALLSelect j+1000 from DATA2 where J )Select J from

In everyday SQL queries, we need to process the data that we want to query, and then query it in the pre-processed data. At this point we need to use the temporary table, pre-processing the data into the temporary table, and then in the temporary

Installation Preparation1 physical memory greater than 1G2 Enough disk space3 explicit host name and corresponding Hosts fileInstall the support package with Yum firstYum-y Install compat-libstdc* elfutils-libelf-devel* libaio-devel numactl-devel

ORACLE11G error ora-27157:os post/wait facility removed Ora-27300:os system dependent Operation:semop failed with status:43Workaround: See http://www.cnblogs.com/abclife/p/5859005.html1). Set/etc/systemd/logind.conf in Removeipc=no2). Restart the

1. Tablespace read-onlyTo view the current table space status[Email Protected]>column file_nameformat A60[email protected]>columntablespace_name format A20[email protected]>SelectTablespace_name,file#,file_name, v.status,v.enabled fromDba_data_files

When you use a report with a database, you often encounter matrix transpose. This requirement in Excel is easy to implement, but many people do not know how to use the Oracle database implementation, the following shows you a few ways to use SQL

1, look for redundant records in the table, duplicate records are based on a single field (ID) to determineSelect * from where inch (Selectfromgrouphavecount>1)2, delete redundant records in the table, duplicate records are based on a single field (

Some time ago there is a need to export the database of 500 table structure, using the Plsqldev tool can also export the build table statements, but need to manually a table one table, very laborious. I wrote a splice of SQL.Select ' Select

CENTOS7 Minimal Installing the Oracle 11GR2 environment VM12+the newly installed CENTOS7 x64 minimal#root some softwareYum Install wget UnzipNet-tool-y#root Installation Environment automatic configuration CD/etc/Yum.

Trying to: try to be one of the database objects the role that the view embodies in the SQL statement is consistent with the table, but it is not a really existing table, but a result set that corresponds to a query statementWhen attempting to

#!/bin/bash# set Oracle Database run account and Oracle's system environment variables Export oracle_base=/data/oracleexport oracle_home= $ORACLE _ Base/product/10gexport oracle_sid=testexport path= $ORACLE _home/bin: $HOME/bin: $PATHexport  ld_