PIXNET Logo登入

DanBrother的部落格

跳到主文

歡迎光臨DanBrother在痞客邦的小天地. 部落格文章同步於=> http://blog.xuite.net/gem083/dba

部落格全站分類：數位生活

  • 相簿
  • 部落格
  • 留言
  • 名片
  • 8月 02 週三 201718:20

  • Oracle Session Control Shell Script (BASH)

Oracle Session Control Shell Script (BASH)
session_control.sh
>>
###########################################################################################################
#!/bin/bash
# This script will allow you to choose whether to enable or disable restricted sessions in TESTDB Database.
###########################################################################################################
echo "************************************"
echo "* Database Session Control Program *"
echo "************************************"
echo "1) Enable Restricted Session."
echo "2) Disable Restricted Session."
read -p "Please specify your option: " option
export ORACLE_SID=TESTDB
case $option in
     1)
         sqlplus -s "/ as sysdba" @session_control.sql ENABLE ;;
     2)
         sqlplus -s "/ as sysdba" @session_control.sql DISABLE ;;
esac
session_control.sql
>>
SET ECHO OFF SERVEROUTPUT ON FEEDBACK OFF VERIFY OFF
DECLARE
v_action constant varchar2(10):='&1';
BEGIN
  execute immediate 'ALTER SYSTEM '||v_action||' RESTRICTED SESSION';
(繼續閱讀...)
文章標籤

DanBrother 發表在 痞客邦 留言(0) 人氣(19)

  • 個人分類：Oracle in General
▲top
  • 2月 18 週六 201715:28

  • Oracle 12c “In-Database Archiving” Practice

Oracle 12c “In-Database Archiving” Practice
“In-Database Archiving” in Oracle 12c allows particular rows to be marked for deletion instead of physically deleting the rows.
(繼續閱讀...)
文章標籤

DanBrother 發表在 痞客邦 留言(0) 人氣(18)

  • 個人分類：Oracle in General
▲top
  • 12月 19 週一 201618:11

  • Oracle 12c Data Redaction Example

redaction_pic1.jpg
Oracle 12c Data Redaction Example
Create a test sample data as follows:
(繼續閱讀...)
文章標籤

DanBrother 發表在 痞客邦 留言(0) 人氣(71)

  • 個人分類：Oracle in General
▲top
  • 1月 27 週三 201614:56

  • Manual Installation of Oracle 12c (12.1.0.2) Sample Schemas

Manual Installation of Oracle 12c (12.1.0.2) Sample Schemas
Download linuxamd64_12c_examples.zip from:
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/database12c-linux-download-2240591.html
(繼續閱讀...)
文章標籤

DanBrother 發表在 痞客邦 留言(0) 人氣(81)

  • 個人分類：Oracle in General
▲top
  • 1月 13 週三 201617:36

  • Oracle 12c In-Memory Table Practice

Oracle 12c In-Memory Table Practice
[oracle@testsvr admin]$ . oraenv
(繼續閱讀...)
文章標籤

DanBrother 發表在 痞客邦 留言(0) 人氣(80)

  • 個人分類：Oracle in General
▲top
  • 1月 12 週二 201615:44

  • Plugin an Oracle 12c non-CDB database to an Oracle 12c Container Database (CDB)

Plugin an Oracle 12c non-CDB database to an Oracle 12c Container Database (CDB)
PS. This non-CDB database is an Oracle 12g database upgraded from Oracle 11gR2 using DBUA (Database Upgrade Assistant) in the same machine.


1. Restart the non-CDB database (TESTDB) in READ-ONLY mode
(繼續閱讀...)
文章標籤

DanBrother 發表在 痞客邦 留言(0) 人氣(38)

  • 個人分類：Oracle in General
▲top
  • 6月 17 週二 201411:46

  • How to stop the Gather Stats Job in Oracle?

How to stop the Gather Stats Job in Oracle?
Answer:
-- For Oracle 10g (10.2.0.4) or higher
( Log in as SYS )
exec dbms_scheduler.disable('GATHER_STATS_JOB',TRUE);
-- For Oracle 11g (11.1.0.7) or higher
( Log in as SYS )
exec dbms_auto_task_admin.disable('auto optimizer stats collection',null,null);
(繼續閱讀...)
文章標籤

DanBrother 發表在 痞客邦 留言(0) 人氣(50)

  • 個人分類：Oracle in General
▲top
  • 6月 11 週三 201415:24

  • Create Oracle Jobs using DBMS_SCHEDULER Package

Create Oracle Jobs using DBMS_SCHEDULER Package
 
Privileges required for creating or managing job schedulers:
a. create job (for regular user)
b. manage scheduler (for database administrator)
sqlplus / as sysdba
grant create job, manage scheduler to TESTUSER;
(繼續閱讀...)
文章標籤

DanBrother 發表在 痞客邦 留言(0) 人氣(26)

  • 個人分類：Oracle in General
