benefits of oracle database

Solution to the Oracle database deadlock problem: oracle DatabaseQuery the locked table Select B. owner, B. object_name, a. session_id, a. locked_mode from v $ locked_object a, dba_objects B where B. object_id = a. object_id;Concatenate and unlock SQL statements Select 'alter system kill session ''' | s. sid | ',' | s. serial # | '''; 'from v $ locked_object l,

Oracle database software and Oracle database in my eyesI like to use Microsoft Office software and Word documents (to be exact: your own Word document, you can think of this word document as a record of the cultivation of "dragon 18 Palm" of the martial arts cheats. ) as an example.Office software can be installed casu

Oracle user. Connect the database to the sysdba user. % Sqlplus/nologSql> Conn/as sysdba;Connected. Increase the "reserved pool" ratio of the Shared pool . Sql> alter system set "_shared_pool_reserved_pct" =10 scope=spfile; Reduce the minimum request size for "Reserved Pool". Sql> alter system set "_shared_pool_reserved_min_alloc" =4000 scope=spfile; Reduce

the Internet.Global_name: The unique identification of a database (Oracle database), Oracle recommends that you use this method to command the database. The value is determined when the database is created, and the default value

How to start the Oracle Database Service and oracle Database in Windows Sometimes we may encounter database connection failures. Of course, there are many reasons for this problem, one of which is because the database service is

Oracle remote connection (PLSQL, SQL developement + Oracle database + client + remote connection settings, plsqldevelopement Server Configuration: oracle11g R2 x64 1. Set the listener A. Launch bar-> Start-> Program-> Oracle-OraDb11g_home1-> Configure and port tools-> Net Manager B.

Tags: imp config file success tool ... prot www oracle shareFirst download instantclient can be downloaded to the Oracle website, to register the account, must be under the corresponding version, otherwise unsuccessful, 10g,11g version of, I have been sent up, free download: Is crossing, wait a minute Configuration file Tnsnames.ora This one place is generally put (network/admin), only in PL/SQL----->tools-

can directly put it behind the called table name or view name, and use a @ in the middle as the delimiter: SELECT * FROM tbl_bjflb @ taowei_to_101; For frequently used database links, you can create a local synonym for ease of use: Create synonym tbl_bjflb _ syn FOR tbl_bjflb @ taowei_to_101; You can also create a local remote view for ease of use: Create view tbl_bjflb as select * FROM tbl_bjflb @ taowei_to_101 where... ; Now this view can be treate

In Oracle learning, architecture is the top priority. At the beginning, we can grasp its physical composition, file composition, and various file composition from a macro perspective. The deeper the knowledge, the better. Problems encountered in actual work can be explained in the architecture. The architecture describes the framework of a system. Is the macro work of designing a system. This is like building a building. First, you should describe the

A customer qq found me and said that a friend recommended me to help them restore the database. Due to the forced shutdown, the database could not start normally. Database recover database failed Mon Mar 28 10:20:33 2016 ALTER DATABASE RECOVER

Archive mode is very important in the real production environment of Oracle. You can use archive mode for hot backup, and then quickly recover data when a database problem occurs, saving the database. But sometimes the database is built, and it is found that the database is