Oracle problem, 10 questions every day (four)

xiaoxiao2021-03-05  18

31. How to modify the editor under SQLPLUS? Define _Editor = "" . SQL is permanently valid. 32. Oracle generates a random function is? DBMS_Random.random 33. LINUX Query disk competition status command? SAR -D 33. Linux Query CPU competition status command? SAR -R 34. Query the current user object? Select * from user_Objects; SELECT * From DBA_SEGMENTS; 35. How to get an error message? Select * from user_errors; 36. How to get a link situation? 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. ORACLE's INTERAL user to modify the password SQLNET.ORA SQLNET.AUTHENTICATION_SERVICES = (NTS? 40. Solutions in Java.exe appear? Generally, the OracleraHomexihttpserver is changed to hand-activated X is 8 or 9

转载请注明原文地址:https://www.9cbs.com/read-38884.html

New Post(0)