Everyone may encounter a lot of problems that seem to be difficult, especially for novices, today I will summarize it, release it to everyone, I hope to help everyone! Discuss with everyone, and make progress together!
It is not used by Oracle masters.
1. Initial password after the Oracle installation? Internal / Oracle
SYS / CHANGE_ON_INSTALL
System / Manager
Scott / Tiger
SYSMAN / OEM_TEMP
2. Oracle9ias web cache's initial default user and password? Administrator / Administrator
3. ORACLE 8.0.5 How to create a database? Use ORAINST. If there is a MotiF interface, you can use ORAINST / M
4. Oracle 8.1.7 How to create a database? DBASSIST
5. How do Oracle 9i creates a database? DBCA
6. What is the bare equipment in Oracle? Bare equipment is the storage space that bypasses the file system directly access.
7. How can Oracle distinguish between 64-bit / 32bit versions? ? ?
$ SQLPLUS / AS SYSDBA
SQL * Plus: Release 9.0.1.0.0 - Production ON MON JUL 14 17:01:09 2003
(c) CopyRight 2001 Oracle Corporation. All Rights Reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production
WITH THE PartInog Option
JServer Release 9.0.1.0.0 - Production
SQL> SELECT * FROM V $ VERSION;
Banner
-------------------------------------------------- ----------------
Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production
PL / SQL Release 9.0.1.0.0 - Production
Core 9.0.1.0.0 Production
TNS for Solaris: Version 9.0.1.0.0 - Production
NLSRTL Version 9.0.1.0.0 - Production
SQL>
8. What does SVRMGR mean? SVRMGRL, Server Manager.
No, there is no, it has been changed to use SQLPLUS.
SQLPlus / NOLOG
Type of archived
9. How do I distinguish which machine login from Oracle? Select Machine, Terminal from V $ session;
10. Using Shi language query fields? DESC TABLE_NAME can look up the structure of the table
SELECT FIELD_NAME, ... from ... You can query the value of the field
Select * from all_tables where Table_name LIKE%
SELECT * from ALL_TAB_COLUMNS Where TABLE_NAME = ??
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 to view the maximum number of sessions? Select * from V $ Parameter Where name Like Proc%;
SQL>
SQL> Show Parameter Processes
Name Type Value
------------------------------------- -----------------------
AQ_TM_PROCESS INTEGER 1
DB_Writer_Processes INTEGER 1
Job_Queue_Processes INTEGER 4
LOG_ARCHIVE_MAX_PROCESSSS INTEGER 1
Processes Integer 200
Here 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 ArchiveLog.
Init.ora
LOG_ARCHIVE_START = TRUE
Restart Database
16. How do you get any users in using the database Select UserName from V $ session;
17. What is the maximum number of fields in the data sheet? The maximum number of columns in the table or view is 1000
18. How to find the SID? Select Name from V $ Database for the Database;
You can also view the init.ora file directly.
19. How to view this machine IP address via SQLPlus on an Oracle server? Select sys_context (useerenv, ip_address) from dual;
If it is logging in to the local database, you can only return 127.0.0.1, huh, huh
20. How do I adjust the time when IIIX? Su -root
Date -u 08010000
21. How to capture the MEMO type field in Oracle Table is an empty data record? Select Remark from OMS_FlowRec Where Trim (from remark) is not null;
22. How to update the information of the AAA table (associated field) Update AAA SET BNS_SNM = (SELECT BNS_SNM from BBB WHERE AAA.DPT_NO = BBB.DPT_NO) Where bbb.dpt_no is not null;
23. P4 Computer installation method change symcjit.dll to sysmcjit.old
24. Which query server is OPS? SELECT * FROM V $ OPTION;
If Parallel Server = True has OPS
25. What is the permission for each user? SELECT * from DBA_SYS_PRIVS;
26. How to move the table space? Alter Table Table_name Move TableSpace_name;
27. How to use the index mobile table space? Alter index index_name rebuild tablepace tablesspace_name;
28. How to activate DBA Studio? Oemapp DBASTUDIO under Linux, Unix?
29. The subject of query lock is available? V $ LOCK, V $ locked_Object, V $ Session, V $ SQLAREA, V $ Process;
Query locks: Select S.SID session_id, S.Username, Decode (LMODE, 0, NONE, 1, NULL, 2, ROW-S (SS), 3, Row-X (SX), 4, Share , 5, S / Row-x (SSX), 6, Exclusive, TO_CHAR (LMODE)) MODE_HELD, DECODE (Request, 0, None, 1, NULL, 2, ROW-S (SS), 3, ROW-X ( SX), 4, Share, 5, S / ROW-X (SSX), 6, Exclusive, To_Char (Request)) mode_requested, o.owner || || (|| O.Object_type || ), S.Type Lock_type, L.ID1 LOCK_ID1, L.ID2 LOCK_ID2 from V $ LOCK L, SYS.DBA_OBJECTS O, V $ session s where l.sid = s.SID and L.ID1 = O.Object_ID;
30. How to unlock? Alter System Kill Session 'SID, Serir #';
31. How to modify the editor under SQLPLUS? Define _Editor = " 32. Oracle generates a random function? DBMS_Random.random 33. Query Disk Competition Commands under Linux? SAR -D 33. Query the CPU competition under Linux? 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_erro 36. How to get link conditions? Select * from DBA_DB_LINKS; 37. View the status of database characters? Select * from NLS_DATABASE_PARAMETERS; Select * from V $ NLS_PARAMETERS; 38. Query the table space information? Select * from DBA_DATA_FILES; 39. Oracle's intend user wants a password? Modify SQLNET.ORA SQLNET.AUTHENTICATION_SERVICES = (NTS) 40. What is the solution to Java.exe? Generally, OracleraHomexihttpserver is changed to hand-activated. X is 8 or 9 41. How to give a list, column incorporation? SQL> Comment on Table Table IS Table Note; Comments have been created. SQL> Comment on column table. Column IS column annotation; comment has been created. SQL> SELECT * from user_tab_comments where comments is not null; 42. How do I check the condition of each table space? SQL> COL TABLESPACAT A20 SQL> SELECT B.File_ID file ID number, B. TableSpace_name table space name, B.bytes bytes, (B.bytes-sum (NVL (A.BYTES, 0))))) SUM (NVL (A.BYTES, 0))) remaining space, SUM (NVL (A.BYTES, 0)) / (B.BYTES) * 100 remaining percentage From DBA_FREE_SPACE A, DBA_DATA_FILES B WHERE A.FILE_ID = B.file_idgroup by b.tablespace_name, b.file_id, B.BYTES ORDER by b.file_id 43. If the Oracle is set to MTS or dedicated mode? #dispatches = "(Service = tcp)" Plus is MTS, the comment is a dedicated mode, and the SID refers to your instance name. 44. How can I know the current SCN number of the system? SELECT MAX (KTuxescnw * Power (2, 32) KTuxescnb) from x $ ktuxe; 45. How do I get milliseconds in Oracle? No support before 9i, 9i starts with TimeStamp. 9i can use Select SystimeStamp from Dual; If you have any questions, please discuss it! ----------- Transferred Http://www.net130.com ----------------------------------------
