5tb gb

Repeat the library cache lock wait event in Oracle 11 GB, 11 glibrary From the example below, we can see that re-Compilation of objects in the production database will lead to library cache lock, so we should try to avoid compiling objects during business peaks. If a package or complex dependency exists in the process, it can easily lead to library cache lock. Therefore, you should also pay attention to this issue during application development. Sessi

Database ErrorGATHER_STATS_JOB encountered errors. Check the trace file.Errors in file/opt/Oracle/diag/rdbms/dbserver1/dbserver1/trace/dbserver1_j003_10544.trc:ORA-20011: Approximate Newcastle failed: ORA-01476: divisor is equal to zero EnvironmentORACLE 11G R2RedHat 5.3 FOR 64 BIT SolutionThe conclusion on the Internet is a BUG.Bug No: 6040840Filed 09-MAY-2007 Updated 10-MAY-2007Product Oracle Server-Enterprise Edition Product Version 9.2.0.8Platform. AIX5L Based Systems (64-bit) Platform. Vers

View Current Character Set ReferenceSQL> select * from nls_database_parameters where parameter like '% SET % '; PARAMETER VALUE----------------------------------------------------------------------NLS_CHARACTERSET WE8ISO8859P1NLS_NCHAR_CHARACTERSET AL16UTF16 ReferenceSQL> select userenv ('language') from dual; USERENV ('language ')----------------------------------------------------AMERICAN_AMERICA.WE8ISO8859P1 Try to modify character set directly ReferenceSQL> ALTER DATABASE CHARACTER SET ZHS16

In order to learn the SQL statements of the database, after a long wait and learning, I finally learned how to use Oracle 10 Gb to learn the SQL statements of the database over the past few days. Required Software: Oracle 10g, TOAD for Oracle The installation of Oracle10g is very simple. Before installation, it is best to set the computer name in advance (if you do not use other visual interfaces, you can only access and operate the database in the DO

Install Oracle 10 Gb in Linux and create a database. After installation, create it manually. Follow these steps to create a database manually: 1: create a directory:/oracle/ora_data/xldb 2: Create a parameter file:/oracle/product/10.2.0/db_1/dbs/initXLDB. ora$ Cp init. ora initXLDB. oraWhere initXLDB. ora is modified:Db_name = XLDBControl_files = ("$ ORACLE_HOME/dbs/XLDB_ctl01.ctl", "$ ORACLE_HOME/dbs/XLDB_ctl02.ctl ")3: Create a password file: orapwd

Oracle10g Profile FAILED_LOGIN_ATTEMPTSOracle Database 10 Gb has a small improvement in the default user management, that is, the failure attempts to FAILED_LOGIN_ATTEMPTS passwords have become 10 times. This setting is indeed a bit problematic. If a user keeps trying wrong passwords, the user will be locked. If there is no limit before restoration, you can run the following command:Alter profile default limit FAILED_LOGIN_ATTEMPTS unlimited; Database

Summary of 10 GB flash back in Oracle1. flashback query (undo)Select current_scn from v $ database;Select * from t as of scn;Time and scn conversion functions:Scn_to_timestamp ()To_timestamp ()Timestamp_to_scn ()2. flashback table (undo)Select row_movement from dba_tables where table_name = 'T' and owner = 'test ';Alter table t enable row movement;Flashback table t to scn number;3. flashback versions query (undo)Select * from t versions between scn mi

not the title, skip this parameter.Fields terminated ",")Location('1.txt', '2.txt', '3.txt ')) SQL>/Table created 4. Perform the select Operation to check whether the operation is correct. SQL> select * from demo; To obtain information about the External table: SQL> select owner, table_name, default_directory_name, access_parameters from dba_external_tables; If the DBA wants to know the position of the flat file, use the following query: SQL> select * from DBA_EXTERNAL_LOCATIONS; Steps: Free in

Note: The Oracle version is 10 GB and the Linux version is RedHat Enterprise Linux 5.6. 1. Check whether the system has installed the file packages required by oracle. Rpm-q gcc make binutils openmotif setarch compat-db compat-gcc-c ++ compat-libstdc ++-devel libXp Because there is a strict dependency between the missing packages, you must install the missing packages in the following order.Compat-db-4 rpm-Uvh *Libaio-0 rpm-Uvh *Rpm-Uvh compat-libstdc

