Oracle

SQL code for viewing the usage of each ORACLE tablespace -- select tablespace_name, sum (bytes)/1024/1024 from dba_data_files group by tablespace_name; -- select tablespace_name, sum (bytes) /1024/1024 from dba_free_space -www.2cto.com-group by

The solution for Oracle TNSListener to automatically stop when it is started has been normal. Today, we suddenly find that the TNSListener service cannot be started. After starting it on the service console, refresh it, it automatically returns to

Create temporary tablespace: create temporary tablespace test_tempTEMPFILE 'd: \ app \ Administrator \ oradata \ orcl \ test_temp01.dbf 'size 32 mautoextend on next 32 m maxsize 2048 mextent management local; CREATE user TABLESPACE: create

Some tips of plsql developer 1. After logon, My Objects is automatically selected by default. By default, after PLSQL Developer logs on, All objects will be selected in Brower. If the user you log on to is dba, to expand the tables directory, it

In oracle, you can use the connect by clause to implement recursive queries. The basic syntax is: select... from where start with connect by order siblings by ; : filter condition used to filter all returned records. (The Association condition

Start the service: services. msc Step 1 enable the listener: lsnrctl start Step 2 export the original data operation Exp tc4_gctos_file/OK @ tcmg import operation: www.2cto.com Imp tc4_gctos_file/OK @ orcl import file: EXPDATA. dmp d: \

Fault symptom: ORA-01078: failure in processing system parametersLRM-00109: cocould not open parameter file '/u01/app/oracle/product/10.2.0/db_1/dbs/initorcl10g. ora principle: in oracle9i and oracle10g, the database starts with spfile by default.

Three steps nomount, mount, and open for Oracle Database Startup: conn sys/sys as sysdbaShutdown abort; Startup nomount; select instance_name, status from v $ instance; www.2cto.com: select value from v $ spparameter where name = 'control _ files ';

Solution: create table t_20120512_a (id varchar2 (6) primary key, cost number (3), www.2cto.com p2 number (3), p3 number (3 )) /create table t_20120512_ B (id varchar2 (6) primary key, name varchar2 (50), B varchar2 (100)/insert into t_20120512_a

The relationship between Oracle sessions and processes is sessions = 1.1 * processes + 5 www.2cto.com ----- experiment part ---- Microsoft Windows [version 5.2.3790] (C) Copyright 1985-2003 Microsoft Corp. c: \ Documents ents and Settings \

ORACLE is a simple and practical SQL statement that converts rows and columns of data and collects statistics. Suppose there is a "beauty" table in the database, you need to use the values in cells in the column "signs" as the new column and column "

For example, if you want to query records with identical names, ID card numbers, and addresses in a personnel table (table name: peosons), select p1. * from persons p1, persons p2 where p1.id <> p2.id and p1.cardid = p2.cardid and p1.pname =

Oracle high water level (HWM) problems in oracle high water level (HWM) find a table with a large number of records, before 1 million, such as table test1. Create table test2 as select * from test1 where 1 = 2; insert into test2 select * from test1;

In Oracle, how does one understand that "Role authorization" requires users to log on again? We often hear that in Oracle, users must log on again to obtain the permissions granted when the role is granted user permissions,How can this sentence be

Oracle display cursor analysis create or replace procedure display cursor update as -- select taid, taname, bqid from table3new_taid number; cursor cur_table is -- display declaration cursor select taid from table3 where taid 10 without adding

Four steps to quickly start the oracle bbed environment: ora10g RHEL5.8 Introduction: bbed is called data block browsing and editing. Deep Learning of oracle block and disaster recovery in special circumstances.1 Compilation connection: cd $

Solve the Problem of ora-12154 recently the project uses oralce 10g as the database, haven't touched for a long time, but vaguely remember that there is such a tool pl/SQL can be very convenient to operate the database. After pl/SQL is installed on

Oracle Installation Often see problem error A: ORA-24324: uninitialized effect handle ORA-24323: do not permit this value ORA-28547: Connector effect failed, perhaps Oracle Net Control Error and then "Ignore" and "interrupt" two buttons, points

Ora-12516: TNS: Listeners cannot find available handlers that meet protocol stack requirements solution: processes reaches the upper limit, increase processes initialization parameter value SQL> select count (*) from v $ process; COUNT (*) ----------

Rac encounters gc buffer busy problem database version: 10.2.0.5-64 nodes: 2 operating system version: centos 5.6-64 awr report today found gc buffer busy wait time gc buffer busy This wait event, also known as global cache buffer busy prior to