[Oracle] ์˜ค๋ผํด ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ๋ฒ„์ „ ํ™•์ธ ์ฟผ๋ฆฌ

2024. 12. 19. 17:50ยท๐Ÿ’ป CS/Database

์˜ค๋ผํด ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ๋ฒ„์ „ ํ™•์ธ ์ฟผ๋ฆฌ

์˜ค๋ผํด ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ๋ฒ„์ „์„ ํ™•์ธํ•  ์ˆ˜ ์žˆ๋Š” ์ฟผ๋ฆฌ์ž…๋‹ˆ๋‹ค.

select * from v$version;

์˜ค๋ผํด 10g

  • 10๋ฒ„์ „๋ถ€ํ„ฐ ์˜ค๋ผํด์˜ ์ธํ„ฐ๋„ท์—์„œ ๊ทธ๋ฆฌ๋“œ๋กœ ์„œ๋น„์Šค๋ฅผ ์—…๊ทธ๋ ˆ์ด๋“œ ํ•˜๋Š” ์‹œ๊ธฐ์— ๋ฐœํ‘œํ•œ ๋ฒ„์ „
  • ๊ธฐ์—…๋‚ด์˜ ์ค‘์†Œํ˜• ์„œ๋ฒ„๋ฅผ ์—ฐ๊ฒฐ์‹œ์ผœ ์œ ํœด์ž์›์„ ํ™œ์šฉ
  • ํ•˜๋‚˜์˜ ์ปค๋‹ค๋ž€ ์„œ๋ฒ„๋กœ ํ™œ์šฉํ•  ์ˆ˜ ์žˆ๊ธฐ ๋•Œ๋ฌธ์— ๋ฌด๋ฆฌํ•˜๊ฒŒ ์„œ๋ฒ„๋ฅผ ๊ตฌ์ž…ํ•  ํ•„์š”๊ฐ€ ์—†์–ด์ง.
  • Provisioning(ํ”„๋กœ๋น„์ €๋‹), Load Balancing(๋ถ€ํ•˜๊ด€๋ฆฌ), Automation(์ž๋™ํ™”) ์ง€์›

์ฐธ๊ณ 

  • [ORACLE] ์˜ค๋ผํด - 2. ์˜ค๋ผํด ๋ฒ„์ „๋ณ„ ํŠน์ง• ๋ฐ ์ฐจ์ด์ 

'๐Ÿ’ป CS > Database' ์นดํ…Œ๊ณ ๋ฆฌ์˜ ๋‹ค๋ฅธ ๊ธ€

[DynamoDB] DynamoDB๋ž€  (0) 2025.03.18
[์˜ค๋ผํด] MERGE INTO  (0) 2025.01.16
[์˜ค๋ผํด] WITH ๊ตฌ๋ฌธ  (0) 2025.01.16
[์˜ค๋ผํด] NULL๊ณผ ๊ณต๋ฐฑ  (0) 2025.01.10
'๐Ÿ’ป CS/Database' ์นดํ…Œ๊ณ ๋ฆฌ์˜ ๋‹ค๋ฅธ ๊ธ€
  • [DynamoDB] DynamoDB๋ž€
  • [์˜ค๋ผํด] MERGE INTO
  • [์˜ค๋ผํด] WITH ๊ตฌ๋ฌธ
  • [์˜ค๋ผํด] NULL๊ณผ ๊ณต๋ฐฑ
jinnkimm7
jinnkimm7
[Nothing changes if nothing changes] ๊ฐœ๋ฐœ ๊ด€๋ จ ๊ธ€ ์œ„์ฃผ๋กœ ํฌ์ŠคํŒ… ํ•  ์˜ˆ์ •์ด๋ฉฐ, ๊ทธ ๋ฐ–์— ์ž๊ธฐ๊ฐœ๋ฐœ/์ผ์ƒ/์—ฌํ–‰์— ๊ด€ํ•œ ์ •๋ณด๋„ ํฌ์ŠคํŒ… ํ•  ์˜ˆ์ •์ž…๋‹ˆ๋‹ค.
  • jinnkimm7
    Jin's log
    jinnkimm7
  • ์ „์ฒด
    ์˜ค๋Š˜
    ์–ด์ œ
  • โœ๏ธ๊ธ€์“ฐ๊ธฐ ๐Ÿฆบ๊ด€๋ฆฌ
    • ๋ถ„๋ฅ˜ ์ „์ฒด๋ณด๊ธฐ (83)
      • ๐Ÿ“š Record (0)
      • ๐Ÿ‘จ‍๐Ÿ’ป Programming (9)
        • JavaScript (2)
        • React (1)
        • Next.js (2)
        • HTML (0)
        • CSS (1)
        • Java (3)
        • Spring (0)
      • ๐Ÿ’ป CS (11)
        • Computer Architecture (1)
        • Operation System (2)
        • Data Structure (0)
        • Algorithm (2)
        • Database (5)
        • Network (1)
      • โš™๏ธ Tool (12)
        • AWS (2)
        • git (3)
        • VS Code (2)
        • IntelliJ (0)
        • Eclipse (1)
        • Excel (4)
      • ๐Ÿ“ Coding Test (37)
        • Programmers Lv0 (6)
        • Programmers Lv1 (1)
        • Programmers Lv2 (2)
        • Programmers Lv3 (1)
        • ๋ฐฑ์ค€ Bronze (0)
        • ๋ฐฑ์ค€ Sliver (3)
        • SQL (24)
      • ๐Ÿ“– Study (9)
      • ๐Ÿ”  English (0)
      • ๐ŸŽ’ Travel (0)
      • ๐Ÿ’ฐ Finance (0)
      • ๐Ÿ“Œ Etc (3)
  • ๋งํฌ

    • Resume
  • ์ธ๊ธฐ ๊ธ€

  • ์ตœ๊ทผ ๋Œ“๊ธ€

  • ์ตœ๊ทผ ๊ธ€

  • ํƒœ๊ทธ

    next.js
    AWS
    ์ฝ”๋”ฉํ…Œ์ŠคํŠธ์—ฐ์Šต
    ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค
    ์ฝ”๋”ฉํ…Œ์ŠคํŠธ์ค€๋น„
    git
    ์˜ค๋ผํด
    MYSQL
    java
    ํ•ญํ•ด99
    ํด๋ž˜์Šค
    ๋ฐฑ์ค€
    ์ฝ”๋”ฉํ…Œ์ŠคํŠธ
    ์˜ค๋ธ”์™„
    SQL
    vscode
    99ํด๋Ÿฝ
    ๋ฐ˜๋„์ฒด8๋Œ€๊ณต์ •
    tanstackQuery
    ํ‹ฐ์Šคํ† ๋ฆฌ์ฑŒ๋ฆฐ์ง€
  • hELLOยท Designed By์ •์ƒ์šฐ.v4.10.0
jinnkimm7
[Oracle] ์˜ค๋ผํด ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ๋ฒ„์ „ ํ™•์ธ ์ฟผ๋ฆฌ
์ƒ๋‹จ์œผ๋กœ

ํ‹ฐ์Šคํ† ๋ฆฌํˆด๋ฐ”