Oracle common problem 1000 asked (one)
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 to see for Oracle masters. 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 to create a database? DBCA 6. What is the bare device in Oracle? Naked equipment is bypassing the file system Access storage space 7. How can oracle distinguish between 64-bit / 32bit version? ? ? $ 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 parting optioning 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. 9i, there is no, it has changed to SQLPlus / Nolog to archive log type 9. How to distinguish which machine is logged in Oracle? Select Machine, Terminal from V $ session; 10. What statement is used inquate? DESC TABLE_NAME You can query 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 the trigger, Process, creation script of function? Desc user_source user_triggers 12. How to calculate the size of the space occupied by a table? 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 do I view the maximum number of sessions? Select * from v $ parameter where name like 'proc%'; SQL> SQL>
Show parameter processes name type value ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------- AQ_TM_Processes Integer 1 db_writer_processes INTEGER 1 JOB_QUE_PROCESS INTEGER 4 log_archive_max_proces INTEGER 1 Processes Integer 200 Here 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 the way ArchiveLog.
Init.ora log_archive_start = True Restart Database 16. How to get any users in using the database Select UserName from V $ session; 17. How much is the maximum number of fields in the data table? How is the maximum number of columns in the table or view? The database's SID? SID? SID? SID? Select Name from V $ database can also be viewed directly. If it is logged in to the local database, you can only return 127.0.0.1, huh, huh 20. How to adjust the time when you adjust the database under UNIX? 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 use the BBB table Update the information of the AAA table (associated field) Update AAA SET BNS_SNM = (SELECT BNS_SNM from bbb.dpt_no) where bbb.dpt_no is not null; 23. P4 computer installation method Change Symcjit.dll For sysmcjit.old 24. Which query Server is OPS? SELECT * FROM V $ Option; if Parallel Server = true has OPS Energy 25. What is the permission for each user? Select * from dba_sys_privs; 26. How to move the table ? table space ALTER tABLE TABLE_NAME mOVE TABLESPACE_NAME; 27. how to move the index table space ALTER iNDEX INDEX_NAME REBUILD tABLESPACE TABLESPACE_NAME;? 28. how to start the DBA STUDIO under LINUX, UNIX oEMAPP dBASTUDIO 29. Object status queries locks have V?? $ LOCK, V $ locked_object, v $ session, V $ SQLAREA, V $ process; Query lock table method: 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_name ||' ('|| 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. Unlock? Alter System Kill Session 'SID, SERIR #'; 31. How to Modify Editor Under SQLPLUS? Define_Editor = "
