— 書籍 —

Books1

2023-09-05

・AI技術の最前線-これからのAIを読み解く先端技術73.pdf ・ビジネス＋IT生成AIに仕事を奪われる？生成AI時代の従業員に求められるスキルとは NewSQL ・TiDB実践入門-──RDBMSのスケール課題を解… もっと読む Books1

— _情報サイト —

URL

2023-09-05

Visual C++ での ODBC プログラミング例 https://www.kkaneko.jp/cc/mysql/odbcvisualcpp.html C++ による MariaDB の操作 http://mode… もっと読む URL

— Windows —

シンボリックリンク(Windows)

2023-08-05

MKLINK [[/D] | [/H] | [/J]] リンクターゲット・/D ディレクトリのシンボリックリンクを作成します。既定では、ファイルのシンボリックリンクが作成されます。・/H シンボリックリンク… もっと読むシンボリックリンク(Windows)

— Oracle —

Database Valut

2023-03-25

https://docs.oracle.com/cd/F19136_01/dvadm/getting-started-with-oracle-database-vault.html#GUID-D3F37B71-0935-… もっと読む Database Valut

— Oracle —

パラメータファイル

2023-03-24

デフォルトのパラメータファイル名・PFILE（初期化パラメータファイル） init<SID>.ora ・SPFILE（サーバーパラメータファイル） SPFILE<SID>.ora ■優先順位前… もっと読むパラメータファイル

— Linux —

スワップ領域追加

2023-03-05

https://e-penguiner.com/extend-swap-size/ # スワップ領域確認 swapon -s # スワップ用ファイルの作成 fallocate -l 12G /swapfile2 # スワ… もっと読むスワップ領域追加

— Oracle —

rman

2023-01-16

圧縮バックアップと増分バックアップ増分バックアップ

— Oracle —

crsctl

2023-01-15

/u01/app/19.0.0/grid/bin/crsctl status res -t

— Oracle —

srvctl

2023-01-15

■DB起動 srvctl start database -db ptvm srvctl stop database -db ptvms srvctl start instance -db ptvm -instance p… もっと読む srvctl

— Oracle —

PL/SQL

2023-01-15

<span class="kwd">SET</span><span class="pln"> FEEDBACK </span><span class="kwd">OFF</span><span class="pln">
</span><span class="kwd">SET</span><span class="pln"> SERVEROUTPUT </span><span class="kwd">ON</span><span class="pln">
</span><span class="kwd">DECLARE</span><span class="pln">
  </span><span class="kwd">CURSOR</span><span class="pln"> cur_thread </span><span class="kwd">IS</span><span class="pln">
    </span><span class="kwd">SELECT</span><span class="pln"> THREAD</span><span class="pun">#</span><span class="pln"> THREAD</span><span class="pun">,</span><span class="pln"> COUNT</span><span class="pun">(*)</span><span class="pln"> COUNT </span><span class="kwd">FROM</span><span class="pln"> V</span><span class="pun">$</span><span class="pln">LOG </span><span class="kwd">GROUP</span><span class="pln"> </span><span class="kwd">BY</span><span class="pln"> THREAD</span><span class="pun">#;</span><span class="pln">
  standbylog_count NUMBER </span><span class="pun">:=</span><span class="pln"> </span><span class="lit">0</span><span class="pun">;</span><span class="pln">
  standbylog_group NUMBER </span><span class="pun">:=</span><span class="pln"> </span><span class="lit">0</span><span class="pun">;</span><span class="pln">
  standbylog_size NUMBER </span><span class="pun">:=</span><span class="pln"> </span><span class="lit">0</span><span class="pun">;</span><span class="pln">
  last_group_number NUMBER</span><span class="pun">;</span><span class="pln">
  sqlstmt VARCHAR2</span><span class="pun">(</span><span class="lit">200</span><span class="pun">);</span><span class="pln">
