Oracle issues, 10 questions per day (vii)

oracle| problem
61. How do I see what programs are running in Oracle? View V$sessions Table

62. How many tablespace can you see in the database?　　SELECT * from Dba_tablespaces;　　63. How do I modify the number of user connections for an Oracle database? Modify the Initsid.ora to enlarge the process and restart the database. 64.　　How do I find out when a record was last updated? You can use Logminer to see 65.　　How do I read and write files in Pl/sql?　　The Utl_file package allows users to read and write operating system files through Pl/sql.　　66. How to Put "&" in a record?　　Insert into a values (translate (' at{&}t ', ' at{} ', ' at '));　　How does EXP add query parameters? EXP user/pass file=a.dmp TABLES (BSEMPMS) query= ' WHERE emp_no=\ ' s09394\ ' \ ';68.　　About oracle8i support for simplified and traditional character set issues? ZHS16GBK can support 69.　　What is Data guard software? is standby's replacement product 70.　　How do I create a spfile? 　　sql> connect/as sysdba sql> select * from V$version; 　　Sql> create Pfile from SPFile; 　　Sql> CREATE SPFILE from pfile= ' E:\ora9i\admin\eygle\pfile\init.ora '; 　　The file has been created. sql> CREATE spfile= ' E:\ora9i\database pfileeygle. 　　　　ORA ' from pfile= ' E:\ora9i\admin\eygle\pfile\init.ora '; The file has been created.