Skip To Main Content
Grant Execute on Muck Rack

Grant Execute

As seen in: Amazon Web Services, Fix This, Oracle, DEV Community, DZone, cnblogs.com, CSDN, SQL Server Central, tech2daily
Is this you? As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work. Claim your profile
Back to Grant Execute’s profile

Articles by Grant Execute

Monitor SQL Server using Zabbix – SQLServerCentral

|
By Pablo Arias Echeverria, Pablo C. Echeverría, Grant Execute, Grant Select
| SQL Server Central
Zabbix is an open-source monitoring software, like Paessler PRTG, which can monitor SQL Server performance statistics and status. Although it doesn’t replace DBA functions, it is useful to provide evidence when things start to fail. Among its features are: Alert when the service fails or stops. Monitor Windows Performance Counters. CPU usage. Disk latency. Active connections. Blocking queue length. Transactions and resource usage. Dashboards for historical graphic visualization.
Open in Who Shared Issue with article?

使用ob_tools包收集分析oceanbase数据库oracle租户缓慢sql语句 - 小至尖尖 - 博客园

|
By Grant Execute, Sid Number
| cnblogs.com
1、手册目的： 本手册旨在提供一种系统化的方法论，以便发现和分析慢SQL语句。通过使用ob_tools包，收集和分析在交付期间，应用程序在不同场景下进行压测时所产生的慢SQL语句，从而实现性能调优和优化建议。 2、文档内容： 本手册包含以下几个主要部分： 1. ob_tools包内存储过程和函数介绍： 详细介绍ob_tools包中的各个存储过程和函数的功能、使用方法以及参数说明，为读者提供清晰的理解和应用基础。 2. ob_tools包内存储过程和函数的不同场景使用案例： 针对不同的应用场景，提供具体的使用案例，展示如何利用这些存储过程和函数来收集和分析数据，以满足特定的性能需求。 3.
Open in Who Shared Issue with article?

Understanding and Configuring Oracle Access Control Lists (ACLs) for Email Sending Using UTL_MAIL

|
By Grant Execute
| DEV Community
Introduction This article is based on real problems I had in a production environment in Oracle 11g. Oracle Database provides powerful networking capabilities, allowing PL/SQL programs to interact with external systems over the network. To enhance security, Oracle introduced Access Control Lists (ACLs) starting from Oracle Database 11g. ACLs enable fine-grained control over network access, ensuring that only authorized users and programs can communicate with specified external hosts and services.
Open in Who Shared Issue with article?

Schedule jobs in Amazon RDS or Amazon Aurora PostgreSQL using pg_tle and pg_dbms_job | Amazon Web Services

|
By Grant Usage, Grant All, Grant Execute
| Amazon Web Services
Customers migrating Oracle databases to Amazon Relational Database Service (Amazon RDS) for PostgreSQL or Amazon Aurora PostgreSQL-Compatible Edition might encounter the challenge of scheduling jobs that require precise sub-minute scheduling to avoid workflow disruptions and maintain business operations. Oracle provides a scheduler called DBMS_JOB to handle these use cases, and you can use the pg_dbms_job open source extension, which provides similar functionality, to simplify migrations.
Open in Who Shared Issue with article?

【数据同步】SeaTunnel初体验，5000字深入浅出带你用上Oracle-CDC-CSDN博客

|
By Grant Select, Grant Execute
| CSDN
SeaTunnel 于 2024-08-21 14:45:47 发布 阅读量1.1k 收藏 13 点赞数 23 版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。 Apache SeaTunnel 是啥？ 下一代高性能、分布式、海量数据集成框架。 支持上百个数据源、传输速度快、准确率高，丰富易扩展的连接器和插件化的连接器设计，能够更轻松的运行复杂的集成。 是一个分布式、高性能的数据集成平台，用于数据迁移和实时流处理任务。 JDK下载安装 需安装Java (Java 8 或 11， 其他高于Java 8的版本理论上也可以工作) 以及设置 JAVA_HOME。 本次选择了安装8u381版本，大部分的bug有得到修复，JDK下载页地址： https://www.oracle.com/java/technologies/javase/javase8u211-later-archive-downloads.html # 解压 tar xvf jdk-8u381-linux-x64.tar.gz # 配置环境变量,添加2行 cat...
Open in Who Shared Issue with article?

