ORACLE - ORACLE FAQ 1000 Q (1)ORACLE | Programing Reference For .Net,Java,C

ORACLE FAQ 1000 Q (1)

ORACLE everyone in the application may be encountered when it is not difficult to look a lot of issues, especially on the novice, I briefly summarize it issued to you, we want to help! And we are working together to achieve a common progress!

ORACLE is the master not read.

1. Oracle after the completion of installation of the initial password?

Internal / oracle

Sys / change_on_install

System / manager

Scott / tiger

Sysman / oem_temp

2. ORACLE9IAS WEB CACHE initial default user and password?

Administrator / administrator

3. Oracle 8.0.5 how to create the database?

By orainst. If motif interface can be used orainst / m

4. Oracle 8.1.7 how to create the database?

Dbassist

5. Oracle 9i how to create the database?

Dbca

6. Oracle in the nude equipment mean?

Bare equipment is bypassing direct access to the file system storage space

7. Oracle how to distinguish 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 Partitioning 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. SVRMGR What does that mean?

Svrmgrl, Server Manager.
Under no 9i, has been replaced by a SQLPLUS
Sqlplus / nolog
Filing into the log -

9. Ask how to tell where a user is landing ORACLE machine?

SELECT machine, the terminal FROM V $ SESSION;

10. Statement on what field?

Desc table_name can learn about the structure of the questionnaire
Select field_name, … from … can learn about the value of field

Select * from all_tables where table_name like '%'
Select * from all_tab_columns where table_name ='??'

11. How to be trigger, procedure, function, the creation of the script?

Desc user_source
User_triggers

12. How to calculate a table the size of the space occupied by?

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. Show how the greatest conversation?

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_queue_processes integer 4
Log_archive_max_processes integer 1
Processes integer 200

Here for 200 users.

Select * from v $ license;
Sessions_highwater record which had reached the maximum number of sessions

14. Show how the system locked affairs?

Select * from v $ locked_object;

15. Archivelog way how to run oracle.

Init.ora
Log_archive_start = true

RESTART DATABASE

16. How to obtain the use of the database in which users

Select username from v $ session;

17. Data table in the field is the largest number?

Table or view the largest listed for 1000

18. Check how the SID in the database?

Select name from v $ database;
Can be directly Show init.ora file

19. How Oracle server through SQLPLUS Show IP address of the machine?

Select sys_context ( 'userenv', 'ip_address') from dual;

If the plane is landing database, only to return to 127.0.0.1, huh

20. Under unix how adjustments database?

Su-root
Date-u 08010000

21. ORACLE TABLE how to crawl MEMO type of column space for the information recorded?

Select remark from oms_flowrec where trim ( '' from remark) is not null;

22. BBB how to use the information to update Table AAA table information (related 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

Will be SYSMCJIT.OLD SYMCJIT.DLL

24. Enquiries SERVER He is not OPS?

SELECT * FROM V $ OPTION;

PARALLEL SERVER = TRUE if there can OPS

25. DR permissions for each user?

SELECT * FROM DBA_SYS_PRIVS;

26. How to Form Mobile table space?

ALTER TABLE TABLE_NAME MOVE TABLESPACE_NAME;

27. How mobile Index Table space?

ALTER INDEX INDEX_NAME REBUILD TABLESPACE TABLESPACE_NAME;

28. In LINUX, UNIX DBA STUDIO how to start?

OEMAPP DBASTUDIO

29. Lock on the status of the object?

V $ LOCK, $ LOCKED_OBJECT V, V $ SESSION, $ SQLAREA V, V $ PROCESS;

The lock on the 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?

ALTER SYSTEM KILL SESSION 'SID, SERIR #';

31. SQLPLUS how to modify the editor?

DEFINE _EDITOR = "<editor integrity via>" - must be added the double quotes to define the new editor, can also write this in the $ ORACLE_HOME / sqlplus / admin / glogin.sql inside it permanent.

32. ORACLE a random function yes?

DBMS_RANDOM.RANDOM

33. LINUX under competition in order for the disk?

Sar-d

33. Query CPU LINUX competition in order?

Sar-r

34. Target for the current user?

SELECT * FROM USER_OBJECTS;

SELECT * FROM DBA_SEGMENTS;

35. How to get the wrong message?

SELECT * FROM USER_ERRORS;

36. How to link the situation?

SELECT * FROM DBA_DB_LINKS;

37. Show Database Character situation?

SELECT * FROM NLS_DATABASE_PARAMETERS;

SELECT * FROM V $ NLS_PARAMETERS;

38. Inquiry form spatial information?

SELECT * FROM DBA_DATA_FILES;

39. INTERAL of ORACLE users password?

Laws SQLNET.ORA

SQLNET.AUTHENTICATION_SERVICES = (NTS)

40. JAVA.EXE in the solution?

ORACLEORAHOMEXIHTTPSERVER generally will be launched into the hand

X is 8 or 9

41. How to form, in Canada Notes?

SQL> comment on table table is' Table Notes';

Notes has been created.

SQL> comment on column table. Out is' in the Notes';

Notes has been created.

SQL> select * from user_tab_comments where comments is not null;

42. Show how each table occupied disk space?

SQL> col tablespace format a20
SQL> select
B.file_id document ID,
Table space b.tablespace_name name
B.bytes bytes,
(B.bytes-sum (nvl (a.bytes, 0))) have been used,
Sum (nvl (a.bytes, 0)) remaining space,
Sum (nvl (a.bytes, 0)) / (b.bytes) * 100 from dba_free_space a percentage of surplus, 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. If the ORACLE set to MTS or exclusive mode?

# Dispatchers = "(PROTOCOL = TCP) (SERVICE = SIDXDB)"
MTS is added, Notes is dedicated mode, SID is an example of you.

44. How can we know the current system of SCN?

Select max (ktuxescnw * power (2, 32) + ktuxescnb) from x $ ktuxe;

45. Ask how ORACLE admitted in milliseconds?

9i before does not support, i began to timestamp 9.

9i can select systimestamp from dual;

If problems welcome everyone to explore!

Bookmark it: These icons link to social bookmarking sites where readers can share and discover new web pages.