ORACLE common dummies: Question 1000 (one)

ORACLE common dummies: Question 1000 (one)

Author: CCBZZP

When you use ORACLE, you may encounter many seemingly unexpected problems. specifically for new users, today I will simply sum up it, I hope it will help you! Explore with everyone and make progress together!

For ORACLE experts, it is not worth looking.

1. What is the initial password after Oracle Security is complete?

Internal/oracle

Sys/change_on_install

System/manager

Scott/tiger

Sysman/oem_temp

2. What is the initial Default User and password of ORACLE9IAS 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 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:
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. What does SVRMGR mean?

Svrmgrl, Server Manager.
No under 9i. I already used SQLPLUS.
Sqlplus/nolog
Changed to archive log type

9. How can I tell from which machine a user logs on to ORACLE?

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?

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

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?

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?

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 does one capture the empty memory of the MEMO type?

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

22. How to Use BBB table data to update AAA table data (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 power station security method

Change SYMCJIT. DLL to SYSMCJIT. OLD.

24. How can I check whether the compute SERVER is OPS?

SELECT * from v $ OPTION;

If parallel server = TRUE, OPS can

25. How can I check the permission limits of each user?

SELECT * FROM DBA_SYS_PRIVS;

26. How can I change the empty table space?

Alter table TABLE_NAME MOVE TABLESPACE_NAME;

27. How can I move the index to an empty table?

Alter index INDEX_NAME rebuild tablespace TABLESPACE_NAME;

28. In LINUX and UNIX, how does one activate dba studio?

OEMAPP DBASTUDIO

29. Are there any matching images of zookeeper?

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

The following describes how to query the tables in sequence:

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, 'clusive', 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, 'clusive', 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 resolve the issue?

Alter system kill session 'sid, SERIR #';

31. Under SQLPLUS, how does one modify the connector?

DEFINE _ EDITOR = "<full path of the EDITOR>" -- double quotation marks must be added.
To define a new editor, you can also write this in $ ORACLE_HOME/sqlplus/admin/glogin. SQL to make it permanently valid.

32. What are the numbers of ORACLE production hosts?

DBMS_RANDOM.RANDOM

33. In LINUX, how does one check the "too many" commands?

Sar-d

33. In LINUX, how does one check the CPU usage?

Sar-r

34. Check whether the object is used before the query?

SELECT * FROM USER_OBJECTS;

SELECT * FROM DBA_SEGMENTS;

35. How does one retrieve zookeeper information?

SELECT * FROM USER_ERRORS;

36. How do I retrieve the token and connect it to the token?

SELECT * FROM DBA_DB_LINKS;

37. How can I view the data transfer character?

SELECT * FROM NLS_DATABASE_PARAMETERS;

SELECT * from v $ NLS_PARAMETERS;

38. How can I query the blank space in the tables Table?

SELECT * FROM DBA_DATA_FILES;

39. What is the password for oracle interal to use ghost?

Modify SQLNET. ORA

SQLNET. AUTHENTICATION_SERVICES = (CNT)

40. How does the JAVA. EXE solution work?

Generally, you can change ORACLEORAHOMEXIHTTPSERVER to manual failover.

X is 8 or 9

41. How do I add comments to tables and columns?

SQL> comment on table is 'table annotation ';

Note created.

SQL> comment on column table. The column is 'column annotation ';

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. ID of the file_id file,
B. tablespace_name: name of the tablespace,
B. bytes,
(B. bytes-sum (nvl (a. bytes, 0) already in use,
Sum (nvl (a. 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. If ORACLE is set to MTS or dedicated mode?

# Dispatchers = "(PROTOCOL = TCP) (SERVICE = SIDXDB )"
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?

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 can use select distinct imestamp from dual;