alter session set ATR=*****请问DBA改其他用户的Session参数,如何指定Session,让修改的Session正确,不是kill session.下面语句行不?
alter session 'SID,SERIAL#' set ATR=*****
alter session 'SID,SERIAL#' set ATR=*****
解决方案 »
- oracle数据库登陆有户名有小数点,提示账户被锁定
- 查找问题,求高手帮忙~!
- oracle中我想創建trigger來實現一個功能,可是執行到trigger中的select語句時老報錯,請教高手!
- oracle 用loop遍历游标,每次总会多走一遍的问题。。。什么情况- -@
- PL/SQL Developer连接不上oracle数据库
- 请教一个关于oracle数据库同步(复制)的问题!???急!!!!
- 初学者的问题
- 请问怎么在oracle中定义自增型字段?
- 哪位大虾在SQL LOADER 里面用过case语句,他的语法是怎么样的
- 运行Oracle9i的机器配置问
- export一个大表时报oracle-01555错误如何解决
- 请问SQL中 WHERE T1.ID(+) = T2.ID是啥意思?
ASM_POWER_LIMIT
COMMIT_WRITE
CREATE_STORED_OUTLINES
In earlier releases, CREATE_STORED_OUTLINES was a session parameter only.
CURSOR_SHARING
See also Oracle Database Performance Tuning Guide for information on setting this parameter in these and other environments.
DB_BLOCK_CHECKING
The setting made by ALTER SESSION SET DB_BLOCK_CHECKING will be overridden by any subsequent ALTER SYSTEM SET DB_BLOCK_CHECKING statement.
DB_CREATE_FILE_DEST
--
DB_CREATE_ONLINE_LOG_DEST_n
--
DB_FILE_MULTIBLOCK_READ_COUNT
--
DB_FILE_NAME_CONVERT
--
DDL_WAIT_FOR_LOCKS
--
GLOBAL_NAMES
See "Referring to Objects in Remote Databases" and Oracle Database Heterogeneous Connectivity Administrator's Guide for more information on global name resolution and how Oracle Database enforces it.
HASH_AREA_SIZE
--
LOG_ARCHIVE_DEST_n
--
LOG_ARCHIVE_DEST_STATE_n
--
LOG_ARCHIVE_MIN_SUCCEED_DEST
--
MAX_DUMP_FILE_SIZE
--
Globalization Support (NLS_) Parameters:
When you start an instance, Oracle Database establishes globalization support based on the values of initialization parameters that begin with "NLS". You can query the dynamic performance table V$NLS_PARAMETERS to see the current globalization attributes for your session. For more information about NLS parameters, see Oracle Database Globalization Support Guide.
NLS_CALENDAR
--
NLS_COMP
--
NLS_CURRENCY
--
NLS_DATE_FORMAT
See "Datetime Format Models" for information on valid date format models.
NLS_DATE_LANGUAGE
--
NLS_DUAL_CURRENCY
See "Number Format Models" for information on number format elements.
NLS_ISO_CURRENCY
--
NLS_LANGUAGE
--
NLS_LENGTH_SEMANTICS
--
NLS_NCHAR_CONV_EXCP
--
NLS_NUMERIC_CHARACTERS
--
NLS_SORT
--
NLS_TERRITORY
--
NLS_TIMESTAMP_FORMAT
--
NLS_TIMESTAMP_TZ_FORMAT
--
OBJECT_CACHE_MAX_SIZE_PERCENT
--
OBJECT_CACHE_OPTIMAL_SIZE
--
OLAP_PAGE_POOL_SIZE
--
OPTIMIZER_DYNAMIC_SAMPLING
See Oracle Database Performance Tuning Guide for information on how to set this parameter.
OPTIMIZER_FEATURES_ENABLE
--
OPTIMIZER_INDEX_CACHING
--
OPTIMIZER_INDEX_COST_ADJ
--
OPTIMIZER_MODE
See Oracle Database Concepts and Oracle Database Performance Tuning Guide for information on how to choose a goal for the cost-based approach based on the characteristics of your application.
PARALLEL_INSTANCE_GROUP
--
PARALLEL_MIN_PERCENT
--
PLSQL_CCFLAGS
PLSQL_CODE_TYPE
--
PLSQL_COMPILER_FLAGS
--
PLSQL_DEBUG
--
PLSQL_OPTIMIZE_LEVEL
--
PLSQL_V2_COMPATIBILITY
--
PLSQL_WARNINGS
--
QUERY_REWRITE_ENABLED
--
QUERY_REWRITE_INTEGRITY
--
RECYCLEBIN
--
REMOTE_DEPENDENCIES_MODE
--
RESUMABLE_TIMEOUT
--
SESSION_CACHED_CURSORS
--
SKIP_UNUSABLE_INDEXES
--
SMTP_OUT_SERVER
--
SORT_AREA_RETAINED_SIZE
--
SORT_AREA_SIZE
--
SQL_TRACE
--
SQLTUNE_CATEGORY
--
STAR_TRANSFORMATION_ENABLED
--
STATISTICS_LEVEL
--
TIMED_OS_STATISTICS
--
TIMED_STATISTICS
--
TRACEFILE_IDENTIFIER
--
WORKAREA_SIZE_POLICY
--
exec sys.dbms_system.set_int_param_in_session(sid =>8,serial#=>3,parnam => 'max_dump_file_size',intval => 2147483647);按照上边的格式自己修改你要修改的参数