/ Oracle EBS

Change user shell on FreeBSD Linux and AIX

參考資料： 這裡

Display user information (FreeBSD):

$pw usershow user_name
user_name:*:1002:1002::0:0:Some User Name:/home/user_name:/bin/sh

You’ll notice that last field (/usr/local/bin/bash) is the shell of the user.
Display user information(AIX):

$ lsuser -a shell root
root shell=/usr/bin/ksh

Change user’s shell on FreeBSD system to bash

$ pw usermod user_name -s /usr/local/bin/bash
$ pw usershow user_name
user_name:*:1002:1002::0:0:Some User Name:/home/user_name:/usr/local/bin/bash

Change user’s shell on Linux

$ chsh -s /bin/bash user_name

Change user shell on AIX

$ chuser shell=/path/to/new/shell root

In this article I’ve used root and user_name users.

You’ll have to use whatever suits your case.

Be careful to what shell you’re changing to because that user (or root in some cases) will not be able to log in if the shell does not exist or is an altered binary file.

/ Oracle EBS

查詢 form session timeout

資料來源：這裡

SELECT disabled_flag,
       TO_CHAR(first_connect, 'MM/DD/YYYY HH:MI:SS') start_time,
       TO_CHAR(SYSDATE, 'HH:MI:SS') current_time,
       user_name,
       session_id,
       ROUND((SYSDATE - last_connect) * 24 * 60) mins_idle,
       fnd_profile.value_specific('ICX_SESSION_TIMEOUT',
                                  a.user_id,
                                  a.responsibility_id,
                                  a.responsibility_application_id,
                                  a.org_id,
                                  NULL) timeout
  FROM icx_sessions a, fnd_user b
 WHERE a.user_id = b.user_id
       AND last_connect > SYSDATE - 1 / 24;
/ Database

SQL 查詢 tablespace

自己組 SQL 來 monitor

SELECT df.tablespace_name TABLESPACE,
       df.max_space_gb max_space_gb,
       df.total_space_gb total_space_gb,
       (df.total_space_gb - fs.free_space_gb) used_space_gb,
       fs.free_space_gb free_space_gb, ROUND(100 * (fs.free_space_gb / df.total_space_gb), 2) pct_free,
       ROUND(100 - 100 * (df.total_space_gb - fs.free_space_gb) / df.max_space_gb, 2) pct_max_free
  FROM (SELECT tablespace_name,
               ROUND(SUM(DECODE(autoextensible, 'YES', maxbytes, bytes)) / 1073741824, 2) max_space_gb,
               ROUND(SUM(bytes) / 1073741824, 2) total_space_gb
          FROM dba_data_files
         GROUP BY tablespace_name) df,
       (SELECT tablespace_name,
               ROUND(SUM(bytes) / 1073741824, 3) free_space_gb
          FROM dba_free_space
         GROUP BY tablespace_name) fs
 WHERE df.tablespace_name = fs.tablespace_name(+)
 ORDER BY fs.tablespace_name;
/ Windows

Portable VirtualBox 使用 bridge 網路連線

隨身攜帶版的 VirtualBox 預設無法使用 bridge 網路連線

使用時, 需依照以下步驟安裝設定網路服務

控制台 => 網路 => 區域網路連線 => 安裝 => 服務 => 從磁片安裝 (選取驅動程式)
Portable-VirtualBox\app64\drivers\network\netflt.inf

vbox_network

安裝後出現 VirtualBox Bridge Network 即可

/ Excel, VBA

以VBA禁用excel工作表中的函數

轉貼資訊來源:

    這裡
1
2
3
4
5
6
7
8
9
10

Sub ChangeFormualToValue()
Dim rng As Range
ActiveSheet.EnableCalculation = False
For Each rng In ActiveSheet.UsedRange
    If rng.HasFormula Then
        rng = rng.Value
    End If
Next
ActiveSheet.EnableCalculation = True
End Sub