Oracle Advanced Queue: A Guide

|
By Grant Execute, Grant Enqueue
| DZone Verified
In this article, we'll look at what Oracle advanced queue is, explore some of the use cases, and consider common best practices while implementing queue. Brief Overview of Oracle Advanced Queue (AQ) In a business application, many systems and apps work together to integrate and exchange information. Oracle Advanced Queuing allows asynchronous communication by sending and receiving the message. This enables the message to be seamlessly integrated and stored at the database structure level.
Open in Who Shared Issue with article?

使用Flink CDC实现 Oracle数据库数据同步（非SQL）

|
By Grant Select, Grant Execute, Import Org.apache.flink.streaming.api.environment.stream ExecutionEnvironment, Import Org.apache.flink.streaming.api.windowing.assigners.tumbling ProcessingTimeWindows
| CSDN
前言 Flink CDC 是一个基于流的数据集成工具，旨在为用户提供一套功能更加全面的编程接口（API）。 该工具使得用户能够以 YAML 配置文件的形式实现数据库同步，同时也提供了Flink CDC Source Connector API。 Flink CDC 在任务提交过程中进行了优化，并且增加了一些高级特性，如表结构变更自动同步（Schema Evolution）、数据转换（Data Transformation）、整库同步（Full Database Synchronization）以及 精确一次（Exactly-once）语义。 本文通过flink-connector-oracle-cdc来实现Oracle数据库的数据同步。 一、开启归档日志 1）数据库服务器终端，使用sysdba角色连接数据库 sqlplus / as sysdba 或 sqlplus /nolog CONNECT sys/password AS SYSDBA; 2）检查归档日志是否开启 archive log list; （“Database log mode: No Archive...
Open in Who Shared Issue with article?

How to clone master user permissions in Amazon RDS for SQL Server | Amazon Web Services

|
By Grant Execute, Grant Select, Grant Alter, Grant Control
| Amazon Web Services
When you create a new Amazon Relational Database Service (Amazon RDS) for SQL Server instance, the master user is granted certain privileges for that database instance. We strongly recommend that you do not use the master user directly in your applications. Instead, adhere to the principles of least privilege and best practices by using a database user created with the minimal permissions required for your application.
Open in Who Shared Issue with article?

Migrate from Oracle to Amazon RDS for MySQL, MariaDB or Amazon Aurora MySQL using Oracle GoldenGate | Amazon Web Services

|
By Grant Execute, Grant Select, Query OK, UserId viqash
| Amazon Web Services
When thinking about modernizing an Oracle Database to an open-source database on AWS, options include Amazon Relational Database Service (Amazon RDS) for MySQL, Amazon RDS for MariaDB, Amazon RDS for PostgreSQL, or Amazon Aurora.
Open in Who Shared Issue with article?

Flink Oracle CDC Connector源码解读

|
By Grant Select, Grant Execute, Oracle Connector.class, createFlush Table
| CSDN
flink cdc是在flink的基础上对oracle的数据进行实时采集，底层使用的是debezium框架来实现，debezium使用oracle自带的logminer技术来实现。logminer的采集需要对数据库和采集表添加补充日志，由于oracle18c不支持对数据添加补充日志，所以目前支持的oracle11、12、19三个版本。 flink oracle cdc 支持sql和api两种方式。oracle需要开启归档日志和补充日志才能完成采集，同时需要提供一个有权限的账号去连接oracle数据库完成实时采集。 归档日志开启方式 ORACLE_SID=SID export ORACLE_SID sqlplus /nolog CONNECT sys/password AS SYSDBA alter system set db_recovery_file_dest_size = 10G; alter system set db_recovery_file_dest = '/opt/oracle/oradata/recovery_area' scope=spfile;...
Open in Who Shared Issue with article?

Continuous Query Notification (CQN) feature does not work with ADB - Ask TOM

|
By Grant Connect, Grant Execute, Import Oracle.jdbc.dcn.database ChangeEvent, Import Oracle.jdbc.dcn.database ChangeListener
| Oracle
We are trying to perform a simple POC to make use of the CQN feature with ADW and ATP. We are following the walkthrough example available at : https://docs.oracle.com/en/ database/oracle/oracle-database/19/jjdbc/continuos-query-notification.html#GUID-17D0D7C5-77C9-420D-9D13-F668C1056792 When we run the following JAVA code, Database change registrations are getting created properly. We can see them getting created in USER_CHANGE_NOTIFICATION_REGS table .
Open in Who Shared Issue with article?