When you use commands to connect to Oracle on the server, you do not need to start the listener (if you want to, you can certainly configure it), as shown below: Sqlplus/nolog Conn sys/admin as sysdba; If the current user belongs to the DBA group, you can run the following command to log on to Oracle: Conn/As sysdba. In this case, the operating system logon authentication is used. However, when the client starts to log on to Oracle for 10 Gb

Windows 2003 operating system: [1] Xeon high-speed server, high-quality data center, 100 mbps bandwidth sharing [2] Real-time file anti-virus protection, hacker intrusion detection, Iis Application Firewall [3] automatic red Resistance Code, Nimda and other viruses [4] Each website runs in an independent process and is not affected by the loads of other sites [5] powerful control panel, online FTP password modification, self-stopping website [6] bind your own domain name and modify the de

After all the hardware is installed, the installer sets related options in the BIOS of the motherboard. At this time, I found that he did not partition and format the common fdisk and format, instead of using the famous partitionmagic or DM, I took out a floppy disk and typed a command on it (I didn't see it). A few seconds later, I restarted the computer, and the GB hard disk was already partitioned and formatted, the system can be installed! I was s

Installing Oracle 10 Gb has encountered the cannot open shared object file error and Solution [Root @ DBA ~] # Su-Oracle [Oracle @ DBA ~] $/Mnt/runinstallerStarting Oracle universal installer... Checking installer requirements... Checking operating system version: Must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2Passed All installer requirements met. Preparing to launch Oracle universal installer from/tmp/OraInstall2013-04-0

1. Set Environment Variables1. Name = ORACLE_HOME value = D: \ oracle \ product \ 10.2.0 \ db_12. Name = java_home value = % ORACLE_HOME % \ JDK (java.exe in oraclecan be disabled)3. Add % java_home % \ bin to change the PATH variable value. (In fact, 2 and 3 are Java environment variables)2. Run cmd To Go To The DOS operation interface1. Run the command: D :\> cd % ORACLE_HOME % \ productname \ J2EE \ ISQLPLUS \ Application-deployments \ ISQLPLUS2. Go to D: \ oracle \ product \ 10.2.0 \ db_1 \

details "buttons. The information obtained from the first" advice "button is the information obtained from the V $ pga_target_advice view above, which is more intuitive here, it is displayed as a graph.Another button "PGA memory usage details" is a statistical column chart obtained through the view v $ pga_target_advice_histogram.The figure is as follows: [View description] Description of views v $ pga_target_advice and V $ pga_target_advice_histogram in 10

Query some common ports in Oracle 10 Gb. Under oracle \ product \ 10.2.0 \ db_1 \ install \, there is a file portlist. ini It contains common ports and can be set as follows: Ultra Search http port No. = 5620 Enterprise Manager Agent port = ISQL * Plus http port number = 5560 Enterprise Manager Console http port (Oracle) = 5500 Enterprise Manager Agent port (Oracle) = 1830 Enterprise Manager Console http port (Oracle) = 5501

Now more and more friends are using Ubuntu, including I have replaced Windows from the very beginning as my only desktop system, and it is working with Oracle, which is used by the company, oracle has many auxiliary tools in windows, while linux ~~ No matter what it is, after installing an Oracle Datebase 10g Express Editon, Hq actually identifies it as O9i. If it is depressing, install a 10g Standard Edition forx86 first. 1. Prepare the environment A. Check whether your system meets the followi

Modify the RAC address in Oracle 10 GB This test is based on Oracle 10.2.0.5 SQL * Plus: Release 10.2.0.5.0-Production on Tue Jul 29 20:45:16 2014 Copyright (c) 1982,201 0, Oracle. All Rights Reserved. Connected:Oracle Database 10g Enterprise Edition Release 10.2.0.5.0-64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data MiningAnd Real Application Testing options SQL> First, let's take a look at the commands used. [Root @ node1

Reproduce the library cache lock wait event at 11 GB in Oracle From the example below, we can see that re-Compilation of objects in the production database will lead to library cache lock, so we should try to avoid compiling objects during business peaks. If a package or complex dependency exists in the process, it can easily lead to library cache lock. Therefore, you should also pay attention to this issue during application development. Session1: SQ

Do you still remember the concept of saving points in SQL? In a transaction, you can create a save point, make some modifications, create another save point, and so on. If these changes are not what you want, all you need to do is roll them back to a specific save point. Now we will introduce a new feature introduced in Oracle Database 10 GB-Flashback database. With this function, you can reverse the database back to the previous time point. In this c