Oracle Common Commands

One, Oracle idle time automatic release connection settings

1. Locate the profile file name for the login user, for example, "DEFAULT"

2.ALTER profile "DEFAULT" LIMIT Idle_time 240 (min)

3, alter system set RESOURCE_LIMIT=TRUE Scope=both;

Ii. viewing the number of Oracle processes

Ps-ef | grep Oracle | Wc-l

Iii. ORACLE EBS Turn-off method

Database:

# Su-oravis

$ cd $ORACLE _home/scripts/vis_v480

$./addbctl.sh Start/stop Immediate

$./addlnctl.sh Start/stop VIS

Application:

# Su-applvis

$ cd $INST _top/admin/scripts

$./adstrtal.sh Apps/apps Launch App

$./adstpall.sh Apps/apps Stop Application

Oracle Common Commands