Oracle initial parameters and current user operations

Today we are going to discuss with you the initial Oracle parameters and current users. The information I saw on the relevant website two days ago is quite good and I will share it with you. If you are interested, you can click the following articles to view them.

Modify parameter values

 
 

  
  
alter system set db_cache_size=20m; 
 
 

Query parameter values in pl/SQL

 
 

  
  
select * from v$parameter where name='db_cache_size'; 
 
 

Sqlplus

 
 

  
  
show parameter db_block_size; 
 
 

Oracle user permission information

 
 

  
  
select * from user_tab_privs 
 
 

Current User ID

 
 

  
  
select * from sys.V$MYSTAT where rownum =1; 
 
 

Information of all logon persons

 
 

  
  
select * from v$session where sid=154  
 
 

The above content describes the initial Oracle parameters and the current user, hoping to help you in this regard.