1. What is the initial password after Oracle is installed?
Internal/oracle
Sys/change_on_install
System/manager
Scott/tiger
Sysman/oem_temp
2. What is the initial Default User and password of ORACLE9I as web cache?
Administrator/administrator
3. How to Create a database in oracle 8.0.5?
Use orainst. If there is a motif interface, you can use orainst/m
4. How to Create a database in oracle 8.1.7?
Dbassist
5. How to Create a database in oracle 9i?
Dbca
6. What does bare device in oracle mean?
A bare device is a storage space that is directly accessed by bypassing the file system.
7. How Does oracle differentiate between 64-bit and 32bit versions?
C:> sqlplus sys/qaz @ dagl as sysdba
SQL * Plus: Release 10.1.0.2.0-Production on Friday June 3 13:47:47 2011
Copyright (c) 1982,200 4, Oracle. All rights reserved.
Connected:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0-Production
With the Partitioning, OLAP and Data Mining options
SQL> select * from v $ version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0-Prod
PL/SQL Release 10.1.0.2.0-Production
CORE 10.1.0.2.0 Production
TNS for 32-bit Windows: Version 10.1.0.2.0-Production
NLSRTL Version 10.1.0.2.0-Production
8. What does SVRMGR mean?
Svrmgrl, not under Server Manager 9i. It has been changed to SQLPLUS.
Change sqlplus/nolog to archive log type
9. How can I tell from which machine a user logs on to ORACLE?
SQL> SELECT machine, terminal FROM V $ SESSION;
10. What statements are used to query fields?
Desc table_name: You can query the table structure.
Select field_name,... from... can query the field value
Select * from all_tables where table_name like %
Select * from all_tab_columns where table_name = ??
11. How can I obtain the script for creating triggers, processes, and functions?
Desc user_source
User_triggers
12. How do I calculate 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?
SQL> SELECT * FROM V $ PARAMETER WHERE NAME LIKE proc %;
SQL> show parameter processes
NAME TYPE VALUE
-------------------------------------------------------------------------
Aq_tm_processes integer 1
Db_writer_processes integer 1
Job_queue_processes integer 4
Log_archive_max_processes integer 1
Processes integer 200
There are 200 users.
Select * from v $ license;
Sessions_highwater records the maximum number of sessions that have been reached.
14. How can I view the transaction time locked by the system?
Select * from v $ locked_object;
15. How to run oracle in archivelog mode?
Init. ora
Log_archive_start = true
RESTART DATABASE
16. How to obtain which users are using the database?
Select username from v $ session;
17. What is the maximum number of fields in the data table?
The maximum number of columns in a table or view is 1000.
18. How can I find the database SID?
SQL> select name from v $ database;
You can also directly view the init. ora file.
19. How can I view the local IP address through SQLPLUS on the Oracle server?
SQL> select sys_context (userenv, ip_address) from dual;
If you log on to the local database, you can only return 127.0.0.1
20. How can I adjust the database time in UNIX?
Su-root
Date-u 08010000
21. In oracle table, how do I capture data records that are empty in the MEMO column?
Select remark from oms_flowrec where trim (from remark) is not null;
22. How to Use BBB table data to update AAA table data (associated fields)
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. How do I query the SERVER? Is it OPS?
SQL> SELECT * FROM V $ OPTION;
If parallel server = TRUE, OPS can
25. How can I query the permissions of each user?
SELECT * FROM DBA_SYS_PRIVS;
26. How do I move a table tablespace?
Alter table TABLE_NAME MOVE TABLESPACE_NAME;
27. How can I move an index to a tablespace?
Alter index INDEX_NAME rebuild tablespace TABLESPACE_NAME;
28. In LINUX and UNIX, how does one start dba studio?
OEMAPP DBASTUDIO
29. Which of the following objects can query the lock status?
V $ LOCK, V $ LOCKED_OBJECT, V $ SESSION, V $ SQLAREA, V $ PROCESS;
To query a locked table:
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. How to unlock it?
Alter system kill session 'sid, SERIR #';
31. How can I modify the editor under SQLPLUS?
DEFINE _ EDITOR = "<full 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. How Does ORACLE generate random numbers?
DBMS_RANDOM.RANDOM
SQL> select dbms_random.random from dual;
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?
SQL> SELECT * FROM USER_ERRORS;
36. How do I obtain the link status?
SQL> SELECT * FROM DBA_DB_LINKS;
37. Check the database character status?
SQL> SELECT * FROM NLS_DATABASE_PARAMETERS;
SQL> SELECT * FROM V $ NLS_PARAMETERS;
38. query table space information?
SQL> 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 oracleorahomihttpserver to manual start, and X is 8 or 9.
41. How do I add comments to tables and columns?
SQL> comment on table is table comment;
Note created.
SQL> comment on column table. column is column comment;
Note created.
SQL> select * from user_tab_comments where comments is not null;
42. How can I view the disk usage of each tablespace?
SQL> col tablespace format a20
SQL> select B. file_id File ID, B. tablespace_name tablespace name, B. bytes, (B. bytes-sum (nvl (. bytes, 0) used, sum (nvl (. bytes, 0) remaining space,
Sum (nvl (a. bytes, 0)/(B. bytes) * 100 percentage remaining
From dba_free_space a, dba_data_files B
Where a. file_id = B. file_id
Group by B. tablespace_name, B. file_id, B. bytes
Order by B. file_id
43. How to Set ORACLE to MTS or private mode?
# Dispatchers = "(PROTOCOL = TCP) (SERVICE = SIDXD"
When MTS is added, the Comment mode is dedicated, And the SID indicates your instance name.
44. How can I know the current SCN Number of the system?
SQL> select max (ktuxescnw * power (2, 32) + ktuxescnb) from x $ ktuxe;
45. How can I retrieve milliseconds in ORACLE?
Not Supported before 9i, 9i starts to have timestamp.
9i available
SQL> select distinct imestamp from dual;
46. How do I add a carriage return to the string?
SQL> select Welcome to visit | chr (10) | http://www.cnblogs.com/huyong from dual;
47. How is Chinese sorted?
Before Oracle9i, Chinese characters were sorted by binary encoding.
The sorting by pinyin, radical, and stroke function is added to oracle9i. Set the value of NLS_SORT:
SCHINESE_RADICAL