</span><span class="kwd">BEGIN</span><span class="pln">
  </span><span class="kwd">SELECT</span><span class="pln"> MAX</span><span class="pun">(</span><span class="kwd">GROUP</span><span class="pun">#),</span><span class="pln"> MAX</span><span class="pun">(</span><span class="pln">BYTES</span><span class="pun">)</span><span class="pln">
</span><span class="kwd">INTO</span><span class="pln"> last_group_number</span><span class="pun">,</span><span class="pln"> standbylog_size
</span><span class="kwd">FROM</span><span class="pln"> V</span><span class="pun">$</span><span class="pln">LOG</span><span class="pun">;</span><span class="pln">
  standbylog_group </span><span class="pun">:=</span><span class="pln"> last_group_number </span><span class="pun">+</span><span class="pln"> </span><span class="lit">1</span><span class="pun">;</span><span class="pln">
  </span><span class="kwd">FOR</span><span class="pln"> rec_thread </span><span class="kwd">IN</span><span class="pln"> cur_thread LOOP
standbylog_count </span><span class="pun">:=</span><span class="pln"> rec_thread</span><span class="pun">.</span><span class="pln">count </span><span class="pun">+</span><span class="pln"> </span><span class="lit">1</span><span class="pun">;</span><span class="pln">
</span><span class="kwd">FOR</span><span class="pln"> i </span><span class="kwd">IN</span><span class="pln"> </span><span class="lit">1.</span><span class="pun">.</span><span class="pln">standbylog_count LOOP
  sqlstmt </span><span class="pun">:=</span><span class="pln"> </span><span class="str">'ALTER DATABASE ADD STANDBY LOGFILE THREAD '</span><span class="pln"> </span><span class="pun">||</span><span class="pln"> rec_thread</span><span class="pun">.</span><span class="pln">thread </span><span class="pun">||</span><span class="pln"> </span><span class="str">' GROUP '</span><span class="pln"> </span><span class="pun">||</span><span class="pln"> TO_CHAR</span><span class="pun">(</span><span class="pln">standbylog_group</span><span class="pun">)</span><span class="pln"> </span><span class="pun">||</span><span class="pln"> </span><span class="str">' SIZE '</span><span class="pln"> </span><span class="pun">||</span><span class="pln"> standbylog_size </span><span class="pun">||</span><span class="pln"> </span><span class="str">';'</span><span class="pun">;</span><span class="pln">
  DBMS_OUTPUT</span><span class="pun">.</span><span class="pln">PUT_LINE</span><span class="pun">(</span><span class="pln"> sqlstmt</span><span class="pun">);</span><span class="pln">
  standbylog_group </span><span class="pun">:=</span><span class="pln"> standbylog_group </span><span class="pun">+</span><span class="pln"> </span><span class="lit">1</span><span class="pun">;</span><span class="pln">
</span><span class="kwd">END</span><span class="pln"> LOOP</span><span class="pun">;</span><span class="pln">
  </span><span class="kwd">END</span><span class="pln"> LOOP</span><span class="pun">;</span><span class="pln">
</span><span class="kwd">END</span><span class="pun">;</span><span class="pln">
</span><span class="pun">/</span><span class="pln">
</span><span class="kwd">SET</span><span class="pln"> FEEDBACK </span><span class="kwd">ON</span><span class="pln">

-----------------------------------------------</span>

SET FEEDBACK OFF

SET SERVEROUTPUT ON

DECLARE

CURSOR cur_thread IS

SELECT THREAD# THREAD, COUNT(*) COUNT FROM V$LOG GROUP BY THREAD#;

standbylog_count NUMBER := 0;

standbylog_group NUMBER := 0;

standbylog_size NUMBER := 0;

last_group_number NUMBER;

sqlstmt VARCHAR2(200);

BEGIN

SELECT MAX(GROUP#), MAX(BYTES)

INTO last_group_number, standbylog_size

FROM V$LOG;

standbylog_group := last_group_number + 1;

FOR rec_thread IN cur_thread LOOP

standbylog_count := rec_thread.count + 1;

FOR i IN 1..standbylog_count LOOP

sqlstmt := 'ALTER DATABASE ADD STANDBY LOGFILE THREAD ' || rec_thread.thread || ' GROUP ' || TO_CHAR(standbylog_group) || ' SIZE ' || standbylog_size || ';';

DBMS_OUTPUT.PUT_LINE( sqlstmt);

standbylog_group := standbylog_group + 1;

END LOOP;

END;

/

SET FEEDBACK ON

-----------------------------------------------

・REDO確認 set lines 120 set pages 100 set term off clear col col GROUP# format … もっと読む PL/SQL

テンプレートサイト

－サンプル、テンプレート－

投稿者: siteadmin_muraoka

Books1

URL

シンボリックリンク(Windows)

Database Valut

パラメータファイル

スワップ領域追加

rman

crsctl

srvctl

PL/SQL