Oracle

Explore the structure of data file header under LMT table space management and the recording mode of bitmap Central The experiment is divided into two steps: 1.LMT locally managed table space, the structure analysis of data files in ASSM automatic

Steps: (1) Create script file bak_112.sh, as follows (automatically back up the database by current date): #!/bin/sh export oracle_base=/u01/app/oracle; oracle_home=/u01/app/oracle/product/11.2.0/db_home1; Export Oracle_home oracle_sid=xxx export

--View SID Sql> show parameter instance_name; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ Instance_name String tos --Create Pfile sql> create pfile= '/tmp/tospfile ' from SPFile; File

sql> desc V$lock; is the name empty? Type ----------------------------------------- -------- ---------------------------- ADDR RAW (8) Kaddr RAW (8) SID number TYPE VARCHAR2 (2) ID1 number ID2 number Lmode number REQUEST number CTIME

1, the structure of the V$sqlarea table Sql> desc V$sqlarea is the name empty? Type ----------------------------------------- -------- ------------------------ Sql_text VARCHAR2 (1000) Sql_fulltext CLOB sql_id VARCHAR2 (13) Sharable_mem

1, v$session table structure sql> desc v$session; is the name empty? Type ----------------------------------------- -------- ---------------------------- Saddr RAW (8) SID number serial# number Audsid number Paddr RAW (8) user# number

Output query content to text Set echo off pagesize 0 heading off feedback out termout off Spool Test.sql Select COUNT (*) from User_tables; Spool off The above script will output the query content to the Test.sql after it has finished executing

Branch of the database performance problems, help to help diagnose. The database is a Oracle10.2.0.3 RAC environment, but is now in a single node working state. The current problem is that page access is slow and no further information is available.

1.dba_logstdby_events This view can be viewed as a logical standby action log, so if an error occurs, you can see what the recent logic standby has done with the view. By default, this view retains only the records of the last 100 events (you can

A function is a subroutine that evaluates the result value, except that the function has a return clause, and the other structure is similar to the procedure. It is worth noting that functions in Oracle must provide a return value, and if you define

№ 1: The current date is the week ordinal of this month Sql> Select To_char (sysdate, ' YYYYMMDD W HH24:MI:SS ') from dual; To_char (sysdate, ' YY-------------------20030327 4 18:16:09 Sql> Select To_char (sysdate, ' W ') from dual; T-4 № 2:

In Oracle 9i, data can be easily exported to a file or imported from a file. With Oracle's Management Server (Oracle Management Server,oms) can be easily implemented, there are many places to explain the entire operation, but the complete guidance

I do not know how to debug a stored procedure when I write it. One way to debug this is to print out the value of a variable in a program that I print on the console in Java. Here's how to do this from the Sqlplus. 1, execute "set serveroptput on"

Running databases on the Internet often has the need to unify database applications across the country, and a node's data changes are reflected not only locally but also remotely. Replication technology provides users with a quick way to access

It is believed that a large number of system administrators are doing the same job every day-backing up the data. Once a day of negligence, and this day the system is precisely the fault, the need for data recovery, then there is nothing at this

　　 Create procedure procedue_name　　[@parameter data_type][output]　　[with]{recompile|encryption}　　as　　sql_statement Explanation Output: Indicates that this parameter is available for return. with {recompile|encryption} Recompile: means recompiling

1. According to Q193893, we need to build two views within Oracle. Information about using Oracle with Microsoft Transaction Server and COM + components http://support.microsoft.com/?id=193893 Based on our past experience, we can try to run

The primary role of the Sys_connect_by_path function is to distinguish all child nodes under a parent node from a single character, and then connect to a column to display select level ,sys_connect_by_path( id , '/' ) from test start with pid= 1

As an Oracle database administrator, you will encounter such database management requirements, stopping or opening constraints and triggers for all tables under the current user (schema). This is one of the things you need to do when merging

Spool is a control command provided by Oracle Sqlplus. You can use the combination of spool and SELECT statements to dynamically generate some SQL scripts or some data. There are probably two types of statement classifications that can be executed