hello! Hello everyone, I am [IT Bond], known as jeames007 in the world. I have more than 10 years of experience in DBA and big data work. A highly motivated [blogger in the field of big data]! Member of China DBA Alliance (ACDU), currently serving the industrial Internet Specialized in mainstream Oracle, MySQL, PG, Gaussian […]
Tag: pdb
How to create Oracle 19c pluggable database PDB
Overview of multi-tenant container database architecture diagram Multi-tenant container database components: 1. There is only one CDB Root (CDB$ROOT), which contains the metadata and data dictionary information of the Root and all PDB databases. 2. There is only one Seed PDB (PDB$SEED). Its function is to create templates for other PDBs. It is a read-only […]
Play with Linux GDB & pdb
1. GDB debugging Use of watch -n command: # Print the current system memory usage on the terminal every 1 second watch -n 1 “cat /proc/meminfo” # Check all running processes in the current system every 1s # ps: View system processes; -e: Display all processes; -f: Full format # The ps -aux command is […]
Analyze the address of DLL internal symbols based on PDB file
Recently, I encountered a given DLL file, but I wanted to quickly locate the address of an internal function (not exported). I thought that the Sym series of functions can directly analyze the address of the function based on the known PDB debugging symbol database. By referring to MSDN, we can know what we need. […]
[SQL Server bit by bit accumulation] The skill of sp_helpdb & sp_send_dbmail
Detailed explanation of Exec msdb.dbo.sp_send_dbmail parameters sp_send_dbmail [ [ @profile_name = ] ‘profile_name’ ] [ , [ @recipients = ] ‘recipients [ ; n ]’ ] [ , [ @copy_recipients = ] ‘copy_recipient [ ; n ]’ ] [ , [ @blind_copy_recipients = ] ‘blind_copy_recipient [ ; n ]’ ] [ , [ @subject = […]
[T-SQL Performance Optimization] 01.TempDB usage and performance issues
In the past, I always pursued new things and discovered that the basics were the most important. This year, my main goal is to become proficient in SQL queries and SQL performance optimization. This series [T-SQL Basics] is mainly a summary of the basics of T-SQL. [T-SQL Basics] 01. Single table query-several sql query questions […]
Database Management – Issue 101 Pitfalls in creating PDB in DG environment (20230908)
Database Management-Issue 101 Pitfalls in creating PDB in DG environment (20230908) This week, when doing PDB migration on the main database of the ADG environment on X9M, a problem occurred. The standby database could not be opened when trying to start the PDB. After in-depth communication with SR, the cause of the problem was discovered. […]
GPDB-Miscellaneous Diseases-PlaceHolderVar
GPDB-Miscellaneous Diseases-PlaceHolderVar When upgrading from GPDB5 to GPDB6, the SQL that could be executed in the past cannot be executed. Error: PlaceHolderVar found where not expected! Is the syntax incompatible? postgres=# CREATE TABLE t1( id1 int) WITH (appendonly=true, compresstype=none, blocksize=8192) DISTRIBUTED BY (id1); postgres=# CREATE TABLE t4(id1 int, id2 text ) DISTRIBUTED BY (id1); postgres=# […]
Multi-tenancy: Plugging and unplugging of PDB archives (12.2)
In Oracle12.1, PDB can be extracted into an “.xml” file, which describes the contents of the PDB database. To move a PDB, you need to manually move the “.xml” file and all related database files. In addition to this feature, Oracle 12.2 also allows unplugging PDBs into “.PDB” archives. The generated archive contains “.xml” files […]
GPDB-Kernel Features-gp_interconnect_fc_method parameter
GPDB-Kernel Features-gp_interconnect_fc_method parameter The gp_interconnect_fc_method parameter controls which flow control method to use: capacity controls sending according to the receiver window; loss (default) controls sending according to packet loss speed. Loss is based on capacity, and the sending speed will be adjusted according to the packet loss. So how to solve this parameter to control […]