Database Administrator

In the Oracle world, only one database can be opened for one instance. If I want to run two databases simultaneously on the local machine, I need to enable two instances, and the ID of the different instances is SID. Close the existing database, set

1. Modify system parameters Alter system set aq_tm_processes = 2 scope = both;Alter system set global_names = true scope = both;Alter system set job_queue_processes = 20 scope = both;Alter system set parallel_max_servers = 20 scope = both;Alter

See the following demo:$ Cat. bash_profile... ...# PATH = $ PATH: $ HOME/bin # Export PATH Oracle_SID = ltyORACLE_BASE =/u01ORACLE_HOME =/u01/oracle# PATH = $ ORACLE_HOME/bin: $ PATH# LD_ASSUME_KERNEL = 2.4.19LD_LIBRARY_PATH = $ ORACLE_HOME/lib:/usr/

D jango's ORM has a very convenient function. It should also be said to be a very basic function. After you call save () to insert a model to the database, the created auto-increment id is synchronized to the current model. The default return value

The Oracle11g database is installed. Deleting the table after the table is created will generate a table name similar to "BIN $ 1Oiy3qm/QJubov1BwBUOgw = $0, (select * from tab to view) For example, the drop table books command will put the table

Oracle application efficiency can be improved from the following aspects: (1) Adjustment of business logic functions; (2) Optimize the data structure design; (3) optimize data processing steps; (4) Optimize SQL statements; ⑸ Physical structure

I recently used MySQL databases for Linux projects, but when I remotely connect to MySQL, I always reported erro 2003: Can't connect to MySQL server on '100. 87. ***. * ** '(111). The solution was found several hours yesterday, as shown below: 1.

An Oracle database of 10.2.0.1 is installed on aix6.1. If you want to enter 10.2.0.5pathc, an error is returned. The specific error was forgotten at the time. It probably means that the system process of some prompts will be ended. Later, I checked

Export the database as follows: Enter cmd in the command line to enter the DOS window. Enter exp ccsbi/ccsbi_jyfx@ Ccsbi_55File = d: daochu. dmp ignore = y To export the entire database. Data export:  1Export the database TEST completely, and

I. significance: We know that the database has at least two sets of online log files, which are recycled.The archive mode stores a copy of the file before the online log file is repeatedly reused (overwritten) to other locations, so that we keep all

At work, we found that orcale time formatting is a little different from Java time formatting: For example, in Java, you can write a string in the format of time when the date is changed: SimpleDateFormat sdf = new SimpleDateFormat (); Sdf.

Oracle record user DDL operation script -- The current common user creates issgztCreate table TAB_DDL(LOGIN_USER VARCHAR2 (60 ),Audsid number,MACHINE VARCHAR2 (60 ),IPADDRESS VARCHAR2 (20 ),SCHEMA_USER VARCHAR2 (60 ),SCHEMA_OBJECT VARCHAR2 (60 ),DDL_

Preparations: How to grant the View query permission to other users:   Sys @ ORCL> grant select on v $ paramter toscott; Grant select on v $ paramter to scott * Row 3 has an error: ORA-00942: Table or view does not exist     Sys @ ORCL> grant select

Problem description: I have installed the Oracle 11g R2 Database Service on my PC. I cannot connect to the database through PL/SQL. The following describes the installation environment. PC operating system: Window7 (64bit) Oracle Server version:

Environment: CentOS6 + Oracle11g   In Linux, When you confirm input of rman, execute the bash Find/-name rman (file with the rman name in the root directory) Su-oracle Echo $ PATH Vi./. bash_profile (adjusted to PATH = $ PATH: $ HOME/bin)   Confirm

Hibernate supports third-party connection pools. the officially recommended connection pools are C3P0, Proxool, and DBCP. Note the following three points when configuring the connection pool: 1. Apche's DBCP is supported in Hibernate2, but it is no

1. Preface Recently, due to project requirements, the employee's working group needs to be returned to the front-end. However, in the database, the employee's working group Id is included in a field (separated by commas ), this does not meet the

Set encoding when MySQL connects to the database The default encoding of the MySQL database used by the user is UTF8, while that of the server is GBK. There are always many data writes. Com. mysql. jdbc. DriverJdbc: mysql: // localhost: 3306/db1?

When you use a client or other methods to connect to data and type Chinese data, garbled characters are displayed in the client. Of course, this is a problem with character set settings. I tried many methods, but still cannot display Chinese in the

Dbms_random is a package that can generate random values or strings. This package includes several functions, including initialize (), seed (), terminate (), value (), normal (), random (), and string (), but value () is the most common. The