Finding various software to make iPad sub-display
I forgot to write the English version of the article. I wrote early in the morning of May 5.
-
-
-
-
-
-
-
-
-
-
- -
-
-
-
-
-
-
-
-
-
This is my first article in a while. I hadn't written a article at all since I wrote my New Year's resolutions.
ryuchan.hatenablog.com
I haven't achieved what I had resoluted for at all. Ugh.
Here are my resolutions for this year. Write blogs regularly and publish technical information. Learn English every day and use it for my work.
New year’s resolution - 都内で働くSEの技術的なひとりごと / Technical soliloquy of System Engineer working in Tokyo
Due to "Corona Virus", Golden Week was turned into Gaman Week ("Gaman" means endurance.) as some governor had sent out by e-mail. Today (May 4), a state of emergency was declared extended until May 31. It looks like I'll still be WFH. The only way to achieve our goals is to improve efficiency, since I mostly work on a PC, so the only way to improve efficiency is to make iPad multi-display. Multi-display is a must. After the state of emergency was declared, I purchased one unsold display at an appliance store.
https://www.biccamera.com/bc/item/5286471/
However, there are many things that i want to keep open at all times while working, such as email, Teams, Twitter? Youtube? Facebook? It's annoying to switch between multiple applications. I want more sub-displays! So, I tried out four sub-display tools this time.
- Sidecar
- Duet Display
- Yam Display
- spacedesk
Sidecar connects to iPad from macOS and is very responsive and functional. However, the MAC has been taken over by my kid's cram school for online classes, so I can no longer use it at work.
Duet Display was probably very much in use on macOS until Sidecar was released. There are many items that can be configured, and it is as good as Sidecar. However, it's wired, and if i buy Duet Air, can do it wirelessly...
Yam Display is only for macOS, so I can't use it this time, unfortunately. So, I tried the last spacedesk and it fit my home requirements perfectly. What's more, it's free! The OS is limited to Windows. In addition, since the connection is via LAN, the sub-display device (iPad etc) must be connected to the same segment of LAN. In some companies, it may be difficult to connect personal devices to the company network, but this time it was not a problem at all because i'am WFH now. So, let's set it up quickly.
First, install the server function on the PC from which i want to connect. The application will be installed as below.
Next, install the Multi Monitor App on your iPad, which will be sub-display. After the installation, set the IP address of the PC on which the server function is installed.
After setting it up, can make it a sub-display by clicking on the red frame part of the tool.
As a result, my home environment looks like below, with a 5 sub-display lol.
Even with all these features, spacedesk is free software. Great!
I recently bought a new oven toaster. It's stylish, multi-functional and very easy to use. I highly recommend it.
www.cuisinart.jpiPad をサブディスプレイ化するソフトをいろいろ探してみた
久ぶりの投稿です。新年の抱負を書いて以来、まったく記事を書いていませんでした。
ryuchan.hatenablog.com
抱負としてあげていたこともまったく達成できていません。ううっ。
今年の抱負をあげます。 定期的にブログを書き、技術情報を公開すること。 毎日英語を勉強し、仕事に役立てること。
今年の抱負を書いてみた - 都内で働くSEの技術的なひとりごと / Technical soliloquy of System Engineer working in Tokyo
コロナウィルスの影響でゴールデンウイーク (GW) は、どこかの知事がメール配信していたようにガマンウィーク (GW) になってしまいました。本日 (5/4) に緊急事態宣言が 5/31 まで延長されました。在宅でのお仕事もまだまだ続きそうです。在宅で子供の面倒や家事などをしながらだと、仕事に集中する時間も限られますので、目標を達成するには効率をあげるしかありません。PC での作業が中心なので、効率を向上させるには....."マルチディスプレイ化" が必須です。緊急事態宣言後、家電量販店で売れ残っていたディスプレイを一台買いました。
https://www.biccamera.com/bc/item/5286471/
しかし、メール, Teams, Twitter?, Youtube?, Facebook?, 各種アプリ画面等々仕事中に常時開いておきたいものは多数あります。複数のアプリケーションを切り替えるのは億劫です。もっとサブディスプレイがほしい!というわけで、今回 4 つほどサブディスプレイツールを試してみました。
- Sidecar
- Duet Display
- Yam Display
- spacedesk
Sidecar は、macOS から iPad に接続するもので、レスポンス・機能ともに非常に優れています。ただ、mac は子供の塾でオンライン授業を行うことになったため、占有されてしまい、仕事で使うことができなくなりました。
Duet Display は、Sidecar がリリースされるまでは、macOS で非常に多くの人が使っていたかと思います。設定できる項目も多く、Sidecar に引けを取らない感じです。ただ、有線なんですよね。Duet Air を購入すれば無線でも可能になるんですが....
Yam Display は、macOS 専用なので、今回は残念ながら使えません。そこで、最後の spacedesk を試してみたんですが、私の在宅要件にぴったりはまりました。しかも、無料!接続元の OS は Windows に限られます。また、LAN 経由での接続になるため、サブディスプレイとなる機器 (iPad) などが、同一セグメントの LAN に接続している必要があります。会社では個人機器を社内ネットワークにつなぐのは難しいケースもあるかと思いますが、今回は在宅なので全く問題ありません。それでは、早速セットアップしてみましょう。
まず、接続元となる PC にサーバー機能をインストールします。下図のようなアプリケーションがインストールされます。
次に、サブディスプレイとなる iPad などに Multi Monitor App をインストールします。インストール後に、サーバー機能をインストールされた PC の IP アドレスを設定します。
設定後、ツールの赤枠部分をクリックすることで、サブモニタ化することができます。
結果、私の在宅環境は下図のようになりました。5面ディスプレイ笑
これだけの機能があり、フリーソフトとは。恐るべし、spacedesk!
最近、オーブントースターを買い換えました。これ、見た目おしゃれで、多機能で、すごく使いやすいです。お勧めです。
www.cuisinart.jpNew year’s resolution
A happy new year! I haven't written an article for a long time. I watch HAKONE EKIDEN, and at the same time, I write this article.
Last year, I changed a job and the technology I use has also changed. The OS changed from Windows to Redhat and CentOS, the virtual environment changed from Hyper-V to VMware Hypervisor, the development language changed from C # to Java, and the cloud environment changed from Azure to AWS. Recently, I have been playing with IncommingWebhook of Microsoft Teams with curl command.
Here are my resolutions for this year.
- Write blogs regularly and publish technical information.
- Learn English every day and use it for my work.
- Learn Linux.
- Learn VMware.
- Learn global operations at a foreign company.
I would like to make the above five points new year's resolutions. When I was looking at the Hakone Ekiden, I wanted shoes lol.
今年の抱負を書いてみた
あけましておめでとうございます。今年もよろしくお願いします。久しぶりの投稿です。箱根駅伝を見ながら、記事を書いています。去年は会社も変わり、それに伴い扱う技術も大きく変化しました。OS は、Windows から、Redhat, CentOS となり、仮想環境は Hyper-V から VMware Hypervisor となり、開発言語は C# から Java となり、そしてクラウド環境は Azure から AWS となりました。最近は、curl コマンドで Teams の IncommingWebhook とか使って遊んでいます。
今年の抱負をあげます。
上記、4点を抱負にしたいと思います。箱根駅伝見ていたら、シューズ 欲しくなってきた。
Started studying Oracle
I haven't posted an article recently. I was busy because my environment has changed. I had used only SQL Server, but now I need to use Oracle at work. ( I had used symfo....lol, too. ) I try to connect Oracle because I can not do anything. I try to connect Oracle, Using tool below.
a5m2.mmatsubara.com
User interface is below.
I try to use a little, I think that A5:SQL Mk-2 has many function and useful. I want to get an information about Oracle, I try to find like dmv and dmf in SQL Server. It is V$ table. Execute below query, you will get list of V$.
SELECT OBJECT_NAME FROM DBA_OBJECTS WHERE OBJECT_NAME LIKE 'V$%'
If you want to get information of Executing query in Oracle, execute below query.
SELECT vs.sid, vsa.sql_text, vs.serial#, vs.status, vs.machine, vs.osuser, vs.module, vs.username, vs.process FROM V$SESSION vs, V$SQLAREA vsa WHERE vs.prev_hash_value = vsa.hash_value AND vs.prev_sql_addr = vsa.address AND vs.status = 'ACTIVE'
Something like SQL Server's sys _exec_requests (Transact-sql) - SQL Server | Microsoft Docs and sys.dm_exec_sql_text (TRANSACT-SQL) - SQL Server | Microsoft Docs
There are many function of V$. It is possible to get so many information of Oracle Database.
V$ACCESS V$ACTIVE_INSTANCES V$ACTIVE_SERVICES V$ACTIVE_SESSION_HISTORY V$ACTIVE_SESS_POOL_MTH V$ADVISOR_CURRENT_SQLPLAN V$ADVISOR_PROGRESS V$ALERT_TYPES V$AQ V$AQ1 V$AQ_BACKGROUND_COORDINATOR V$AQ_BMAP_NONDUR_SUBSCRIBERS V$AQ_CROSS_INSTANCE_JOBS V$AQ_JOB_COORDINATOR V$AQ_MESSAGE_CACHE V$AQ_MSGBM V$AQ_NONDUR_REGISTRATIONS V$AQ_NONDUR_SUBSCRIBER V$AQ_NONDUR_SUBSCRIBER_LWM V$AQ_NOTIFICATION_CLIENTS V$AQ_SERVER_POOL V$AQ_SUBSCRIBER_LOAD V$ARCHIVE V$ARCHIVED_LOG V$ARCHIVE_DEST V$ARCHIVE_DEST_STATUS V$ARCHIVE_GAP V$ARCHIVE_PROCESSES V$ASH_INFO V$ASM_ACFSREPL V$ASM_ACFSREPLTAG V$ASM_ACFSSNAPSHOTS V$ASM_ACFSTAG V$ASM_ACFSVOLUMES V$ASM_ACFS_ENCRYPTION_INFO V$ASM_ACFS_SECURITY_INFO V$ASM_ACFS_SEC_ADMIN V$ASM_ACFS_SEC_CMDRULE V$ASM_ACFS_SEC_REALM V$ASM_ACFS_SEC_REALM_FILTER V$ASM_ACFS_SEC_REALM_GROUP V$ASM_ACFS_SEC_REALM_USER V$ASM_ACFS_SEC_RULE V$ASM_ACFS_SEC_RULESET V$ASM_ACFS_SEC_RULESET_RULE V$ASM_ALIAS V$ASM_ATTRIBUTE V$ASM_AUDIT_CLEANUP_JOBS V$ASM_AUDIT_CLEAN_EVENTS V$ASM_AUDIT_CONFIG_PARAMS V$ASM_AUDIT_LAST_ARCH_TS V$ASM_CLIENT V$ASM_DISK V$ASM_DISKGROUP V$ASM_DISKGROUP_SPARSE V$ASM_DISKGROUP_STAT V$ASM_DISK_IOSTAT V$ASM_DISK_IOSTAT_SPARSE V$ASM_DISK_SPARSE V$ASM_DISK_SPARSE_STAT V$ASM_DISK_STAT V$ASM_ESTIMATE V$ASM_FILE V$ASM_FILESYSTEM V$ASM_OPERATION V$ASM_TEMPLATE V$ASM_USER V$ASM_USERGROUP V$ASM_USERGROUP_MEMBER V$ASM_VOLUME V$ASM_VOLUME_STAT V$AW_AGGREGATE_OP V$AW_ALLOCATE_OP V$AW_CALC V$AW_LONGOPS V$AW_OLAP V$AW_SESSION_INFO V$BACKUP V$BACKUP_ARCHIVELOG_DETAILS V$BACKUP_ARCHIVELOG_SUMMARY V$BACKUP_ASYNC_IO V$BACKUP_CONTROLFILE_DETAILS V$BACKUP_CONTROLFILE_SUMMARY V$BACKUP_COPY_DETAILS V$BACKUP_COPY_SUMMARY V$BACKUP_CORRUPTION V$BACKUP_DATAFILE V$BACKUP_DATAFILE_DETAILS V$BACKUP_DATAFILE_SUMMARY V$BACKUP_DEVICE V$BACKUP_FILES V$BACKUP_NONLOGGED V$BACKUP_PIECE V$BACKUP_PIECE_DETAILS V$BACKUP_REDOLOG V$BACKUP_SET V$BACKUP_SET_DETAILS V$BACKUP_SET_SUMMARY V$BACKUP_SPFILE V$BACKUP_SPFILE_DETAILS V$BACKUP_SPFILE_SUMMARY V$BACKUP_SYNC_IO V$BGPROCESS V$BH V$BLOCKING_QUIESCE V$BLOCK_CHANGE_TRACKING V$BSP V$BTS_STAT V$BT_SCAN_CACHE V$BT_SCAN_OBJ_TEMPS V$BUFFERED_PUBLISHERS V$BUFFERED_QUEUES V$BUFFERED_SUBSCRIBERS V$BUFFER_POOL V$BUFFER_POOL_STATISTICS V$CACHE V$CACHE_LOCK V$CACHE_TRANSFER V$CALLTAG V$CELL V$CELL_CONFIG V$CELL_CONFIG_INFO V$CELL_DB V$CELL_DB_HISTORY V$CELL_DISK V$CELL_DISK_HISTORY V$CELL_GLOBAL V$CELL_GLOBAL_HISTORY V$CELL_IOREASON V$CELL_IOREASON_NAME V$CELL_METRIC_DESC V$CELL_OFL_THREAD_HISTORY V$CELL_OPEN_ALERTS V$CELL_REQUEST_TOTALS V$CELL_STATE V$CELL_THREAD_HISTORY V$CHANNEL_WAITS V$CIRCUIT V$CLASS_CACHE_TRANSFER V$CLASS_PING V$CLIENT_SECRETS V$CLIENT_STATS V$CLONEDFILE V$CLUSTER_INTERCONNECTS V$CONFIGURED_INTERCONNECTS V$CONTAINERS V$CONTEXT V$CONTROLFILE V$CONTROLFILE_RECORD_SECTION V$CON_SYSSTAT V$CON_SYSTEM_EVENT V$CON_SYSTEM_WAIT_CLASS V$CON_SYS_TIME_MODEL V$COPY_CORRUPTION V$COPY_NONLOGGED V$CORRUPT_XID_LIST V$CPOOL_CC_INFO V$CPOOL_CC_STATS V$CPOOL_CONN_INFO V$CPOOL_STATS V$CR_BLOCK_SERVER V$CURRENT_BLOCK_SERVER V$DATABASE V$DATABASE_BLOCK_CORRUPTION V$DATABASE_INCARNATION V$DATABASE_KEY_INFO V$DATAFILE V$DATAFILE_COPY V$DATAFILE_HEADER V$DATAGUARD_CONFIG V$DATAGUARD_STATS V$DATAGUARD_STATUS V$DATAPUMP_JOB V$DATAPUMP_SESSION V$DBFILE V$DBLINK V$DB_CACHE_ADVICE V$DB_OBJECT_CACHE V$DB_PIPES V$DB_TRANSPORTABLE_PLATFORM V$DEAD_CLEANUP V$DELETED_OBJECT V$DETACHED_SESSION V$DG_BROKER_CONFIG V$DIAG_ADR_CONTROL V$DIAG_ADR_INVALIDATION V$DIAG_ALERT_EXT V$DIAG_AMS_XACTION V$DIAG_CRITICAL_ERROR V$DIAG_DDE_USER_ACTION V$DIAG_DDE_USER_ACTION_DEF V$DIAG_DDE_USR_ACT_PARAM V$DIAG_DDE_USR_ACT_PARAM_DEF V$DIAG_DDE_USR_INC_ACT_MAP V$DIAG_DDE_USR_INC_TYPE V$DIAG_DFW_CONFIG_CAPTURE V$DIAG_DFW_CONFIG_ITEM V$DIAG_DFW_PATCH_CAPTURE V$DIAG_DFW_PATCH_ITEM V$DIAG_DIAGV_INCIDENT V$DIAG_DIR_EXT V$DIAG_EM_DIAG_JOB V$DIAG_EM_TARGET_INFO V$DIAG_EM_USER_ACTIVITY V$DIAG_HM_FDG_SET V$DIAG_HM_FINDING V$DIAG_HM_INFO V$DIAG_HM_MESSAGE V$DIAG_HM_RECOMMENDATION V$DIAG_HM_RUN V$DIAG_INCCKEY V$DIAG_INCIDENT V$DIAG_INCIDENT_FILE V$DIAG_INC_METER_CONFIG V$DIAG_INC_METER_IMPT_DEF V$DIAG_INC_METER_INFO V$DIAG_INC_METER_PK_IMPTS V$DIAG_INC_METER_SUMMARY V$DIAG_INFO V$DIAG_IPS_CONFIGURATION V$DIAG_IPS_FILE_COPY_LOG V$DIAG_IPS_FILE_METADATA V$DIAG_IPS_PACKAGE V$DIAG_IPS_PACKAGE_FILE V$DIAG_IPS_PACKAGE_HISTORY V$DIAG_IPS_PACKAGE_INCIDENT V$DIAG_IPS_PKG_UNPACK_HIST V$DIAG_IPS_PROGRESS_LOG V$DIAG_IPS_REMOTE_PACKAGE V$DIAG_LOG_EXT V$DIAG_PICKLEERR V$DIAG_PROBLEM V$DIAG_RELMD_EXT V$DIAG_SWEEPERR V$DIAG_VEM_USER_ACTLOG V$DIAG_VEM_USER_ACTLOG1 V$DIAG_VHM_RUN V$DIAG_VIEW V$DIAG_VIEWCOL V$DIAG_VINCIDENT V$DIAG_VINCIDENT_FILE V$DIAG_VINC_METER_INFO V$DIAG_VIPS_FILE_COPY_LOG V$DIAG_VIPS_FILE_METADATA V$DIAG_VIPS_PACKAGE_FILE V$DIAG_VIPS_PACKAGE_HISTORY V$DIAG_VIPS_PACKAGE_MAIN_INT V$DIAG_VIPS_PACKAGE_SIZE V$DIAG_VIPS_PKG_FILE V$DIAG_VIPS_PKG_INC_CAND V$DIAG_VIPS_PKG_INC_DTL V$DIAG_VIPS_PKG_INC_DTL1 V$DIAG_VIPS_PKG_MAIN_PROBLEM V$DIAG_VNOT_EXIST_INCIDENT V$DIAG_VPROBLEM V$DIAG_VPROBLEM1 V$DIAG_VPROBLEM2 V$DIAG_VPROBLEM_BUCKET V$DIAG_VPROBLEM_BUCKET1 V$DIAG_VPROBLEM_BUCKET_COUNT V$DIAG_VPROBLEM_INT V$DIAG_VPROBLEM_LASTINC V$DIAG_VSHOWCATVIEW V$DIAG_VSHOWINCB V$DIAG_VSHOWINCB_I V$DIAG_VTEST_EXISTS V$DIAG_V_ACTINC V$DIAG_V_ACTPROB V$DIAG_V_INCCOUNT V$DIAG_V_INCFCOUNT V$DIAG_V_INC_METER_INFO_PROB V$DIAG_V_IPSPRBCNT V$DIAG_V_IPSPRBCNT1 V$DIAG_V_NFCINC V$DIAG_V_SWPERRCOUNT V$DISK_RESTORE_RANGE V$DISPATCHER V$DISPATCHER_CONFIG V$DISPATCHER_RATE V$DLM_ALL_LOCKS V$DLM_CONVERT_LOCAL V$DLM_CONVERT_REMOTE V$DLM_LATCH V$DLM_LOCKS V$DLM_MISC V$DLM_RESS V$DLM_TRAFFIC_CONTROLLER V$DNFS_CHANNELS V$DNFS_FILES V$DNFS_SERVERS V$DNFS_STATS V$DYNAMIC_REMASTER_STATS V$EDITIONABLE_TYPES V$EMON V$EMX_USAGE_STATS V$ENABLEDPRIVS V$ENCRYPTED_TABLESPACES V$ENCRYPTION_KEYS V$ENCRYPTION_WALLET V$ENQUEUE_LOCK V$ENQUEUE_STAT V$ENQUEUE_STATISTICS V$EVENTMETRIC V$EVENT_HISTOGRAM V$EVENT_HISTOGRAM_MICRO V$EVENT_NAME V$EXECUTION V$FALSE_PING V$FAST_START_SERVERS V$FAST_START_TRANSACTIONS V$FILEMETRIC V$FILEMETRIC_HISTORY V$FILESPACE_USAGE V$FILESTAT V$FILE_CACHE_TRANSFER V$FILE_HISTOGRAM V$FILE_OPTIMIZED_HISTOGRAM V$FILE_PING V$FIXED_TABLE V$FIXED_VIEW_DEFINITION V$FLASHBACK_DATABASE_LOG V$FLASHBACK_DATABASE_LOGFILE V$FLASHBACK_DATABASE_STAT V$FLASHBACK_TXN_GRAPH V$FLASHBACK_TXN_MODS V$FLASHFILESTAT V$FLASH_RECOVERY_AREA_USAGE V$FOREIGN_ARCHIVED_LOG V$FS_FAILOVER_HISTOGRAM V$FS_FAILOVER_STATS V$FS_OBSERVER_HISTOGRAM V$GCSHVMASTER_INFO V$GCSPFMASTER_INFO V$GC_ELEMENT V$GC_ELEMENTS_WITH_COLLISIONS V$GES_BLOCKING_ENQUEUE V$GES_CONVERT_LOCAL V$GES_CONVERT_REMOTE V$GES_DEADLOCKS V$GES_DEADLOCK_SESSIONS V$GES_ENQUEUE V$GES_LATCH V$GES_RESOURCE V$GES_STATISTICS V$GES_TRAFFIC_CONTROLLER V$GG_APPLY_COORDINATOR V$GG_APPLY_READER V$GG_APPLY_RECEIVER V$GG_APPLY_SERVER V$GLOBALCONTEXT V$GLOBAL_BLOCKED_LOCKS V$GLOBAL_TRANSACTION V$GOLDENGATE_CAPABILITIES V$GOLDENGATE_CAPTURE V$GOLDENGATE_MESSAGE_TRACKING V$GOLDENGATE_TABLE_STATS V$GOLDENGATE_TRANSACTION V$HANG_INFO V$HANG_SESSION_INFO V$HANG_STATISTICS V$HEAT_MAP_SEGMENT V$HM_CHECK V$HM_CHECK_PARAM V$HM_FINDING V$HM_INFO V$HM_RECOMMENDATION V$HM_RUN V$HS_AGENT V$HS_PARAMETER V$HS_SESSION V$HVMASTER_INFO V$IM_COLUMN_LEVEL V$IM_COL_CU V$IM_HEADER V$IM_SEGMENTS V$IM_SEGMENTS_DETAIL V$IM_SEG_EXT_MAP V$IM_SMU_CHUNK V$IM_SMU_HEAD V$IM_TBS_EXT_MAP V$IM_USER_SEGMENTS V$INCMETER_CONFIG V$INCMETER_INFO V$INCMETER_SUMMARY V$INDEXED_FIXED_COLUMN V$INMEMORY_AREA V$INSTANCE V$INSTANCE_CACHE_TRANSFER V$INSTANCE_LOG_GROUP V$INSTANCE_PING V$INSTANCE_RECOVERY V$IOFUNCMETRIC V$IOFUNCMETRIC_HISTORY V$IOSTAT_CONSUMER_GROUP V$IOSTAT_FILE V$IOSTAT_FUNCTION V$IOSTAT_FUNCTION_DETAIL V$IOSTAT_NETWORK V$IOS_CLIENT V$IO_CALIBRATION_STATUS V$IO_OUTLIER V$IR_FAILURE V$IR_FAILURE_SET V$IR_MANUAL_CHECKLIST V$IR_REPAIR V$JAVAPOOL V$JAVA_LIBRARY_CACHE_MEMORY V$JAVA_POOL_ADVICE V$KERNEL_IO_OUTLIER V$KEY_VECTOR V$LATCH V$LATCHHOLDER V$LATCHNAME V$LATCH_CHILDREN V$LATCH_MISSES V$LATCH_PARENT V$LGWRIO_OUTLIER V$LIBCACHE_LOCKS V$LIBRARYCACHE V$LIBRARY_CACHE_MEMORY V$LICENSE V$LISTENER_NETWORK V$LOADISTAT V$LOADPSTAT V$LOBSTAT V$LOCK V$LOCKED_OBJECT V$LOCKS_WITH_COLLISIONS V$LOCK_ACTIVITY V$LOCK_ELEMENT V$LOCK_TYPE V$LOG V$LOGFILE V$LOGHIST V$LOGMNR_CONTENTS V$LOGMNR_DICTIONARY V$LOGMNR_DICTIONARY_LOAD V$LOGMNR_LATCH V$LOGMNR_LOGFILE V$LOGMNR_LOGS V$LOGMNR_PARAMETERS V$LOGMNR_PROCESS V$LOGMNR_SESSION V$LOGMNR_STATS V$LOGMNR_TRANSACTION V$LOGSTDBY V$LOGSTDBY_PROCESS V$LOGSTDBY_PROGRESS V$LOGSTDBY_STATE V$LOGSTDBY_STATS V$LOGSTDBY_TRANSACTION V$LOG_HISTORY V$MANAGED_STANDBY V$MAPPED_SQL V$MAP_COMP_LIST V$MAP_ELEMENT V$MAP_EXT_ELEMENT V$MAP_FILE V$MAP_FILE_EXTENT V$MAP_FILE_IO_STACK V$MAP_LIBRARY V$MAP_SUBELEMENT V$MAX_ACTIVE_SESS_TARGET_MTH V$MEMORY_CURRENT_RESIZE_OPS V$MEMORY_DYNAMIC_COMPONENTS V$MEMORY_RESIZE_OPS V$MEMORY_TARGET_ADVICE V$METRIC V$METRICGROUP V$METRICNAME V$METRIC_HISTORY V$MTTR_TARGET_ADVICE V$MUTEX_SLEEP V$MUTEX_SLEEP_HISTORY V$MVREFRESH V$MYSTAT V$NFS_CLIENTS V$NFS_LOCKS V$NFS_OPEN_FILES V$NLS_PARAMETERS V$NLS_VALID_VALUES V$NONLOGGED_BLOCK V$OBJECT_DEPENDENCY V$OBJECT_DML_FREQUENCIES V$OBJECT_PRIVILEGE V$OBJECT_USAGE V$OBSOLETE_PARAMETER V$OFFLINE_RANGE V$OFSMOUNT V$OFS_STATS V$OPEN_CURSOR V$OPTIMIZER_PROCESSING_RATE V$OPTION V$OSSTAT V$PARALLEL_DEGREE_LIMIT_MTH V$PARAMETER V$PARAMETER2 V$PARAMETER_VALID_VALUES V$PATCHES V$PDBS V$PDB_INCARNATION V$PERSISTENT_PUBLISHERS V$PERSISTENT_QMN_CACHE V$PERSISTENT_QUEUES V$PERSISTENT_SUBSCRIBERS V$PGASTAT V$PGA_TARGET_ADVICE V$PGA_TARGET_ADVICE_HISTOGRAM V$PING V$POLICY_HISTORY V$PQ_SESSTAT V$PQ_SLAVE V$PQ_SYSSTAT V$PQ_TQSTAT V$PROCESS V$PROCESS_GROUP V$PROCESS_MEMORY V$PROCESS_MEMORY_DETAIL V$PROCESS_MEMORY_DETAIL_PROG V$PROPAGATION_RECEIVER V$PROPAGATION_SENDER V$PROXY_ARCHIVEDLOG V$PROXY_ARCHIVELOG_DETAILS V$PROXY_ARCHIVELOG_SUMMARY V$PROXY_COPY_DETAILS V$PROXY_COPY_SUMMARY V$PROXY_DATAFILE V$PWFILE_USERS V$PX_BUFFER_ADVICE V$PX_INSTANCE_GROUP V$PX_PROCESS V$PX_PROCESS_SYSSTAT V$PX_PROCESS_TRACE V$PX_SESSION V$PX_SESSTAT V$QMON_COORDINATOR_STATS V$QMON_SERVER_STATS V$QMON_TASKS V$QMON_TASK_STATS V$QUEUE V$QUEUEING_MTH V$RECOVERY_AREA_USAGE V$RECOVERY_FILE_DEST V$RECOVERY_FILE_STATUS V$RECOVERY_LOG V$RECOVERY_PROGRESS V$RECOVERY_STATUS V$RECOVER_FILE V$REDO_DEST_RESP_HISTOGRAM V$REPLAY_CONTEXT V$REPLAY_CONTEXT_LOB V$REPLAY_CONTEXT_SEQUENCE V$REPLAY_CONTEXT_SYSDATE V$REPLAY_CONTEXT_SYSGUID V$REPLAY_CONTEXT_SYSTIMESTAMP V$REPLPROP V$REPLQUEUE V$REQDIST V$RESERVED_WORDS V$RESOURCE V$RESOURCE_LIMIT V$RESTORE_POINT V$RESTORE_RANGE V$RESULT_CACHE_DEPENDENCY V$RESULT_CACHE_MEMORY V$RESULT_CACHE_OBJECTS V$RESULT_CACHE_STATISTICS V$RESUMABLE V$RFS_THREAD V$RMAN_BACKUP_JOB_DETAILS V$RMAN_BACKUP_SUBJOB_DETAILS V$RMAN_BACKUP_TYPE V$RMAN_COMPRESSION_ALGORITHM V$RMAN_CONFIGURATION V$RMAN_ENCRYPTION_ALGORITHMS V$RMAN_OUTPUT V$RMAN_STATUS V$ROLLNAME V$ROLLSTAT V$ROWCACHE V$ROWCACHE_PARENT V$ROWCACHE_SUBORDINATE V$RO_USER_ACCOUNT V$RSRCMGRMETRIC V$RSRCMGRMETRIC_HISTORY V$RSRC_CONSUMER_GROUP V$RSRC_CONSUMER_GROUP_CPU_MTH V$RSRC_CONS_GROUP_HISTORY V$RSRC_PLAN V$RSRC_PLAN_CPU_MTH V$RSRC_PLAN_HISTORY V$RSRC_SESSION_INFO V$RT_ADDM_CONTROL V$RULE V$RULE_SET V$RULE_SET_AGGREGATE_STATS V$SBT_RESTORE_RANGE V$SCHEDULER_INMEM_MDINFO V$SCHEDULER_INMEM_RTINFO V$SCHEDULER_RUNNING_JOBS V$SECUREFILE_TIMER V$SEGMENT_STATISTICS V$SEGSPACE_USAGE V$SEGSTAT V$SEGSTAT_NAME V$SERVICEMETRIC V$SERVICEMETRIC_HISTORY V$SERVICES V$SERVICE_EVENT V$SERVICE_STATS V$SERVICE_WAIT_CLASS V$SERV_MOD_ACT_STATS V$SESSION V$SESSIONS_COUNT V$SESSION_BLOCKERS V$SESSION_CONNECT_INFO V$SESSION_CURSOR_CACHE V$SESSION_EVENT V$SESSION_FIX_CONTROL V$SESSION_LONGOPS V$SESSION_OBJECT_CACHE V$SESSION_WAIT V$SESSION_WAIT_CLASS V$SESSION_WAIT_HISTORY V$SESSMETRIC V$SESSTAT V$SESS_IO V$SESS_TIME_MODEL V$SES_OPTIMIZER_ENV V$SGA V$SGAINFO V$SGASTAT V$SGA_CURRENT_RESIZE_OPS V$SGA_DYNAMIC_COMPONENTS V$SGA_DYNAMIC_FREE_MEMORY V$SGA_RESIZE_OPS V$SGA_TARGET_ADVICE V$SHARED_POOL_ADVICE V$SHARED_POOL_RESERVED V$SHARED_SERVER V$SHARED_SERVER_MONITOR V$SORT_SEGMENT V$SORT_USAGE V$SPPARAMETER V$SQL V$SQLAREA V$SQLAREA_PLAN_HASH V$SQLCOMMAND V$SQLFN_ARG_METADATA V$SQLFN_METADATA V$SQLPA_METRIC V$SQLSTATS V$SQLSTATS_PLAN_HASH V$SQLTEXT V$SQLTEXT_WITH_NEWLINES V$SQL_BIND_CAPTURE V$SQL_BIND_DATA V$SQL_BIND_METADATA V$SQL_CS_HISTOGRAM V$SQL_CS_SELECTIVITY V$SQL_CS_STATISTICS V$SQL_CURSOR V$SQL_DIAG_REPOSITORY V$SQL_DIAG_REPOSITORY_REASON V$SQL_FEATURE V$SQL_FEATURE_DEPENDENCY V$SQL_FEATURE_HIERARCHY V$SQL_HINT V$SQL_JOIN_FILTER V$SQL_MONITOR V$SQL_MONITOR_SESSTAT V$SQL_MONITOR_STATNAME V$SQL_OPTIMIZER_ENV V$SQL_PLAN V$SQL_PLAN_MONITOR V$SQL_PLAN_STATISTICS V$SQL_PLAN_STATISTICS_ALL V$SQL_REDIRECTION V$SQL_REOPTIMIZATION_HINTS V$SQL_SHARED_CURSOR V$SQL_SHARED_MEMORY V$SQL_WORKAREA V$SQL_WORKAREA_ACTIVE V$SQL_WORKAREA_HISTOGRAM V$SSCR_SESSIONS V$STANDBY_EVENT_HISTOGRAM V$STANDBY_LOG V$STATISTICS_LEVEL V$STATNAME V$STREAMS_APPLY_COORDINATOR V$STREAMS_APPLY_READER V$STREAMS_APPLY_SERVER V$STREAMS_CAPTURE V$STREAMS_MESSAGE_TRACKING V$STREAMS_POOL_ADVICE V$STREAMS_POOL_STATISTICS V$STREAMS_TRANSACTION V$SUBCACHE V$SUBSCR_REGISTRATION_STATS V$SYSAUX_OCCUPANTS V$SYSMETRIC V$SYSMETRIC_HISTORY V$SYSMETRIC_SUMMARY V$SYSSTAT V$SYSTEM_CURSOR_CACHE V$SYSTEM_EVENT V$SYSTEM_FIX_CONTROL V$SYSTEM_PARAMETER V$SYSTEM_PARAMETER2 V$SYSTEM_WAIT_CLASS V$SYS_OPTIMIZER_ENV V$SYS_REPORT_REQUESTS V$SYS_REPORT_STATS V$SYS_TIME_MODEL V$TABLESPACE V$TEMPFILE V$TEMPORARY_LOBS V$TEMPSEG_USAGE V$TEMPSTAT V$TEMPUNDOSTAT V$TEMP_CACHE_TRANSFER V$TEMP_EXTENT_MAP V$TEMP_EXTENT_POOL V$TEMP_PING V$TEMP_SPACE_HEADER V$THREAD V$THRESHOLD_TYPES V$TIMER V$TIMEZONE_FILE V$TIMEZONE_NAMES V$TOPLEVELCALL V$TRANSACTION V$TRANSACTION_ENQUEUE V$TRANSPORTABLE_PLATFORM V$TSDP_SUPPORTED_FEATURE V$TSM_SESSIONS V$TYPE_SIZE V$UNDOSTAT V$UNIFIED_AUDIT_RECORD_FORMAT V$UNIFIED_AUDIT_TRAIL V$UNUSABLE_BACKUPFILE_DETAILS V$VERSION V$VPD_POLICY V$WAITCLASSMETRIC V$WAITCLASSMETRIC_HISTORY V$WAITSTAT V$WAIT_CHAINS V$WALLET V$WLM_PCMETRIC V$WLM_PCMETRIC_HISTORY V$WLM_PC_STATS V$WORKLOAD_REPLAY_THREAD V$XML_AUDIT_TRAIL V$XSTREAM_APPLY_COORDINATOR V$XSTREAM_APPLY_READER V$XSTREAM_APPLY_RECEIVER V$XSTREAM_APPLY_SERVER V$XSTREAM_CAPTURE V$XSTREAM_MESSAGE_TRACKING V$XSTREAM_OUTBOUND_SERVER V$XSTREAM_TABLE_STATS V$XSTREAM_TRANSACTION V$XS_SESSIONS V$XS_SESSION_NS_ATTRIBUTE V$XS_SESSION_NS_ATTRIBUTES V$XS_SESSION_ROLE V$XS_SESSION_ROLES V$_LOCK
I bought drive recorder what can be connect by using smart phone. I wonder if it can be connected by using REST API. If it is true, excellent!
カーメイト ドライブレコーダー アクションカメラ 360度カメラ ダクション 360S 前後 左右 撮影 超広角 全天球モデル スマホ連携 駐車監視オプションあり DC5000
- 出版社/メーカー: カーメイト(CARMATE)
- 発売日: 2018/12/03
- メディア: Automotive
- この商品を含むブログを見る
オラクルの勉強開始してみた
最近、ブログを書いていませんでした。個人的には色々環境が変わり、少しバタバタしていたためです。データベースは、SQL Server しか使ったことはないのですが ( Sy〇fo とかも少しだけ扱ったことありますが... )、業務上 Oracle を使わないければならなくなりました。まずはデータベースに接続しないと何も始まらないので、下記のツールを使ってみることにしました。
a5m2.mmatsubara.com
ツールはこんな感じです。
触ってみると、かなり多機能なツールで使い勝手もよさそうです。まずは、オラクルに関する情報を取得したい、SQL Server でいう DMVとか、DMF などを探してみました。V$ 表というものがあるのですね。どんなものがあるかは、下記のクエリを実行することでわかります。
SELECT OBJECT_NAME FROM DBA_OBJECTS WHERE OBJECT_NAME LIKE 'V$%'
実行中の SQL を取得したい場合は、下記のクエリを実行することで取得できます。
SELECT vs.sid, vsa.sql_text, vs.serial#, vs.status, vs.machine, vs.osuser, vs.module, vs.username, vs.process FROM V$SESSION vs, V$SQLAREA vsa WHERE vs.prev_hash_value = vsa.hash_value AND vs.prev_sql_addr = vsa.address AND vs.status = 'ACTIVE'
SQL Server の sys _exec_requests (Transact-sql) - SQL Server | Microsoft Docs と sys.dm_exec_sql_text (TRANSACT-SQL) - SQL Server | Microsoft Docs みたいなもんですね。
まだまだたくさんあります。これだけあれば、問題なく情報が取得できそうです。
V$ACCESS V$ACTIVE_INSTANCES V$ACTIVE_SERVICES V$ACTIVE_SESSION_HISTORY V$ACTIVE_SESS_POOL_MTH V$ADVISOR_CURRENT_SQLPLAN V$ADVISOR_PROGRESS V$ALERT_TYPES V$AQ V$AQ1 V$AQ_BACKGROUND_COORDINATOR V$AQ_BMAP_NONDUR_SUBSCRIBERS V$AQ_CROSS_INSTANCE_JOBS V$AQ_JOB_COORDINATOR V$AQ_MESSAGE_CACHE V$AQ_MSGBM V$AQ_NONDUR_REGISTRATIONS V$AQ_NONDUR_SUBSCRIBER V$AQ_NONDUR_SUBSCRIBER_LWM V$AQ_NOTIFICATION_CLIENTS V$AQ_SERVER_POOL V$AQ_SUBSCRIBER_LOAD V$ARCHIVE V$ARCHIVED_LOG V$ARCHIVE_DEST V$ARCHIVE_DEST_STATUS V$ARCHIVE_GAP V$ARCHIVE_PROCESSES V$ASH_INFO V$ASM_ACFSREPL V$ASM_ACFSREPLTAG V$ASM_ACFSSNAPSHOTS V$ASM_ACFSTAG V$ASM_ACFSVOLUMES V$ASM_ACFS_ENCRYPTION_INFO V$ASM_ACFS_SECURITY_INFO V$ASM_ACFS_SEC_ADMIN V$ASM_ACFS_SEC_CMDRULE V$ASM_ACFS_SEC_REALM V$ASM_ACFS_SEC_REALM_FILTER V$ASM_ACFS_SEC_REALM_GROUP V$ASM_ACFS_SEC_REALM_USER V$ASM_ACFS_SEC_RULE V$ASM_ACFS_SEC_RULESET V$ASM_ACFS_SEC_RULESET_RULE V$ASM_ALIAS V$ASM_ATTRIBUTE V$ASM_AUDIT_CLEANUP_JOBS V$ASM_AUDIT_CLEAN_EVENTS V$ASM_AUDIT_CONFIG_PARAMS V$ASM_AUDIT_LAST_ARCH_TS V$ASM_CLIENT V$ASM_DISK V$ASM_DISKGROUP V$ASM_DISKGROUP_SPARSE V$ASM_DISKGROUP_STAT V$ASM_DISK_IOSTAT V$ASM_DISK_IOSTAT_SPARSE V$ASM_DISK_SPARSE V$ASM_DISK_SPARSE_STAT V$ASM_DISK_STAT V$ASM_ESTIMATE V$ASM_FILE V$ASM_FILESYSTEM V$ASM_OPERATION V$ASM_TEMPLATE V$ASM_USER V$ASM_USERGROUP V$ASM_USERGROUP_MEMBER V$ASM_VOLUME V$ASM_VOLUME_STAT V$AW_AGGREGATE_OP V$AW_ALLOCATE_OP V$AW_CALC V$AW_LONGOPS V$AW_OLAP V$AW_SESSION_INFO V$BACKUP V$BACKUP_ARCHIVELOG_DETAILS V$BACKUP_ARCHIVELOG_SUMMARY V$BACKUP_ASYNC_IO V$BACKUP_CONTROLFILE_DETAILS V$BACKUP_CONTROLFILE_SUMMARY V$BACKUP_COPY_DETAILS V$BACKUP_COPY_SUMMARY V$BACKUP_CORRUPTION V$BACKUP_DATAFILE V$BACKUP_DATAFILE_DETAILS V$BACKUP_DATAFILE_SUMMARY V$BACKUP_DEVICE V$BACKUP_FILES V$BACKUP_NONLOGGED V$BACKUP_PIECE V$BACKUP_PIECE_DETAILS V$BACKUP_REDOLOG V$BACKUP_SET V$BACKUP_SET_DETAILS V$BACKUP_SET_SUMMARY V$BACKUP_SPFILE V$BACKUP_SPFILE_DETAILS V$BACKUP_SPFILE_SUMMARY V$BACKUP_SYNC_IO V$BGPROCESS V$BH V$BLOCKING_QUIESCE V$BLOCK_CHANGE_TRACKING V$BSP V$BTS_STAT V$BT_SCAN_CACHE V$BT_SCAN_OBJ_TEMPS V$BUFFERED_PUBLISHERS V$BUFFERED_QUEUES V$BUFFERED_SUBSCRIBERS V$BUFFER_POOL V$BUFFER_POOL_STATISTICS V$CACHE V$CACHE_LOCK V$CACHE_TRANSFER V$CALLTAG V$CELL V$CELL_CONFIG V$CELL_CONFIG_INFO V$CELL_DB V$CELL_DB_HISTORY V$CELL_DISK V$CELL_DISK_HISTORY V$CELL_GLOBAL V$CELL_GLOBAL_HISTORY V$CELL_IOREASON V$CELL_IOREASON_NAME V$CELL_METRIC_DESC V$CELL_OFL_THREAD_HISTORY V$CELL_OPEN_ALERTS V$CELL_REQUEST_TOTALS V$CELL_STATE V$CELL_THREAD_HISTORY V$CHANNEL_WAITS V$CIRCUIT V$CLASS_CACHE_TRANSFER V$CLASS_PING V$CLIENT_SECRETS V$CLIENT_STATS V$CLONEDFILE V$CLUSTER_INTERCONNECTS V$CONFIGURED_INTERCONNECTS V$CONTAINERS V$CONTEXT V$CONTROLFILE V$CONTROLFILE_RECORD_SECTION V$CON_SYSSTAT V$CON_SYSTEM_EVENT V$CON_SYSTEM_WAIT_CLASS V$CON_SYS_TIME_MODEL V$COPY_CORRUPTION V$COPY_NONLOGGED V$CORRUPT_XID_LIST V$CPOOL_CC_INFO V$CPOOL_CC_STATS V$CPOOL_CONN_INFO V$CPOOL_STATS V$CR_BLOCK_SERVER V$CURRENT_BLOCK_SERVER V$DATABASE V$DATABASE_BLOCK_CORRUPTION V$DATABASE_INCARNATION V$DATABASE_KEY_INFO V$DATAFILE V$DATAFILE_COPY V$DATAFILE_HEADER V$DATAGUARD_CONFIG V$DATAGUARD_STATS V$DATAGUARD_STATUS V$DATAPUMP_JOB V$DATAPUMP_SESSION V$DBFILE V$DBLINK V$DB_CACHE_ADVICE V$DB_OBJECT_CACHE V$DB_PIPES V$DB_TRANSPORTABLE_PLATFORM V$DEAD_CLEANUP V$DELETED_OBJECT V$DETACHED_SESSION V$DG_BROKER_CONFIG V$DIAG_ADR_CONTROL V$DIAG_ADR_INVALIDATION V$DIAG_ALERT_EXT V$DIAG_AMS_XACTION V$DIAG_CRITICAL_ERROR V$DIAG_DDE_USER_ACTION V$DIAG_DDE_USER_ACTION_DEF V$DIAG_DDE_USR_ACT_PARAM V$DIAG_DDE_USR_ACT_PARAM_DEF V$DIAG_DDE_USR_INC_ACT_MAP V$DIAG_DDE_USR_INC_TYPE V$DIAG_DFW_CONFIG_CAPTURE V$DIAG_DFW_CONFIG_ITEM V$DIAG_DFW_PATCH_CAPTURE V$DIAG_DFW_PATCH_ITEM V$DIAG_DIAGV_INCIDENT V$DIAG_DIR_EXT V$DIAG_EM_DIAG_JOB V$DIAG_EM_TARGET_INFO V$DIAG_EM_USER_ACTIVITY V$DIAG_HM_FDG_SET V$DIAG_HM_FINDING V$DIAG_HM_INFO V$DIAG_HM_MESSAGE V$DIAG_HM_RECOMMENDATION V$DIAG_HM_RUN V$DIAG_INCCKEY V$DIAG_INCIDENT V$DIAG_INCIDENT_FILE V$DIAG_INC_METER_CONFIG V$DIAG_INC_METER_IMPT_DEF V$DIAG_INC_METER_INFO V$DIAG_INC_METER_PK_IMPTS V$DIAG_INC_METER_SUMMARY V$DIAG_INFO V$DIAG_IPS_CONFIGURATION V$DIAG_IPS_FILE_COPY_LOG V$DIAG_IPS_FILE_METADATA V$DIAG_IPS_PACKAGE V$DIAG_IPS_PACKAGE_FILE V$DIAG_IPS_PACKAGE_HISTORY V$DIAG_IPS_PACKAGE_INCIDENT V$DIAG_IPS_PKG_UNPACK_HIST V$DIAG_IPS_PROGRESS_LOG V$DIAG_IPS_REMOTE_PACKAGE V$DIAG_LOG_EXT V$DIAG_PICKLEERR V$DIAG_PROBLEM V$DIAG_RELMD_EXT V$DIAG_SWEEPERR V$DIAG_VEM_USER_ACTLOG V$DIAG_VEM_USER_ACTLOG1 V$DIAG_VHM_RUN V$DIAG_VIEW V$DIAG_VIEWCOL V$DIAG_VINCIDENT V$DIAG_VINCIDENT_FILE V$DIAG_VINC_METER_INFO V$DIAG_VIPS_FILE_COPY_LOG V$DIAG_VIPS_FILE_METADATA V$DIAG_VIPS_PACKAGE_FILE V$DIAG_VIPS_PACKAGE_HISTORY V$DIAG_VIPS_PACKAGE_MAIN_INT V$DIAG_VIPS_PACKAGE_SIZE V$DIAG_VIPS_PKG_FILE V$DIAG_VIPS_PKG_INC_CAND V$DIAG_VIPS_PKG_INC_DTL V$DIAG_VIPS_PKG_INC_DTL1 V$DIAG_VIPS_PKG_MAIN_PROBLEM V$DIAG_VNOT_EXIST_INCIDENT V$DIAG_VPROBLEM V$DIAG_VPROBLEM1 V$DIAG_VPROBLEM2 V$DIAG_VPROBLEM_BUCKET V$DIAG_VPROBLEM_BUCKET1 V$DIAG_VPROBLEM_BUCKET_COUNT V$DIAG_VPROBLEM_INT V$DIAG_VPROBLEM_LASTINC V$DIAG_VSHOWCATVIEW V$DIAG_VSHOWINCB V$DIAG_VSHOWINCB_I V$DIAG_VTEST_EXISTS V$DIAG_V_ACTINC V$DIAG_V_ACTPROB V$DIAG_V_INCCOUNT V$DIAG_V_INCFCOUNT V$DIAG_V_INC_METER_INFO_PROB V$DIAG_V_IPSPRBCNT V$DIAG_V_IPSPRBCNT1 V$DIAG_V_NFCINC V$DIAG_V_SWPERRCOUNT V$DISK_RESTORE_RANGE V$DISPATCHER V$DISPATCHER_CONFIG V$DISPATCHER_RATE V$DLM_ALL_LOCKS V$DLM_CONVERT_LOCAL V$DLM_CONVERT_REMOTE V$DLM_LATCH V$DLM_LOCKS V$DLM_MISC V$DLM_RESS V$DLM_TRAFFIC_CONTROLLER V$DNFS_CHANNELS V$DNFS_FILES V$DNFS_SERVERS V$DNFS_STATS V$DYNAMIC_REMASTER_STATS V$EDITIONABLE_TYPES V$EMON V$EMX_USAGE_STATS V$ENABLEDPRIVS V$ENCRYPTED_TABLESPACES V$ENCRYPTION_KEYS V$ENCRYPTION_WALLET V$ENQUEUE_LOCK V$ENQUEUE_STAT V$ENQUEUE_STATISTICS V$EVENTMETRIC V$EVENT_HISTOGRAM V$EVENT_HISTOGRAM_MICRO V$EVENT_NAME V$EXECUTION V$FALSE_PING V$FAST_START_SERVERS V$FAST_START_TRANSACTIONS V$FILEMETRIC V$FILEMETRIC_HISTORY V$FILESPACE_USAGE V$FILESTAT V$FILE_CACHE_TRANSFER V$FILE_HISTOGRAM V$FILE_OPTIMIZED_HISTOGRAM V$FILE_PING V$FIXED_TABLE V$FIXED_VIEW_DEFINITION V$FLASHBACK_DATABASE_LOG V$FLASHBACK_DATABASE_LOGFILE V$FLASHBACK_DATABASE_STAT V$FLASHBACK_TXN_GRAPH V$FLASHBACK_TXN_MODS V$FLASHFILESTAT V$FLASH_RECOVERY_AREA_USAGE V$FOREIGN_ARCHIVED_LOG V$FS_FAILOVER_HISTOGRAM V$FS_FAILOVER_STATS V$FS_OBSERVER_HISTOGRAM V$GCSHVMASTER_INFO V$GCSPFMASTER_INFO V$GC_ELEMENT V$GC_ELEMENTS_WITH_COLLISIONS V$GES_BLOCKING_ENQUEUE V$GES_CONVERT_LOCAL V$GES_CONVERT_REMOTE V$GES_DEADLOCKS V$GES_DEADLOCK_SESSIONS V$GES_ENQUEUE V$GES_LATCH V$GES_RESOURCE V$GES_STATISTICS V$GES_TRAFFIC_CONTROLLER V$GG_APPLY_COORDINATOR V$GG_APPLY_READER V$GG_APPLY_RECEIVER V$GG_APPLY_SERVER V$GLOBALCONTEXT V$GLOBAL_BLOCKED_LOCKS V$GLOBAL_TRANSACTION V$GOLDENGATE_CAPABILITIES V$GOLDENGATE_CAPTURE V$GOLDENGATE_MESSAGE_TRACKING V$GOLDENGATE_TABLE_STATS V$GOLDENGATE_TRANSACTION V$HANG_INFO V$HANG_SESSION_INFO V$HANG_STATISTICS V$HEAT_MAP_SEGMENT V$HM_CHECK V$HM_CHECK_PARAM V$HM_FINDING V$HM_INFO V$HM_RECOMMENDATION V$HM_RUN V$HS_AGENT V$HS_PARAMETER V$HS_SESSION V$HVMASTER_INFO V$IM_COLUMN_LEVEL V$IM_COL_CU V$IM_HEADER V$IM_SEGMENTS V$IM_SEGMENTS_DETAIL V$IM_SEG_EXT_MAP V$IM_SMU_CHUNK V$IM_SMU_HEAD V$IM_TBS_EXT_MAP V$IM_USER_SEGMENTS V$INCMETER_CONFIG V$INCMETER_INFO V$INCMETER_SUMMARY V$INDEXED_FIXED_COLUMN V$INMEMORY_AREA V$INSTANCE V$INSTANCE_CACHE_TRANSFER V$INSTANCE_LOG_GROUP V$INSTANCE_PING V$INSTANCE_RECOVERY V$IOFUNCMETRIC V$IOFUNCMETRIC_HISTORY V$IOSTAT_CONSUMER_GROUP V$IOSTAT_FILE V$IOSTAT_FUNCTION V$IOSTAT_FUNCTION_DETAIL V$IOSTAT_NETWORK V$IOS_CLIENT V$IO_CALIBRATION_STATUS V$IO_OUTLIER V$IR_FAILURE V$IR_FAILURE_SET V$IR_MANUAL_CHECKLIST V$IR_REPAIR V$JAVAPOOL V$JAVA_LIBRARY_CACHE_MEMORY V$JAVA_POOL_ADVICE V$KERNEL_IO_OUTLIER V$KEY_VECTOR V$LATCH V$LATCHHOLDER V$LATCHNAME V$LATCH_CHILDREN V$LATCH_MISSES V$LATCH_PARENT V$LGWRIO_OUTLIER V$LIBCACHE_LOCKS V$LIBRARYCACHE V$LIBRARY_CACHE_MEMORY V$LICENSE V$LISTENER_NETWORK V$LOADISTAT V$LOADPSTAT V$LOBSTAT V$LOCK V$LOCKED_OBJECT V$LOCKS_WITH_COLLISIONS V$LOCK_ACTIVITY V$LOCK_ELEMENT V$LOCK_TYPE V$LOG V$LOGFILE V$LOGHIST V$LOGMNR_CONTENTS V$LOGMNR_DICTIONARY V$LOGMNR_DICTIONARY_LOAD V$LOGMNR_LATCH V$LOGMNR_LOGFILE V$LOGMNR_LOGS V$LOGMNR_PARAMETERS V$LOGMNR_PROCESS V$LOGMNR_SESSION V$LOGMNR_STATS V$LOGMNR_TRANSACTION V$LOGSTDBY V$LOGSTDBY_PROCESS V$LOGSTDBY_PROGRESS V$LOGSTDBY_STATE V$LOGSTDBY_STATS V$LOGSTDBY_TRANSACTION V$LOG_HISTORY V$MANAGED_STANDBY V$MAPPED_SQL V$MAP_COMP_LIST V$MAP_ELEMENT V$MAP_EXT_ELEMENT V$MAP_FILE V$MAP_FILE_EXTENT V$MAP_FILE_IO_STACK V$MAP_LIBRARY V$MAP_SUBELEMENT V$MAX_ACTIVE_SESS_TARGET_MTH V$MEMORY_CURRENT_RESIZE_OPS V$MEMORY_DYNAMIC_COMPONENTS V$MEMORY_RESIZE_OPS V$MEMORY_TARGET_ADVICE V$METRIC V$METRICGROUP V$METRICNAME V$METRIC_HISTORY V$MTTR_TARGET_ADVICE V$MUTEX_SLEEP V$MUTEX_SLEEP_HISTORY V$MVREFRESH V$MYSTAT V$NFS_CLIENTS V$NFS_LOCKS V$NFS_OPEN_FILES V$NLS_PARAMETERS V$NLS_VALID_VALUES V$NONLOGGED_BLOCK V$OBJECT_DEPENDENCY V$OBJECT_DML_FREQUENCIES V$OBJECT_PRIVILEGE V$OBJECT_USAGE V$OBSOLETE_PARAMETER V$OFFLINE_RANGE V$OFSMOUNT V$OFS_STATS V$OPEN_CURSOR V$OPTIMIZER_PROCESSING_RATE V$OPTION V$OSSTAT V$PARALLEL_DEGREE_LIMIT_MTH V$PARAMETER V$PARAMETER2 V$PARAMETER_VALID_VALUES V$PATCHES V$PDBS V$PDB_INCARNATION V$PERSISTENT_PUBLISHERS V$PERSISTENT_QMN_CACHE V$PERSISTENT_QUEUES V$PERSISTENT_SUBSCRIBERS V$PGASTAT V$PGA_TARGET_ADVICE V$PGA_TARGET_ADVICE_HISTOGRAM V$PING V$POLICY_HISTORY V$PQ_SESSTAT V$PQ_SLAVE V$PQ_SYSSTAT V$PQ_TQSTAT V$PROCESS V$PROCESS_GROUP V$PROCESS_MEMORY V$PROCESS_MEMORY_DETAIL V$PROCESS_MEMORY_DETAIL_PROG V$PROPAGATION_RECEIVER V$PROPAGATION_SENDER V$PROXY_ARCHIVEDLOG V$PROXY_ARCHIVELOG_DETAILS V$PROXY_ARCHIVELOG_SUMMARY V$PROXY_COPY_DETAILS V$PROXY_COPY_SUMMARY V$PROXY_DATAFILE V$PWFILE_USERS V$PX_BUFFER_ADVICE V$PX_INSTANCE_GROUP V$PX_PROCESS V$PX_PROCESS_SYSSTAT V$PX_PROCESS_TRACE V$PX_SESSION V$PX_SESSTAT V$QMON_COORDINATOR_STATS V$QMON_SERVER_STATS V$QMON_TASKS V$QMON_TASK_STATS V$QUEUE V$QUEUEING_MTH V$RECOVERY_AREA_USAGE V$RECOVERY_FILE_DEST V$RECOVERY_FILE_STATUS V$RECOVERY_LOG V$RECOVERY_PROGRESS V$RECOVERY_STATUS V$RECOVER_FILE V$REDO_DEST_RESP_HISTOGRAM V$REPLAY_CONTEXT V$REPLAY_CONTEXT_LOB V$REPLAY_CONTEXT_SEQUENCE V$REPLAY_CONTEXT_SYSDATE V$REPLAY_CONTEXT_SYSGUID V$REPLAY_CONTEXT_SYSTIMESTAMP V$REPLPROP V$REPLQUEUE V$REQDIST V$RESERVED_WORDS V$RESOURCE V$RESOURCE_LIMIT V$RESTORE_POINT V$RESTORE_RANGE V$RESULT_CACHE_DEPENDENCY V$RESULT_CACHE_MEMORY V$RESULT_CACHE_OBJECTS V$RESULT_CACHE_STATISTICS V$RESUMABLE V$RFS_THREAD V$RMAN_BACKUP_JOB_DETAILS V$RMAN_BACKUP_SUBJOB_DETAILS V$RMAN_BACKUP_TYPE V$RMAN_COMPRESSION_ALGORITHM V$RMAN_CONFIGURATION V$RMAN_ENCRYPTION_ALGORITHMS V$RMAN_OUTPUT V$RMAN_STATUS V$ROLLNAME V$ROLLSTAT V$ROWCACHE V$ROWCACHE_PARENT V$ROWCACHE_SUBORDINATE V$RO_USER_ACCOUNT V$RSRCMGRMETRIC V$RSRCMGRMETRIC_HISTORY V$RSRC_CONSUMER_GROUP V$RSRC_CONSUMER_GROUP_CPU_MTH V$RSRC_CONS_GROUP_HISTORY V$RSRC_PLAN V$RSRC_PLAN_CPU_MTH V$RSRC_PLAN_HISTORY V$RSRC_SESSION_INFO V$RT_ADDM_CONTROL V$RULE V$RULE_SET V$RULE_SET_AGGREGATE_STATS V$SBT_RESTORE_RANGE V$SCHEDULER_INMEM_MDINFO V$SCHEDULER_INMEM_RTINFO V$SCHEDULER_RUNNING_JOBS V$SECUREFILE_TIMER V$SEGMENT_STATISTICS V$SEGSPACE_USAGE V$SEGSTAT V$SEGSTAT_NAME V$SERVICEMETRIC V$SERVICEMETRIC_HISTORY V$SERVICES V$SERVICE_EVENT V$SERVICE_STATS V$SERVICE_WAIT_CLASS V$SERV_MOD_ACT_STATS V$SESSION V$SESSIONS_COUNT V$SESSION_BLOCKERS V$SESSION_CONNECT_INFO V$SESSION_CURSOR_CACHE V$SESSION_EVENT V$SESSION_FIX_CONTROL V$SESSION_LONGOPS V$SESSION_OBJECT_CACHE V$SESSION_WAIT V$SESSION_WAIT_CLASS V$SESSION_WAIT_HISTORY V$SESSMETRIC V$SESSTAT V$SESS_IO V$SESS_TIME_MODEL V$SES_OPTIMIZER_ENV V$SGA V$SGAINFO V$SGASTAT V$SGA_CURRENT_RESIZE_OPS V$SGA_DYNAMIC_COMPONENTS V$SGA_DYNAMIC_FREE_MEMORY V$SGA_RESIZE_OPS V$SGA_TARGET_ADVICE V$SHARED_POOL_ADVICE V$SHARED_POOL_RESERVED V$SHARED_SERVER V$SHARED_SERVER_MONITOR V$SORT_SEGMENT V$SORT_USAGE V$SPPARAMETER V$SQL V$SQLAREA V$SQLAREA_PLAN_HASH V$SQLCOMMAND V$SQLFN_ARG_METADATA V$SQLFN_METADATA V$SQLPA_METRIC V$SQLSTATS V$SQLSTATS_PLAN_HASH V$SQLTEXT V$SQLTEXT_WITH_NEWLINES V$SQL_BIND_CAPTURE V$SQL_BIND_DATA V$SQL_BIND_METADATA V$SQL_CS_HISTOGRAM V$SQL_CS_SELECTIVITY V$SQL_CS_STATISTICS V$SQL_CURSOR V$SQL_DIAG_REPOSITORY V$SQL_DIAG_REPOSITORY_REASON V$SQL_FEATURE V$SQL_FEATURE_DEPENDENCY V$SQL_FEATURE_HIERARCHY V$SQL_HINT V$SQL_JOIN_FILTER V$SQL_MONITOR V$SQL_MONITOR_SESSTAT V$SQL_MONITOR_STATNAME V$SQL_OPTIMIZER_ENV V$SQL_PLAN V$SQL_PLAN_MONITOR V$SQL_PLAN_STATISTICS V$SQL_PLAN_STATISTICS_ALL V$SQL_REDIRECTION V$SQL_REOPTIMIZATION_HINTS V$SQL_SHARED_CURSOR V$SQL_SHARED_MEMORY V$SQL_WORKAREA V$SQL_WORKAREA_ACTIVE V$SQL_WORKAREA_HISTOGRAM V$SSCR_SESSIONS V$STANDBY_EVENT_HISTOGRAM V$STANDBY_LOG V$STATISTICS_LEVEL V$STATNAME V$STREAMS_APPLY_COORDINATOR V$STREAMS_APPLY_READER V$STREAMS_APPLY_SERVER V$STREAMS_CAPTURE V$STREAMS_MESSAGE_TRACKING V$STREAMS_POOL_ADVICE V$STREAMS_POOL_STATISTICS V$STREAMS_TRANSACTION V$SUBCACHE V$SUBSCR_REGISTRATION_STATS V$SYSAUX_OCCUPANTS V$SYSMETRIC V$SYSMETRIC_HISTORY V$SYSMETRIC_SUMMARY V$SYSSTAT V$SYSTEM_CURSOR_CACHE V$SYSTEM_EVENT V$SYSTEM_FIX_CONTROL V$SYSTEM_PARAMETER V$SYSTEM_PARAMETER2 V$SYSTEM_WAIT_CLASS V$SYS_OPTIMIZER_ENV V$SYS_REPORT_REQUESTS V$SYS_REPORT_STATS V$SYS_TIME_MODEL V$TABLESPACE V$TEMPFILE V$TEMPORARY_LOBS V$TEMPSEG_USAGE V$TEMPSTAT V$TEMPUNDOSTAT V$TEMP_CACHE_TRANSFER V$TEMP_EXTENT_MAP V$TEMP_EXTENT_POOL V$TEMP_PING V$TEMP_SPACE_HEADER V$THREAD V$THRESHOLD_TYPES V$TIMER V$TIMEZONE_FILE V$TIMEZONE_NAMES V$TOPLEVELCALL V$TRANSACTION V$TRANSACTION_ENQUEUE V$TRANSPORTABLE_PLATFORM V$TSDP_SUPPORTED_FEATURE V$TSM_SESSIONS V$TYPE_SIZE V$UNDOSTAT V$UNIFIED_AUDIT_RECORD_FORMAT V$UNIFIED_AUDIT_TRAIL V$UNUSABLE_BACKUPFILE_DETAILS V$VERSION V$VPD_POLICY V$WAITCLASSMETRIC V$WAITCLASSMETRIC_HISTORY V$WAITSTAT V$WAIT_CHAINS V$WALLET V$WLM_PCMETRIC V$WLM_PCMETRIC_HISTORY V$WLM_PC_STATS V$WORKLOAD_REPLAY_THREAD V$XML_AUDIT_TRAIL V$XSTREAM_APPLY_COORDINATOR V$XSTREAM_APPLY_READER V$XSTREAM_APPLY_RECEIVER V$XSTREAM_APPLY_SERVER V$XSTREAM_CAPTURE V$XSTREAM_MESSAGE_TRACKING V$XSTREAM_OUTBOUND_SERVER V$XSTREAM_TABLE_STATS V$XSTREAM_TRANSACTION V$XS_SESSIONS V$XS_SESSION_NS_ATTRIBUTE V$XS_SESSION_NS_ATTRIBUTES V$XS_SESSION_ROLE V$XS_SESSION_ROLES V$_LOCK
最近、ドライブレコーダー買いました。スマフォから参照することができるのがいい感じだったので。REST API とかで機能を呼べるといいんだけどなぁ。しばらく色々と遊べそうです。
カーメイト ドライブレコーダー アクションカメラ 360度カメラ ダクション 360S 前後 左右 撮影 超広角 全天球モデル スマホ連携 駐車監視オプションあり DC5000
- 出版社/メーカー: カーメイト(CARMATE)
- 発売日: 2018/12/03
- メディア: Automotive
- この商品を含むブログを見る