▲top
  • 4月 23 週三 201411:56

  • Solving Number Data Type Display Issue (Scientific Notation) in PL/SQL Developer

Solving Number Data Type Display Issue (Scientific Notation) in PL/SQL Developer:
Issue:
In PL/SQL Developper, when the column data type is number and the data value have more than 15 digits, the query result becomes scientific notation.

e.g.
select to_number('999999999999999')  as "15 Digits" from dual;
>> -- would be fine
999999999999999
select to_number('9999999999999990')  as "16 Digits" from dual;
>> -- would become scientific notation
9.99999999999999E15
(繼續閱讀...)
文章標籤

DanBrother 發表在 痞客邦 留言(0) 人氣(23)

  • 個人分類：Oracle in General
▲top
  • 2月 17 週一 201412:22

  • Oracle Useful Views for identifying Blocking Sessions

Oracle Useful Views for identifying Blocking Sessions
DBA_BLOCKERS display a session if it is not waiting for a locked object but is holding on an object for which another session is waiting.
In an Oracle RAC environment, this only applies if the blocker is on the same instance.
DBA_WAITERS shows all the sessions that are waiting for a lock.
(繼續閱讀...)
文章標籤

DanBrother 發表在 痞客邦 留言(0) 人氣(13)

  • 個人分類：Oracle in General
▲top
12...12»

廣告

個人資訊

DanBrother
暱稱：
DanBrother
分類：
數位生活
好友：
累積中
地區：

熱門文章

  • (58,073)祝福禱告文-為工作祝福
  • (49,259)Excel 2007 中文字顯示亂碼之修復步驟
  • (2,928)ORA-24247: 存取控制清單 (ACL) 拒絕網路存取
  • (626)OSQL公用程式的使用方法
  • (136)crsctl command usage
  • (84)Oracle 11.2.0.3 Grid Infrastructure ora.diskmon shows OFFLINE
  • (83)ORA-15306: ASM Password File Update Failed On At Last One Node
  • (15)DB_FILE_MULTIBLOCK_READ_COUNT
  • (6)SQL Server 2005 Reporting Services Permission Settings for Viewing Reports
  • (5)RPM & SRPM

文章分類

  • Android (1)
  • Java (1)
  • MongoDB (1)
  • MariaDB (7)
  • Python (10)
  • HTML (1)
  • ORDS (1)
  • Apache Tomcat (1)
  • Oracle Streams (1)
  • Javascript (1)
  • Oracle Data Guard (2)
  • Oracle VirtualBox (3)
  • Grid Infrastructure (4)
  • Oracle SQL Tuning (6)
  • OEM11g / 12c (28)
  • IT Links (1)
  • 心靈饗宴 (161)
  • Oracle Clusterware (5)
  • ORACLE RAC (21)
  • Oracle ASM (18)
  • Oracle Export/Import (10)
  • MySQL (22)
  • Windows Series (18)
  • Oracle HTTP Server (8)
  • Linux (49)
  • Microsoft Office (6)
  • SQL SERVER (19)
  • Install Apache & PHP (2)
  • Oracle in General (111)
  • RMAN (15)
  • SQL / PL/SQL (30)
  • 未分類文章 (1)

最新文章

  • MySQL Array Simulation in Stored Procedure
  • Extracts, orders, and then prints grants for MySQL user accounts (pt-show-grants)
  • MySQL Stored Procedure - Nested Loop Example
  • Metabase H2 DB Migration to MySQL 5.7
  • Steps for Upgrading Percona-Toolkit to the Latest Version
  • MySQL Slave - Skip Replication for A Particular Table
  • MySQL - Export & Import Table Data Based on the SQL Query
  • MySQL Table Fragmentation Detection and De-fragmentation Implementation
  • Multiple Log File Viewer (Linux Bash)
  • Solving MySQL slave lag Issues

最新留言

  • [21/08/16] jwang0189 於文章「祝福禱告文-為工作祝福...」留言：
    非常實用的文章，謝謝提供，已點廣告表示支持 https://...
  • [20/04/23] 廣利 於文章「祝福禱告文-為工作祝福...」留言：
    129:8 過路的也不說，願耶和華所賜的福，歸於你們；我們在...
  • [17/10/30] 66國語言翻譯公司 於文章「Download Google Chro...」留言：
    不了走會點中見你隻有果新家而去十走相隻把見作樣 ９5國...
  • [17/05/06] 50國語言翻譯公司 於文章「Python >>> a, b = b...」留言：
    之的不會然文道果三那大這年來來年物月用理學， 11５國...
  • [16/10/13] KK 於文章「How to Change Defaul...」留言：
    感謝您分享的工作禱詞! 真的太感謝了!! 願 平安...
  • [15/08/23] 洪秀柱 於文章「如何在UltraEdit中正常顯示韓文?...」留言：
    此破解法可用於 UEstudio UltraEdit V2...

動態訂閱

文章精選

文章搜尋

誰來我家

參觀人氣

  • 本日人氣：
  • 累積人氣：

留言板