Oracle issues, 10 questions per day (ii)

oracle| problem
11. How to get trigger, procedure, function creation script? Desc User_source user_triggers

12. How to calculate the size of the space occupied by a table? 　　Select Owner,table_name, Num_rows, blocks*aaa/1024/1024 "Size M", Empty_blocks, last_analyzed from Dba_tables 　　where table_name= ' XXX '; 　　HERE:AAA is the value of db_block_size; XXX is the table name for you want to check 13.　　How do I see the maximum number of sessions?　　SELECT * from V$parameter WHERE NAME like ' proc% '; sql> sql> Show parameter Processes NAME TYPE VALUE--------------------------------------------------------- ----------------aq_tm_processes integer 1 db_writer_processes integer 1 job_queue_processes integer 4 log_archive　　_max_processes integer 1 Processes integer 200 is here for 200 users. 　　SELECT * from V$license; The maximum number of sessions that Sessions_highwater records ever reached

14. How can I view the transaction time when the system is locked?　　SELECT * from V$locked_object;　　15. How to run Oracle in a archivelog manner. Init.ora Log_archive_start = True restart DATABASE 16.　　How to obtain which users are using the database select username from v$session;　　17. What is the maximum number of fields in the datasheet? The maximum number of columns in a table or view is 1000 18.　　How do I find the SID of the database? 　　Select name from V$database; You can also view Init.ora file 19 directly.　　How do I view a native IP address on an Oracle server by Sqlplus?　　Select Sys_context (' Userenv ', ' ip_address ') from dual; If you are landing the local database, you can only return 127.0.0.1, hehe 20.　　How do I adjust the time of the database under UNIX? Su-root Date-u 08010000