{
    "version": "https:\/\/jsonfeed.org\/version\/1.1",
    "title": "M9K blog: заметки с тегом Oracle",
    "_rss_description": "Заметки обо всём: devops, lifestyle, культура.",
    "_rss_language": "ru",
    "_itunes_email": "",
    "_itunes_categories_xml": "",
    "_itunes_image": "",
    "_itunes_explicit": "",
    "home_page_url": "https:\/\/blog.m9k.space\/tags\/oracle\/",
    "feed_url": "https:\/\/blog.m9k.space\/tags\/oracle\/json\/",
    "icon": "https:\/\/blog.m9k.space\/pictures\/userpic\/userpic@2x.jpg?1769095194",
    "authors": [
        {
            "name": "M",
            "url": "https:\/\/blog.m9k.space\/",
            "avatar": "https:\/\/blog.m9k.space\/pictures\/userpic\/userpic@2x.jpg?1769095194"
        }
    ],
    "items": [
        {
            "id": "183",
            "url": "https:\/\/blog.m9k.space\/all\/posmotret-telo-aktivnogo-sql-zaprosa-po-sid-u\/",
            "title": "Посмотреть тело активного SQL-запроса по SID-у",
            "content_html": "<pre class=\"e2-text-code\"><code class=\"\">select \n  a.sid, \n  a.serial#,\n  b.sql_text \nfrom \n  v$session a, \n  v$sqlarea b \nwhere \n  a.sql_address = b.address \n  and sid = $SID_NUMBER;<\/code><\/pre>",
            "summary": "",
            "date_published": "2025-03-19T15:08:40+07:00",
            "date_modified": "2025-04-23T12:56:23+07:00",
            "tags": [
                "Oracle",
                "SQL"
            ],
            "_date_published_rfc2822": "Wed, 19 Mar 2025 15:08:40 +0700",
            "_rss_guid_is_permalink": "false",
            "_rss_guid": "183",
            "_e2_data": {
                "is_favourite": false,
                "links_required": [
                    "highlight\/highlight.js",
                    "highlight\/highlight.css"
                ],
                "og_images": []
            }
        },
        {
            "id": "164",
            "url": "https:\/\/blog.m9k.space\/all\/oracle-cloning-scheme-in-entire-db\/",
            "title": "Oracle: Cloning scheme in entire DB",
            "content_html": "<pre class=\"e2-text-code\"><code class=\"\">&gt;CREATE USER &lt;SCHEME_DEST&gt; IDENTIFIED BY &quot;&lt;SCHEME_DEST_PASSWORD&gt;&quot;;\n&gt;GRANT CONNECT TO &lt;SCHEME_DEST&gt;;\n&gt;GRANT CREATE SESSION TO &lt;SCHEME_DEST&gt;;\n&gt;ALTER USER &lt;SCHEME_DEST&gt; quota unlimited on &lt;DEFAULT_USER_TABLESPACE&gt;;\n&gt;expdp system\/&lt;SYSTEM PASSWORD&gt;@&lt;DB_SID&gt; schemas=&lt;SCHEME_SRC&gt; directory=&lt;DIRECTORY NAME&gt; dumpfile=&lt;DUMP NAME&gt;.dmp logfile=explog.txt\n&gt;impdp system\/&lt;SYSTEM PASSWORD&gt;@&lt;DB_SID&gt; directory=&lt;DIRECTORY NAME&gt; dumpfile=&lt;DUMP NAME&gt;.dmp logfile=implog.txt remap_schema=&lt;SCHEME_SRC&gt;:&lt;SCHEME_DEST&gt; transform=OID:N<\/code><\/pre>",
            "summary": "",
            "date_published": "2024-08-06T14:27:14+07:00",
            "date_modified": "2024-08-06T14:34:11+07:00",
            "tags": [
                "expdp",
                "impdp",
                "Oracle",
                "администрирование",
                "системное администрирование"
            ],
            "_date_published_rfc2822": "Tue, 06 Aug 2024 14:27:14 +0700",
            "_rss_guid_is_permalink": "false",
            "_rss_guid": "164",
            "_e2_data": {
                "is_favourite": false,
                "links_required": [
                    "highlight\/highlight.js",
                    "highlight\/highlight.css"
                ],
                "og_images": []
            }
        },
        {
            "id": "121",
            "url": "https:\/\/blog.m9k.space\/all\/oracle-view-scheduler-jobs\/",
            "title": "Oracle — View Scheduler Jobs",
            "content_html": "<pre class=\"e2-text-code\"><code class=\"\">SELECT owner, job_name, comments FROM dba_scheduler_jobs;<\/code><\/pre>",
            "summary": "",
            "date_published": "2022-12-29T15:03:30+07:00",
            "date_modified": "2022-12-29T15:03:29+07:00",
            "tags": [
                "Jobs",
                "Oracle",
                "SQL",
                "sqlplus"
            ],
            "_date_published_rfc2822": "Thu, 29 Dec 2022 15:03:30 +0700",
            "_rss_guid_is_permalink": "false",
            "_rss_guid": "121",
            "_e2_data": {
                "is_favourite": false,
                "links_required": [
                    "highlight\/highlight.js",
                    "highlight\/highlight.css"
                ],
                "og_images": []
            }
        },
        {
            "id": "117",
            "url": "https:\/\/blog.m9k.space\/all\/oracle-disable-jobs\/",
            "title": "Oracle — Disable Jobs",
            "content_html": "<pre class=\"e2-text-code\"><code class=\"\">BEGIN\nDBMS_SCHEDULER.disable (NAME =&gt; &#039;JOB_NAME&#039;, FORCE =&gt; TRUE);\nEND;<\/code><\/pre>",
            "summary": "",
            "date_published": "2022-12-16T10:22:18+07:00",
            "date_modified": "2022-12-16T10:22:14+07:00",
            "tags": [
                "Jobs",
                "Oracle"
            ],
            "_date_published_rfc2822": "Fri, 16 Dec 2022 10:22:18 +0700",
            "_rss_guid_is_permalink": "false",
            "_rss_guid": "117",
            "_e2_data": {
                "is_favourite": false,
                "links_required": [
                    "highlight\/highlight.js",
                    "highlight\/highlight.css"
                ],
                "og_images": []
            }
        },
        {
            "id": "59",
            "url": "https:\/\/blog.m9k.space\/all\/sqlplus-i-kodirovka\/",
            "title": "SQLplus и кодировка",
            "content_html": "<p>Фикс:<\/p>\n<pre class=\"e2-text-code\"><code class=\"\">cmd\n&gt;set NLS_LANG=russian_cis.ru8pc866\n&gt;sqlplus<\/code><\/pre>",
            "summary": "Фикс",
            "date_published": "2020-12-10T11:35:12+07:00",
            "date_modified": "2025-02-27T15:12:06+07:00",
            "tags": [
                "Oracle",
                "sqlplus",
                "кодировка",
                "системное администрирование"
            ],
            "_date_published_rfc2822": "Thu, 10 Dec 2020 11:35:12 +0700",
            "_rss_guid_is_permalink": "false",
            "_rss_guid": "59",
            "_e2_data": {
                "is_favourite": false,
                "links_required": [
                    "highlight\/highlight.js",
                    "highlight\/highlight.css"
                ],
                "og_images": []
            }
        },
        {
            "id": "52",
            "url": "https:\/\/blog.m9k.space\/all\/processy-oracle\/",
            "title": "Процессы Oracle",
            "content_html": "<p>Наличие запущенных листенеров в памяти<\/p>\n<pre class=\"e2-text-code\"><code class=\"\">ps -ef | grep tnslsnr<\/code><\/pre><p>Запущенные инстансы Oracle SQL<\/p>\n<pre class=\"e2-text-code\"><code class=\"\">ps -ef | grep pmon | cut -s -f 3 -d &quot;_&quot;<\/code><\/pre>",
            "summary": "Наличие запущенных листенеров в памяти",
            "date_published": "2020-09-25T11:51:14+07:00",
            "date_modified": "2020-09-25T11:49:56+07:00",
            "tags": [
                "linux",
                "Oracle",
                "SQL",
                "Unix"
            ],
            "_date_published_rfc2822": "Fri, 25 Sep 2020 11:51:14 +0700",
            "_rss_guid_is_permalink": "false",
            "_rss_guid": "52",
            "_e2_data": {
                "is_favourite": false,
                "links_required": [
                    "highlight\/highlight.js",
                    "highlight\/highlight.css"
                ],
                "og_images": []
            }
        }
    ],
    "_e2_version": 4199,
    "_e2_ua_string": "Aegea 11.5 (v4199)"
}