Oracle

The views related to permissions and roles include the following:Dba_sys_privs: query the system permissions of a userUser_sys_privs: system permissions of the current userSession_privs: All permissions of the current userRole_sys_privs: system

1. Modify the oracle11g parameter to solve the cursor exceeding problem:Log on to sys and change the startup parameter file.Open_cursors = 3000Session_cached_cursors = 3000Restart the Oracle instance using the command line (using new parameters)  

First install the Oracle client 1. Choose Control Panel> Administrative Tools> data source (ODBC)> add data source> select Oracle client data source name, we recommend that you use the same description as Sid to describe TNS service name. The

Table join   Table join refers to the association between tables in an SQL statement to retrieve relevant data from one or more tables. If an SQL statement has more than two associated tables,So what is the order of connection? Oracle first connects

In the past, I never wanted to read Oracle's copyright statement carefully. Today I opened the oracle10gr2 document, So I simply read this article from the beginning. I think everyone should know that although the concept of copyright in China is

Enterprise Manager can be created by using dbca, manually, or using templates. When dbca is used to create a database, "Use Enterprise Manager to configure a Database" is not selected ", if you want to use EM later, you must manually configure em to

Analyze table tablename compute statistics; Analyze index indexname compute statistics; It is very beneficial to use CBO, and more reliable table information can be used, so that the execution plan can be more accurate. In 10 Gb, analyze is

There are several startup methods: 1. startup nomount Non-installation startup. In this mode, you can execute: re-build the control file and re-build the database. Read the init. ora file and start the instance, that is, start the SGA and background

DBA-Oracle.com is a well-known foreign Oracle expert service company (pythian.com is another), let's take a look at their Oracle service charges: Transferred from http://www.anysql.net/dba/oracle_consult_price.html: The service is becoming more

Add formOpen the template, change it to the name you want, delete blockname and detailblock in data blacks, delete blockname in canvases, delete blockname in windows, and add your own windows, canvases, and dateblacks, in form-level PRE-FORM, change

The logical standby architecture was completed yesterday and runs in the maximum performance mode of the default mode. When trying to change to the maximum available mode today, the primary database reports the following error. No answer was found

At this morning, a telephone bell woke me up. My colleagues at night shift made a mistake again. As a result, my colleagues told me that the database could not be connected and the production line could not be refreshed. Open your computer and

Today, I am bored. I downloaded an Oracle 11g and want to see what new functions are available. After the installation, enable em and find that the feature is excellent. It is used to import data from another database. Set to import data from the

1. Remove the network cable of the priv Nic of rac2. rac2 reboot and Rac1 work normally.[Oracle @ mesdb01 ~] $ Crs_stat-TName type target State host------------------------------------------------------------Ora. Mes. DB application online

1. Create a New tablespace:Create tablespace newxxt Datafile '/Oradata/dduyoung/newxxt1.dbf' size 200 m autoextend on next 10 m maxsize unlimited, '/Oradata/dduyoung/newxxt2.dbf' size 200 m autoextend on next 10 m maxsize Unlimited Extent management

Instr usage is transferred from the http://www.cnblogs.com/Xrinehart/archive/2005/04/21/142791.html. Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->The format of the instr method is Instr (source

PL/SQL table --- table () function usage /* PL/SQL table --- table () function usage:Using the table () function, we can replace the result set returned by PL/SQL. Oracle memory tables are frequently used for queries and reports. They are dozens of

Original article: http://xace.javaeye.com/blog/434537 /* In actual use of SQL, the value of a column is always displayed in the title, that is, the conversion or interchange of the rows and columns.For example, the following data is available:ID

1. Oracle special character escapeKeywords: Oracle escape environment: Oracle 9i PLSQL execute in PLSQL:Update userinfo set pageurl = 'myjsp? Page = 1 & pagesize = 10 'where id = 'test'This SQL statement adds a URL address to the pageurl field of

  I sorted out the DB hang issue during the shutdown process yesterday. For details, refer: Dbhang solution during oracleshutdown Http://blog.csdn.net/tianlesoftware/article/details/7407587   Today, my colleague modified the stored procedure, which