Oracle

In Oracle databases, it is often difficult for management tablespaces to visualize data from SQL queries. One way to achieve tablespaces visualization and easier management is to create a segmented use mapping (block usage maps) similar to the

Transferred from: https://www.cnblogs.com/chinalantian/archive/2011/09/09/2172145.htmlAccording to your needs to the Oracle website (http://www.oracle.com/technetwork/database/features/instant-client/ index-097480.html) to download the corresponding

I. Classification of databasesI. Classification of databases1. Small database: Access, Foxbase2. Medium database: Informix, SQL Server, MySQL3. Large database: Sybase, DB2, OracleSecond, how to reasonably use the database in the project, can be

Problem point:Upgrade to the latest version of Win10 10.0.17134, after installing the latest patch cannot remotely win server 2016 server, error message is as follows:An authentication error has occurred that requires an incorrect function, which

1. Absolute value: ABS ()Select ABS ( -2) value from dual;2. Rounding function (Large): Ceil ()Select Ceil ( -2.001) value from dual; (-2)3. Rounding function (small): Floor ()Select Floor ( -2.001) value from dual; (-3)4. Rounding function

Resolution: The ORA-12514 TNS Listener currently does not recognize the request service in the connection descriptorOr you can't go to the console Enterprise Manager (OEM) graphical interface after restarting your computer (add an injection listener

The Oracle 18c was released in 2018-02-16 or with Oracle's cloud first concept, and 18c is now available on cloud and engineered Systems. Oracle 18c claims to be an autonomous database that reduces the work of many DBAs, and does a lot of DBA work

HBase vs. Oracle comparison (column and row database)1 Main differences HBase is suitable for a large number of insertions and read cases The bottleneck of HBase is hard drive transfer speed , and Oracle's bottleneck is hard drive seek

Defined:A stored procedure (Stored Procedure) is a set of SQL statements that are compiled and stored in a database in order to accomplish a specific function. The user executes it by specifying the name of the stored procedure and giving the

Oracle 11G R2 RAC adds the scan IP feature, Before 11.2, the client link to the database with the VIP, if your cluster has 4 nodes, then the clients Tnsnames.ora in the corresponding has four host VIP of a connection string, if the cluster added a

Reference: http://docs.oracle.com/database/122/SQLRF/Functions.htm#SQLRF006Single-row functions return a single result row for every row of a queried table or view. These functions can appear in select lists, WHERE clauses, and START WITH CONNECT BY

Oracle TIP error message ora-28001:the password has expired is due to the new features of oracle11g, oracle11g the default password expiration limit when creating a user is 180 days (that is, 6 months). If the user password has not been modified for

Every download and installation can't remember, so I summed up, standing on the shoulders of the predecessorsOriginal address: http://jingyan.baidu.com/article/48b558e33af4a57f39c09a42.htmlOracle database is now the most widely used database, in

1, first check whether DG Space is sufficientSql> select Name,total_mb,free_mb,usable_file_mb from V$asm_diskgroup;NAME TOTAL_MB FREE_MB USABLE_FILE_MB--------------------------------- ---------- ---------- --------------DATADG 4198790 230531

In 12c, Oracle introduced the History command, which is much like the history in the Shell, reducing the knock-down of SQL and bringing a lot of convenience.1. View the history HelpSql> HelpHistory-------Stores, lists, executes, edits of the

The Decode function is one of the powerful functions of Oracle PL/SQL. Only Oracle's SQL provides this function at the moment, and the SQL implementations of other database vendors do not yet have this capability.What is the use of decode? Let's

Background ProcessIn order to provide services to multiple users and ensure system performance, there are multiple Oracle processes called background processes (background process) in a multi-process Oracle System (multiprocess Oracle Systems).  an

Oracle database Cluster disaster tolerance implementation and maintenance (Rac+dataguard+goldengate) Training TutorialsPackage Description:Wind Brother Oracle Database Cluster disaster Recovery (rac+dataguard+goldengate) Implementation and

Introduction to oracle management tools, oracle management tools 1. SQL * plus is a tool software provided by oracle. It is mainly used to execute SQL statements and pl \ SQL blocks. How to use: 1) choose Start> program> oracle oradb_home10g>

Instance code for Oracle 11g User Password modification and lock/unlock function, oracle11g 1. Run cmd.exe; 2. Enter sqlplus/as sysdba to connect to the database as a system administrator (sysdba) for database management. 3. After successful