When using linked servers, I believe, all processing occurs on the calling server. For processing to occur on the linked server you would use OpenQuery.
Oracle Corp. today unveiled MCP Server for Oracle Database, a new Model Context Protocol offering that brings artificial intelligence-powered interaction directly into its core database platform to ...