Flink CDC SQL Oracle to Postgresql与jdbc连接oracle报错处理

|
By Grant Select, Grant Execute
| CSDN
flink-cdc官网：Oracle CDC Connector — CDC Connectors for Apache Flink® documentation Flink环境依赖: （1）下载postgresql jdbc jar包 postgresql-42.3.5 和 flink-sql-connector-oracle-cdc-2.2.0.jar将包放到flink 下 lib目录里面 下载地址https://jdbc.postgresql.org/download.html flink-connector-jdbc_2.12_1.14.4.jar 包 https://mvnrepository.com/artifact/org.apache.flink/flink-connector-jdbc_2.12/1.14.4 （2）以 DBA 身份连接到数据库 ORACLE_SID=SID export ORACLE_SID sqlplus /nolog CONNECT sys/password AS SYSDBA （3）启用日志归档 alter system set...
Open in Who Shared Issue with article?

Flink CDC SQL Oracle To Kafka To ES

|
By Grant Select, Grant Execute
| CSDN
Oracle CDC 连接器 下载flink-sql-connector-oracle-cdc-2.2.1.jar放在<FLINK_HOME>/lib/.
Open in Who Shared Issue with article?

Flink CDC Oracle To ES与Oracle To PG SQL和Stream方法实现 (单表、多表)

|
By Grant Select, Grant Execute, return deleteRequest, Runtime Context ctx
| CSDN
1.FlinkDataStream_CDC实现： 利用Flink_CDC自带的连接资源，如MySQLSource通过设置hostname、port、username、password、database、table、deserializer、startupOptions等参数配置 实现获取CRUD数据变化日志 2.FlinkSQL_CDC实现： 通过FlinkSQL创建虚拟表获取关键字段的变化情况并且配置hostname、port、username、password、database、table等参数可以看到具体表数据的变化过程 注意：FlinkSQL_CDC2.0仅支持Flink1.13之后的版本 Flink Table/SQL模块集成了数据库表和变化记录流（例如CDC的数据流）。作为同一事物的两面，结果是Upsert Message结构（+I表示新增、-U表示记录更新前的值、+U表示记录的更新值、-D表示删除） 两种方式对比: 1.FlinkDataStream_CDC支持多库多表的操作（优点） 2.FlinkFlinkDataStream_CDC需要自定义序列化器（缺点）...
Open in Who Shared Issue with article?

Flink cdc 实时监听oracle归档日志及oracle数据延迟参数调优

|
By Grant Select, Grant Execute
| CSDN
1.1 oracle 归档日志开启配置 1.数据库服务器终端执行命令 sqlplus / as sysdba 或 sqlplus /nolog CONNECT sys/password@host:port AS SYSDBA; 2.检查归档日志是否开启 archive log list; （“Database log mode: No Archive Mode”，日志归档未开启） （“Database log mode: Archive Mode”，日志归档已开启） 3.配置归档日志参数 alter system set db_recovery_file_dest_size = 100G; alter system set db_recovery_file_dest = '/opt/oracle/oradata/recovery_area' scope=spfile; 4.创建表空间 CREATE TABLESPACE logminer_tbs DATAFILE '/opt/oracle/oradata/SID/logminer_tbs.dbf' SIZE 25M REUSE...
Open in Who Shared Issue with article?

New – Trusted Language Extensions for PostgreSQL on Amazon Aurora and Amazon RDS | Amazon Web Services

|
By Grant Usage, Grant Execute, Channy Yun
| Amazon Web Services
PostgreSQL has become the preferred open-source relational database for many enterprises and start-ups with its extensible design for developers. One of the reasons developers use PostgreSQL is it allows them to add database functionality by building extensions with their preferred programming languages. You can already install and use PostgreSQL extensions in Amazon Aurora PostgreSQL-Compatible Edition and Amazon Relational Database Service for PostgreSQL.
Open in Who Shared Issue with article?

Oracle数据库中的数据加密_oracle加密函数_Tracts的博客-CSDN博客

