Oracle 内存

Basic Memory Structures

Oracle Database Memory Structures

System global area (SGA)

Program global area (PGA)

One PGA exists for each server process and background process.

User global area (UGA)

The UGA is memory associated with a user session.

Automatic Memory Management

Enabling Automatic Memory Management

SGA_TARGET

1
2
3
4
5
SELECT (
   (SELECT SUM(value) FROM V$SGA) -
   (SELECT CURRENT_SIZE FROM V$SGA_DYNAMIC_FREE_MEMORY)
   ) "SGA_TARGET"
FROM DUAL;

MEMORY_TARGET

show parameter memory_max_target
show parameter memory_target

– 修改自动内存管理参数
alter system set memory_max_target=600M scope=spfile;
alter system set memory_target=600M scope=spfile;

show parameters shared_pool_size;

– 指定 shared_pool_size 大小
alter system set shared_pool_size=’60m’ scope=spfile;

Psychology

Comfort object

In human childhood development, the term transitional object is normally used. It is something, usually a physical object, which takes the place of the mother-child bond. Common examples include dolls, teddy bears or blankets.

Donald Woods Winnicott introduced the concepts of transitional objects and transitional experience in reference to a particular developmental sequence. With “transition” Winnicott means an intermediate developmental phase between the psychic and external reality.

Pareidolia

Pareidolia is the tendency for perception to impose a meaningful interpretation on a nebulous stimulus, usually visual, so that one sees an object, pattern, or meaning where there is none.

Rorschach test

The Rorschach test is a projective psychological test in which subjects’ perceptions of inkblots are recorded and then analyzed using psychological interpretation, complex algorithms, or both.

The Major Branches of Psychology

  • Abnormal Psychology
  • Behavioral Psychology
  • Biopsychology
  • Clinical Psychology
  • Cognitive Psychology
  • Comparative Psychology
  • Counseling Psychology
  • Cross-Cultural Psychology
  • Developmental Psychology
  • Educational Psychology
  • Experimental Psychology
  • Forensic Psychology
  • Health Psychology
  • Industrial-Organizational Psychology
  • Personality Psychology
  • School Psychology
  • Social Psychology
  • Sports Psychology

https://www.verywellmind.com/major-branches-of-psychology-4139786

Sigmund Freud (1856-1939)

  • The Interpretation of Dreams (1899)
  • Introductory Lectures on Psychoanalysis (1917)
  • Civilization and Its Discontents (1930)

Carl Jung (1875-1961)

Anima and animus

Shadow

BOOKS

  • Memories, Dreams, Reflections
  • Man and His Symbols

Personality Psychology

Self-report inventory

Nature

Cymothoa exigua

Cymothoa exigua, or the tongue-eating louse, is a parasitic isopod of the family Cymothoidae. It enters fish through the gills and the female attaches to the tongue, with the male attaching on the gill arches beneath and behind the female. The parasite severs the blood vessels in the fish’s tongue, causing the tongue to fall off. It then attaches itself to the remaining stub of the tongue and becomes the fish’s new tongue.

This is the only known case of a parasite assumed to be functionally replacing a host organ.

A mutated version of Cymothoa exigua was explored in the eco-terror film The Bay.

The-insiders-©-Qing-Lin-Wildlife-Photographer-of-the-Year

Apparent death

Paralysis
Pinch-induced behavioral inhibition

中国常识

党委书记、人大主任、政府市长、政协主席，哪个权力比较大？
经中央决定，“中央”具体指的是什么？
黄花岗在中国哪个省份？