11. How to get a trigger, process, and function creation script? DESC User_Source User_Triggers
12. How to calculate the size of a space occupied? 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 you want to check 13 How do I view the maximum number of sessions? Select * from v $ parameter where name limited 'proc%'; SQL> SQL> Show parameter processes name type value -------------------------- ---------- ---------------------------------- AQ_TM_Processes INTEGER 1 DB_Writer_Proces INTEGER 1 JOB_QUE_PROCESS INTEGER 4 log_archive_max_processes INTEGER 1 Processes Integer 200 is 200 users. Select * from V $ license; where the sessions_highwater record has reached the maximum number of sessions
14. How do I check the system locked transaction time? Select * from V $ locked_Object; 15. How to run Oracle in the way ArchiveLog. Init.ora log_archive_start = True Restart Database 16. How to get what users use database Select UserName from V $ session; 17. What is the maximum number of fields in the data table? The maximum number of columns in the table or view is 1000 18. How to find the SID? SID? Select Name from V $ Database in the database; you can also view the init.ora file directly. If it is logged to the local database, you can only return 127.0.0.1, huh, huh 20. How do I adjust the database for UNIX? Su -root Date -u 08010000
