Programmer Think

A 4-node rac of a provincial power system and a 2-node crash in the morning.Wed Nov 03 07:59:05 2021 SMON: Restarting fast_start parallel rollback Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x505E9323] [PC:0x98214CA, kgegpa()+40] [flags: 0x0, count: 1] Exception [type: SIGSEGV, Add ...

1.Data Guard Chapter 1 detailed reading - Portal 2 detailed explanation of DG services – Redo Transport Services Chapter 2 detailed reading - Portal 3 DG Services details – Apply Services 3.1 Apply Services The application service can automatically apply the received redo data in the standby database, so as to maintain the syn ...

It seems strange. Why are PHP and oracle? Generally, they are not PHP and Mysql. They are the golden partners 🤣， Everything comes from free. Oracle database is collected for free. As the saying goes, it's useless 🤩， Since there is this resource, it is like how to use it, and then start the whole process, because the articles on the netw ...

JDBC Today's goal Master the CRUD of JDBCUnderstand the role of various objects in JDBCMaster the use of Druid 1. JDBC overview In the development, we use java language, so it is necessary to operate the data in the database through Java language. This is the JDBC to learn next. 1.1 JDBC concept JDBC is a set of API s that use ...

preface This tutorial has been tested by practice for five times, and there will be various errors each time. However, it should not be a problem to install more times and find out the reasons more Baidu. The last installation takes 1 hour There are no virtual machines, centos7 images and Oracle 11 installation packages. I've provided them to ...

This machine involves oracle database and has never been involved before. I also take this opportunity to get familiar with the operation method of this database; As well as the knowledge about memory forensics, I just learned the forensics master in the Meiya Cup last time, so I also took this opportunity to learn the relevant knowledge of for ...

sql and functions commonly used in oracle TO_DATE, EXISTS, CASE... WHEN functionLISTAGG function and OVER PARTITION BY functionFind out whether a value exists in the whole database in Oracle databaseoracle sql statement specification, creating columns, adding columns, deleting columns, functions, etcFunction that returns the time difference b ...

view Views are other objects in the database 1. What is a view You can create a view of a table to represent a logical subset of data or a combination of data. A view is a logical table based on a table or another view. A view does not contain its own data. It is like a window through which you can view or change the data in the table. T ...

Note: the sql used in this article provides data and tables for HR users. HR user introduction view the following links. https://blog.csdn.net/weixin_45842494/article/details/122528264 1. Top-N analysis 1.1 what is Top-N analysis The Top-N query is useful when you need to display the first record or the last n records from the table ba ...

1, Foreword Let's look at an interesting case first The above sql queries two fields a and b, both of which are "Zhang San", and uses the length function to check that the length is 2. However, when you see the following sql output results, your first reaction is likely to be: "How is this possible?" In fact, as lik ...