|
By Grant Execute
| CSDN
Oracle数据库中的数据加密 / Oracle数据库DES加密 有个需求，需要对某些敏感信息字段进行脱敏，要求在数据库中不能显示明文。如果目的侧重保护数据而非脱敏的话，可以考虑用表空间透明数据加密（TDE），不过现在是需要对字段内容脱敏，则读取和存储都要是加密后的密文数据。 增量数据好说，后台代码实现即可。但存量数据如果也要后台与数据库交互进行加密的话，且不说IO的消耗，就先查再改，无论单条还是分批，在数十、百万的数据量下估计需要很长时间。那就要考虑在数据库里用PL/SQL做存量数据的加密操作。 Oracle中的加密函数 Oracle的PL/SQL包中有提供相关的函数。 PL/SQL包类官方文档（10.2版本）：Database PL/SQL Packages and Types Reference - Contents (oracle.com)...
Open in Who Shared Issue with article?

Flink connector Oracle CDC 实时同步数据到MySQL（Oracle19c）

|
By Grant Select, Grant Execute, Sname String
| CSDN
在这一步需要配置Oracle。主要包含。 开启Archive log 开启数据库和数据表的supplemental log 创建CDC用户并赋予权限 注意：不要使用Oracle的SYS和SYSTEM用户做为CDC用户。因为这两个用户能够捕获到大量Oracle数据库内部的变更信息，对于业务数据来说是不必要的。Debezium会过滤掉这两个用户捕获到的变更内容。 下面开始配置步骤。在安装Oracle的机器上执行： su - oracle sqlplus / as sysdba 进入Sqlplus。然后开启Archive log。 alter system set db_recovery_file_dest_size = 10G; alter system set db_recovery_file_dest = '/opt/oracle/oradata/recovery_area' scope=spfile; shutdown immediate; startup mount; alter database archivelog; alter database open; #...
Open in Who Shared Issue with article?

Energy to the SQL Folks: Introducing Python UDFs in Databricks SQL

|
By Grant Execute
| tech2daily
We have been thrilled to announce the preview for Python Consumer-Outlined Features (UDFs) in Databricks SQL (DBSQL) finally month’s Knowledge and AI Summit. This weblog submit offers an summary of the brand new functionality and walks you thru an instance showcasing its options and use-cases. Python UDFs permit customers to jot down Python code and invoke it by a SQL perform in a simple safe and absolutely ruled approach, bringing the facility of Python to Databricks SQL.
Open in Who Shared Issue with article?

Flink-----Flink CDC 实现数据实时同步

|
By Grant Select, Grant Execute, Import Org.apache.flink.streaming.api.datastream. DataStream, import org.apache.flink.table.api.Table
| CSDN
1.什么是Flink_CDC CDC 全称是 Change Data Capture（变化数据获取） ，它是一个比较广义的概念，只要能捕获变更的数据，我们都可以称为 CDC 。业界主要有基于查询的 CDC 和基于日志的 CDC ，可以从下面表格对比他们功能和差异点。 2.Flink_CDC应用场景 1.数据同步：用于备份，容灾 2.数据分发：一个数据源分发给多个下游系统 3.数据采集：面向数据仓库/数据湖的ETL数据集成，是非常重要的数据源 3.传统实时数据获取与FlinkCDC数据实时获取 传统实时数据获取： FlinkCDC实时数据获取： 对比： Flink 1.11 引入了 Flink CDC，flink-cdc解决了普通的CDC必须通过kafka的问题，简化了流程，第一个图是普通的cdc的流程，通过cdc的工具将mysql的数据采集到kafka，在通过flink、sparkStreaming等流式计算写入到hbase、es，大数据湖等。流程相对复杂，flink-cdc做的就是可以省去普通cdc到kafka的过程。将采集、计算都在flink中完成 Flink_CDC优势：...
Open in Who Shared Issue with article?

Integrating OCI Generative AI with Select AI and APEX to query data using natural language

|
By Rekha Mathew, Grant Execute, Atefeh Yousefi-Attaei
| Oracle
Introduction One remarkable capability of Large Language Models (LLMs) is their ability to generate code, including Structured Query Language (SQL) for databases. LLMs can understand the natural language question and generate a corresponding SQL query as an output. A large amount of enterprise data resides in databases, and the ability to query databases in natural language makes databases more accessible to users. Business users and data analysts can ask questions about data in natural language.
Open in Who Shared Issue with article?

