摘要:
oracle查看字符集 ``` select * from v$nls_parameters where parameter = 'NLS_CHARACTERSET' select * from v$nls_parameters where parameter = 'NLS NCHAR CHARAC 阅读全文
摘要:
col sid format 9999 col spid format 9999999999 col serial# format 9999999 col logon_time format a20 col machine format a30 col terminal format a20 set 阅读全文
摘要:
oracle 11g开机自启动 vi /etc/oratab PROD:/u01/app/oracle/product/11.2.0/dbhome_1:Y vi /etc/rc.d/rc.local su - oracle -lc "/u01/app/oracle/product/11.2.0/db 阅读全文
摘要:
ADDR:进程地址,与v$session中PADDR对应 PID:Oracle进程标识符 SPID:操作系统的进程ID PNAME:进程名称 USERNAME:操作系统进程的用户名,不是Oracle用户名 SERIAL#:**进程**序列号 TERMINAL:操作系统的终端标识符 PROGRAM:当 阅读全文
摘要:
v$session常用字段如下 SID SERIAL# SPID SQL_ID STATUS ROW_WAIT_OBJ# BLOCKING_SESSION_STATUS ![](https://img2023.cnblogs.com/blog/2191731/202306/2191731-20230 阅读全文
摘要:
``` SQL> desc v$session; Name Null? Type SADDR RAW(8) SID NUMBER SERIAL# NUMBER AUDSID NUMBER PADDR RAW(8) USER# NUMBER USERNAME VARCHAR2(30) COMMAND 阅读全文
摘要:
expdp expuser/oracle parfile=exptable.par content=metadata_only cluster=n 编辑exptable.par文件 more exptable.par dumpfile=mdm.dmp logfile=mdm.log schemas= 阅读全文
摘要:
示例参数max_connections select * from pg_settings where name='max_connections'; -[ RECORD 1 ] + name | max_connections setting | 14 unit | category | Conn 阅读全文
摘要:
#include <stdio.h> #include <stdlib.h> void main() { int data[20]={0}; int *p=data; int i; for(i=0;i<5;i++) { data[i]=i+1; printf("第%d个元素的值为%d ",i+1,d 阅读全文
摘要:
配置OEM之前修改密码 alter user SYSMAN identified by "password"; alter user DBSNMP identified by "password"; emca -repos create创建 [oracle@test ~]$ emca -repos 阅读全文