Oracle questions, 10 questions every day (4)

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