Working with Trusted Language Extensions for PostgreSQL

|
By Grant Role, Grant Usage, Grant Execute
| Fix This
Trusted Language Extensions for PostgreSQL is an open source development kit for building PostgreSQL extensions. It allows you to build high performance PostgreSQL extensions and safely run them on your RDS for PostgreSQL DB instance. By using Trusted Language Extensions (TLE) for PostgreSQL, you can create PostgreSQL extensions that follow the documented approach for extending PostgreSQL functionality.
Open in Who Shared Issue with article?

PostGres and SQL Server - Divided by a common language – SQLServerCentral

|
By David Poole, Grant Execute, Alloc UnitName
| SQL Server Central
My database career took off when I was sent on the two SQL Server 6.5 training courses. As a developer and later as a DBA I stayed with SQL Server until 2014. Since then I have been exposed to a variety of database platforms and technologies. I have reached the conclusion that, for me, it is hardest to retain new knowledge when the technology is familiar. It is not the differences that trip me up, it is the similarities.
Open in Who Shared Issue with article?

Creating a configurable SSMS script – SQLServerCentral

|
By Kenneth Fisher, Grant Execute
| SQL Server Central
Several times over the last few weeks I’ve gotten a request to create a new work database. The individuals from this team each have their own database that they can use as a type of scratch pad and I guess they’ve been hiring. It’s simple enough to create the database and then grant the necessary permissions, but let’s face it, after the first time I was already tired of the GUI and scripted the process out.
Open in Who Shared Issue with article?

Ensure that SSRS is Working while Using Availability Groups – SQLServerCentral

|
By Steve Rezhener, Grant Execute, Grant Select
| SQL Server Central
This blog post discusses SSRS in an Always On Availability Group. To make sure I'm staying laser focused on this topic, I need to cover some fundamentals. SSRS installation (SQL Server 2017 and later) Starting from SQL Server 2017, Microsoft decided to separate SSRS from a SQL Server installation container (ISO).
Open in Who Shared Issue with article?

Hacking SQL Server Stored Procedures - Part 3: SQL Injection

|
By Scott Sutherland, Execute As, Grant Execute
| blog.netspi.com
Introduction If you read the first two blogs in this series then you already know that SQL Server roles and privileges can be misconfigured in ways that allow users to escalate their privileges to a sysadmin (database administrator). Even when those roles and privileges are configured correctly, sometimes stored procedures can still be a threat.
Open in Who Shared Issue with article?

SQL Server Security: Fixed Database Roles – SQLServerCentral

|
By Brian Kelley Verified, Grant Execute
| SQL Server Central
In a previous article, SQL Server Security: Server Roles, I covered the fixed server roles included with SQL Server 2000. Another set of roles that are available to us are fixed database roles. As the name would imply, these are at the database level only. Like with fixed server roles, some of the fixed database roles, such as db_accessadmin and db_securityadmin, are designed to assist a DBA with delegating administrative responsibilities.
Open in Who Shared Issue with article?

Azure DWH part 10: WPF and Azure SQL Data Warehouse – SQLServerCentral

|
By Daniel Calbimonte, using System.Data, Using System.data. SqlClient, Grant Execute
| SQL Server Central
Introduction In our chapter 8, we learned how to create a simple C# in the Console Project using Visual Studio to access to ASDW. In this new chapter, we will learn how to create a C# WPF project, how to work with a configuration file (app.config), how to work with stored procedures with ASDW, and how to create an account with less privileges than the ASDW administrator. WPF (Windows Presentation Foundation) is a popular Microsoft graphical interface for desktop applications.
Open in Who Shared Issue with article?

Using XP_EXECRESULTSET To Obtain Database Size Information and More – SQLServerCentral

|
By Grant Execute, Declare Nvarchar, J. T. Shyman
| SQL Server Central
Having recently read Boris Baliner’s article on “Quickly Viewing Available Space” (http://www.sqlservercentral.com/columnists/bBaliner/quicklyviewingavailablespace.asp) and reading the ensuing conversation, it struck me that I knew a way to use Boris’ space formula and to execute it for every database on a server at the same time. This is what many of the users in the forum were asking for. The trick is in knowing about and how to use the undocumented stored procedure XP_EXECRESULTSET.
Open in Who Shared Issue with article?
Show More