Oracle

  1.Queries the current tablespace of a database. Select tablespace_name, file_name, sum (bytes)/1024/1024 table_size from dba_data_files group by tablespace_name, file_name;   2.Create a tablespace Create tablespace data01 Datafile

Grid infrastructure shared component Grid infrastructure uses two types of shared devices to manage cluster resources and nodes: OCR (Oracle cluster registry) and voting disk. Oracle 11.2 introduces a new file called Oracle local registry (OLR),

 I. Official Website description   Http://download.oracle.com/docs/cd/E11882_01/server.112/e26088/functions088.htm#SQLRF00658  Purpose The length functionsreturn the length of char. Length calculates length usingcharacters as defined by the input

Environment The source end is a RACRac1 rac2: RHEL 4u7 + Oracle 10.2.0.4 + ASMRac1 Internet IP address 192.168.47.241 virtual IP address 192.168.47.243Rac2 Internet IP address 192.168.47.242 virtual IP address 192.168.47.244 The target end is a

For undo tablespace management instructions, refer: Oracle undo tablespace Management Http://blog.csdn.net/tianlesoftware/article/details/5689558 We can use the following script to view the information of the Oracle undo Segment segment: /*

2 hours after the database is started, you can use the following SQL to test the database performance.   1. Buffer hit rate: Buffer hit rate indicates the frequency of finding common data blocks in the memory structure without disk access.   Select (

  Windows: 1. Choose "start"> "Settings"> "Control Panel"> "Administrative Tools"> "services" to stop all Oracle services.2. Start-> Program-> Oracle-orahome92-> Oracle Installation products-> universal installer uninstalls all Oracle products, but

First, you can use the following statement to view the existing database mode:Select name, log_mode from V $ database;You can also use the following statementArchive log list; (This method requires the as sysdba) SQL> archive log listDatabase Log

  When creating an instance in Oracle 11gr2 RAC, the following configuration types are selected: Admin-managed and policy-managed:   The official website documents are explained as follows:   6.1 understanding serverpools Server pools arelogical

 I. Problem Description Install RAC of Oracle 11.2.0.1 on vbox. An error is reported during SSH Configuration: INS-06006: passwordless sshconnectivity not set up between the following node (s)       Note: The strange result here is that setup is

  On the platform after Oracle 10.2.0.4, we may encounter the following error when importing materialized views using a Data Pump:   ...Ksedmp: internal or fatal errorORA-7445: exception encountered: core dump [_ intel_fast_memcpy.a () + 10][SIGSEGV]

  Use expdp to export the database. An error is reported and unexpected interruption occurs: ORA-39125: worker unexpected fatal error in KUPW $ worker. unload_metadata while calling dbms_metadata.fetch_xml_clob [procact_schema: "GGS"] ORA-04063:

   I. Test Environment SQL> select * from V $ version where rownum = 1;   Banner -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition release11.2.0.3.0-64bit Production   SQL> Create

  Installing Oracle 10.2.0.1 on Oracle Linux 6.1 is a tortuous process when installing software. When dbca creates an instance, it encounters: ORA-27125: Unable to create shared memory segment   The installation is interrupted. Rac2:/u02> oerr ora

 1. Block cleanout description Article arrangement reference: http://www.orawh.com/60.html   Previous test references: Inclueitl (Interested Transaction list) Description Http://blog.csdn.net/tianlesoftware/article/details/6573988   Oracleblock

      Before Oracle 11g, we can create pfile from spfile or use pfile to create spfile. In Oracle 11g, spfile management is enhanced. You can use memory to create pfile and spfile.   Syntax: Create pfile [= 'pfile _ name'] From {spfile [= 'spfile _

  From Eagle blog, the original link address is as follows: http://www.dbafan.com/blog? P = 495   11gr2 hasn't studied it yet. paste it to prevent this problem in the future. -----------------Begin ------------------ On the 11.2.0.2 database, we

  My colleague said that a table in the test database was locked. You cannot perform DML operations. The exact description of the lock table should be blocking. The previous blog has the following descriptions: Lock deadlock blocking latch wait

1. username and password after Oracle installation is completeSys/change_on_installSystem/ManagerScott/TigerSysman/oem_tempInternal/Oracle 2. Change the user's passwordSQL> conn sys/change_on_install as sysdbaConnected.SQL> alter user SYS identified

 I. Data Migration instructions During DBA's work, I may encounter data migration, such as migrating a local disk to ASM or changing the storage device. Then I need to migrate the storage location of the entire database.   If you only want to move a