31. How can I modify the editor under sqlplus?
Define _ editor = "<complete path of the editor>" -- you must add double quotation marks to define the new editor. You can also write this in $ ORACLE_HOME/sqlplus/admin/glogin. SQL to make it permanently valid.
32. What are the random functions generated by Oracle?
Dbms_random.random
33. What is the command for querying disk competition conditions in Linux?
Sar-d
33. What is the command for querying CPU competition conditions in Linux?
Sar-R
34. query the current user object?
Select * From user_objects;
Select * From dba_segments;
35. How to Get error information?
Select * From user_errors;
36. How do I obtain the link status?
Select * From dba_db_links;
37. Check the database character status?
Select * From nls_database_parameters;
Select * from V $ nls_parameters;
38. query table space information?
Select * From dba_data_files;
39. Do Oracle interal users need a password?
Modify sqlnet. ora
Sqlnet. authentication_services = (CNT)
40. How can I solve the problem of Java. EXE?
Generally, you can change oracleorahomexihttpserver to manual activation.
X is 8 or 9