Lyphtesttest SQL of System session

--Stop Session Select A.object, B.sid, b.serial# from SYS. V_$access A, SYS. V_$session b where a.type = ' PROCEDURE ' and (A.object like Upper ('%e_hoshitori% ') or a.object like lower ('%e_hoshito ri% ') and A.sid = B.sid and b.status = ' ACTIVE ';

--Stop session--alter system kill session ' 539,13863 ';

--All TABLE COL SELECT TAB. TABLE_NAME table physical name, tab_c.comments table name, COL. column_nameコラム physical name, col_c.commentsコラム name, COL.   column_id from User_tables TAB, user_tab_comments Tab_c, User_tab_columns COL, user_col_comments COL_C WHERE TAB. table_name = Tab_c.table_name and TAB. table_name = COL. TABLE_NAME and COL. table_name = Col_c.table_name and COL. COLUMN_NAME = Col_c.column_name and TAB. table_name not LIKE '%bak% '--bak TABLE and TAB. table_name not LIKE '%_20% '--bak TABLE and TAB. table_name ' view% '--view ORDER by Tab_c.comments, COL. column_id;

--? See all the use?

SELECT * from All_users; -------? See all the use?

SELECT * from User_users; --------? look at the current use?

--2.? What do you think of the role system? Limit:

SELECT * from User_sys_privs; --------? look at the current limit of use?

--3.? Look at the limits of what the character contains.

SELECT * from Role_sys_privs; -------

--4.? Look at the use?? Elephant limit

SELECT * from All_tab_privs; --------? See the operational table for use? SELECT * from User_tab_privs; --------? See the current table can be operated?

--5.? Look at the role or role

SELECT * from User_role_privs; ------? see the role of current use?

--? look at the table? Bundle conditions include: main? Outside? and index

SELECT * from user_constraints where table_name= '?    ‘; -----? See the bundle of a table?

Select Constraint_type,constraint_name,search_condition from all_constraints where Table_name= '? ‘;

SELECT * from User_cons_columns where table_name= '?   ‘; -----One of the bundles?

Select Index_name,index_type,status,blevel from user_indexes where table_name = '?   ‘; -----? See all indexes on a table

SELECT table_name, index_name, COLUMN_NAME, column_position from User_ind_columns WHERE table_name= '?    ‘; ----? look at the index?

Lyphtesttest SQL of System session